Created
October 24, 2023 14:49
-
-
Save kashinoki38/7a9d82c1f48f45f76898ff64bf4552da to your computer and use it in GitHub Desktop.
2022 Youtube history analysis
This file contains hidden or 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": 116, | |
| "id": "d945a889-093b-4ff6-b2aa-bd1dc548f208", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "# htmlからDFを作る\n", | |
| "import pandas as pd\n", | |
| "from bs4 import BeautifulSoup\n", | |
| "\n", | |
| "# fname = './history/watch-history.html'\n", | |
| "fname = './data/YouTube と YouTube Music/履歴/watch-history.html'\n", | |
| "f = open(fname, 'r', encoding='utf-8')\n", | |
| "text = f.read()\n", | |
| "\n", | |
| "soup = BeautifulSoup(text, 'lxml')\n", | |
| "body = soup.find(\"body\")\n", | |
| "items = body.find_all( \"div\", attrs={\"class\": \"outer-cell mdl-cell mdl-cell--12-col mdl-shadow--2dp\"} )\n", | |
| "\n", | |
| "rows = []\n", | |
| "for item in items:\n", | |
| " divs = item.find(\"div\", attrs={\"class\": \"content-cell mdl-cell mdl-cell--6-col mdl-typography--body-1\"})\n", | |
| " tmp = [ i for i in divs ]\n", | |
| " if len(tmp) == 6:\n", | |
| " links = divs.find_all(\"a\")\n", | |
| " # print (tmp[0],tmp[3],tmp[5])\n", | |
| " watchtime = tmp[-1]\n", | |
| " for l in links:\n", | |
| " url = l.get('href')\n", | |
| " if url.find('channel') == -1:\n", | |
| " titleUrl = url\n", | |
| " titleText = l.text\n", | |
| " else:\n", | |
| " channelUrl = url\n", | |
| " channelText = l.text\n", | |
| " # print (titleText, channelText)\n", | |
| " # print (titleUrl, channelUrl)\n", | |
| " rows.append( [ watchtime, titleText, channelText, titleUrl, channelUrl ] )\n", | |
| "\n", | |
| "\n", | |
| "df = pd.DataFrame( rows, columns=['time', 'title', 'channel', 'titleUrl', 'channelUrl'] )\n", | |
| "# print (df)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 117, | |
| "id": "3ea516e7-e523-401c-940d-1d1f075d591f", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "# 2022年だけに絞る\n", | |
| "df = df.query('time >= \"2022-1-1\" & time < \"2023-1-1\"')\n" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 118, | |
| "id": "182f8000-14dc-4831-9037-c22371296733", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stderr", | |
| "output_type": "stream", | |
| "text": [ | |
| "/var/folders/kl/wr5jnx_j38j78hl0d1vyhrlr0000gn/T/ipykernel_3727/3584999029.py:2: FutureWarning: Parsing 'JST' as tzlocal (dependent on system timezone) is deprecated and will raise in a future version. Pass the 'tz' keyword or call tz_localize after construction instead\n", | |
| " df['time'] = pd.to_datetime(df['time'])\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "# datetime変換\n", | |
| "df['time'] = pd.to_datetime(df['time'])\n", | |
| "df['month'] = df['time'].dt.month" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 119, | |
| "id": "19df428e-34a3-410e-bc94-3c90c13ed825", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "df = df.drop('channelUrl', axis=1)\n", | |
| "df = df.drop('titleUrl', axis=1)\n", | |
| "df = df.drop('title', axis=1)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 120, | |
| "id": "0126d4b9-ab53-4a86-87f4-87bcfbbf2951", | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/plain": [ | |
| "Index([' American video', ' Dragon Mania', ' SHAKA Ad Channel', ' Sleepy boy',\n", | |
| " ' ひろゆき, こんなコト言ってるよ', ' バート・ウィザースがキャラなどの解説をするチャンネル',\n", | |
| " ' ホリエモンのタイムマシン2【堀江貴文 切り抜き】※旧 ホリエモンのセカイ', ' ホリエモンの行ってらっしゃい', '!星の屑大作戦!',\n", | |
| " '#ハット3-hatto3',\n", | |
| " ...\n", | |
| " '𝑅𝑜𝑙𝑒𝑠_روليس', '𝕀𝕍𝔸 𝔱𝔥𝔢 𝑬𝓪𝓰𝒍𝓮', '𝕼𝖔𝖔𝕭𝕬𝕭𝖄 𝕮𝖍𝖆𝖓𝖓𝖊𝖑', '𝙰𝚎𝚜𝚝_𝚜𝚘𝚗𝚎𝚊',\n", | |
| " '🌸Lili Art🌸', '🍠さつまりこ🥔', '🏸᚛Badᴍiήtoภ᚜', '🐯春虎です‼️', '😻福はこび😻', 'All'],\n", | |
| " dtype='object', name='channel', length=5759)" | |
| ] | |
| }, | |
| "execution_count": 120, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "df_pivot = pd.pivot_table(df, index='channel', columns='month', aggfunc=len, margins=True)\n", | |
| "df_pivot\n", | |
| "\n", | |
| "df_pivot.index" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 121, | |
| "id": "d30c3e41-5142-4401-b05e-101c4708ff7e", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "df_pivot = df_pivot.sort_values(by=('time','All'), ascending=False)\n", | |
| "# df_pivot = df_pivot.sort_index()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 122, | |
| "id": "c451d8cb-89d6-4a47-912d-5773374fa5bc", | |
| "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 tr th {\n", | |
| " text-align: left;\n", | |
| " }\n", | |
| "\n", | |
| " .dataframe thead tr:last-of-type th {\n", | |
| " text-align: right;\n", | |
| " }\n", | |
| "</style>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr>\n", | |
| " <th></th>\n", | |
| " <th colspan=\"13\" halign=\"left\">time</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>month</th>\n", | |
| " <th>1</th>\n", | |
| " <th>2</th>\n", | |
| " <th>3</th>\n", | |
| " <th>4</th>\n", | |
| " <th>5</th>\n", | |
| " <th>6</th>\n", | |
| " <th>7</th>\n", | |
| " <th>8</th>\n", | |
| " <th>9</th>\n", | |
| " <th>10</th>\n", | |
| " <th>11</th>\n", | |
| " <th>12</th>\n", | |
| " <th>All</th>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>channel</th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " <th></th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>All</th>\n", | |
| " <td>1141.0</td>\n", | |
| " <td>2281.0</td>\n", | |
| " <td>1669.0</td>\n", | |
| " <td>1525.0</td>\n", | |
| " <td>1049.0</td>\n", | |
| " <td>2657.0</td>\n", | |
| " <td>2302.0</td>\n", | |
| " <td>993.0</td>\n", | |
| " <td>1233.0</td>\n", | |
| " <td>628.0</td>\n", | |
| " <td>1273.0</td>\n", | |
| " <td>1712.0</td>\n", | |
| " <td>18463</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>しもふりチューブ</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>18.0</td>\n", | |
| " <td>66.0</td>\n", | |
| " <td>25.0</td>\n", | |
| " <td>34.0</td>\n", | |
| " <td>74.0</td>\n", | |
| " <td>53.0</td>\n", | |
| " <td>29.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>21.0</td>\n", | |
| " <td>341</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>かまいたちチャンネル</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>67.0</td>\n", | |
| " <td>25.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>93.0</td>\n", | |
| " <td>79.0</td>\n", | |
| " <td>294</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>関優太</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>30.0</td>\n", | |
| " <td>104.0</td>\n", | |
| " <td>86.0</td>\n", | |
| " <td>10.0</td>\n", | |
| " <td>23.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>269</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>【公式】オードリーさん、ぜひ会ってほしい人がいるんです。</th>\n", | |
| " <td>2.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>127.0</td>\n", | |
| " <td>35.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>217</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>かまいたちMC ABEMA 「ぜにいたち」【公式】</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>20.0</td>\n", | |
| " <td>51.0</td>\n", | |
| " <td>40.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>196</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>THE FIRST TAKE</th>\n", | |
| " <td>16.0</td>\n", | |
| " <td>38.0</td>\n", | |
| " <td>31.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>20.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>39.0</td>\n", | |
| " <td>192</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>しくじり先生 俺みたいになるな!!【公式】</th>\n", | |
| " <td>85.0</td>\n", | |
| " <td>31.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>24.0</td>\n", | |
| " <td>17.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>182</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ボキアートch</th>\n", | |
| " <td>4.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>31.0</td>\n", | |
| " <td>25.0</td>\n", | |
| " <td>17.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>31.0</td>\n", | |
| " <td>152</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>SHAKAch</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>72.0</td>\n", | |
| " <td>20.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>146</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>OFFICIAL HIGE DANDISM - Topic</th>\n", | |
| " <td>9.0</td>\n", | |
| " <td>58.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>18.0</td>\n", | |
| " <td>24.0</td>\n", | |
| " <td>142</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>TWICE - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>44.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>42.0</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>135</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ABEMA チャンスの時間 【公式】</th>\n", | |
| " <td>5.0</td>\n", | |
| " <td>28.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>21.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>128</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ABEMA Prime #アベプラ【公式】</th>\n", | |
| " <td>5.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>21.0</td>\n", | |
| " <td>29.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>36.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>127</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>たつろう</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>45.0</td>\n", | |
| " <td>50.0</td>\n", | |
| " <td>19.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>114</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Amazon Web Services Japan 公式</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>17.0</td>\n", | |
| " <td>18.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>18.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>112</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Avicii - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>32.0</td>\n", | |
| " <td>78.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>111</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Official髭男dism</th>\n", | |
| " <td>6.0</td>\n", | |
| " <td>52.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>107</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>JYP Entertainment</th>\n", | |
| " <td>11.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>37.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>104</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ABEMA 愛のハイエナ【公式】</th>\n", | |
| " <td>2.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>10.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>16.0</td>\n", | |
| " <td>99</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Yuki Hayashi - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>76.0</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>98</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>マツヤマイカ Maika Matsuya</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>73.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>86</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>IVE - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>48.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>24.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>84</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ひろすき【切り抜き】</th>\n", | |
| " <td>20.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>21.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>83</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>太田上田【公式】</th>\n", | |
| " <td>20.0</td>\n", | |
| " <td>23.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>82</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>【ほりぬき】衒学者・堀元見の切り抜きチャンネル【公認】</th>\n", | |
| " <td>56.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>76</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>King Gnu - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>28.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>75</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>動画、はじめてみました【テレビ朝日公式】</th>\n", | |
| " <td>3.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>10.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>70</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Kep1er - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>27.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>26.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>68</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>MicroPumpkin【Music】</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>27.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>68</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>YOASOBI - Topic</th>\n", | |
| " <td>1.0</td>\n", | |
| " <td>31.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>67</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>back number - Topic</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>64</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ライブドアニュース</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>39.0</td>\n", | |
| " <td>20.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>63</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>NewsPicks /ニューズピックス</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>18.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>62</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>aimyon - Topic</th>\n", | |
| " <td>4.0</td>\n", | |
| " <td>27.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>61</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>カカ姉妹</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>52.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>59</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>粗品のロケ</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>10.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>59</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>泉ノ波あみの「あみです、どうも」</th>\n", | |
| " <td>20.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>59</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>TWICE</th>\n", | |
| " <td>13.0</td>\n", | |
| " <td>15.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>58</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>TIE Ru</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>13.0</td>\n", | |
| " <td>39.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>58</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ジャルジャルタワー JARUJARU TOWER</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>11.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>54</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>岡野タケシ弁護士【アトム法律事務所】</th>\n", | |
| " <td>8.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>54</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>King Gnu official YouTube channel</th>\n", | |
| " <td>5.0</td>\n", | |
| " <td>12.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>10.0</td>\n", | |
| " <td>51</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ABEMA バラエティ【公式】</th>\n", | |
| " <td>6.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>20.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>51</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>MOS</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>8.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>50</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>粗品 Official Channel</th>\n", | |
| " <td>9.0</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>5.0</td>\n", | |
| " <td>26.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>49</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Kep1er</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>22.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>7.0</td>\n", | |
| " <td>48</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>Yorushika - Topic</th>\n", | |
| " <td>3.0</td>\n", | |
| " <td>17.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>3.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>45</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>ずっと真夜中でいいのに。 ZUTOMAYO</th>\n", | |
| " <td>4.0</td>\n", | |
| " <td>14.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>1.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>6.0</td>\n", | |
| " <td>9.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>4.0</td>\n", | |
| " <td>44</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>SPYGEA / スパイギア</th>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>24.0</td>\n", | |
| " <td>16.0</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>2.0</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>44</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " time \\\n", | |
| "month 1 2 3 4 5 \n", | |
| "channel \n", | |
| "All 1141.0 2281.0 1669.0 1525.0 1049.0 \n", | |
| "しもふりチューブ NaN 18.0 66.0 25.0 34.0 \n", | |
| "かまいたちチャンネル NaN NaN NaN NaN 4.0 \n", | |
| "関優太 1.0 30.0 104.0 86.0 10.0 \n", | |
| "【公式】オードリーさん、ぜひ会ってほしい人がいるんです。 2.0 14.0 NaN 8.0 8.0 \n", | |
| "かまいたちMC ABEMA 「ぜにいたち」【公式】 NaN 9.0 15.0 4.0 6.0 \n", | |
| "THE FIRST TAKE 16.0 38.0 31.0 4.0 1.0 \n", | |
| "しくじり先生 俺みたいになるな!!【公式】 85.0 31.0 3.0 8.0 NaN \n", | |
| "ボキアートch 4.0 6.0 31.0 25.0 17.0 \n", | |
| "SHAKAch NaN 19.0 72.0 20.0 6.0 \n", | |
| "OFFICIAL HIGE DANDISM - Topic 9.0 58.0 NaN NaN 1.0 \n", | |
| "TWICE - Topic NaN 1.0 NaN NaN NaN \n", | |
| "ABEMA チャンスの時間 【公式】 5.0 28.0 14.0 8.0 2.0 \n", | |
| "ABEMA Prime #アベプラ【公式】 5.0 NaN NaN NaN NaN \n", | |
| "たつろう NaN NaN NaN NaN NaN \n", | |
| "Amazon Web Services Japan 公式 1.0 8.0 7.0 6.0 5.0 \n", | |
| "Avicii - Topic NaN NaN NaN NaN NaN \n", | |
| "Official髭男dism 6.0 52.0 14.0 NaN 3.0 \n", | |
| "JYP Entertainment 11.0 14.0 5.0 NaN NaN \n", | |
| "ABEMA 愛のハイエナ【公式】 2.0 8.0 14.0 12.0 10.0 \n", | |
| "Yuki Hayashi - Topic NaN NaN NaN NaN NaN \n", | |
| "マツヤマイカ Maika Matsuya NaN NaN NaN NaN NaN \n", | |
| "IVE - Topic NaN NaN NaN NaN NaN \n", | |
| "ひろすき【切り抜き】 20.0 12.0 11.0 4.0 NaN \n", | |
| "太田上田【公式】 20.0 23.0 NaN 8.0 NaN \n", | |
| "【ほりぬき】衒学者・堀元見の切り抜きチャンネル【公認】 56.0 8.0 1.0 NaN NaN \n", | |
| "King Gnu - Topic NaN 28.0 4.0 1.0 1.0 \n", | |
| "動画、はじめてみました【テレビ朝日公式】 3.0 8.0 2.0 8.0 8.0 \n", | |
| "Kep1er - Topic NaN NaN NaN NaN NaN \n", | |
| "MicroPumpkin【Music】 NaN 27.0 14.0 NaN 3.0 \n", | |
| "YOASOBI - Topic 1.0 31.0 1.0 NaN NaN \n", | |
| "back number - Topic NaN 22.0 2.0 NaN 2.0 \n", | |
| "ライブドアニュース NaN NaN 1.0 NaN NaN \n", | |
| "NewsPicks /ニューズピックス NaN 5.0 NaN 3.0 1.0 \n", | |
| "aimyon - Topic 4.0 27.0 1.0 1.0 1.0 \n", | |
| "カカ姉妹 NaN NaN NaN NaN NaN \n", | |
| "粗品のロケ NaN 6.0 6.0 10.0 14.0 \n", | |
| "泉ノ波あみの「あみです、どうも」 20.0 15.0 NaN 4.0 5.0 \n", | |
| "TWICE 13.0 15.0 4.0 NaN NaN \n", | |
| "TIE Ru NaN 13.0 39.0 3.0 1.0 \n", | |
| "ジャルジャルタワー JARUJARU TOWER NaN 7.0 NaN NaN 9.0 \n", | |
| "岡野タケシ弁護士【アトム法律事務所】 8.0 9.0 7.0 5.0 2.0 \n", | |
| "King Gnu official YouTube channel 5.0 12.0 8.0 NaN 1.0 \n", | |
| "ABEMA バラエティ【公式】 6.0 2.0 1.0 NaN 1.0 \n", | |
| "MOS NaN NaN NaN NaN 14.0 \n", | |
| "粗品 Official Channel 9.0 1.0 NaN 5.0 26.0 \n", | |
| "Kep1er NaN NaN NaN NaN NaN \n", | |
| "Yorushika - Topic 3.0 17.0 3.0 NaN 1.0 \n", | |
| "ずっと真夜中でいいのに。 ZUTOMAYO 4.0 14.0 4.0 NaN NaN \n", | |
| "SPYGEA / スパイギア NaN NaN 24.0 16.0 2.0 \n", | |
| "\n", | |
| " \\\n", | |
| "month 6 7 8 9 10 \n", | |
| "channel \n", | |
| "All 2657.0 2302.0 993.0 1233.0 628.0 \n", | |
| "しもふりチューブ 74.0 53.0 29.0 5.0 9.0 \n", | |
| "かまいたちチャンネル 13.0 11.0 67.0 25.0 2.0 \n", | |
| "関優太 23.0 15.0 NaN NaN NaN \n", | |
| "【公式】オードリーさん、ぜひ会ってほしい人がいるんです。 127.0 35.0 7.0 NaN 8.0 \n", | |
| "かまいたちMC ABEMA 「ぜにいたち」【公式】 20.0 51.0 40.0 14.0 5.0 \n", | |
| "THE FIRST TAKE 22.0 1.0 NaN 20.0 1.0 \n", | |
| "しくじり先生 俺みたいになるな!!【公式】 24.0 17.0 7.0 1.0 1.0 \n", | |
| "ボキアートch 12.0 11.0 NaN NaN NaN \n", | |
| "SHAKAch 15.0 13.0 1.0 NaN NaN \n", | |
| "OFFICIAL HIGE DANDISM - Topic 2.0 1.0 7.0 19.0 3.0 \n", | |
| "TWICE - Topic 2.0 NaN 15.0 44.0 9.0 \n", | |
| "ABEMA チャンスの時間 【公式】 21.0 4.0 6.0 7.0 3.0 \n", | |
| "ABEMA Prime #アベプラ【公式】 21.0 29.0 15.0 36.0 19.0 \n", | |
| "たつろう 45.0 50.0 19.0 NaN NaN \n", | |
| "Amazon Web Services Japan 公式 8.0 17.0 18.0 11.0 11.0 \n", | |
| "Avicii - Topic NaN NaN NaN 32.0 78.0 \n", | |
| "Official髭男dism 4.0 2.0 3.0 1.0 NaN \n", | |
| "JYP Entertainment 2.0 1.0 13.0 37.0 1.0 \n", | |
| "ABEMA 愛のハイエナ【公式】 6.0 9.0 3.0 7.0 6.0 \n", | |
| "Yuki Hayashi - Topic NaN NaN NaN NaN NaN \n", | |
| "マツヤマイカ Maika Matsuya 73.0 12.0 NaN 1.0 NaN \n", | |
| "IVE - Topic NaN NaN NaN 48.0 6.0 \n", | |
| "ひろすき【切り抜き】 12.0 21.0 2.0 NaN 1.0 \n", | |
| "太田上田【公式】 22.0 1.0 1.0 NaN 4.0 \n", | |
| "【ほりぬき】衒学者・堀元見の切り抜きチャンネル【公認】 NaN NaN NaN NaN NaN \n", | |
| "King Gnu - Topic 3.0 1.0 3.0 7.0 1.0 \n", | |
| "動画、はじめてみました【テレビ朝日公式】 22.0 10.0 4.0 1.0 NaN \n", | |
| "Kep1er - Topic NaN NaN NaN 27.0 6.0 \n", | |
| "MicroPumpkin【Music】 3.0 NaN 3.0 2.0 NaN \n", | |
| "YOASOBI - Topic 1.0 1.0 6.0 6.0 NaN \n", | |
| "back number - Topic 1.0 1.0 9.0 11.0 2.0 \n", | |
| "ライブドアニュース NaN NaN NaN 39.0 20.0 \n", | |
| "NewsPicks /ニューズピックス 11.0 11.0 5.0 18.0 5.0 \n", | |
| "aimyon - Topic 1.0 NaN 11.0 8.0 1.0 \n", | |
| "カカ姉妹 52.0 4.0 2.0 NaN NaN \n", | |
| "粗品のロケ 2.0 13.0 7.0 1.0 NaN \n", | |
| "泉ノ波あみの「あみです、どうも」 11.0 2.0 NaN NaN NaN \n", | |
| "TWICE 2.0 2.0 7.0 8.0 1.0 \n", | |
| "TIE Ru 1.0 1.0 NaN NaN NaN \n", | |
| "ジャルジャルタワー JARUJARU TOWER 11.0 4.0 4.0 12.0 5.0 \n", | |
| "岡野タケシ弁護士【アトム法律事務所】 9.0 12.0 2.0 NaN NaN \n", | |
| "King Gnu official YouTube channel 3.0 2.0 3.0 3.0 NaN \n", | |
| "ABEMA バラエティ【公式】 9.0 20.0 3.0 NaN NaN \n", | |
| "MOS 8.0 9.0 6.0 4.0 1.0 \n", | |
| "粗品 Official Channel 6.0 NaN 1.0 NaN 1.0 \n", | |
| "Kep1er NaN 1.0 NaN 22.0 4.0 \n", | |
| "Yorushika - Topic 3.0 2.0 2.0 6.0 NaN \n", | |
| "ずっと真夜中でいいのに。 ZUTOMAYO 1.0 NaN 6.0 9.0 NaN \n", | |
| "SPYGEA / スパイギア NaN 2.0 NaN NaN NaN \n", | |
| "\n", | |
| " \n", | |
| "month 11 12 All \n", | |
| "channel \n", | |
| "All 1273.0 1712.0 18463 \n", | |
| "しもふりチューブ 7.0 21.0 341 \n", | |
| "かまいたちチャンネル 93.0 79.0 294 \n", | |
| "関優太 NaN NaN 269 \n", | |
| "【公式】オードリーさん、ぜひ会ってほしい人がいるんです。 6.0 2.0 217 \n", | |
| "かまいたちMC ABEMA 「ぜにいたち」【公式】 13.0 19.0 196 \n", | |
| "THE FIRST TAKE 19.0 39.0 192 \n", | |
| "しくじり先生 俺みたいになるな!!【公式】 4.0 1.0 182 \n", | |
| "ボキアートch 15.0 31.0 152 \n", | |
| "SHAKAch NaN NaN 146 \n", | |
| "OFFICIAL HIGE DANDISM - Topic 18.0 24.0 142 \n", | |
| "TWICE - Topic 42.0 22.0 135 \n", | |
| "ABEMA チャンスの時間 【公式】 11.0 19.0 128 \n", | |
| "ABEMA Prime #アベプラ【公式】 2.0 NaN 127 \n", | |
| "たつろう NaN NaN 114 \n", | |
| "Amazon Web Services Japan 公式 18.0 2.0 112 \n", | |
| "Avicii - Topic 1.0 NaN 111 \n", | |
| "Official髭男dism 9.0 13.0 107 \n", | |
| "JYP Entertainment 12.0 8.0 104 \n", | |
| "ABEMA 愛のハイエナ【公式】 6.0 16.0 99 \n", | |
| "Yuki Hayashi - Topic 76.0 22.0 98 \n", | |
| "マツヤマイカ Maika Matsuya NaN NaN 86 \n", | |
| "IVE - Topic 24.0 6.0 84 \n", | |
| "ひろすき【切り抜き】 NaN NaN 83 \n", | |
| "太田上田【公式】 2.0 1.0 82 \n", | |
| "【ほりぬき】衒学者・堀元見の切り抜きチャンネル【公認】 11.0 NaN 76 \n", | |
| "King Gnu - Topic 13.0 13.0 75 \n", | |
| "動画、はじめてみました【テレビ朝日公式】 NaN 4.0 70 \n", | |
| "Kep1er - Topic 26.0 9.0 68 \n", | |
| "MicroPumpkin【Music】 5.0 11.0 68 \n", | |
| "YOASOBI - Topic 9.0 11.0 67 \n", | |
| "back number - Topic 8.0 6.0 64 \n", | |
| "ライブドアニュース 3.0 NaN 63 \n", | |
| "NewsPicks /ニューズピックス 2.0 1.0 62 \n", | |
| "aimyon - Topic 3.0 3.0 61 \n", | |
| "カカ姉妹 NaN 1.0 59 \n", | |
| "粗品のロケ NaN NaN 59 \n", | |
| "泉ノ波あみの「あみです、どうも」 2.0 NaN 59 \n", | |
| "TWICE 3.0 3.0 58 \n", | |
| "TIE Ru NaN NaN 58 \n", | |
| "ジャルジャルタワー JARUJARU TOWER 2.0 NaN 54 \n", | |
| "岡野タケシ弁護士【アトム法律事務所】 NaN NaN 54 \n", | |
| "King Gnu official YouTube channel 4.0 10.0 51 \n", | |
| "ABEMA バラエティ【公式】 2.0 7.0 51 \n", | |
| "MOS 2.0 6.0 50 \n", | |
| "粗品 Official Channel NaN NaN 49 \n", | |
| "Kep1er 14.0 7.0 48 \n", | |
| "Yorushika - Topic 6.0 2.0 45 \n", | |
| "ずっと真夜中でいいのに。 ZUTOMAYO 2.0 4.0 44 \n", | |
| "SPYGEA / スパイギア NaN NaN 44 " | |
| ] | |
| }, | |
| "execution_count": 122, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "df_pivot.head(50)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "id": "4567a558-62d5-4208-827a-9c87ef00cc90", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "id": "b421c8c8-77a9-42ca-970a-1cfcbaab2cc2", | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [] | |
| } | |
| ], | |
| "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.9.6" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 5 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment