-
-
Save alexander-wei/25db7389996deca9c562f699b1f48985 to your computer and use it in GitHub Desktop.
hacker news posts eda
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 6, | |
| "id": "a6ff9e5c-d7ee-492c-9e98-d895fcd77d31", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<style scoped>\n", | |
| " .dataframe tbody tr th:only-of-type {\n", | |
| " vertical-align: middle;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe tbody tr th {\n", | |
| " vertical-align: top;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>id</th>\n", | |
| " <th>title</th>\n", | |
| " <th>url</th>\n", | |
| " <th>num_points</th>\n", | |
| " <th>num_comments</th>\n", | |
| " <th>author</th>\n", | |
| " <th>created_at</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>12579008</td>\n", | |
| " <td>You have two days to comment if you want stem ...</td>\n", | |
| " <td>http://www.regulations.gov/document?D=FDA-2015...</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>altstar</td>\n", | |
| " <td>9/26/2016 3:26</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>12579005</td>\n", | |
| " <td>SQLAR the SQLite Archiver</td>\n", | |
| " <td>https://www.sqlite.org/sqlar/doc/trunk/README.md</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>blacksqr</td>\n", | |
| " <td>9/26/2016 3:24</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>12578997</td>\n", | |
| " <td>What if we just printed a flatscreen televisio...</td>\n", | |
| " <td>https://medium.com/vanmoof/our-secrets-out-f21...</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>pavel_lishin</td>\n", | |
| " <td>9/26/2016 3:19</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>12578989</td>\n", | |
| " <td>algorithmic music</td>\n", | |
| " <td>http://cacm.acm.org/magazines/2011/7/109891-al...</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>poindontcare</td>\n", | |
| " <td>9/26/2016 3:16</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>12578979</td>\n", | |
| " <td>How the Data Vault Enables the Next-Gen Data W...</td>\n", | |
| " <td>https://www.talend.com/blog/2016/05/12/talend-...</td>\n", | |
| " <td>1</td>\n", | |
| " <td>0</td>\n", | |
| " <td>markgainor1</td>\n", | |
| " <td>9/26/2016 3:14</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>...</th>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " <td>...</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>293114</th>\n", | |
| " <td>10176919</td>\n", | |
| " <td>Ask HN: What is/are your favorite quote(s)?</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>15</td>\n", | |
| " <td>20</td>\n", | |
| " <td>kumarski</td>\n", | |
| " <td>9/6/2015 6:02</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>293115</th>\n", | |
| " <td>10176917</td>\n", | |
| " <td>Attention and awareness in stage magic: turnin...</td>\n", | |
| " <td>http://people.cs.uchicago.edu/~luitien/nrn2473...</td>\n", | |
| " <td>14</td>\n", | |
| " <td>0</td>\n", | |
| " <td>stakent</td>\n", | |
| " <td>9/6/2015 6:01</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>293116</th>\n", | |
| " <td>10176908</td>\n", | |
| " <td>Dying vets [...] letter (2013)</td>\n", | |
| " <td>http://dangerousminds.net/comments/dying_vets_...</td>\n", | |
| " <td>10</td>\n", | |
| " <td>2</td>\n", | |
| " <td>mycodebreaks</td>\n", | |
| " <td>9/6/2015 5:56</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>293117</th>\n", | |
| " <td>10176907</td>\n", | |
| " <td>PHP 7 Coolest Features: Space Ships, Type Hint...</td>\n", | |
| " <td>https://www.zend.com/en/resources/php-7</td>\n", | |
| " <td>2</td>\n", | |
| " <td>0</td>\n", | |
| " <td>Garbage</td>\n", | |
| " <td>9/6/2015 5:55</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>293118</th>\n", | |
| " <td>10176903</td>\n", | |
| " <td>Toyota Establishes Research Centers with MIT a...</td>\n", | |
| " <td>http://newsroom.toyota.co.jp/en/detail/9233109/</td>\n", | |
| " <td>4</td>\n", | |
| " <td>0</td>\n", | |
| " <td>tim_sw</td>\n", | |
| " <td>9/6/2015 5:50</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>293119 rows × 7 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " id title \\\n", | |
| "0 12579008 You have two days to comment if you want stem ... \n", | |
| "1 12579005 SQLAR the SQLite Archiver \n", | |
| "2 12578997 What if we just printed a flatscreen televisio... \n", | |
| "3 12578989 algorithmic music \n", | |
| "4 12578979 How the Data Vault Enables the Next-Gen Data W... \n", | |
| "... ... ... \n", | |
| "293114 10176919 Ask HN: What is/are your favorite quote(s)? \n", | |
| "293115 10176917 Attention and awareness in stage magic: turnin... \n", | |
| "293116 10176908 Dying vets **** you letter (2013) \n", | |
| "293117 10176907 PHP 7 Coolest Features: Space Ships, Type Hint... \n", | |
| "293118 10176903 Toyota Establishes Research Centers with MIT a... \n", | |
| "\n", | |
| " url num_points \\\n", | |
| "0 http://www.regulations.gov/document?D=FDA-2015... 1 \n", | |
| "1 https://www.sqlite.org/sqlar/doc/trunk/README.md 1 \n", | |
| "2 https://medium.com/vanmoof/our-secrets-out-f21... 1 \n", | |
| "3 http://cacm.acm.org/magazines/2011/7/109891-al... 1 \n", | |
| "4 https://www.talend.com/blog/2016/05/12/talend-... 1 \n", | |
| "... ... ... \n", | |
| "293114 NaN 15 \n", | |
| "293115 http://people.cs.uchicago.edu/~luitien/nrn2473... 14 \n", | |
| "293116 http://dangerousminds.net/comments/dying_vets_... 10 \n", | |
| "293117 https://www.zend.com/en/resources/php-7 2 \n", | |
| "293118 http://newsroom.toyota.co.jp/en/detail/9233109/ 4 \n", | |
| "\n", | |
| " num_comments author created_at \n", | |
| "0 0 altstar 9/26/2016 3:26 \n", | |
| "1 0 blacksqr 9/26/2016 3:24 \n", | |
| "2 0 pavel_lishin 9/26/2016 3:19 \n", | |
| "3 0 poindontcare 9/26/2016 3:16 \n", | |
| "4 0 markgainor1 9/26/2016 3:14 \n", | |
| "... ... ... ... \n", | |
| "293114 20 kumarski 9/6/2015 6:02 \n", | |
| "293115 0 stakent 9/6/2015 6:01 \n", | |
| "293116 2 mycodebreaks 9/6/2015 5:56 \n", | |
| "293117 0 Garbage 9/6/2015 5:55 \n", | |
| "293118 0 tim_sw 9/6/2015 5:50 \n", | |
| "\n", | |
| "[293119 rows x 7 columns]" | |
| ] | |
| }, | |
| "execution_count": 6, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "_X" | |
| ] | |
| } | |
| ], | |
| "metadata": { | |
| "kernelspec": { | |
| "display_name": "Python 3 (ipykernel)", | |
| "language": "python", | |
| "name": "python3" | |
| }, | |
| "language_info": { | |
| "codemirror_mode": { | |
| "name": "ipython", | |
| "version": 3 | |
| }, | |
| "file_extension": ".py", | |
| "mimetype": "text/x-python", | |
| "name": "python", | |
| "nbconvert_exporter": "python", | |
| "pygments_lexer": "ipython3", | |
| "version": "3.10.5" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 5 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment