staying/python
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
master
python/公开课/文档/年薪50W+的Python程序员如何写代码/code/Python/使用Pandas做数据分析.ipynb

1715 lines
131 KiB
Plaintext
Raw Permalink Normal View History

记录
2024-12-04 00:04:56 +08:00
{
"cells": [
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [],
"source": [
"import pandas"
]
},
{
"cell_type": "code",
"execution_count": 29,
"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>video_id</th>\n",
" <th>trending_date</th>\n",
" <th>title</th>\n",
" <th>channel_title</th>\n",
" <th>category_id</th>\n",
" <th>publish_time</th>\n",
" <th>tags</th>\n",
" <th>views</th>\n",
" <th>likes</th>\n",
" <th>dislikes</th>\n",
" <th>comment_count</th>\n",
" <th>thumbnail_link</th>\n",
" <th>comments_disabled</th>\n",
" <th>ratings_disabled</th>\n",
" <th>video_error_or_removed</th>\n",
" <th>description</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2kyS6SvSYSE</td>\n",
" <td>17.14.11</td>\n",
" <td>WE WANT TO TALK ABOUT OUR MARRIAGE</td>\n",
" <td>CaseyNeistat</td>\n",
" <td>22</td>\n",
" <td>2017-11-13T17:13:01.000Z</td>\n",
" <td>SHANtell martin</td>\n",
" <td>748374</td>\n",
" <td>57527</td>\n",
" <td>2966</td>\n",
" <td>15954</td>\n",
" <td>https://i.ytimg.com/vi/2kyS6SvSYSE/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>SHANTELL'S CHANNEL - https://www.youtube.com/s...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>1ZAPwfrtAFY</td>\n",
" <td>17.14.11</td>\n",
" <td>The Trump Presidency: Last Week Tonight with J...</td>\n",
" <td>LastWeekTonight</td>\n",
" <td>24</td>\n",
" <td>2017-11-13T07:30:00.000Z</td>\n",
" <td>last week tonight trump presidency|\"last week ...</td>\n",
" <td>2418783</td>\n",
" <td>97185</td>\n",
" <td>6146</td>\n",
" <td>12703</td>\n",
" <td>https://i.ytimg.com/vi/1ZAPwfrtAFY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>One year after the presidential election, John...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>5qpjK5DgCt4</td>\n",
" <td>17.14.11</td>\n",
" <td>Racist Superman | Rudy Mancuso, King Bach &amp; Le...</td>\n",
" <td>Rudy Mancuso</td>\n",
" <td>23</td>\n",
" <td>2017-11-12T19:05:24.000Z</td>\n",
" <td>racist superman|\"rudy\"|\"mancuso\"|\"king\"|\"bach\"...</td>\n",
" <td>3191434</td>\n",
" <td>146033</td>\n",
" <td>5339</td>\n",
" <td>8181</td>\n",
" <td>https://i.ytimg.com/vi/5qpjK5DgCt4/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>WATCH MY PREVIOUS VIDEO ▶ \\n\\nSUBSCRIBE ► http...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3</td>\n",
" <td>puqaWrEC7tY</td>\n",
" <td>17.14.11</td>\n",
" <td>Nickelback Lyrics: Real or Fake?</td>\n",
" <td>Good Mythical Morning</td>\n",
" <td>24</td>\n",
" <td>2017-11-13T11:00:04.000Z</td>\n",
" <td>rhett and link|\"gmm\"|\"good mythical morning\"|\"...</td>\n",
" <td>343168</td>\n",
" <td>10172</td>\n",
" <td>666</td>\n",
" <td>2146</td>\n",
" <td>https://i.ytimg.com/vi/puqaWrEC7tY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>Today we find out if Link is a Nickelback amat...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>d380meD0W0M</td>\n",
" <td>17.14.11</td>\n",
" <td>I Dare You: GOING BALD!?</td>\n",
" <td>nigahiga</td>\n",
" <td>24</td>\n",
" <td>2017-11-12T18:01:41.000Z</td>\n",
" <td>ryan|\"higa\"|\"higatv\"|\"nigahiga\"|\"i dare you\"|\"...</td>\n",
" <td>2095731</td>\n",
" <td>132235</td>\n",
" <td>1989</td>\n",
" <td>17518</td>\n",
" <td>https://i.ytimg.com/vi/d380meD0W0M/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>I know it's been a while since we did this sho...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\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",
" <td>40944</td>\n",
" <td>BZt0qjTWNhw</td>\n",
" <td>18.14.06</td>\n",
" <td>The Cat Who Caught the Laser</td>\n",
" <td>AaronsAnimals</td>\n",
" <td>15</td>\n",
" <td>2018-05-18T13:00:04.000Z</td>\n",
" <td>aarons animals|\"aarons\"|\"animals\"|\"cat\"|\"cats\"...</td>\n",
" <td>1685609</td>\n",
" <td>38160</td>\n",
" <td>1385</td>\n",
" <td>2657</td>\n",
" <td>https://i.ytimg.com/vi/BZt0qjTWNhw/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>The Cat Who Caught the Laser - Aaron's Animals</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40945</td>\n",
" <td>1h7KV2sjUWY</td>\n",
" <td>18.14.06</td>\n",
" <td>True Facts : Ant Mutualism</td>\n",
" <td>zefrank1</td>\n",
" <td>22</td>\n",
" <td>2018-05-18T01:00:06.000Z</td>\n",
" <td>[none]</td>\n",
" <td>1064798</td>\n",
" <td>60008</td>\n",
" <td>382</td>\n",
" <td>3936</td>\n",
" <td>https://i.ytimg.com/vi/1h7KV2sjUWY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40946</td>\n",
" <td>D6Oy4LfoqsU</td>\n",
" <td>18.14.06</td>\n",
" <td>I GAVE SAFIYA NYGAARD A PERFECT HAIR MAKEOVER ...</td>\n",
" <td>Brad Mondo</td>\n",
" <td>24</td>\n",
" <td>2018-05-18T17:34:22.000Z</td>\n",
" <td>I gave safiya nygaard a perfect hair makeover ...</td>\n",
" <td>1066451</td>\n",
" <td>48068</td>\n",
" <td>1032</td>\n",
" <td>3992</td>\n",
" <td>https://i.ytimg.com/vi/D6Oy4LfoqsU/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>I had so much fun transforming Safiyas hair in...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40947</td>\n",
" <td>oV0zkMe1K8s</td>\n",
" <td>18.14.06</td>\n",
" <td>How Black Panther Should Have Ended</td>\n",
" <td>How It Should Have Ended</td>\n",
" <td>1</td>\n",
" <td>2018-05-17T17:00:04.000Z</td>\n",
" <td>Black Panther|\"HISHE\"|\"Marvel\"|\"Infinity War\"|...</td>\n",
" <td>5660813</td>\n",
" <td>192957</td>\n",
" <td>2846</td>\n",
" <td>13088</td>\n",
" <td>https://i.ytimg.com/vi/oV0zkMe1K8s/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>How Black Panther Should Have EndedWatch More ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40948</td>\n",
" <td>ooyjaVdt-jA</td>\n",
" <td>18.14.06</td>\n",
" <td>Official Call of Duty®: Black Ops 4 — Multipla...</td>\n",
" <td>Call of Duty</td>\n",
" <td>20</td>\n",
" <td>2018-05-17T17:09:38.000Z</td>\n",
" <td>call of duty|\"cod\"|\"activision\"|\"Black Ops 4\"</td>\n",
" <td>10306119</td>\n",
" <td>357079</td>\n",
" <td>212976</td>\n",
" <td>144795</td>\n",
" <td>https://i.ytimg.com/vi/ooyjaVdt-jA/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>Call of Duty: Black Ops 4 Multiplayer raises t...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>40949 rows × 16 columns</p>\n",
"</div>"
],
"text/plain": [
" video_id trending_date \\\n",
"0 2kyS6SvSYSE 17.14.11 \n",
"1 1ZAPwfrtAFY 17.14.11 \n",
"2 5qpjK5DgCt4 17.14.11 \n",
"3 puqaWrEC7tY 17.14.11 \n",
"4 d380meD0W0M 17.14.11 \n",
"... ... ... \n",
"40944 BZt0qjTWNhw 18.14.06 \n",
"40945 1h7KV2sjUWY 18.14.06 \n",
"40946 D6Oy4LfoqsU 18.14.06 \n",
"40947 oV0zkMe1K8s 18.14.06 \n",
"40948 ooyjaVdt-jA 18.14.06 \n",
"\n",
" title \\\n",
"0 WE WANT TO TALK ABOUT OUR MARRIAGE \n",
"1 The Trump Presidency: Last Week Tonight with J... \n",
"2 Racist Superman | Rudy Mancuso, King Bach & Le... \n",
"3 Nickelback Lyrics: Real or Fake? \n",
"4 I Dare You: GOING BALD!? \n",
"... ... \n",
"40944 The Cat Who Caught the Laser \n",
"40945 True Facts : Ant Mutualism \n",
"40946 I GAVE SAFIYA NYGAARD A PERFECT HAIR MAKEOVER ... \n",
"40947 How Black Panther Should Have Ended \n",
"40948 Official Call of Duty®: Black Ops 4 — Multipla... \n",
"\n",
" channel_title category_id publish_time \\\n",
"0 CaseyNeistat 22 2017-11-13T17:13:01.000Z \n",
"1 LastWeekTonight 24 2017-11-13T07:30:00.000Z \n",
"2 Rudy Mancuso 23 2017-11-12T19:05:24.000Z \n",
"3 Good Mythical Morning 24 2017-11-13T11:00:04.000Z \n",
"4 nigahiga 24 2017-11-12T18:01:41.000Z \n",
"... ... ... ... \n",
"40944 AaronsAnimals 15 2018-05-18T13:00:04.000Z \n",
"40945 zefrank1 22 2018-05-18T01:00:06.000Z \n",
"40946 Brad Mondo 24 2018-05-18T17:34:22.000Z \n",
"40947 How It Should Have Ended 1 2018-05-17T17:00:04.000Z \n",
"40948 Call of Duty 20 2018-05-17T17:09:38.000Z \n",
"\n",
" tags views likes \\\n",
"0 SHANtell martin 748374 57527 \n",
"1 last week tonight trump presidency|\"last week ... 2418783 97185 \n",
"2 racist superman|\"rudy\"|\"mancuso\"|\"king\"|\"bach\"... 3191434 146033 \n",
"3 rhett and link|\"gmm\"|\"good mythical morning\"|\"... 343168 10172 \n",
"4 ryan|\"higa\"|\"higatv\"|\"nigahiga\"|\"i dare you\"|\"... 2095731 132235 \n",
"... ... ... ... \n",
"40944 aarons animals|\"aarons\"|\"animals\"|\"cat\"|\"cats\"... 1685609 38160 \n",
"40945 [none] 1064798 60008 \n",
"40946 I gave safiya nygaard a perfect hair makeover ... 1066451 48068 \n",
"40947 Black Panther|\"HISHE\"|\"Marvel\"|\"Infinity War\"|... 5660813 192957 \n",
"40948 call of duty|\"cod\"|\"activision\"|\"Black Ops 4\" 10306119 357079 \n",
"\n",
" dislikes comment_count \\\n",
"0 2966 15954 \n",
"1 6146 12703 \n",
"2 5339 8181 \n",
"3 666 2146 \n",
"4 1989 17518 \n",
"... ... ... \n",
"40944 1385 2657 \n",
"40945 382 3936 \n",
"40946 1032 3992 \n",
"40947 2846 13088 \n",
"40948 212976 144795 \n",
"\n",
" thumbnail_link comments_disabled \\\n",
"0 https://i.ytimg.com/vi/2kyS6SvSYSE/default.jpg False \n",
"1 https://i.ytimg.com/vi/1ZAPwfrtAFY/default.jpg False \n",
"2 https://i.ytimg.com/vi/5qpjK5DgCt4/default.jpg False \n",
"3 https://i.ytimg.com/vi/puqaWrEC7tY/default.jpg False \n",
"4 https://i.ytimg.com/vi/d380meD0W0M/default.jpg False \n",
"... ... ... \n",
"40944 https://i.ytimg.com/vi/BZt0qjTWNhw/default.jpg False \n",
"40945 https://i.ytimg.com/vi/1h7KV2sjUWY/default.jpg False \n",
"40946 https://i.ytimg.com/vi/D6Oy4LfoqsU/default.jpg False \n",
"40947 https://i.ytimg.com/vi/oV0zkMe1K8s/default.jpg False \n",
"40948 https://i.ytimg.com/vi/ooyjaVdt-jA/default.jpg False \n",
"\n",
" ratings_disabled video_error_or_removed \\\n",
"0 False False \n",
"1 False False \n",
"2 False False \n",
"3 False False \n",
"4 False False \n",
"... ... ... \n",
"40944 False False \n",
"40945 False False \n",
"40946 False False \n",
"40947 False False \n",
"40948 False False \n",
"\n",
" description \n",
"0 SHANTELL'S CHANNEL - https://www.youtube.com/s... \n",
"1 One year after the presidential election, John... \n",
"2 WATCH MY PREVIOUS VIDEO ▶ \\n\\nSUBSCRIBE ► http... \n",
"3 Today we find out if Link is a Nickelback amat... \n",
"4 I know it's been a while since we did this sho... \n",
"... ... \n",
"40944 The Cat Who Caught the Laser - Aaron's Animals \n",
"40945 NaN \n",
"40946 I had so much fun transforming Safiyas hair in... \n",
"40947 How Black Panther Should Have EndedWatch More ... \n",
"40948 Call of Duty: Black Ops 4 Multiplayer raises t... \n",
"\n",
"[40949 rows x 16 columns]"
]
},
"execution_count": 29,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"frame = pandas.read_csv('USvideos.csv')\n",
"frame"
]
},
{
"cell_type": "code",
"execution_count": 30,
"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>video_id</th>\n",
" <th>trending_date</th>\n",
" <th>title</th>\n",
" <th>channel_title</th>\n",
" <th>category_id</th>\n",
" <th>publish_time</th>\n",
" <th>tags</th>\n",
" <th>views</th>\n",
" <th>likes</th>\n",
" <th>dislikes</th>\n",
" <th>comment_count</th>\n",
" <th>thumbnail_link</th>\n",
" <th>comments_disabled</th>\n",
" <th>ratings_disabled</th>\n",
" <th>video_error_or_removed</th>\n",
" <th>description</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>0</td>\n",
" <td>2kyS6SvSYSE</td>\n",
" <td>17.14.11</td>\n",
" <td>WE WANT TO TALK ABOUT OUR MARRIAGE</td>\n",
" <td>CaseyNeistat</td>\n",
" <td>22</td>\n",
" <td>2017-11-13T17:13:01.000Z</td>\n",
" <td>SHANtell martin</td>\n",
" <td>748374</td>\n",
" <td>57527</td>\n",
" <td>2966</td>\n",
" <td>15954</td>\n",
" <td>https://i.ytimg.com/vi/2kyS6SvSYSE/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>SHANTELL'S CHANNEL - https://www.youtube.com/s...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>1</td>\n",
" <td>1ZAPwfrtAFY</td>\n",
" <td>17.14.11</td>\n",
" <td>The Trump Presidency: Last Week Tonight with J...</td>\n",
" <td>LastWeekTonight</td>\n",
" <td>24</td>\n",
" <td>2017-11-13T07:30:00.000Z</td>\n",
" <td>last week tonight trump presidency|\"last week ...</td>\n",
" <td>2418783</td>\n",
" <td>97185</td>\n",
" <td>6146</td>\n",
" <td>12703</td>\n",
" <td>https://i.ytimg.com/vi/1ZAPwfrtAFY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>One year after the presidential election, John...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2</td>\n",
" <td>5qpjK5DgCt4</td>\n",
" <td>17.14.11</td>\n",
" <td>Racist Superman | Rudy Mancuso, King Bach &amp; Le...</td>\n",
" <td>Rudy Mancuso</td>\n",
" <td>23</td>\n",
" <td>2017-11-12T19:05:24.000Z</td>\n",
" <td>racist superman|\"rudy\"|\"mancuso\"|\"king\"|\"bach\"...</td>\n",
" <td>3191434</td>\n",
" <td>146033</td>\n",
" <td>5339</td>\n",
" <td>8181</td>\n",
" <td>https://i.ytimg.com/vi/5qpjK5DgCt4/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>WATCH MY PREVIOUS VIDEO ▶ \\n\\nSUBSCRIBE ► http...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>4</td>\n",
" <td>d380meD0W0M</td>\n",
" <td>17.14.11</td>\n",
" <td>I Dare You: GOING BALD!?</td>\n",
" <td>nigahiga</td>\n",
" <td>24</td>\n",
" <td>2017-11-12T18:01:41.000Z</td>\n",
" <td>ryan|\"higa\"|\"higatv\"|\"nigahiga\"|\"i dare you\"|\"...</td>\n",
" <td>2095731</td>\n",
" <td>132235</td>\n",
" <td>1989</td>\n",
" <td>17518</td>\n",
" <td>https://i.ytimg.com/vi/d380meD0W0M/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>I know it's been a while since we did this sho...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>12</td>\n",
" <td>5E4ZBSInqUU</td>\n",
" <td>17.14.11</td>\n",
" <td>Marshmello - Blocks (Official Music Video)</td>\n",
" <td>marshmello</td>\n",
" <td>10</td>\n",
" <td>2017-11-13T17:00:00.000Z</td>\n",
" <td>marshmello|\"blocks\"|\"marshmello blocks\"|\"block...</td>\n",
" <td>687582</td>\n",
" <td>114188</td>\n",
" <td>1333</td>\n",
" <td>8371</td>\n",
" <td>https://i.ytimg.com/vi/5E4ZBSInqUU/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>WATCH SILENCE MUSIC VIDEO ▶ https://youtu.be/T...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\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",
" <td>40942</td>\n",
" <td>ju_inUnrLc4</td>\n",
" <td>18.14.06</td>\n",
" <td>Fifth Harmony - Don't Say You Love Me</td>\n",
" <td>FifthHarmonyVEVO</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T07:00:08.000Z</td>\n",
" <td>fifth hamony|\"harmonizers\"|\"lauren\"|\"ally\"|\"no...</td>\n",
" <td>23502572</td>\n",
" <td>676467</td>\n",
" <td>15993</td>\n",
" <td>52432</td>\n",
" <td>https://i.ytimg.com/vi/ju_inUnrLc4/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>Fifth Harmony available at iTunes http://smart...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40943</td>\n",
" <td>1PhPYr_9zRY</td>\n",
" <td>18.14.06</td>\n",
" <td>BTS Plays With Puppies While Answering Fan Que...</td>\n",
" <td>BuzzFeed Celeb</td>\n",
" <td>22</td>\n",
" <td>2018-05-18T16:39:29.000Z</td>\n",
" <td>BuzzFeed|\"BuzzFeedVideo\"|\"Puppy Interview\"|\"pu...</td>\n",
" <td>8259128</td>\n",
" <td>645888</td>\n",
" <td>4052</td>\n",
" <td>62610</td>\n",
" <td>https://i.ytimg.com/vi/1PhPYr_9zRY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS with the PPS, the puppies. These adorable ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40945</td>\n",
" <td>1h7KV2sjUWY</td>\n",
" <td>18.14.06</td>\n",
" <td>True Facts : Ant Mutualism</td>\n",
" <td>zefrank1</td>\n",
" <td>22</td>\n",
" <td>2018-05-18T01:00:06.000Z</td>\n",
" <td>[none]</td>\n",
" <td>1064798</td>\n",
" <td>60008</td>\n",
" <td>382</td>\n",
" <td>3936</td>\n",
" <td>https://i.ytimg.com/vi/1h7KV2sjUWY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40947</td>\n",
" <td>oV0zkMe1K8s</td>\n",
" <td>18.14.06</td>\n",
" <td>How Black Panther Should Have Ended</td>\n",
" <td>How It Should Have Ended</td>\n",
" <td>1</td>\n",
" <td>2018-05-17T17:00:04.000Z</td>\n",
" <td>Black Panther|\"HISHE\"|\"Marvel\"|\"Infinity War\"|...</td>\n",
" <td>5660813</td>\n",
" <td>192957</td>\n",
" <td>2846</td>\n",
" <td>13088</td>\n",
" <td>https://i.ytimg.com/vi/oV0zkMe1K8s/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>How Black Panther Should Have EndedWatch More ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>40948</td>\n",
" <td>ooyjaVdt-jA</td>\n",
" <td>18.14.06</td>\n",
" <td>Official Call of Duty®: Black Ops 4 — Multipla...</td>\n",
" <td>Call of Duty</td>\n",
" <td>20</td>\n",
" <td>2018-05-17T17:09:38.000Z</td>\n",
" <td>call of duty|\"cod\"|\"activision\"|\"Black Ops 4\"</td>\n",
" <td>10306119</td>\n",
" <td>357079</td>\n",
" <td>212976</td>\n",
" <td>144795</td>\n",
" <td>https://i.ytimg.com/vi/ooyjaVdt-jA/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>Call of Duty: Black Ops 4 Multiplayer raises t...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>11065 rows × 16 columns</p>\n",
"</div>"
],
"text/plain": [
" video_id trending_date \\\n",
"0 2kyS6SvSYSE 17.14.11 \n",
"1 1ZAPwfrtAFY 17.14.11 \n",
"2 5qpjK5DgCt4 17.14.11 \n",
"4 d380meD0W0M 17.14.11 \n",
"12 5E4ZBSInqUU 17.14.11 \n",
"... ... ... \n",
"40942 ju_inUnrLc4 18.14.06 \n",
"40943 1PhPYr_9zRY 18.14.06 \n",
"40945 1h7KV2sjUWY 18.14.06 \n",
"40947 oV0zkMe1K8s 18.14.06 \n",
"40948 ooyjaVdt-jA 18.14.06 \n",
"\n",
" title \\\n",
"0 WE WANT TO TALK ABOUT OUR MARRIAGE \n",
"1 The Trump Presidency: Last Week Tonight with J... \n",
"2 Racist Superman | Rudy Mancuso, King Bach & Le... \n",
"4 I Dare You: GOING BALD!? \n",
"12 Marshmello - Blocks (Official Music Video) \n",
"... ... \n",
"40942 Fifth Harmony - Don't Say You Love Me \n",
"40943 BTS Plays With Puppies While Answering Fan Que... \n",
"40945 True Facts : Ant Mutualism \n",
"40947 How Black Panther Should Have Ended \n",
"40948 Official Call of Duty®: Black Ops 4 — Multipla... \n",
"\n",
" channel_title category_id publish_time \\\n",
"0 CaseyNeistat 22 2017-11-13T17:13:01.000Z \n",
"1 LastWeekTonight 24 2017-11-13T07:30:00.000Z \n",
"2 Rudy Mancuso 23 2017-11-12T19:05:24.000Z \n",
"4 nigahiga 24 2017-11-12T18:01:41.000Z \n",
"12 marshmello 10 2017-11-13T17:00:00.000Z \n",
"... ... ... ... \n",
"40942 FifthHarmonyVEVO 10 2018-05-18T07:00:08.000Z \n",
"40943 BuzzFeed Celeb 22 2018-05-18T16:39:29.000Z \n",
"40945 zefrank1 22 2018-05-18T01:00:06.000Z \n",
"40947 How It Should Have Ended 1 2018-05-17T17:00:04.000Z \n",
"40948 Call of Duty 20 2018-05-17T17:09:38.000Z \n",
"\n",
" tags views likes \\\n",
"0 SHANtell martin 748374 57527 \n",
"1 last week tonight trump presidency|\"last week ... 2418783 97185 \n",
"2 racist superman|\"rudy\"|\"mancuso\"|\"king\"|\"bach\"... 3191434 146033 \n",
"4 ryan|\"higa\"|\"higatv\"|\"nigahiga\"|\"i dare you\"|\"... 2095731 132235 \n",
"12 marshmello|\"blocks\"|\"marshmello blocks\"|\"block... 687582 114188 \n",
"... ... ... ... \n",
"40942 fifth hamony|\"harmonizers\"|\"lauren\"|\"ally\"|\"no... 23502572 676467 \n",
"40943 BuzzFeed|\"BuzzFeedVideo\"|\"Puppy Interview\"|\"pu... 8259128 645888 \n",
"40945 [none] 1064798 60008 \n",
"40947 Black Panther|\"HISHE\"|\"Marvel\"|\"Infinity War\"|... 5660813 192957 \n",
"40948 call of duty|\"cod\"|\"activision\"|\"Black Ops 4\" 10306119 357079 \n",
"\n",
" dislikes comment_count \\\n",
"0 2966 15954 \n",
"1 6146 12703 \n",
"2 5339 8181 \n",
"4 1989 17518 \n",
"12 1333 8371 \n",
"... ... ... \n",
"40942 15993 52432 \n",
"40943 4052 62610 \n",
"40945 382 3936 \n",
"40947 2846 13088 \n",
"40948 212976 144795 \n",
"\n",
" thumbnail_link comments_disabled \\\n",
"0 https://i.ytimg.com/vi/2kyS6SvSYSE/default.jpg False \n",
"1 https://i.ytimg.com/vi/1ZAPwfrtAFY/default.jpg False \n",
"2 https://i.ytimg.com/vi/5qpjK5DgCt4/default.jpg False \n",
"4 https://i.ytimg.com/vi/d380meD0W0M/default.jpg False \n",
"12 https://i.ytimg.com/vi/5E4ZBSInqUU/default.jpg False \n",
"... ... ... \n",
"40942 https://i.ytimg.com/vi/ju_inUnrLc4/default.jpg False \n",
"40943 https://i.ytimg.com/vi/1PhPYr_9zRY/default.jpg False \n",
"40945 https://i.ytimg.com/vi/1h7KV2sjUWY/default.jpg False \n",
"40947 https://i.ytimg.com/vi/oV0zkMe1K8s/default.jpg False \n",
"40948 https://i.ytimg.com/vi/ooyjaVdt-jA/default.jpg False \n",
"\n",
" ratings_disabled video_error_or_removed \\\n",
"0 False False \n",
"1 False False \n",
"2 False False \n",
"4 False False \n",
"12 False False \n",
"... ... ... \n",
"40942 False False \n",
"40943 False False \n",
"40945 False False \n",
"40947 False False \n",
"40948 False False \n",
"\n",
" description \n",
"0 SHANTELL'S CHANNEL - https://www.youtube.com/s... \n",
"1 One year after the presidential election, John... \n",
"2 WATCH MY PREVIOUS VIDEO ▶ \\n\\nSUBSCRIBE ► http... \n",
"4 I know it's been a while since we did this sho... \n",
"12 WATCH SILENCE MUSIC VIDEO ▶ https://youtu.be/T... \n",
"... ... \n",
"40942 Fifth Harmony available at iTunes http://smart... \n",
"40943 BTS with the PPS, the puppies. These adorable ... \n",
"40945 NaN \n",
"40947 How Black Panther Should Have EndedWatch More ... \n",
"40948 Call of Duty: Black Ops 4 Multiplayer raises t... \n",
"\n",
"[11065 rows x 16 columns]"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 喜欢数5W以上的视频\n",
"frame[frame.likes>50000]"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"2618681277"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 喜欢数5W以上的视频的总和\n",
"frame[frame.likes>50000].likes.sum()"
]
},
{
"cell_type": "code",
"execution_count": 32,
"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>video_id</th>\n",
" <th>trending_date</th>\n",
" <th>title</th>\n",
" <th>channel_title</th>\n",
" <th>category_id</th>\n",
" <th>publish_time</th>\n",
" <th>tags</th>\n",
" <th>views</th>\n",
" <th>likes</th>\n",
" <th>dislikes</th>\n",
" <th>comment_count</th>\n",
" <th>thumbnail_link</th>\n",
" <th>comments_disabled</th>\n",
" <th>ratings_disabled</th>\n",
" <th>video_error_or_removed</th>\n",
" <th>description</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>38273</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.01.06</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>123010920</td>\n",
" <td>5613827</td>\n",
" <td>206892</td>\n",
" <td>1228655</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>38072</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.31.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>121219886</td>\n",
" <td>5595203</td>\n",
" <td>205565</td>\n",
" <td>1225326</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37861</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.30.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>115664850</td>\n",
" <td>5530568</td>\n",
" <td>200995</td>\n",
" <td>1213172</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37655</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.29.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>111882133</td>\n",
" <td>5486349</td>\n",
" <td>197638</td>\n",
" <td>1204867</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37453</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.28.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>107756615</td>\n",
" <td>5439015</td>\n",
" <td>194172</td>\n",
" <td>1197130</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37247</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.27.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>103786733</td>\n",
" <td>5386959</td>\n",
" <td>190567</td>\n",
" <td>1189456</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>37031</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.26.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>98637739</td>\n",
" <td>5321402</td>\n",
" <td>186331</td>\n",
" <td>1165350</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>36816</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.25.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>92054928</td>\n",
" <td>5232318</td>\n",
" <td>179451</td>\n",
" <td>1163977</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>36611</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.24.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>87430865</td>\n",
" <td>5150831</td>\n",
" <td>172570</td>\n",
" <td>1142269</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>36397</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.23.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK...</td>\n",
" <td>80738011</td>\n",
" <td>5053329</td>\n",
" <td>165853</td>\n",
" <td>1114809</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" video_id trending_date title \\\n",
"38273 7C2z4GqqS5E 18.01.06 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"38072 7C2z4GqqS5E 18.31.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"37861 7C2z4GqqS5E 18.30.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"37655 7C2z4GqqS5E 18.29.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"37453 7C2z4GqqS5E 18.28.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"37247 7C2z4GqqS5E 18.27.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"37031 7C2z4GqqS5E 18.26.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"36816 7C2z4GqqS5E 18.25.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"36611 7C2z4GqqS5E 18.24.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"36397 7C2z4GqqS5E 18.23.05 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"\n",
" channel_title category_id publish_time \\\n",
"38273 ibighit 10 2018-05-18T09:00:02.000Z \n",
"38072 ibighit 10 2018-05-18T09:00:02.000Z \n",
"37861 ibighit 10 2018-05-18T09:00:02.000Z \n",
"37655 ibighit 10 2018-05-18T09:00:02.000Z \n",
"37453 ibighit 10 2018-05-18T09:00:02.000Z \n",
"37247 ibighit 10 2018-05-18T09:00:02.000Z \n",
"37031 ibighit 10 2018-05-18T09:00:02.000Z \n",
"36816 ibighit 10 2018-05-18T09:00:02.000Z \n",
"36611 ibighit 10 2018-05-18T09:00:02.000Z \n",
"36397 ibighit 10 2018-05-18T09:00:02.000Z \n",
"\n",
" tags views likes \\\n",
"38273 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 123010920 5613827 \n",
"38072 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 121219886 5595203 \n",
"37861 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 115664850 5530568 \n",
"37655 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 111882133 5486349 \n",
"37453 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 107756615 5439015 \n",
"37247 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 103786733 5386959 \n",
"37031 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 98637739 5321402 \n",
"36816 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 92054928 5232318 \n",
"36611 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 87430865 5150831 \n",
"36397 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"FAK... 80738011 5053329 \n",
"\n",
" dislikes comment_count \\\n",
"38273 206892 1228655 \n",
"38072 205565 1225326 \n",
"37861 200995 1213172 \n",
"37655 197638 1204867 \n",
"37453 194172 1197130 \n",
"37247 190567 1189456 \n",
"37031 186331 1165350 \n",
"36816 179451 1163977 \n",
"36611 172570 1142269 \n",
"36397 165853 1114809 \n",
"\n",
" thumbnail_link comments_disabled \\\n",
"38273 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"38072 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"37861 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"37655 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"37453 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"37247 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"37031 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"36816 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"36611 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"36397 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"\n",
" ratings_disabled video_error_or_removed \\\n",
"38273 False False \n",
"38072 False False \n",
"37861 False False \n",
"37655 False False \n",
"37453 False False \n",
"37247 False False \n",
"37031 False False \n",
"36816 False False \n",
"36611 False False \n",
"36397 False False \n",
"\n",
" description \n",
"38273 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"38072 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"37861 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"37655 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"37453 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"37247 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"37031 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"36816 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"36611 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"36397 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... "
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 喜欢数Top10视频\n",
"frame.sort_values('likes', ascending=False)[:10]"
]
},
{
"cell_type": "code",
"execution_count": 33,
"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>video_id</th>\n",
" <th>trending_date</th>\n",
" <th>title</th>\n",
" <th>channel_title</th>\n",
" <th>category_id</th>\n",
" <th>publish_time</th>\n",
" <th>tags</th>\n",
" <th>views</th>\n",
" <th>likes</th>\n",
" <th>dislikes</th>\n",
" <th>comment_count</th>\n",
" <th>thumbnail_link</th>\n",
" <th>comments_disabled</th>\n",
" <th>ratings_disabled</th>\n",
" <th>video_error_or_removed</th>\n",
" <th>description</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>35550</td>\n",
" <td>7C2z4GqqS5E</td>\n",
" <td>18.19.05</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-18T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>39349927</td>\n",
" <td>3880071</td>\n",
" <td>72707</td>\n",
" <td>692305</td>\n",
" <td>https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>2201</td>\n",
" <td>kTlv5_Bs8aw</td>\n",
" <td>17.25.11</td>\n",
" <td>BTS (방탄소년단) 'MIC Drop (Steve Aoki Remix)' Offi...</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2017-11-24T09:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>13945717</td>\n",
" <td>2055137</td>\n",
" <td>23888</td>\n",
" <td>395562</td>\n",
" <td>https://i.ytimg.com/vi/kTlv5_Bs8aw/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'MIC Drop (Steve Aoki Remix)' Offi...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>21173</td>\n",
" <td>OK3GJ0WIQ8s</td>\n",
" <td>18.02.03</td>\n",
" <td>j-hope 'Daydream (백일몽)' MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-03-01T15:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>10695328</td>\n",
" <td>2050527</td>\n",
" <td>14711</td>\n",
" <td>387384</td>\n",
" <td>https://i.ytimg.com/vi/OK3GJ0WIQ8s/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>j-hope 'Daydream (백일몽)'\\n\\n\\nj-hope's 'Daydrea...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>33151</td>\n",
" <td>p8npDG2ulKQ</td>\n",
" <td>18.07.05</td>\n",
" <td>BTS (방탄소년단) LOVE YOURSELF 轉 Tear 'Singularity'...</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-05-06T15:00:02.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>10666323</td>\n",
" <td>1956202</td>\n",
" <td>13966</td>\n",
" <td>285583</td>\n",
" <td>https://i.ytimg.com/vi/p8npDG2ulKQ/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) LOVE YOURSELF 轉 Tear 'Singularity'...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>3200</td>\n",
" <td>6ZfuNTqbHE8</td>\n",
" <td>17.30.11</td>\n",
" <td>Marvel Studios' Avengers: Infinity War Officia...</td>\n",
" <td>Marvel Entertainment</td>\n",
" <td>24</td>\n",
" <td>2017-11-29T13:26:24.000Z</td>\n",
" <td>marvel|\"comics\"|\"comic books\"|\"nerdy\"|\"geeky\"|...</td>\n",
" <td>37736281</td>\n",
" <td>1735895</td>\n",
" <td>21969</td>\n",
" <td>241237</td>\n",
" <td>https://i.ytimg.com/vi/6ZfuNTqbHE8/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>There was an idea… Avengers: Infinity War. In ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>70</td>\n",
" <td>2Vv-BfVoq4g</td>\n",
" <td>17.14.11</td>\n",
" <td>Ed Sheeran - Perfect (Official Music Video)</td>\n",
" <td>Ed Sheeran</td>\n",
" <td>10</td>\n",
" <td>2017-11-09T11:04:14.000Z</td>\n",
" <td>edsheeran|\"ed sheeran\"|\"acoustic\"|\"live\"|\"cove...</td>\n",
" <td>33523622</td>\n",
" <td>1634124</td>\n",
" <td>21082</td>\n",
" <td>85067</td>\n",
" <td>https://i.ytimg.com/vi/2Vv-BfVoq4g/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>🎧: https://ad.gt/yt-perfect\\n💰: https://atlant...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>28156</td>\n",
" <td>kX0vO4vlJuU</td>\n",
" <td>18.06.04</td>\n",
" <td>BTS (방탄소년단) 'Euphoria : Theme of LOVE YOURSELF...</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-04-05T15:00:05.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>7518332</td>\n",
" <td>1572997</td>\n",
" <td>8113</td>\n",
" <td>180262</td>\n",
" <td>https://i.ytimg.com/vi/kX0vO4vlJuU/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'Euphoria : Theme of LOVE YOURSELF...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>38352</td>\n",
" <td>D_6QmL6rExk</td>\n",
" <td>18.02.06</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV (Extended ...</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-06-01T15:00:01.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"fak...</td>\n",
" <td>5884233</td>\n",
" <td>1437859</td>\n",
" <td>6390</td>\n",
" <td>134721</td>\n",
" <td>https://i.ytimg.com/vi/D_6QmL6rExk/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>BTS (방탄소년단) 'FAKE LOVE' Official MV (Extended ...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>33351</td>\n",
" <td>VYOjWnS4cMY</td>\n",
" <td>18.08.05</td>\n",
" <td>Childish Gambino - This Is America (Official V...</td>\n",
" <td>ChildishGambinoVEVO</td>\n",
" <td>10</td>\n",
" <td>2018-05-06T04:00:07.000Z</td>\n",
" <td>Childish Gambino|\"Rap\"|\"This Is America\"|\"mcDJ...</td>\n",
" <td>31648454</td>\n",
" <td>1405355</td>\n",
" <td>51547</td>\n",
" <td>149473</td>\n",
" <td>https://i.ytimg.com/vi/VYOjWnS4cMY/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>“This is America” by Childish Gambino http://s...</td>\n",
" </tr>\n",
" <tr>\n",
" <td>22174</td>\n",
" <td>8O_MwlZ2dEg</td>\n",
" <td>18.07.03</td>\n",
" <td>j-hope 'Airplane' MV</td>\n",
" <td>ibighit</td>\n",
" <td>10</td>\n",
" <td>2018-03-06T15:00:10.000Z</td>\n",
" <td>BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"</td>\n",
" <td>5275672</td>\n",
" <td>1401915</td>\n",
" <td>6268</td>\n",
" <td>158127</td>\n",
" <td>https://i.ytimg.com/vi/8O_MwlZ2dEg/default.jpg</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>False</td>\n",
" <td>j-hope 'Airplane' MV\\n\\n\\n\\nj-hope - 'Hope Wor...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" video_id trending_date \\\n",
"35550 7C2z4GqqS5E 18.19.05 \n",
"2201 kTlv5_Bs8aw 17.25.11 \n",
"21173 OK3GJ0WIQ8s 18.02.03 \n",
"33151 p8npDG2ulKQ 18.07.05 \n",
"3200 6ZfuNTqbHE8 17.30.11 \n",
"70 2Vv-BfVoq4g 17.14.11 \n",
"28156 kX0vO4vlJuU 18.06.04 \n",
"38352 D_6QmL6rExk 18.02.06 \n",
"33351 VYOjWnS4cMY 18.08.05 \n",
"22174 8O_MwlZ2dEg 18.07.03 \n",
"\n",
" title \\\n",
"35550 BTS (방탄소년단) 'FAKE LOVE' Official MV \n",
"2201 BTS (방탄소년단) 'MIC Drop (Steve Aoki Remix)' Offi... \n",
"21173 j-hope 'Daydream (백일몽)' MV \n",
"33151 BTS (방탄소년단) LOVE YOURSELF 轉 Tear 'Singularity'... \n",
"3200 Marvel Studios' Avengers: Infinity War Officia... \n",
"70 Ed Sheeran - Perfect (Official Music Video) \n",
"28156 BTS (방탄소년단) 'Euphoria : Theme of LOVE YOURSELF... \n",
"38352 BTS (방탄소년단) 'FAKE LOVE' Official MV (Extended ... \n",
"33351 Childish Gambino - This Is America (Official V... \n",
"22174 j-hope 'Airplane' MV \n",
"\n",
" channel_title category_id publish_time \\\n",
"35550 ibighit 10 2018-05-18T09:00:02.000Z \n",
"2201 ibighit 10 2017-11-24T09:00:02.000Z \n",
"21173 ibighit 10 2018-03-01T15:00:02.000Z \n",
"33151 ibighit 10 2018-05-06T15:00:02.000Z \n",
"3200 Marvel Entertainment 24 2017-11-29T13:26:24.000Z \n",
"70 Ed Sheeran 10 2017-11-09T11:04:14.000Z \n",
"28156 ibighit 10 2018-04-05T15:00:05.000Z \n",
"38352 ibighit 10 2018-06-01T15:00:01.000Z \n",
"33351 ChildishGambinoVEVO 10 2018-05-06T04:00:07.000Z \n",
"22174 ibighit 10 2018-03-06T15:00:10.000Z \n",
"\n",
" tags views likes \\\n",
"35550 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 39349927 3880071 \n",
"2201 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 13945717 2055137 \n",
"21173 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 10695328 2050527 \n",
"33151 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 10666323 1956202 \n",
"3200 marvel|\"comics\"|\"comic books\"|\"nerdy\"|\"geeky\"|... 37736281 1735895 \n",
"70 edsheeran|\"ed sheeran\"|\"acoustic\"|\"live\"|\"cove... 33523622 1634124 \n",
"28156 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 7518332 1572997 \n",
"38352 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\"|\"fak... 5884233 1437859 \n",
"33351 Childish Gambino|\"Rap\"|\"This Is America\"|\"mcDJ... 31648454 1405355 \n",
"22174 BIGHIT|\"빅히트\"|\"방탄소년단\"|\"BTS\"|\"BANGTAN\"|\"방탄\" 5275672 1401915 \n",
"\n",
" dislikes comment_count \\\n",
"35550 72707 692305 \n",
"2201 23888 395562 \n",
"21173 14711 387384 \n",
"33151 13966 285583 \n",
"3200 21969 241237 \n",
"70 21082 85067 \n",
"28156 8113 180262 \n",
"38352 6390 134721 \n",
"33351 51547 149473 \n",
"22174 6268 158127 \n",
"\n",
" thumbnail_link comments_disabled \\\n",
"35550 https://i.ytimg.com/vi/7C2z4GqqS5E/default.jpg False \n",
"2201 https://i.ytimg.com/vi/kTlv5_Bs8aw/default.jpg False \n",
"21173 https://i.ytimg.com/vi/OK3GJ0WIQ8s/default.jpg False \n",
"33151 https://i.ytimg.com/vi/p8npDG2ulKQ/default.jpg False \n",
"3200 https://i.ytimg.com/vi/6ZfuNTqbHE8/default.jpg False \n",
"70 https://i.ytimg.com/vi/2Vv-BfVoq4g/default.jpg False \n",
"28156 https://i.ytimg.com/vi/kX0vO4vlJuU/default.jpg False \n",
"38352 https://i.ytimg.com/vi/D_6QmL6rExk/default.jpg False \n",
"33351 https://i.ytimg.com/vi/VYOjWnS4cMY/default.jpg False \n",
"22174 https://i.ytimg.com/vi/8O_MwlZ2dEg/default.jpg False \n",
"\n",
" ratings_disabled video_error_or_removed \\\n",
"35550 False False \n",
"2201 False False \n",
"21173 False False \n",
"33151 False False \n",
"3200 False False \n",
"70 False False \n",
"28156 False False \n",
"38352 False False \n",
"33351 False False \n",
"22174 False False \n",
"\n",
" description \n",
"35550 BTS (방탄소년단) 'FAKE LOVE' Official MVDirector : ... \n",
"2201 BTS (방탄소년단) 'MIC Drop (Steve Aoki Remix)' Offi... \n",
"21173 j-hope 'Daydream (백일몽)'\\n\\n\\nj-hope's 'Daydrea... \n",
"33151 BTS (방탄소년단) LOVE YOURSELF 轉 Tear 'Singularity'... \n",
"3200 There was an idea… Avengers: Infinity War. In ... \n",
"70 🎧: https://ad.gt/yt-perfect\\n💰: https://atlant... \n",
"28156 BTS (방탄소년단) 'Euphoria : Theme of LOVE YOURSELF... \n",
"38352 BTS (방탄소년단) 'FAKE LOVE' Official MV (Extended ... \n",
"33351 “This is America” by Childish Gambino http://s... \n",
"22174 j-hope 'Airplane' MV\\n\\n\\n\\nj-hope - 'Hope Wor... "
]
},
"execution_count": 33,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"frame2 = frame.drop(index=frame[frame.video_id.duplicated()].index)\n",
"# 喜欢数Top10视频\n",
"frame2.sort_values('likes', ascending=False)[:10]"
]
},
{
"cell_type": "code",
"execution_count": 34,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"channel_title\n",
"12 News 2\n",
"1MILLION Dance Studio 33\n",
"1theK (원더케이) 19\n",
"20th Century Fox 135\n",
"2CELLOS 2\n",
" ... \n",
"ワーナー ブラザース 公式チャンネル 6\n",
"圧倒的不審者の極み! 12\n",
"杰威爾音樂 JVR Music 29\n",
"郭韋辰 2\n",
"영국남자 Korean Englishman 6\n",
"Length: 2207, dtype: int64"
]
},
"execution_count": 34,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 根据频道分组查看每个频道视频数量\n",
"frame.groupby('channel_title').size()"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"channel_title\n",
"ESPN 203\n",
"The Tonight Show Starring Jimmy Fallon 197\n",
"Vox 193\n",
"TheEllenShow 193\n",
"Netflix 193\n",
"The Late Show with Stephen Colbert 187\n",
"Jimmy Kimmel Live 186\n",
"Late Night with Seth Meyers 183\n",
"Screen Junkies 182\n",
"NBA 181\n",
"dtype: int64"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 找出视频数量最多的频道Top10\n",
"frame.groupby('channel_title').size().sort_values(ascending=False)[:10]"
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Text(0.5, 1.0, 'Top 10 Channels')"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAugAAAI+CAYAAADuPf+iAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjAsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+17YcXAAAgAElEQVR4nOzdd5yU5bn/8c+1hbow9KqwKOoMuEhTQEGwxYKaGJOYRGNJMcR004g50U05CUk0poiaHnKSX3rMSUKOsaCADRUFUcYugvQiZQtbZq7fHzPoCgtb2Nl7yvf9eu2L3WeeuZ/vzC47195zPfdj7o6IiIiIiGSHotABRERERETkTSrQRURERESyiAp0EREREZEsogJdRERERCSLqEAXEREREckiKtBFRERERLKICnQREck4M5tjZveEzrE/M/uDmf1X6BwiIk2pQBcRySJmVtXkI2lmtU2+vrSDj3WpmT2cPsadzdx+opmtMLMaM3vUzI5vYbzZZvZAOusWM1tkZud2ZGYRkUKgAl1EJIu4e9m+D2AtcEGTbb/r4MNtB24Cvr//DWbWHfhf4KdAX+DPwB1mVtLcQOk/Hv4f8DNgGDAU+G/g7R2cWUQk76lAFxHJIWbW3czmm9lGM3vNzL5nZqXp284xsxfN7GtmtsPMXjGzdx9sLHe/093/Amxs5uazgL3ufqu715Eq5HsB05vJVJK+/b/cfYG773b3hLvf6+5z3rqr/cjMdprZS2Z2ZpMbPmpmz5rZnvRj+GCT2/Y9ruvMbKuZrW/6bkK6TeUHZvaf9P0fNLORTW4/Pj2b/7qZxc3sHQd5boeY2Z3pfNvNbNHBnjsRkUxSgS4iklu+BowDKoBJwCzgi01uLwe6AEOAjwALzGxUO44zFli57wt3TwJPp7fv73hgMPCXFsY8FXgc6A/cAvy8yW0bgXOB3sAcYL6ZNT3WSMBIzc5/ArjdzMqa3P5+4MtAv/RYXwMws97A3cAvgAHA5cAvzWx0M/m+BDyX3m8oUNnC4xERyQgV6CIiueVS4AZ33+bum4FvAh9ocnsj8DV3r3f3e4B7gHe14zhlwK79tu0iNYu+v/6AA5tbGPM5d/+NuyeABcBIM+sD4O7/cPdXPOUeYDFvna2vAb7t7g3ufkf6eE2L7D+5+xPu3kCq1WZ8evtFwNPu/rv0rP5jwD+Bi5vJ10DqD4AR6edvSQuPR0QkI1Sgi4jkCDMzUjPjrzbZ/CowvMnXW9197363D2vH4apIzWY31RvY08y+20nNbg9uYcxNTT6vSf9bBmBmF6ZPRN1hZjuB00nNZO+zNT2L3/T+TWfQ9x97320jgVPTbSs702NfTGqGfH//DWwA7ku31FzbwuMREckIFegiIjnC3Z1UITqyyeYRwPomXw8ws2773b6hHYd7Bjhh3xdmVkSqleWZZvZ9mtTseXOz0i0ys56kTkL9BjDI3fsAi0gV/YdrHXCXu/dp8lHm7p/Zf0d33+Xun3b3kaQey3+Z2SkdkEFEpE1UoIuI5JbfAzeYWX8zGwR8Bfhtk9tLga+aWRczO53UyZ5/bW4gMytOF/MlQJGZdWuySsvdQPf0+uVdgc8C1cAD+4/j7o3A54FvmtkHzKyXmRWZ2Uwzu7UVj6l7OvcWIGlmF5Lqre8IfwcmmNklZlaafl6mmtmx+++YnsU/Kv1OxS4gAST3309EJNNUoIuI5JbrgdWkZrJXAA8C321y+xpSfeibgF8CV7n7ywcZ6yNALXAzqUK+ltTJm7h7LaklEucAO4H3Au9IF+MHcPffApel99+YPv4NpJZqPCR330aqwP8nqXaZdwD/bul+reHurwNnA1elc20g1bdf2szuMeA+Um08S4Ab3f3hjsghItIWlnrHVEREcp2ZnQPc4u7NrVAiIiI5QjPoIiIiIiJZRAW6iIiIiEgWUYuLiIiIiEgW0Qy6iIiIiEgWUYEuIiIiIpJFVKCLiIiIiGQRFegiIiIiIllEBbqIiIiISBZRgS4iIiIikkVUoIuIiIiIZBEV6CIiIiIiWUQFuoiIiIhIFlGBLiIiIiKSRVSgi4iIiIhkERXoIiIiIiJZRAW6iIiIiEgWUYEuIiIiIpJFVKCLiIiIiGQRFegiIiIiIllEBbqIiIiISBZRgS4iIiIikkVUoIuIiIiIZBEV6CIiIiIiWUQFuoiIiIhIFlGBLiIiIiKSRVSgi4iIiIhkERXoIiIiIiJZRAW6iIiIiEgWUYEuIiIiIpJFVKCLiIiIiGQRFegiIiIiIllEBbqIiIiISBZRgS4iIiIikkVUoIuI5Akzu8/Mzt5v22fM7LZQmUREpO1UoIuI5I/fA+/db9t709tFRCRHqEAXEckffwFmm1kXADMrB4YBS83se2b2tJmtMrNL0rdfZGb3WspQM3vezIYESy8iIoAKdBGRvOHuO4BHgXPTm94L/Al4JzAeOAE4E/iemQ119zuAjcDHgZ8BN7j7pk4PLiIib6ECXUQkvzRtc9nX3jId+L27J9x9M7AYODG9zyeBLwN17q5WGBGRLKACXUQkv/wvcIaZTQR6uPvyFvY/AkgCg81MrwkiIllAv4xFRPKIu1cB9wG/5M2TQ5cCl5hZsZkNBE4FHjWzkvR+7wPiwLUBIouIyH5KQgcQEZEO93vgDt5sdbkDmAasBBz4ortvMrPrgaXu/oCZrQQeM7OF7h4PklpERAAwdw+dQURERERE0tTiIiIiIiKSRVSgi4iIiIhkERXoIiIiIiJZRAW6iIiIiEgWUYEuIiIiIpJFVKCLiIiIiGQRFegiIiIiIllEBbqIiIiISBZRgS4iIiIikkVUoIuIiIiIZBEV6CIiIiIiWUQFuoiIiIhIFlGBLiIiIiKSRVSgi4iIiIhkERXoIiIiIiJZRAW6iIiIiEgWUYEuIiIiIpJFSkIHEBGR7FaxoKIY6A1Emnz0SW8rAZKAp/9t+tGabQ5UA1uBLauuWLW7sx6XiEi2MncPnUFERDpRxYIKA4YDQ4FB6Y/BTT7f99GfVDFeBlgnxaslXawDm9P/HuzzrauuWJXopFwiIp1GBbqISJ6qWFBRBhwHRPf79xige8BoHSUJ7CBVrG8A4sAzwNPAM6uuWLUzYDYRkXZTgS4iksPSs+EjSRXe+xfjwwJGywYbSBXsb/lQG42IZDsV6CIiOaJiQUUEOAWYQqoAj5I/s+Gd6TUOLNxXr7pi1Z6gqURE0lSgi4hkqYoFFcOBGcD09L/Ho9W3MsWBV4GHgKXpj9WrrlilF0kR6XQq0EVEskTFgooYbxbjM4DyoIFkO/AgbxbsT6y6YlVD2EgiUghUoIuIBFCxoKIEmMibxfgpwICgoeSQitzXrlyz7jngnvTHk1Tu0ouoiHQ4FegiIp2kYkHFeOBCYCYwFegRNpG0xciGhof/9drGaU02bQPuI1Ws303lrlfCJBORfKMCXUQkQ9IrrEwBLgbeCRwVNpEcjqt27l5y7es7Tz3ELi8DdwF/Ae6ncpfWaBeRdlGBLiLSgdJX3ZxBqii/iNQFgSQP/PW1ja8c29AwqpW7bwb+CvwRWKpWGBFpCxXoIiKHqWJBRSlwBqmi/O3AwLCJpKMVuW9euWbd4HbefT3wZ+CPVO56pANjiUieUoEuItIOFQsqugNnkyrKzwf6hE0kmVRe3/DQP9dvPLkDhnoV+BOpYn15B4yX1cysP3Bv+sshQALYSmqFog3uPqYdY14FfDr95RjgufS4d7r73DaOVQzc7+4zWtjvNeB4d9+53/bTgRp3P+APLzMbCvyC1LtopcCL7n6hmZ0JfMLd39GWrK1lZjHgdiACdCX1+D5mZhOBQe5+52GO36rnrJVjvfFcmNlFwGh3/97hjtvOHH8F9p1Hstndzz7E/h8m9fPwGTP7JrDN3X/QkZlKOnIwEZF8VrGgoidwAami/FygZ9hE0lnOrKnpqH7ykcAXgC9QGXmRVAvMH6nctaqDxs8q7r4dGA9gZpVAlbvfaGblwL/aOeavgF+lx1wDnObu29o5VoJUS1p7nU7qZOHm3hn5JrDQ3ecDmNm4wzhOW9wCfNfdF5qZkbp
"text/plain": [
"<Figure size 1440x720 with 1 Axes>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"%matplotlib inline\n",
"\n",
"import matplotlib.pyplot as plt\n",
"# 绘制饼图\n",
"top10 = frame.groupby('channel_title').size().sort_values(ascending=False)[:10]\n",
"top10.plot.pie(figsize=(20, 10), autopct='%.2f%%')\n",
"plt.title('Top 10 Channels')"
]
},
{
"cell_type": "code",
"execution_count": 37,
"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>video_count</th>\n",
" </tr>\n",
" <tr>\n",
" <th>channel_title</th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <td>ESPN</td>\n",
" <td>203</td>\n",
" </tr>\n",
" <tr>\n",
" <td>The Tonight Show Starring Jimmy Fallon</td>\n",
" <td>197</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Vox</td>\n",
" <td>193</td>\n",
" </tr>\n",
" <tr>\n",
" <td>TheEllenShow</td>\n",
" <td>193</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Netflix</td>\n",
" <td>193</td>\n",
" </tr>\n",
" <tr>\n",
" <td>The Late Show with Stephen Colbert</td>\n",
" <td>187</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Jimmy Kimmel Live</td>\n",
" <td>186</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Late Night with Seth Meyers</td>\n",
" <td>183</td>\n",
" </tr>\n",
" <tr>\n",
" <td>Screen Junkies</td>\n",
" <td>182</td>\n",
" </tr>\n",
" <tr>\n",
" <td>NBA</td>\n",
" <td>181</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" video_count\n",
"channel_title \n",
"ESPN 203\n",
"The Tonight Show Starring Jimmy Fallon 197\n",
"Vox 193\n",
"TheEllenShow 193\n",
"Netflix 193\n",
"The Late Show with Stephen Colbert 187\n",
"Jimmy Kimmel Live 186\n",
"Late Night with Seth Meyers 183\n",
"Screen Junkies 182\n",
"NBA 181"
]
},
"execution_count": 37,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# 将Series转成DataFrame\n",
"frame3 = frame.groupby('channel_title').size().sort_values(ascending=False)[:10].to_frame('video_count')\n",
"frame3"
]
},
{
"cell_type": "code",
"execution_count": 38,
"metadata": {},
"outputs": [],
"source": [
"# 将数据写入CVS文件\n",
"frame3.to_csv('result.csv')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"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.7.6"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Reference in New Issue Copy Permalink