Skip to content

Instantly share code, notes, and snippets.

@blaesus
Last active September 7, 2015 04:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save blaesus/c3e0d1cd8764fddb0757 to your computer and use it in GitHub Desktop.
Save blaesus/c3e0d1cd8764fddb0757 to your computer and use it in GitHub Desktop.
120 Forbidden Songs EDA
{
"cells": [
{
"cell_type": "code",
"execution_count": 52,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>author</th>\n",
" <th>serial</th>\n",
" <th>title</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>阴三儿</td>\n",
" <td>1</td>\n",
" <td>老师好</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>阴三儿</td>\n",
" <td>2</td>\n",
" <td>老师你好</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>阴三儿</td>\n",
" <td>3</td>\n",
" <td>北京晚报</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>阴三儿</td>\n",
" <td>4</td>\n",
" <td>我又没说你</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>阴三儿</td>\n",
" <td>5</td>\n",
" <td>没钱没朋友</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>阴三儿</td>\n",
" <td>6</td>\n",
" <td>天生疯塔儿</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>阴三儿</td>\n",
" <td>7</td>\n",
" <td>北京混子</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>阴三儿</td>\n",
" <td>8</td>\n",
" <td>都得死</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>阴三儿</td>\n",
" <td>9</td>\n",
" <td>凭什么我买单</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>阴三儿</td>\n",
" <td>10</td>\n",
" <td>Da-la-di-la-da</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>阴三儿</td>\n",
" <td>11</td>\n",
" <td>我不管</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>阴三儿</td>\n",
" <td>12</td>\n",
" <td>燃烧吧火焰</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>阴三儿</td>\n",
" <td>13</td>\n",
" <td>没完没了</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>阴三儿</td>\n",
" <td>14</td>\n",
" <td>这条大街</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>阴三儿</td>\n",
" <td>15</td>\n",
" <td>爽歪歪</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>阴三儿</td>\n",
" <td>16</td>\n",
" <td>魔爪重生</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>阴三儿</td>\n",
" <td>17</td>\n",
" <td>龙宫宴请</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>新街口组合</td>\n",
" <td>18</td>\n",
" <td>我TM不愿意</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>新街口组合</td>\n",
" <td>19</td>\n",
" <td>教父</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>新街口组合</td>\n",
" <td>20</td>\n",
" <td>我们都不睡觉</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>新街口组合</td>\n",
" <td>21</td>\n",
" <td>不想上学</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>新街口组合</td>\n",
" <td>22</td>\n",
" <td>脏蜜震西单</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>新街口组合</td>\n",
" <td>23</td>\n",
" <td>一夜情</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>新街口组合</td>\n",
" <td>24</td>\n",
" <td>我要呲大蜜</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>新街口组合</td>\n",
" <td>25</td>\n",
" <td>自杀日记</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>家家</td>\n",
" <td>26</td>\n",
" <td>黑暗之中吻了你的嘴</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>小峰峰/二饼</td>\n",
" <td>27</td>\n",
" <td>拉屎歌</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>光光/K-Bo</td>\n",
" <td>28</td>\n",
" <td>No性No爱</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>光光</td>\n",
" <td>29</td>\n",
" <td>这不是一首一夜情的歌</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>颜韵</td>\n",
" <td>30</td>\n",
" <td>Mlgb</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>90</th>\n",
" <td>小莫</td>\n",
" <td>91</td>\n",
" <td>骚麦</td>\n",
" </tr>\n",
" <tr>\n",
" <th>91</th>\n",
" <td>Mc洪磊</td>\n",
" <td>92</td>\n",
" <td>2013社会磕</td>\n",
" </tr>\n",
" <tr>\n",
" <th>92</th>\n",
" <td>Mc天佑</td>\n",
" <td>93</td>\n",
" <td>溜冰经典</td>\n",
" </tr>\n",
" <tr>\n",
" <th>93</th>\n",
" <td>Mc洪磊</td>\n",
" <td>94</td>\n",
" <td>迪厅粗口现场-寰宇网络版</td>\n",
" </tr>\n",
" <tr>\n",
" <th>94</th>\n",
" <td></td>\n",
" <td>95</td>\n",
" <td>写给妓女的话-东北粗口</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td></td>\n",
" <td>96</td>\n",
" <td>超级叫春迷药</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td></td>\n",
" <td>97</td>\n",
" <td>秀X你妈个</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>黄秋生</td>\n",
" <td>98</td>\n",
" <td>今晚叼胶(鸠)你</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>大懒堂</td>\n",
" <td>99</td>\n",
" <td>今晚叼胶(鸠)你</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td></td>\n",
" <td>100</td>\n",
" <td>女人需要男人搞</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <td>沈阳 mm</td>\n",
" <td>101</td>\n",
" <td>超强XX歌</td>\n",
" </tr>\n",
" <tr>\n",
" <th>101</th>\n",
" <td></td>\n",
" <td>102</td>\n",
" <td>泡妞秘笈</td>\n",
" </tr>\n",
" <tr>\n",
" <th>102</th>\n",
" <td></td>\n",
" <td>103</td>\n",
" <td>叫床声刺激</td>\n",
" </tr>\n",
" <tr>\n",
" <th>103</th>\n",
" <td>罗百吉、宝贝</td>\n",
" <td>104</td>\n",
" <td>花花公子</td>\n",
" </tr>\n",
" <tr>\n",
" <th>104</th>\n",
" <td>罗百吉</td>\n",
" <td>105</td>\n",
" <td>那一夜</td>\n",
" </tr>\n",
" <tr>\n",
" <th>105</th>\n",
" <td>罗百吉</td>\n",
" <td>106</td>\n",
" <td>动你的屁股</td>\n",
" </tr>\n",
" <tr>\n",
" <th>106</th>\n",
" <td>Mc振炮</td>\n",
" <td>107</td>\n",
" <td>你们这群狗</td>\n",
" </tr>\n",
" <tr>\n",
" <th>107</th>\n",
" <td>正黄旗组合</td>\n",
" <td>108</td>\n",
" <td>你们这群狗</td>\n",
" </tr>\n",
" <tr>\n",
" <th>108</th>\n",
" <td>Mc Hotdog/张震岳</td>\n",
" <td>109</td>\n",
" <td>我爱台妹</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>罗百吉</td>\n",
" <td>110</td>\n",
" <td>吹喇叭</td>\n",
" </tr>\n",
" <tr>\n",
" <th>110</th>\n",
" <td>铁竹堂</td>\n",
" <td>111</td>\n",
" <td>为了兄弟</td>\n",
" </tr>\n",
" <tr>\n",
" <th>111</th>\n",
" <td>旺福</td>\n",
" <td>112</td>\n",
" <td>迷你裙</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>黄立成、麻吉</td>\n",
" <td>113</td>\n",
" <td>屌</td>\n",
" </tr>\n",
" <tr>\n",
" <th>113</th>\n",
" <td>哈狗帮</td>\n",
" <td>114</td>\n",
" <td>补补补</td>\n",
" </tr>\n",
" <tr>\n",
" <th>114</th>\n",
" <td>黄立行</td>\n",
" <td>115</td>\n",
" <td>我的梦中情人</td>\n",
" </tr>\n",
" <tr>\n",
" <th>115</th>\n",
" <td>黄立行</td>\n",
" <td>116</td>\n",
" <td>爽</td>\n",
" </tr>\n",
" <tr>\n",
" <th>116</th>\n",
" <td>麻吉</td>\n",
" <td>117</td>\n",
" <td>噩梦</td>\n",
" </tr>\n",
" <tr>\n",
" <th>117</th>\n",
" <td>黄立行</td>\n",
" <td>118</td>\n",
" <td>打分数</td>\n",
" </tr>\n",
" <tr>\n",
" <th>118</th>\n",
" <td>张震岳</td>\n",
" <td>119</td>\n",
" <td>放屁</td>\n",
" </tr>\n",
" <tr>\n",
" <th>119</th>\n",
" <td>葡桃</td>\n",
" <td>120</td>\n",
" <td>摩的神曲</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>120 rows × 3 columns</p>\n",
"</div>"
],
"text/plain": [
" author serial title\n",
"0 阴三儿 1 老师好\n",
"1 阴三儿 2 老师你好\n",
"2 阴三儿 3 北京晚报\n",
"3 阴三儿 4 我又没说你\n",
"4 阴三儿 5 没钱没朋友\n",
"5 阴三儿 6 天生疯塔儿\n",
"6 阴三儿 7 北京混子\n",
"7 阴三儿 8 都得死\n",
"8 阴三儿 9 凭什么我买单\n",
"9 阴三儿 10 Da-la-di-la-da\n",
"10 阴三儿 11 我不管\n",
"11 阴三儿 12 燃烧吧火焰\n",
"12 阴三儿 13 没完没了\n",
"13 阴三儿 14 这条大街\n",
"14 阴三儿 15 爽歪歪\n",
"15 阴三儿 16 魔爪重生\n",
"16 阴三儿 17 龙宫宴请\n",
"17 新街口组合 18 我TM不愿意\n",
"18 新街口组合 19 教父\n",
"19 新街口组合 20 我们都不睡觉\n",
"20 新街口组合 21 不想上学\n",
"21 新街口组合 22 脏蜜震西单\n",
"22 新街口组合 23 一夜情\n",
"23 新街口组合 24 我要呲大蜜\n",
"24 新街口组合 25 自杀日记\n",
"25 家家 26 黑暗之中吻了你的嘴\n",
"26 小峰峰/二饼 27 拉屎歌\n",
"27 光光/K-Bo 28 No性No爱\n",
"28 光光 29 这不是一首一夜情的歌\n",
"29 颜韵 30 Mlgb\n",
".. ... ... ...\n",
"90 小莫 91 骚麦\n",
"91 Mc洪磊 92 2013社会磕\n",
"92 Mc天佑 93 溜冰经典\n",
"93 Mc洪磊 94 迪厅粗口现场-寰宇网络版\n",
"94 95 写给妓女的话-东北粗口 \n",
"95 96 超级叫春迷药 \n",
"96 97 秀X你妈个 \n",
"97 黄秋生 98 今晚叼胶(鸠)你\n",
"98 大懒堂 99 今晚叼胶(鸠)你\n",
"99 100 女人需要男人搞 \n",
"100 沈阳 mm 101 超强XX歌\n",
"101 102 泡妞秘笈 \n",
"102 103 叫床声刺激 \n",
"103 罗百吉、宝贝 104 花花公子\n",
"104 罗百吉 105 那一夜\n",
"105 罗百吉 106 动你的屁股\n",
"106 Mc振炮 107 你们这群狗\n",
"107 正黄旗组合 108 你们这群狗\n",
"108 Mc Hotdog/张震岳 109 我爱台妹\n",
"109 罗百吉 110 吹喇叭\n",
"110 铁竹堂 111 为了兄弟\n",
"111 旺福 112 迷你裙\n",
"112 黄立成、麻吉 113 屌\n",
"113 哈狗帮 114 补补补\n",
"114 黄立行 115 我的梦中情人\n",
"115 黄立行 116 爽\n",
"116 麻吉 117 噩梦\n",
"117 黄立行 118 打分数\n",
"118 张震岳 119 放屁\n",
"119 葡桃 120 摩的神曲\n",
"\n",
"[120 rows x 3 columns]"
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"\n",
"# Read the list\n",
"f = open('official_list.txt', 'r', encoding='utf-8')\n",
"txt = f.read()\n",
"\n",
"song_list = []\n",
"for line in txt.splitlines():\n",
" serial, main_component = line.split('、', maxsplit=1)\n",
" if ('(' in main_component):\n",
" title, author = main_component.rsplit('(', maxsplit=1)\n",
" else:\n",
" title = main_component\n",
" author = ''\n",
" author = author.replace(')', '').replace('\\s', '')\n",
" song_list.append({\n",
" 'serial': int(serial),\n",
" 'title' : title,\n",
" 'author': author,\n",
" })\n",
" \n",
"songs = pd.DataFrame(data=song_list)\n",
"songs"
]
},
{
"cell_type": "code",
"execution_count": 110,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>author</th>\n",
" <th>count</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>阴三儿</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>新街口组合</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td></td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc Hotdog</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>网络歌手</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>张震岳</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>谣乐队</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>黄立行</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>罗百吉</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc洪磊</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc天佑</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>小安</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>颜韵</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>小右</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>黑撒</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>许嵩</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>支原体</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc振炮/张子源</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc和尚/小举</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc流星</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc和尚</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>猥琐小丑</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>大懒堂</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>小莫</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>黄秋生</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>喻小米</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>沈阳 mm</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>罗百吉、宝贝</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Mc振炮</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>正黄旗组合</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>易燃</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>葡桃</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>家家</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>小峰峰/二饼</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>光光/K-Bo</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>光光</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>赵雷</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>李志</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>宋威</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>不是那么黑</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>马旭东</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>洛天依</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>本兮</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>郝雨</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>徐良</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>小贱</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Vnek</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>凌橘绿</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>漠然</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>苏仨</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>少年霜</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>凌音/钟洁</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>渔圈/刘芸</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>费尼克斯/邝巧汾</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>欧阳正萌/小莹儿/乌拉呆</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>沈雁</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>司小魂/Mc诺</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>V.Jey/油炸鬼</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>菜儿/Chyna Apple</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>葡桃</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>68 rows × 2 columns</p>\n",
"</div>"
],
"text/plain": [
" author count\n",
"0 阴三儿 17\n",
"0 新街口组合 8\n",
"0 6\n",
"0 Mc Hotdog 6\n",
"0 网络歌手 5\n",
"0 张震岳 4\n",
"0 谣乐队 4\n",
"0 黄立行 3\n",
"0 罗百吉 3\n",
"0 Mc洪磊 2\n",
"0 Mc天佑 2\n",
"0 小安 2\n",
"0 颜韵 2\n",
"0 小右 2\n",
"0 黑撒 1\n",
"0 许嵩 1\n",
"0 支原体 1\n",
"0 Mc振炮/张子源 1\n",
"0 Mc和尚/小举 1\n",
"0 Mc流星 1\n",
"0 Mc和尚 1\n",
"0 猥琐小丑 1\n",
"0 大懒堂 1\n",
"0 小莫 1\n",
"0 黄秋生 1\n",
"0 喻小米 1\n",
"0 沈阳 mm 1\n",
"0 罗百吉、宝贝 1\n",
"0 Mc振炮 1\n",
"0 正黄旗组合 1\n",
".. ... ...\n",
"0 易燃 1\n",
"0 葡桃 1\n",
"0 家家 1\n",
"0 小峰峰/二饼 1\n",
"0 光光/K-Bo 1\n",
"0 光光 1\n",
"0 赵雷 1\n",
"0 李志 1\n",
"0 宋威 1\n",
"0 不是那么黑 1\n",
"0 马旭东 1\n",
"0 洛天依 1\n",
"0 本兮 1\n",
"0 郝雨 1\n",
"0 徐良 1\n",
"0 小贱 1\n",
"0 Vnek 1\n",
"0 凌橘绿 1\n",
"0 漠然 1\n",
"0 苏仨 1\n",
"0 少年霜 1\n",
"0 凌音/钟洁 1\n",
"0 渔圈/刘芸 1\n",
"0 费尼克斯/邝巧汾 1\n",
"0 欧阳正萌/小莹儿/乌拉呆 1\n",
"0 沈雁 1\n",
"0 司小魂/Mc诺 1\n",
"0 V.Jey/油炸鬼 1\n",
"0 菜儿/Chyna Apple 1\n",
"0 葡桃 1\n",
"\n",
"[68 rows x 2 columns]"
]
},
"execution_count": 110,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Who's the most banned authors?\n",
"author_df = pd.DataFrame(columns=('author', 'count'))\n",
"for author in songs['author'].unique():\n",
" count = len(songs[songs['author'] == author])\n",
" df = pd.DataFrame([[author, count]], columns=('author', 'count'))\n",
" author_df = pd.concat([author_df, df])\n",
"author_df.sort('count', ascending=False)"
]
},
{
"cell_type": "code",
"execution_count": 198,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"downloaded http://s.geci.me/lrc/379/37940/3794030.lrc for 老师好\n",
"downloaded http://s.geci.me/lrc/379/37940/3794034.lrc for 北京晚报\n",
"downloaded http://s.geci.me/lrc/379/37940/3794033.lrc for 我又没说你\n",
"downloaded http://s.geci.me/lrc/379/37940/3794032.lrc for 没钱没朋友\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/7792/779220.lrc for 凭什么我买单\n",
"downloaded http://music.qq.com/miniportal/static/lyric/06/5079906.xml for Da-la-di-la-da\n",
"downloaded http://s.geci.me/lrc/249/24902/2490287.lrc for 我不管\n",
"downloaded http://s.geci.me/lrc/250/25071/2507154.lrc for 没完没了\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/9076/907631.lrc for 教父\n",
"downloaded http://s.geci.me/lrc/140/14062/1406277.lrc for 一夜情\n",
"downloaded http://music.qq.com/miniportal/static/lyric/43/102666343.xml for Mlgb\n",
"downloaded http://s.geci.me/lrc/189/18950/1895065.lrc for 背叛\n",
"downloaded http://s.geci.me/lrc/148/14834/1483491.lrc for 他们\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/8682/868225.lrc for 大学生自习室\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/10552/1055276.lrc for 绝世小攻之年下诱惑\n",
"downloaded http://s.geci.me/lrc/281/28129/2812994.lrc for 我想要做爱\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/1253/125362.lrc for 哇靠\n",
"downloaded http://s.geci.me/lrc/326/32619/3261973.lrc for 大连站\n",
"downloaded http://s.geci.me/lrc/369/36919/3691906.lrc for 城市夜生活的副作用\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/472/47279.lrc for 狗男女\n",
"downloaded http://music.qq.com/miniportal/static/lyric/97/4097.xml for TROUBLE\n",
"downloaded http://music.qq.com/miniportal/static/lyric/17/257417.xml for 0204\n",
"downloaded http://s.geci.me/lrc/253/25393/2539316.lrc for 哈狗帮\n",
"downloaded http://music.qq.com/miniportal/static/lyric/56/56.xml for 1030\n",
"downloaded http://s.geci.me/lrc/253/25393/2539318.lrc for 补习\n",
"downloaded http://s.geci.me/lrc/381/38110/3811029.lrc for 十八岁\n",
"downloaded http://s.geci.me/lrc/313/31310/3131085.lrc for 我行我素\n",
"downloaded http://s.geci.me/lrc/149/14922/1492289.lrc for 花花公子\n",
"downloaded http://s.geci.me/lrc/401/40198/4019843.lrc for 那一夜\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/6696/669689.lrc for 动你的屁股\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/96/9638.lrc for 我爱台妹\n",
"downloaded http://s.geci.me/lrc/302/30262/3026252.lrc for 吹喇叭\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/422/42241.lrc for 为了兄弟\n",
"downloaded http://s.geci.me/lrc/302/30270/3027089.lrc for 迷你裙\n",
"downloaded http://s.geci.me/lrc/328/32808/3280876.lrc for 屌\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/6156/615613.lrc for 补补补\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/473/47383.lrc for 我的梦中情人\n",
"downloaded http://s.geci.me/lrc/344/34477/3447774.lrc for 爽\n",
"downloaded http://s.geci.me/lrc/286/28630/2863052.lrc for 噩梦\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/154/15417.lrc for 打分数\n",
"downloaded http://box.zhangmen.baidu.com/bdlrc/400/40054.lrc for 放屁\n",
"totally downloade lyrics for 41 songs\n"
]
}
],
"source": [
"# Let's download the lyrics!\n",
"\n",
"import requests\n",
"\n",
"def get_lyrics_url(title, author=''):\n",
" \n",
" result = None\n",
"\n",
" if result is None:\n",
" url = \"http://qqmusic.qq.com/fcgi-bin/qm_getLyricId.fcg?name=\"+title+\"&singer=\"+author+\"&from=qqplayer\"\n",
" req = requests.get(url)\n",
" res = req.text\n",
" \n",
" start_tag = 'id=\"'\n",
" end_tag = '\" scroll='\n",
" pos = res.find(start_tag)\n",
" if pos != -1:\n",
" pos_end = res.find(end_tag, pos)\n",
" numeral = res[pos+len(start_tag):pos_end]\n",
" if numeral != '0':\n",
" result = \"http://music.qq.com/miniportal/static/lyric/\"+numeral[-2:]+'/'+numeral+'.xml'\n",
" \n",
" \n",
" \n",
" if result is None:\n",
" url = \"http://box.zhangmen.baidu.com/x?op=12&count=1&title=\" + title + \"$$\" + author + \"$$$$\"\n",
" req = requests.get(url)\n",
" res = req.text\n",
" \n",
" start_tag = '<lrcid>'\n",
" end_tag = '</lrcid>'\n",
" pos = res.find(start_tag)\n",
" if pos != -1:\n",
" pos_end = res.find(end_tag, pos)\n",
" numeral = res[pos+len(start_tag):pos_end]\n",
" if numeral != '0':\n",
" result = 'http://box.zhangmen.baidu.com/bdlrc/'+str(numeral)[:-2]+'/'+str(numeral)+'.lrc'\n",
"\n",
" \n",
" if result is None:\n",
" url = 'http://geci.me/api/lyric/' + title # Search by author returns false negative; hence we don't use author.\n",
" req = requests.get(url)\n",
" res = req.json()['result']\n",
" if len(res) >= 1:\n",
" result = res[0]['lrc']\n",
"\n",
" \n",
" return result\n",
"\n",
"def download_lyrics(url, title, author=''):\n",
" if url:\n",
" req = requests.get(url)\n",
" f = open('lyrics/'+title+'_lyrics.txt', 'w', encoding=req.encoding)\n",
" f.write(req.text)\n",
" f.close()\n",
"\n",
"song_with_lyrics = 0\n",
"\n",
"for song_title in songs['title']:\n",
" \n",
" lyrics_url = get_lyrics_url(song_title)\n",
" if lyrics_url is not None:\n",
" download_lyrics(lyrics_url, song_title)\n",
" print('downloaded', lyrics_url, 'for', song_title)\n",
" song_with_lyrics += 1\n",
" \n",
"print('totally downloade lyrics for', song_with_lyrics, 'songs')"
]
},
{
"cell_type": "code",
"execution_count": 216,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Cleaning lyrics/0204_lyrics.txt\n",
"Cleaning lyrics/1030_lyrics.txt\n",
"Cleaning lyrics/Da-la-di-la-da_lyrics.txt\n",
"Cleaning lyrics/Mlgb_lyrics.txt\n",
"Cleaning lyrics/TROUBLE_lyrics.txt\n",
"Cleaning lyrics/一夜情_lyrics.txt\n",
"Cleaning lyrics/为了兄弟_lyrics.txt\n",
"Cleaning lyrics/他们_lyrics.txt\n",
"Cleaning lyrics/凭什么我买单_lyrics.txt\n",
"Cleaning lyrics/动你的屁股_lyrics.txt\n",
"Cleaning lyrics/北京晚报_lyrics.txt\n",
"Cleaning lyrics/十八岁_lyrics.txt\n",
"Cleaning lyrics/吹喇叭_lyrics.txt\n",
"Cleaning lyrics/哇靠_lyrics.txt\n",
"Cleaning lyrics/哈狗帮_lyrics.txt\n",
"Cleaning lyrics/噩梦_lyrics.txt\n",
"Cleaning lyrics/城市夜生活的副作用_lyrics.txt\n",
"Cleaning lyrics/大学生自习室_lyrics.txt\n",
"Cleaning lyrics/大连站_lyrics.txt\n",
"Cleaning lyrics/屌_lyrics.txt\n",
"Cleaning lyrics/我不管_lyrics.txt\n",
"Cleaning lyrics/我又没说你_lyrics.txt\n",
"Cleaning lyrics/我想要做爱_lyrics.txt\n",
"Cleaning lyrics/我爱台妹_lyrics.txt\n",
"Cleaning lyrics/我的梦中情人_lyrics.txt\n",
"Cleaning lyrics/我行我素_lyrics.txt\n",
"Cleaning lyrics/打分数_lyrics.txt\n",
"Cleaning lyrics/放屁_lyrics.txt\n",
"Cleaning lyrics/教父_lyrics.txt\n",
"Cleaning lyrics/没完没了_lyrics.txt\n",
"Cleaning lyrics/没钱没朋友_lyrics.txt\n",
"Cleaning lyrics/爽_lyrics.txt\n",
"Cleaning lyrics/狗男女_lyrics.txt\n",
"Cleaning lyrics/绝世小攻之年下诱惑_lyrics.txt\n",
"Cleaning lyrics/老师好_lyrics.txt\n",
"Cleaning lyrics/背叛_lyrics.txt\n",
"Cleaning lyrics/花花公子_lyrics.txt\n",
"Cleaning lyrics/补习_lyrics.txt\n",
"Cleaning lyrics/补补补_lyrics.txt\n",
"Cleaning lyrics/迷你裙_lyrics.txt\n",
"Cleaning lyrics/那一夜_lyrics.txt\n"
]
}
],
"source": [
"# Clean the lrc files\n",
"import re\n",
"import glob\n",
"\n",
"for path in glob.glob('lyrics/*lyrics.txt'):\n",
" print('Cleaning', path)\n",
" f = open(path, 'r')\n",
" txt = f.read()\n",
" # Remove timestamps\n",
" txt = re.sub('\\[.*\\]', '', txt)\n",
" \n",
" f_clean = open(path.replace('_lyrics', '_lyrics_timestampRemoved'), 'w')\n",
" f_clean.write(txt)\n",
" \n",
" # Known bug: It doesn't work with \"那一夜_lyrics.txt\""
]
},
{
"cell_type": "code",
"execution_count": 234,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"\n",
"1712|我688|的614|你416|了198|是134|都126|就114|在110|说102|他90|\n",
"\n",
"85|她78|補74|有73|也69|屌63|着54|不53|要52|我们52|去50|个49|这48|不是48|还47|谁47|没有44|爱42|人42|得41|什么41|让41|知道41|找39|把38|想36|到36|那35|给35|没35|看35|一个34|补补33|跟33|会33|到底32|pop32|喜欢32|哈狗帮30|030|自己30|因为30|大30|被29|你们29|上29|北京28|儿28|现在28|I28|兄弟28|他们28|就是28|一27|这个27|習26|还是26|40426|怎么26|又26|更25|真的25|mini25|妈25|台25|像25|对25|the25|补习24|太24|不要24|叫23|妹23|document22|最22|听21|多21|吧21|so20|好20|有人20|来19|打19|qq19|别19|过19|想要19|my19|为了19|說19|和19|已经18|var18|起来18|逼18|is18|啊17|吃17|不会17|可以17|got17|style17|能17|t17|a16|可是16|shake16|长16|不出16|com16|\n",
"\n",
"\n",
"\n",
"\n",
"16|http16|晚报16|帮16|北京晚报16|i16|\n",
"\n",
"\n",
"\n",
"16|得到16|中16|出来16|script16|新15|don15|朋友15|fucking15|与15|做15|一直15|带15|小15|躲15|不知15|your15|当14|不能14|越14|text14|再14|p14|如果14|很14|生活14|看到13|一起13|事儿13|mi13|hip13|on13|\n",
"hip13|才13|比13|trouble\n",
"You13|今天13|晚上13|喝13|you13|女13|\n",
"\n",
"\n",
"13|甩13|學13|著12|丫12|老12|try12|\n",
"mini12|多少12|学生12|有错12|但是12|不到12|没事12|时候12|catch12|music12|阿哈12|page12|面12|老师12|请11|喇叭11|音乐11|挂11|其实11|从11|sexy\n",
"11|吹11|mini\n",
"11|111|卖11|眼睛11|那个11|们11|个人11|势11|不想11|if11|回家11|老板11|讲11|不行10|只是10|为10|javascript10|只10|拿10|大家10|玩10|吹喇叭10|制作10|那么10|name10|万岁10|男10|好像10|html10|最后10|color10|img10|里10|不用10|ps10|有钱10|问10|divs10|不见10|不管10|有点10|脸10|body10|210|啥10|哈哈10|钱10|补习班10|装10|da10|hi10|妞儿10|梦10|实在10|div10|是不是9|传教9|跳9|管9|告诉9|as9|走9|背9|还有9|辣9|背叛9|xml9|漂亮9|太多9|真9|version9|班9|以为9|喔9|可爱9|假9|一点9|女人9|個9|感觉9|所以9|够9|遇到9|we9|一天9|\n",
"10309|B9|几分9|出去9|青春9|只有9|没完9|点9|身边9|妈妈8|十字8|词8|噔8|我心8|className8|e8|开始8|48|怎么办8|人家8|明天8|一样8|\n",
"\n",
"hip8|座8|么8|这种8|heels8|href8|十字架8|放在8|type8|看看8|top8|margin8|难道8|妹妹8|象牙8|攻8|同一8|惊8|买8|电话8|男女8|来说8|getElementById8|算8|88|第一8|这样8|referrer8|歹8|be8|romp8|哪里8|meta8|教士8|多多8|俗8|街头8|嗯8|狗嘴吐不8|每天8|用8|me8|+8|情人8|非常8|到处8|content8|下8|听说8|sexy\n",
"Lace8|干8|一口8|话声8|传教士8|字架8|这么8|window8|车8|满分8|一下8|src8|穿8|花7|傻7|女孩7|一些7|m7|愿意7|乖乖7|and7|等7|can7|已7|\n",
"High7|怕7|放7|大学7|快7|这里7|没事儿7|IN37|爽7|迷你7|屁股7|麼7|跑7|哪7|代表7|just7|\n",
"IN37|狗7|它7|全部7|放屁7|计较7|大腿7|倒楣7|只能7|但7|哎7|麦克7|开7|曲7|相信7|我会7|to7|饶舌7|只要7|性病7|全7|低7|靠7|补7|赶快7|根本7|无法7|时间7|啦7|却7|吗7|高高7|慢慢7|know7|ya6|而6|那些6|轻轻6|行不行6|一种6|所有6|看着6|黄立行6|有力6|ll6|麦克风6|font6|泪6|脸皮6|charset6|不同6|大连6|中情6|大街6|一口气6|\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"6|还要6|每个6|书包6|口气6|getCookie6|j6|QQ6|ur6|最好6|TM6|哦6|掉6|受6|呢6|睡6|自习6|一眼6|为什么6|永远6|流行6|演唱6|家6|操6|133px6|for6|utf6|lyric6|社会6|学校6|突然6|可6|outer6|昏天暗地6|break6|分钟6|page4046|觉得6|空中6|天暗6|头6|中国6|默念6|下午6|什6|common6|您6|修改6|面前6|冰淇淋6|显示6|后6|506|爱情6|getElementsByTagName6|消失6|height6|wanna6|应该6|url6|length6|敌人6|move6|死6|更多6|向6|display6|坐6|暗地6|挺6|\n",
"hi6|new6|衣服6|homp6|width6|真正6|别人5|上来5|滋味5|心里5|以5|说唱5|口水5|没完没了5|戴5|分5|成5|1005|真的假5|媽5|哥5|一夜5|老夫子5|欺负5|手5|吃饭5|狗男女5|不敢5|接受5|花花公子5|少年5|n5|灯5|www5|每5|女生5|大哥5|穿着5|世界5|少5|离开5|想像5|喊5|肚子5|老夫5|同学5|god5|的话5|来到5|X5|哥哥5|二十5|赶紧5|乱5|Money5|性感5|笑5|几个5|变5|吹牛5|送5|良心5|嘴巴5|上学5|看不见5|it5|屁5|哈5|夫子5|疯5|实在太5|床上5|发现5|能够5|假装5|黑5|样儿5|一声5|公子5|小姐5|of5|身体5|MC5|HIPHOP5|花花5|难看5|up5|一遍5|过来5|问题5|who5|理想5|嘴5|城市5|歌手5|這5|继续5|快乐5|终于5|give5|不够5|手段5|没了5|太阳5|血5|连5|夏天5|眼神5|约5|大人5|為5|清楚5|出5|B\n",
"5|肯定5|唱5|美丽5|神秘5|亲5|马上5|生5|十八5|林志玲5|黑夜5|安心4|write4|说话4|骂4|站4|弹4|街4|叫做4|十八岁4|喃4|goBack4|俏皮4|location4|姑娘4|美国4|心情4|听见4|一层4|破4|js4|no4|盼4|页面4|把手4|background4|满4|到处跑4|门口4|ex4|position4|hidden4|span4|今晚4|不住4|哪儿4|追4|不如4|師4|寻找4|话4|舞池4|活4|丢上来4|听到4|低头4|k4|info4|children4|厄4|坐在4|l4|what4|八岁4|拒绝4|咱4|奶罩4|天下4|來4|根儿4|酒吧4|这点4|变成4|哥们4|侯佩岑4|返回4|勾引4|head4|external4|哇4|report4|人生4|挣4|多么4|\n",
"04|泛4|恩4|阿4|吆4|门前4|none4|文化4|一会4|拒4|有时4|信息4|class4|5FAE4|種4|出息4|事情4|作曲4|占4|美4|ooh4|midportal4|片4|角落4|目的4|聯4|equiv4|抱4|五分钟4|5b8b4|lable4|光光4|+document4|matter4|++4|Image4|就让4|火4|呦4|数4|看见4|am4|教4|腿4|qm4|感受4|cmd4|104|学费4|里面4|咋4|8F6F4|問4|block4|各4|command4|想去4|故事4|A4|left4|一堆4|父母4|抽4|爸4|忍不住4|个个4|见4|剩下4|value4|电视4|高中4|头发4|歌词4|味儿4|联考4|4f534|qqmusic4|边儿4|然而4|五分4|曾经4|病4|失去4|呵呵4|大声4|瓶子4|不着4|霓虹4|动4|留下4|学习4|warp4|工作4|宽度4|xwl784|卷4|國4|恋爱4|镜子4|出门4|需要4|意义4|找到4|两个4|absolute4|教父4|考4|家里4|不好4|无聊4|id4|YO4|else4|action4|亲吻4|寻4|未4|自由4|9ED14|subcmd4|絕4|好奇4|东西4|歌曲4|对于4|懂4|icon4|身上4|一般4|真是4|买单4|search4|就要4|lll4|经过4|内容4|U4|天4|用户4|96C54|不断4|很多4|tab4|台北4|呼吸4|教育4|教育部4|title4|family4|过去4|多浪4|只管4|掀起4|parseInt4|气息3|倒3|座位3|交3|克3|结局3|嘿嘿3|听讲3|蛇3|门儿3|干掉3|留在3|烦3|记得3|GB23123|姐姐3|招展3|简短3|白脸3|红了脸3|打开3|闪3|秋天3|作词3|出现3|红色3|時3|想起3|穿金戴银3|满血3|spot3|反正3|习惯3|张开3|依然3|街上3|不爽3|作业3|看过3|最快3|蒂3|革命3|尊重3|thugz3|陽3|翘3|玩儿3|热力3|不在3|言传3|节奏3|满意3|金戴银3|神经3|真神3|老大3|基因3|拾掇3|成绩3|好多3|不过3|打电话3|三天3|弄3|血红3|说出3|刚3|眼里3|鸟3|花枝3|晃3|脚步声3|耍3|感到3|encoding3|一边3|支3|臀3|了了3|风儿3|张3|趋炎附势3|写3|力3|小白脸3|流氓3|那里3|合洗3|心3|上课3|苏3|超3|孩子3|手机3|然后3|很大3|ben3|拥有3|起3|blok3|双手3|作用3|昨天3|地3|现代3|第二3|任3|\n",
"\n",
"yeah3|莫名其妙3|奔3|中文3|浅浅的3|\n",
"www3|屁屁3|裙3|一切3|任何3|臭3|算计3|需3|都市3|她家3|才能3|椅3|赛车3|now3|娘3|明星3|听起3|奇怪3|南阳3|尽3|\n",
"my3|麽3|涌出3|天知道3|冤枉3|浅浅3|格外3|富婆3|银子3|七3|发热3|白3|陪3|龙套3|思考3|神经病3|过错3|夜生活3|有没有3|洗涤3|about3|胡3|面子3|歌名3|将3|接3|不对3|ki3|不了3|沒3|口中3|离3|眼角3|一伙3|小心3|旧3|开心3|饭3|u3|牛3|红灯3|CD3|之年3|在乎3|张震岳3|gonna3|熟悉3|股3|要说3|一年3|从头3|画3|精神3|回答3|高低3|要是3|摇3|两句3|現3|天都3|一定3|屋里3|会儿3|般的3|南阳街3|世纪3|追踪3|这些3|NB3|戒指3|迟到3|种3|资本3|花枝招展3|仿佛3|融合3|张雨生3|莫名3|哈哈哈3|要紧3|脚步3|编辑3|表现3|态度3|唱歌3|毕竟3|前面3|血红色3|大学生3|穿梭3|不然3|神气3|热情3|正在3|分数3|費3|关系3|舞3|祷告3|\n",
"who3|她们3|心想3|in3|散发3|南3|男生3|一块3|扎3|homiez3|课堂3|热裤3|kno3|残忍3|babe\n",
"3|背影3|罪3|帮助3|位置3|came3|worldwide3|亚3|鲜血3|副作用3|好象3|脚3|走到3|冲力3|醒目3|露出3|招3|完3|上自3|yo3|很爽3|电影3|热狗3|how3|戰3|路口3|歪歪3|自在3|right3|金丝鸟3|流下3|仔3|笨蛋3|见面3|喘息3|邪恶3|陈3|故意3|爱抚3|道3|趁3|經3|笑容3|鞋面3|from3|快要3|满大街3|shut3|高高低低3|妹子3|home3|way3|咱们3|喷3|此刻3|池上3|往3|萝卜3|麻利3|一群3|金丝3|夏季3|大款3|动起3|缴3|鸡3|咆哮3|整个3|旁边3|com\n",
"3|之后3|候3|不要紧3|快速3|当成3|望3|何3|年轻3|可能3|快下3|静静3|带你去3|上帝3|沃3|烧3|低点3|试3|出手3|丢3|听不见3|台北市2|不再2|受够2|Type2|爸妈2|滚2|共2|s+2|182|呼2|总2|时代2|啤酒2|勉强2|英雄2|黑板2|长期2|person2|明2|气氛2|嫌犯2|之中2|removeChild2|训练2|BMW\n",
"2|第二天2|Jason\n",
"2|报警2|推门2|66px2|子2|留2|拉2|辫子2|酒家2|部长2|或2|拾回2|宝马2|传说2|始自2|0px2|Girl\n",
"2|五道口2|从中2|场面2|\n",
"LRC2|谈2|唉呀2|girls2|肾上腺2|访问2|身材2|冬眠2|算算看2|上眼2|嚼2|忽悠2|今天下午2|面宽2|拿起2|哈哈哈哈2|上班2|小妞2|一日2|IN3\n",
"2|而且2|纯情2|经历2|六百2|太黑2|抓去2|一瓶2|绕2|叶子2|票子2|560px2|血汗2|国家2|吵2|没钱2|decoration2|最亮2|想一想2|子弹2|这时2|火警2|关掉2|不要脸2|解2|圈2|世纪末2|部分2|照亮2|不信2|以前2|爱小2|振动2|一名2|顺风2|提醒2|This2|兜里2|负有2|脸蛋2|讲课2|不犯2|脏2|好不好2|small2|抢2|小妞儿2|绕到2|回去2|信仰2|假如2|come2|日复一日2|三个2|瘾2|眼看2|脾气2|QQmusic2|处分2|算算2|东北2|禧2|simple2|墙上2|以后2|west2|气2|回到2|两声2|载2|顶2|这事2|容易2|一夜情2|欣赏2|洋酒2|国大2|搁2|坏2|首页2|auto2|下去2|琢磨2|耶2|分给2|调成2|No2|闪烁2|百计2|曼2|金马2|吉他2|\n",
"\n",
"function2|纯2|听不进去2|解脱2|太重2|一帮2|对劲2|旭东2|估计2|\n",
"U2|凯2|where2|做爱2|YD2|后面2|搂2|lrc2|92|数学2|千2|打手2|onclick2|宝2|瞧2|一案2|道理2|字2|Vince\n",
"U2|赖2|教育部长2|Content2|IE2|酒2|当年2|地下2|查找2|\n",
"try2|基本2|烟2|带回家2|巴巴2|5px2|\n",
"body2|所在2|人大2|胜利2|their2|撒2|11402|overflow2|烂2|51lrc2|般般2|附庸风雅2|表皮2|有钱人2|干架2|国小2|面对2|漆黑2|发脾气2|一片2|诚2|要来2|谢2|五六百2|\n",
"if2|真得2|錢2|丧2|血色2|发愁2|直至2|鸡蛋2|闲事2|聽2|眠2|泡2|Tencent2|mouth\n",
"2|半点2|防腐2|三寸2|原因2|年期2|无非2|一般般2|洁身2|芭比2|教授2|来临2|出发2|握2|乎2|真命天子2|夜2|吴2|滿2|刀2|既然2|本事2|惹2|换2|馆2|一袋2|床2|宝贝2|买票2|一班2|JpoPcC2|大小2|聊2|make2|alert2|地方2|泥2|你家2|力气2|磕巴2|年头2|考试2|不动2|恨2|些2|乐子2|润2|狂2|用力2|不满2|地儿2|自由自在2|磕磕巴巴2|噢2|各种2|非得2|#373b3a2|績2|毫不2|哀乐2|s2|要钱2|另2|Tahoma2|嘲笑2|这位2|警察2|test2|miniversion2|领导2|转2|Life2|警方2|摊子2|专辑2|長2|\n",
"You2|get2|兜风2|听不进2|刷卡2|#FFFFFF2|眼镜2|常常2|改用2|sexy\n",
"sexy2|迷人2|腹2|从一而终2|进去2|最近2|二十一2|带够2|不破2|天时2|作弊2|闲着2|傍2|没什么2|Arial2|Edge2|年纪2|走开2|李2|灿烂2|本2|天一2|side\n",
"\n",
"42|King2|一份2|Fuck2|半天2|牌2|组织2|Et2|書2|秘密2|无关2|pa2|边2|撑2|overflowY2|一章2|other2|indexOf2|mediastyle2|西2|\n",
"html2|长大2|甚至2|风2|次2|css2|\n",
"get2|徵2|P2|with2|这年头2|拧2|小学2|marginBottom2|462|举起2|算了2|霓虹灯2|十分2|唱起2|台湾2|唧唧2|一穷二白2|大方2|好好2|闭上眼睛2|不分2|生气2|NAR2|办公室2|feel2|野兽2|适应2|在家2|下车2|答案2|国际2|防腐剂2|de2|学学2|随便2|商店2|广告2|JUANA2|房2|枪2|不显2|SKY2|吓傻2|发疯2|邻居2|脚底板2|系2|天子2|香2|Description2|交叉2|叨咕2|百万2|喜怒哀乐2|還2|变态2|喜怒2|\n",
"I2|Keywords2|驰2|k++2|1802|头条2|爸爸2|全部都是2|edition2|扣分2|泪汪汪2|必要2|FastWeb2|累2|徘徊2|WebPerformAsync2|png2|ask2|三寸不烂之舌2|此2|line2|半瓶2|校外2|打牌2|道口2|大部2|完整2|送给2|宋2|姐妹2|狠2|没关2|抬头2|思想2|满脸2|static2|忽然2|v22|路2|升官发财2|有空2|槟榔2|开嘴2|视线2|嘴里2|bzmtv2|闹2|乳液2|回想2|5em2|带回2|暖2|肉2|不及2|现实2|公斤2|事2|轻松2|三十2|骗钱2|附庸2|嘻2|不免2|hover2|阮2|受不了2|忘2|实话2|ignore\n",
"2|天与地2|升2|革命者2|半夜2|看电视2|不得2|龙2|#16BC5C2|r2|UA2|向着2|必须2|喝醉2|百个2|innerHTML2|瓷2|三百2|不负2|setAttribute2|大部分2|伙计2|好个2|闲人2|升官2|念2|哭2|乾脆2|loading2|犯傻2|雨2|课2|go2|唯一2|沉默2|逮捕2|管闲事2|hear2|北市2|damn2|pop\n",
"2|警车2|防晒2|吃药2|不对劲2|不通2|drop\n",
"\n",
"Smokin2|小弟2|历史2|不可2|房间2|害2|size2|成年2|拍2|padding2|情况2|美好2|align2|裡2|砸2|五千2|party2|脱落2|迎接2|左手2|折腾2|命2|看清2|滚动2|around2|like2|似2|dans2|慌2|尝到2|味2|\n",
"Ki2|telling2|胸口2|报销2|水平2|没人2|both2|属于2|于是2|天王2|型2|露相2|炫2|暂时2|总是2|洁身自好2|功夫2|片儿2|成天2|垂直2|多点2|防晒乳2|包2|高度2|混2|难2|DOCTYPE2|脚底2|互相2|reprezent2|自欺欺人2|垃圾2|CAO\n",
"2|真不2|high\n",
"2|负责2|第一天2|新鲜2|空气2|惦2|肾上腺素2|一半2|主角2|真命2|三寸不烂2|夠2|Like2|渐渐2|无2|啊哈2|最高2|底板2|肥2|厕所2|踩2|惨2|生意2|miniframe2|坐牢2|有心2|清纯2|原来2|五百2|镇定2|腐烂2|小伙2|RegExp2|染上2|顿饭2|墙角2|皮肤2|440px2|不理2|更年期2|ClientInterfaceForWeb2|10742|are\n",
"So2|耳朵2|放纵2|脖子2|彩虹2|白白2|国外2|擦2|追求2|爱国2|作2|要不然2|时尚2|睡觉2|五道2|verson2|无赖2|王子2|芭乐2|Vince\n",
"\n",
"This2|存在2|一把2|暑2|会来2|function2|舞台2|巴黎2|远去2|文说2|失踪2|出卖2|秘密组织2|休2|肚子饿2|充满2|逃走2|花招2|广大2|随2|干嘛2|学会2|\n",
"function2|自负2|得意2|生火2|奶粉2|贼2|仙人2|JB2|规矩2|怨2|伸来2|骗子2|180px2|滚动条2|无奈2|十五分2|手指2|#9494942|俊2|从来2|对不起2|要脸2|闭上眼2|叽咕2|优良2|爷们2|塞住2|办公2|第三2|发片2|好几2|east2|整天2|程2|智2|腾讯2|纳闷2|LrC2|三2|金马奖2|回首2|話2|入睡2|五六2|从前2|寒2|xxxx2|中央2|setTimeout2|走进2|DJ2|G2|麻烦2|十二2|二天2|不来2|几公斤2|风雅2|回音2|反应2|enemies2|耳边2|千方百计2|listen2|没关系2|中高2|boring2|彩色2|早早2|ride\n",
"\n",
"U2|back2|五百万2|扑腾2|块儿2|阴2|冀2|公室2|十五分钟2|继承2|缺2|男主角2|That2|黄2|忙2|劲儿2|手心2|只好2|蛋2|Compatible2|大叔2|强2|Sexy2|好听2|骗2|东2|课后2|娱乐2|战争2|千万2|imgcache2|or2|從2|渐染2|le2|头上2|先2|看不到2|repeat2|没出2|他妈的2|It2|早晚2|不一2|吐2|去冬2|可靠2|請2|蝌蚪2|口音2|汪汪2|夜幕2|叹一口气2|的确2|动物2|ho2|痒2|雪茄2|分局2|8002|没看2|喂2|center2|十章2|第五2|chronik2|从小2|睡不着2|闹钟2|hustlers2|千方2|周围2|data2|打架2|头皮2|十一2|16px2|双眼2|性2|發2|中正2|自好2|哇塞2|网上2|善良2|domain2|票2|周末2|mic2|\n",
"China2|压力2|hop2|自习室2|刘2|34px2|自欺2|传统2|忍2|阳光2|said2|v112|靠近2|大场2|#9290912|天天2|无辜2|te2|好看2|剩2|不敢相信2|落掉2|诱惑2|外表2|抽风2|无数2|off2|密组织2|马2|下雨2|对白2|是因为2|die2|彻底2|自个2|起舞2|同2|爭2|recom2|沾满2|怎2|阿妈2|发财2|木乃伊2|尿2|搓2|蒸2|输2|風2|10302|没出息2|标题2|哈拉2|十五2|太阳眼镜2|酒店2|幫2|停止2|遇见2|紧张2|ready2|真心2|小腿2|浪漫2|所谓2|搞2|包装2|敢2|这边2|天生2|十多2|遗憾1|二点1|十四1|五千万1|n\n",
"\n",
"1|冥思1|寻乐1|国宝1|占有1|混水1|喝酒1|\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"\n",
"1|台币1|手拿着1|不让1|接触1|两1|法相1|滋1|天赋1|法拉1|在校1|黄绿1|躺1|整条1|fuck\n",
"A31|天伦1|进入1|旁人1|狗肉1|thugz\n",
"And1|检查1|三双1|皮条客1|舐1|光棍1|b\n",
"1|见到1|骗人1|一套1|预约1|破口1|起床1|装得1|水蛇1|他人1|名字1|聋1|生存1|无敌1|网吧1|没事干1|再说1|抗战1|碰到1|SIR\n",
"1|侦探1|合在1|种树1|怎样1|无能1|过瘾1|滚出1|几千个1|朋克1|難1|姐1|哮喘1|日夜1|mc1|动力1|背不动1|简直1|境界1|tcolle1|圣经1|礼拜1|一九四三1|stay1|暗里1|叹1|停1|la1|货1|电视墙1|原则1|冲出1|默里1|要付1|嗓子1|割过1|不用说1|thugs1|汗水1|喀1|have1|目光1|牙1|书名1|财产1|回来1|口里1|生辰1|續1|\n",
"PSS1|十岁1|聚1|歪1|中国式1|恋爱史1|双刀1|腸1|勇气1|五趟1|体育1|跑车1|坑1|傻眼1|聊聊1|BBBB\n",
"1|组长1|大老爷们儿1|debark1|例行公事1|蹦1|方块1|拜师学艺1|陷害1|冒1|不一会1|千万个1|唠唠叨叨1|电视机1|确1|过后1|影响1|狐假虎威1|吐痰1|挨着1|呼叫1|叼1|春意1|当做1|带刺1|欢音1|五章1|安1|三句1|光顾1|束之高阁1|贩卖1|关于1|喷上1|几好1|那时1|yo\n",
"\n",
"1|背痛1|娃娃1|桌1|do1|口臭1|一问三不知1|带刺儿1|背着1|横行1|鼻息1|看书1|一眨1|玻璃1|加速1|使1|易犯1|明白1|句句1|正事1|讲义1|逻辑1|开卷考试1|通话1|来者1|yy1|sexy\n",
"party1|火力1|下跪1|恣1|真他妈1|化做1|肆意挥霍1|钞票1|冰冰1|宝岛1|吃饱1|几1|马戏团1|后期1|英语1|夜夜1|现金1|我俩1|baze1|生就1|baztoz1|别误会1|耽误1|好感1|期待1|改革1|主楼1|滚刀1|婚外恋1|慈济1|pour1|源头1|水里1|买卖1|守1|阿哥哥1|拜拜1|岛1|商业1|情侣1|打分1|瞭1|因1|信儿1|综合1|右手1|很漂亮1|HIP1|未满1|漂亮女孩1|张唱片1|香肠1|嘻嘻哈哈1|掏1|膛1|既来之则1|记录1|\n",
"MM1|绣花针1|笑话1|太爽了1|峇1|Le1|崎岖1|太贵1|豁然1|fux1|大卫1|收礼1|玉米1|一十1|处男1|机1|私人侦探1|十戒1|大中1|红1|不知不觉1|夏威夷1|后边1|追上1|成百上千1|远走1|别说1|一五一十1|可不1|旺1|调查1|皇天1|滚蛋1|打着1|派对1|外面1|林振强1|\n",
"No1|不良1|末日1|进1|琪1|轻蔑1|恁1|犯人1|一事1|天空1|want1|丑八怪1|两姐妹1|破口大骂1|违法1|蔌1|音乐网1|洋文1|TEE1|going1|厚1|销魂1|任人1|戏1|扔下1|\n",
"It1|肆意1|气儿1|run\n",
"None1|面带1|young1|九四1|位子1|开朗1|海海1|君1|诗书1|十分钟1|富士1|铁1|down1|新鲜感1|八章1|反攻1|服气1|柜台1|认识1|欢迎1|暴发户1|罪愆1|香味儿1|茬1|公款吃喝1|done1|没劲1|羞涩1|不堪入目1|锵1|从来没1|人流1|believe\n",
"1|句子1|内心1|耳1|纯洁1|N1|LP1|九章1|\n",
"MC1|呻吟1|太烂1|技术1|天使1|有意1|要不是1|杂草1|可口可乐1|自内心1|国中1|消极1|例行1|宣传1|点点1|垃圾筒1|2891246421|脖1|抹粉1|分不清1|种颜色1|憔悴1|赚1|微笑1|开卷1|关门1|无病1|是否1|定会1|stand\n",
"1|闯红灯1|alwayz1|豹1|癌1|天下第一1|知不知道1|屈服1|翼1|睡醒1|把头1|冲突1|答问1|男模1|表出1|四十1|口儿1|门窗1|女朋友1|麥1|怀念1|摇出1|深处1|请进1|十八招1|踢1|身1|found1|浓妆艳抹1|尤物1|管到1|由1|没想1|孤单1|靠着1|埋汰1|瞪1|黑人1|华纳1|杀1|大二1|多元化1|peta1|照片1|贪污1|一两杯1|高梁1|jvaichez1|米粒1|二十多年1|手枪1|咱俩1|顺风耳1|光芒1|嫉妒1|单数1|always1|冷面1|最终1|灯泡1|腦1|特多1|奇迹1|少管闲事1|发自1|棒1|迎来1|疙瘩1|引来1|行为1|有着1|foire1|\n",
"\n",
"\n",
"\n",
"\n",
"oh1|晚1|趴1|fuck\n",
"A21|\n",
"Q1|當1|一出戏1|re1|牵手1|战国时代1|门1|无可1|十秒1|不服气1|提升1|一零一1|\n",
"lrc1|来自1|着迷1|加入1|peur1|則1|哎呀1|乔1|教堂1|要好看1|十种1|trouble\n",
"1|反差1|小窗1|变出1|私人1|vecleberetta\n",
"Jet1|通红1|争名1|無1|吐沫1|否认1|声音1|竹1|彩色笔1|乐观1|地下通道1|回头1|针1|忐忑1|一点点1|好好学习1|者1|好色1|突变1|下书1|调1|KITY1|改革开放1|线民1|能比1|硬1|三十六计1|卖狗肉1|sound1|厅1|苦1|拇指1|炫耀1|\n",
"come1|讲台1|急呀1|经验1|却是1|误时1|电动1|听闻1|息肉1|拥1|四处1|不离1|三十六1|most1|资格1|拘禁1|作礼拜1|抚慰1|34567\n",
"OHH\n",
"1|好学1|一阵1|欠1|垫1|等到1|牛仔裤1|朝霞1|张开嘴1|七八1|家事1|残年1|哲1|搞定1|堂1|颂1|lovelrc1|早起1|不长1|发声1|大事儿1|假唱1|钟1|无名英雄1|一次1|不长不短1|高官1|这回1|背信弃义1|绝世1|one1|一辈子1|K1|躁1|掩耳1|派出1|Couteau1|日利1|高年级1|山越1|达明一派1|配合1|风烛残年1|成立1|随地吐痰1|瞅1|原谅1|礼貌1|温柔1|狼1|豆腐1|play1|狗屎1|芳心1|摸不着1|两分钟1|luv1|羽1|大金1|收1|湿润1|浓度1|土生1|比出1|超越1|Night1|左面1|整成1|烟瘴1|酒精1|視1|外套1|咧1|二十分1|BYE1|长满1|公司1|一管1|Bitch\n",
"\n",
"IN31|一晚1|浇1|拉住1|大力1|Kiss1|大陆1|透透气1|Up\n",
"1|生命1|想学1|\n",
"Go1|家门口1|尖儿1|大哭1|燒1|很轻1|霸占1|不堪1|机器1|china\n",
"1|翅膀1|通都1|嗎1|\n",
"Don1|stopped\n",
"Drop1|settle1|曾1|\n",
"Bathing1|凭1|手里1|无成1|andrew1|AK1|jail1|令人遗憾1|未成1|忘恩负义1|网1|山上1|猜想1|放牛1|霖1|\n",
"We1|泽1|门外1|总经理1|撒旦1|捐给1|当作1|划破1|话费1|贪心1|铃声1|肥羊1|顺便1|上到1|愁眉苦脸1|飞散1|全国1|满足1|可喜可贺1|人身1|可怜1|pantz1|昊1|打坏1|捡1|没空1|往下1|女孩儿1|全世界1|垦丁1|恶魔1|genre1|Raper1|第七1|往后1|伪装1|大地1|hot1|切变1|一丝1|收起1|兽人1|台南1|差1|转身1|混混1|拔出来1|少年郎1|发生1|亲密1|炮火1|鞋1|左右1|讲话1|dog\n",
"\n",
"1|下有1|诱人1|杯1|昨天晚上1|残废1|俄罗斯1|建设1|无所谓1|童子1|庞1|如果说1|你老1|\n",
"1030\n",
"\n",
"1|31|成群结队1|无解1|恶1|停过1|试得1|随地1|大老爷1|博1|多分1|贞洁1|愁眉1|翻山1|出去玩1|殘1|We1|471|为人师表1|Heart\n",
"No1|大雪1|没去1|可乐1|填鸭式1|Martin1|裁1|幹1|My1|me\n",
"Stay1|头儿1|大面1|坐下1|生为1|落入1|平平1|毫不客气1|段子1|传播1|带走1|桑拿1|不少1|理1|技不如人1|马路边1|\n",
"when1|狗屁1|\n",
"H1|玖1|舞弄1|清爽1|爱现1|个位1|拉出1|打折1|萤光幕1|躲起1|烦人1|\n",
"MACHI1|第八章1|没味1|老李1|钢琴1|提前1|鲁1|驻场1|非要1|四季1|不得了1|人群1|后生1|俚语1|式1|路人1|\n",
"http1|幻1|麦当劳1|明确1|今夜1|肛裂1|乖巧1|没办1|黄土1|美妙1|懂得1|快来1|扔进1|聞1|stop1|组1|嘴唇1|经变1|多元1|二环1|home\n",
"Start1|\n",
"ip1|暴力1|闭起1|直往1|双脚1|连人1|耽误时间1|过头1|大片1|忘却1|围坐1|ape1|就此1|光天化日1|花针1|张开嘴巴1|平时1|导演1|愁1|无味1|工1|rock1|计1|停车1|一九1|第二章1|舍得1|捅1|中心1|眼泪1|颜色1|血丝1|一家1|青1|溜走1|曲线1|走错1|倚1|所里1|看穿1|名1|做好1|其他人1|坷1|报仇1|lascars1|生辰八字1|冷静1|二十多1|鱼子1|混水摸鱼1|万万1|第三章1|差一点1|心中1|业务1|主题1|这点儿1|一副1|辈子1|经理1|员1|七十二变1|几句1|打爆1|大宛1|于是乎1|怀抱1|多年1|stop\n",
"never1|工夫1|不该1|结队1|四五1|闷1|梗1|再也1|二十一岁1|夹带1|下肚1|水道1|百多1|填词1|模特儿1|嘿嘿嘿1|狂热1|挂羊头卖狗肉1|四五点1|中时1|hype1|咕1|不觉1|beat1|talk1|从没1|公款1|杀人1|换过1|气疯1|纳闷儿1|唉1|填1|民间1|饭后1|笑地1|遜1|回1|七十二1|太大1|妇产科1|欺1|主题乐园1|\n",
"Hey1|忧伤1|一年四季1|屎1|丸子1|this1|映出1|半兽人1|YES1|北人1|反恐1|老脸1|黑暗1|约谈1|金门1|纵横1|HOP1|光想1|翻1|逼到1|感情1|佛珠1|隐痛1|kejai\n",
"vrnimenpadkoeur\n",
"Juis1|塞进1|舞厅1|以下1|受伤1|HotDog\n",
"10301|流行风1|两句话1|门上1|得知1|昏昏1|染1|雷锋1|一出1|上网1|琵琶1|于今1|韵1|德1|与我无关1|集合1|露珠1|MUSIC1|发抖1|饶舌歌1|彼此1|其他1|宁1|流泪1|带枪1|壮1|敢不敢1|五点钟1|淋湿1|time1|直说1|HotDog\n",
"1|小笼1|冬天1|十七八1|心所1|开房1|後1|刻苦1|饶1|发软1|醉过1|假日1|摸鱼1|礼物1|坚定1|拉下1|金牙1|树立1|凶1|des1|周1|睡懒觉1|中午1|说明1|黑马1|回回1|几点1|精明1|呀1|束1|儿子1|8\n",
"sexy\n",
"1|\n",
"endhttp1|记者1|请问1|第五章1|常1|Lee\n",
"\n",
"1|H1|Vince\n",
"This1|马虎1|浓厚1|唇齿1|douleur1|行年1|衣裳1|亲爱1|花钱1|洗手1|大老爷们1|狞笑1|夜猫子1|乐园1|改行1|所有人1|yes81|修辞1|萧1|俺们1|哪位1|消化1|红黄绿1|浓浓的1|花样1|J\n",
"1|火药1|61|抵1|trouble1|不绝1|\n",
"and1|畫1|三章1|筆1|信心1|七彩1|打扫1|攀1|收获1|通来1|裤子1|分送1|三里屯1|乱讲1|京城1|电灯泡1|一根1|蜷缩1|柔和1|脊椎1|\n",
"TM1|墙头草1|天才1|嚎啕1|think\n",
"You1|光带1|自言自语1|闹热1|一番1|告密1|管好1|跑出去1|乐趣1|frakass\n",
"1|好开心1|跳起1|受够了1|天堂1|爷们儿1|不烦1|對1|叽叽1|火药味1|出神1|男女关系1|跳出1|晌1|覆1|另外1|輸1|无所1|兩1|hard1|立1|承认1|串1|深宵1|愤青1|只在乎1|便利1|纵火1|兼1|阿里1|關1|凶手1|便利商店1|捏造1|jae1|心不在焉1|舞姿1|作文1|动物园1|Q1|都行1|呈1|土生土长1|网友1|那件1|小心眼1|名师1|一则1|没收1|兄弟姐妹1|呆呆1|54321\n",
"OHH1|垫子1|哭诉1|训练有素1|关心1|一本1|几亿1|小礼1|良1|動1|1\n",
"C11|学历1|疯魔1|Lg1|阿哥1|开口1|比我强1|\n",
"ooh1|印满1|一问三不1|说完1|尴尬1|一堂1|潇洒1|rococo1|源深1|foi\n",
"Jtexecute1|洗衣粉1|待会1|再次1|姐们儿1|荒地1|一步1|酒瓶1|认不出来1|別1|snitch1|吓一跳1|娘子1|出了门1|句句实话1|小笼包1|迷幻1|big1|羊头1|不开1|留意1|阿妹1|枇杷1|有权1|步骤1|坐满1|上千1|京味1|Vince\n",
"Chuis1|有名1|背景1|两条1|尬1|校工1|从小到大1|厚着脸皮1|聪明1|ride\n",
"\n",
"A11|\n",
"Break21|聊天1|关机1|包里1|右1|不服1|恨不得1|启示录1|蹒跚1|編1|CDATA1|溜溜1|sure\n",
"1|放松1|后半1|盡1|得手1|噩梦1|救出1|当上1|可喜1|备有1|种花1|骚动1|黑发1|萝1|别以为1|评分1|凌乱1|立定1|保镖1|沙发1|骑1|One1|震动1|鞋子1|us1|十六1|瞎转1|手摸1|升学1|怀1|油1|唱片1|哈日1|71|一气1|正式1|象1|拼命1|之为1|怀疑1|来来1|旱1|阴天1|翻山越岭1|真意1|copz\n",
"My1|七十1|外国1|有事1|立成1|非1|德行1|比林1|福1|跋扈1|十二点1|搞不懂1|\n",
"\n",
"\n",
"\n",
"In1|杀人狂1|白马王子1|小灵通1|当到1|抢钱1|年复一年1|多数1|宽衣1|第六1|表情1|分道1|实况1|五六百个1|hoez1|饿1|條1|拳1|交际1|2728573553\n",
"\n",
"1|拔掉1|尊1|一双1|包皮1|洗浴1|SB1|瞥见1|乱搞1|送信1|刘以达1|Feiyes1|嚎啕大哭1|天儿1|血汗钱1|注意1|别碰1|令1|chrome\n",
"U1|\n",
"YO1|练1|满脸风霜1|\n",
"Mother1|饭馆1|二排1|三十秒1|可看1|留面子1|barbare1|loser1|\n",
"When1|氣1|开上1|绑1|於1|值得1|医药费1|台大1|精神爽1|风格1|小样1|\n",
"\n",
"\n",
"\n",
"\n",
"021|鹅1|即纳1|德智体1|实是1|没道理1|柔弱1|伤痕累累1|最爱1|神话1|\n",
"ho1|詞1|舞女1|二章1|全身1|Hotdog1|目标1|放进1|遥远1|姐们1|越来1|小狗1|搞笑1|自从1|喷火1|要害1|城门1|年1|半边1|够劲1|转过1|登上1|表演1|玻璃窗1|饿死1|浓妆1|com\n",
"Intro1|直接1|投向1|得有1|风烛1|挂羊头卖1|care1|对着1|天真1|夜幕降临1|wannabe1|票价1|即将1|玩具1|亲亲1|爱女1|猴儿1|滴血1|佚名1|並1|款1|Air1|安静1|理由1|第一章1|贡献1|忙碌1|上边1|出租1|一会儿1|贱1|百步1|floor1|活着1|萤光1|鼠1|真心话1|六1|后半夜1|车站1|stars1|盯住1|鲜花1|正1|際1|F1|压倒1|欺负人1|够紧1|不变1|皱纹1|燥1|應1|一身1|不快1|shank1|诺1|何人1|酸1|哼1|脱衣服1|薰香1|忽然间1|乱跑1|造1|397994570\n",
"\n",
"1|相看1|当夜幕1|大大1|比较1|thing1|多难1|豆豆1|高宗1|问候1|卑微1|混到1|comes1|show1|弄死1|鼻息肉1|面孔1|Force1|拜托1|mtvzz1|可口1|上摸1|许多1|就算1|秋冬1|赚钱1|能开1|QQ89045143\n",
"la1|罗百吉1|产科1|谈起1|粒1|嬉皮1|一岁1|于1|avek1|隔音1|持续1|自语1|縱1|mess1|残疾1|走神1|派来1|甜蜜1|\n",
"Iet1|决定1|脸上1|讲理1|诚意1|不下1|dirty\n",
"1|打广告1|语文1|\n",
"Rocin1|水湿1|群体1|过硬1|枕头1|飞1|秀1|干杯1|有说有笑1|前1|皮衣1|大溪地1|嬭1|并重1|罗嗦1|作假1|藏1|处女1|high1|好不容易1|浓1|八招1|凄1|同事1|田1|力量1|metaphyzikal1|say1|撕破脸1|深1|雅座1|一堂课1|错1|引进1|姝1|迹1|看下1|罗斯1|这条1|倒霉1|本质1|醉1|六百个1|前人1|uz1|揪1|炕头1|俩1|old1|应对1|万万岁1|花无百日1|生锈1|枪响1|叫醒1|記1|\n",
"\n",
"10301|舔着1|夜市1|一粒1|place\n",
"Sinon1|泥泞1|速1|朗读1|roll1|heurez1|分身1|暝1|\n",
"oh1|遇1|难受1|八道1|发自内心1|震1|嘎嘎1|找我聊1|两粒1|究竟1|热爱1|爬满1|满天1|approche\n",
"ma1|danfeng927\n",
"1|早就1|真不少1|香水1|八1|灯笼1|二十分钟1|三餐1|心眼1|抛1|料1|一眨眼1|冷冰冰1|瞄1|十一岁1|刷1|人民币1|walk\n",
"This1|蓝1|别的1|dit1|两千1|三陪1|那时快1|浓浓1|爱女人1|胸部1|cuz1|普通话1|招牌1|笼罩1|居然1|全都1|逼进1|泡面1|打分数1|点火1|一大1|場1|逆我者亡1|该不该1|先前1|爱神1|看好1|可畏1|多情1|Fxxk1|主张1|不敢想像1|胡说1|盟约1|胖1|当天1|DISCO1|怪怪1|\n",
"the1|早已1|通知1|胡子1|师学艺1|老人1|是从1|仙1|电话费1|平静1|vendusfoktu1|孩童1|\n",
"Car1|大白1|堵1|瘫痪1|一题1|星1|Chong1|骄傲1|心痒1|没法儿1|白马1|着作1|开到1|电灯1|医院1|追赶1|水珠1|则安之1|不规矩1|无诚意1|敢出1|脱掉1|whatz1|进来1|惟1|蒙1|正北1|咯1|祝1|提供1|NB\n",
"1|想法1|印度1|甜言1|路上1|清真1|跟着1|跋山涉水1|赶赶1|tight1|基因突变1|义气1|心头1|讨厌1|发呆1|一场1|右上1|眼中1|rap\n",
"1|from\n",
"It1|旁边儿1|东方1|混合1|第七章1|成人1|拜师1|第九章1|迅雷不及掩耳1|安山1|略过1|弃1|老汉1|开开1|野蛮1|猫子1|罚1|wit1|别跟我1|毕业1|第十章1|新台币1|最低1|大溪1|一五1|累累1|多管闲事1|dead1|军官1|茄子1|尾巴1|痒痒1|收钱1|付账1|前线1|抢走1|场合1|飘1|重要1|Stop\n",
"messing1|考虑1|烧掉1|放在眼里1|贩卖机1|忍心1|上变1|报告1|帶1|包括1|动不动1|繳1|Free91|精虫1|batar1|早1|课堂纪律1|你好1|在建1|德智体群1|been1|五点1|理性1|卷子1|进口1|有心人1|第四1|完全1|嬉皮士1|铁杵磨成针1|青春年少1|迅雷不及1|嘛1|Mlgb1|讀1|叨叨1|行风1|\n",
"Rap1|每当1|一派1|位1|挂羊头1|雄性1|蔡依林1|贵1|兜1|富士山1|漏子1|野狗1|红润1|市中心1|欺骗1|正人君子1|庙里1|MACHI1|放洋1|那样1|一对1|复数1|五一1|群1|球门1|那双1|两分1|滔滔1|street1|dfoutr1|上头1|911\n",
"1|线1|T1|盎然1|体育老师1|没亲1|两杯1|强大1|下水道1|吐字1|虽然1|同时1|圈儿1|单身1|浪费1|仇恨1|法拉利1|练到1|狗屎运1|Jdebark1|一窝蜂1|are1|醒1|飞机1|意为1|9\n",
"sexy\n",
"1|圣人1|\n",
"How1|失去理性1|未成年1|那种1|收惊1|迭1|法儿1|了不起1|点儿1|出双入对1|拍拖1|亲戚1|双腿1|直来直往1|看得见1|透气1|爆1|過1|打破1|限1|123260740\n",
"1|大拇指1|三种1|拔出1|今天天气1|背后1|\n",
"i1|大连人1|上下1|锻炼身体1|来点1|冒汗1|旧情1|箭1|双截棍1|好好学1|No\n",
"1|堵车1|第十1|真理1|巡逻1|tapoire1|干什么1|摸1|四亿1|第四章1|头痛1|第三天1|PS2\n",
"1|没得1|废话1|万里1|冲1|称之为1|百利1|最前1|空手1|环境1|顽皮1|内裤1|夏秋1|学生服1|走过1|奇遇1|褪去1|at1|艳抹1|温暖1|小便1|題1|大事1|换来1|\n",
"\n",
"QQ1|想想1|傻子1|公认1|Animal\n",
"1|倍1|无病呻吟1|score\n",
"U1|勾肩搭背1|打打1|油条1|ces1|pefra1|几千1|来来回回1|摇摆1|猪脚1|hardcore\n",
"So1|两张1|罩1|直播1|风霜1|填鸭1|\n",
"C21|春光1|梅1|八字1|秃尾1|经受1|喘气1|新鲜空气1|永1|福音1|一面1|春色1|夜猫1|胀1|一个月1|第八1|遗忘1|隐藏1|暗号1|捐1|\n",
"Fuck1|发麻1|十多年1|营业1|孤独1|道路1|群魔乱舞1|sa\n",
"1|放下1|雷1|\n",
"101|apres1|黎明1|降临1|尽情1|热吻1|想为1|大火1|night1|猧1|吃到1|勾勾1|任何人1|叔叔1|时差1|醉生梦死1|昨晚1|裂缝1|红灯区1|四章1|den1|够劲儿1|很忙1|兽性1|风气1|改1|第一眼1|再好1|硬着头皮1|师学1|早餐1|春夏1|汉子1|摊1|很快1|鸡巴1|媳妇1|迅雷1|街灯1|抛弃1|莫非1|叶1|离谱1|\n",
"common1|知晓1|配色1|成佛1|秽语1|劲1|幻想1|彦1|\n",
"so1|机车1|撸1|夢1|女子1|三环1|合好1|初中1|马超1|踏青1|射向1|牆1|童话1|Break1|密接1|holy1|久1|cd1|圣母1|通知单1|滔滔不绝1|人师1|娘娘腔1|不错1|古典1|睡到1|不自1|shittin1|投币1|盘1|既来之1|判1|所需1|嫌1|光1|摇滚1|啪1|\n",
"Remy1|浪1|那天1|照1|主义1|John1|射进1|持1|\n",
"\n",
"GOOD1|千万别1|不容1|写歌1|流行音乐1|模1|九折1|Night\n",
"One1|将来1|归1|达1|春夏秋冬1|锁门1|功力1|抹1|春天1|帝制1|墙头1|果儿1|老爷1|统统1|脱衣1|要饭1|宗旨1|叽1|便道1|涉水1|找不着1|既1|征婚1|不眠之夜1|HotDog1|狱1|流利1|乐观主义1|之前1|亮起1|down\n",
"1|体会1|那话儿1|出钱1|落发1|高级1|楷1|刚强1|遠1|执著1|走神儿1|numba1|眨眼1|右面1|正人1|\n",
"Party1|应酬1|野兽派1|抓1|文明1|醒来1|发票1|三百多1|一得1|滚出去1|暴发1|嘻嘻1|井底1|爽朗1|紧锁1|讲解1|进出1|停掉1|独舞1|打中1|拖拉1|投资1|算是1|三代1|碰1|纯良1|chow\n",
"1|黑光1|三条1|龊1|家门1|滚刀肉1|刺儿1|肥猫1|草莓1|接着1|魂1|wan1|高超1|司机1|语文课1|憎厌1|兴趣1|四人帮1|图片1|皮鞭1|编1|好多钱1|纪律1|喘1|轮胎1|似的1|顺我者昌1|赞1|even1|万个1|蜜1|钟关1|男人1|人民1|擦屁股1|付出1|密语1|爸爸妈妈1|了解1|冷笑1|too1|饿狼1|崔1|句1|西装1|轻率1|脱1|危险1|童子鸡1|十七1|灯光1|心跳1|营造1|车辆1|身旁1|学生证1|深更半夜1|八成1|分清1|北京城1|老二1|乱舞1|god\n",
"1|捣鬼1|忘恩1|倾向1|动人1|德性1|瘝1|drop1|behind1|眼前1|教学1|Rapper\n",
"1|话儿1|好几千1|后生可畏1|die\n",
"1|Mc1|尽头1|小小1|天生我才1|发1|中指1|奸商1|照样1|粗布1|利用1|五街1|高1|桃源1|几天1|台上1|逗乐1|色情图1|耽1|Now1|較1|成见1|泪流1|服务1|灵通1|睬1|呆1|无名1|Sache1|gone1|大妹1|睡着1|天荒地老1|偷偷1|小国1|亲切1|历练1|习以为常1|来回1|END1|尿片1|肝1|这时候1|骚1|职业1|噩1|仙人跳1|排在1|学成1|代1|真实1|刺激1|一色1|马家爵1|现场1|們1|记住1|散1|熬夜1|深深1|唠叨1|介绍1|煮菜1|问一问1|爱护1|认为1|\n",
"GUCCI1|处女膜1|述说1|汉堡1|招待1|哈里1|大喊1|有素1|舞动1|里头1|下水1|凳子1|\n",
"QQ745606801\n",
"\n",
"1|点钟1|逊1|你报1|美女1|有所1|撕破脸皮1|一事无成1|抱怨1|奴1|等等1|匪军1|水蛇腰1|下面1|Wake1|伤1|铁塔1|难过1|\n",
"\n",
"\n",
"\n",
"\n",
"10301|懒觉1|板1|星光1|歌1|顶多1|少有1|六章1|张学友1|业绩1|失望1|china1|伊1|一下下1|when1|用去1|我处1|车马1|屠刀1|明明1|可贺1|误会1|\n",
"mc1|恋1|\n",
"Oh1|钱包1|34567\n",
"High1|偏见1|郑1|假象1|德福1|流1|豁然开朗1|客1|坏话1|缠1|九1|简单1|开放1|博弈1|说好1|两只1|out1|臭豆腐1|想到1|vek1|普吉岛1|鸭1|瘴气1|up\n",
"1|jump1|汪1|启示1|金属1|神父1|意在1|光用1|止1|抽尽1|懒惰1|往日1|从来不1|东风1|哪个1|转动1|手持1|含1|all1|之身1|香味1|更是1|帅1|away1|\n",
"Yeah\n",
"1|走廊1|胡说八道1|弟弟1|上海1|數1|孙子1|草1|越来越1|out\n",
"We1|整1|我行我素1|折1|DVD1|舔1|戏团1|弦1|下课后1|不以1|偷看1|濟1|几岁1|服人1|质量1|无力1|几百1|Stand1|单挑1|接客1|露1|莉1|竟然1|一族1|二十岁1|Yo1|另类1|上天1|住1|bitches1|起身1|步履1|老外1|熱1|眼瞅1|箕1|路边1|再者说1|until1|校内1|放轻1|信1|派出所1|门框1|着急1|听歌1|等待1|S1|绣花1|药费1|酒瓶子1|三里1|换上1|爱带1|tmd1|发扬1|一杯1|认不出1|挥霍1|养1|军车1|没想到1|热闹1|若是1|没法1|襬1|PUSSY1|一拍即合1|一块儿1|本色1|抖颤1|b1|呼喊1|通通1|责任1|寻求1|到任1|Friend\n",
"\n",
"\n",
"\n",
"1|当个1|\n",
"shake1|人前人后1|撕破1|萬1|大大小小1|疯狂1|窗户1|春1|岃1|壓1|棒子1|色情图片1|步1|负义1|餐厅1|迷你裙1|看得1|里面儿1|甭1|妆1|機1|清1|瞄着1|小混混1|rodick1|好险1|十多条1|皮条1|多心1|躲起来1|远1|色笔1|彪1|脆弱1|一筐1|玩转1|打炮1|y1|性向1|上去1|小弟弟1|炼1|语句1|喝一杯1|中枪1|接起1|生土1|紧1|付钱1|\n",
"just1|前方1|吃喝1|老鸟1|下课1|传奇1|也许1|掩饰1|综合症1|无可奈何1|再一1|涓1|周杰伦1|boyz1|焉1|投入1|再摇1|打小报告1|夜总会1|站起1|动机1|韩1|任务1|发泄1|bang1|相辞1|巷1|难怪1|做生意1|地上1|let1|see1|抄收1|自以为是1|读书1|精1|dla1|嘿1|学1|d1|办法1|合法1|世界末日1|堕落1|恰好1|子鸡1|電1|普通1|唬1|争名夺利1|令人1|剪掉1|锈了1|马戏1|疙1|狠心1|手上1|分道扬镖1|百日1|叹息1|车灯1|药味1|冰冷1|遇上1|呗1|持刀1|内地1|痕1|学友1|下下1|抓住1|每次1|各取所需1|月前1|管路1|腰1|天气1|消费1|刷牙1|逗1|要为1|之蛙1|正事儿1|解渴1|第六章1|留点1|第一次1|換1|杯酒1|衣衫1|人儿1|lyrics1|词曲1|警1|香烟1|xx1|天黑1|冰凉1|鸡鸡1|几百个1|出门儿1|得得1|COM\n",
"1|舅舅1|普吉1|动作1|直发抖1|本书1|Don1|换成1|知识1|这根1|toi1|差点1|歇会儿1|山越岭1|涛1|tou1|多条1|连站1|拍电影1|照相1|有些1|君子1|损1|牛仔1|3932358001|heures1|未来1|板凳1|superstar1|一曲1|大面儿1|方法1|shotz1|模特1|教室1|\n",
"Asshole\n",
"1|垃圾桶1|Friend\n",
"\n",
"1|套儿1|黑影1|PUB1|多派1|一拳1|腰酸1|孩儿1|ZXTW1|器1|一辈1|起不来1|生理1|慈1|脸颊1|Jue1|半兽1|吹笛1|妇产1|换新1|港台1|TAMAKI1|商量1|味道1|镜1|脑满肠肥1|撞死1|一道1|上街1|抓贼1|两瓶1|毫不考虑1|冻1|磨成1|多任务1|学艺1|\n",
"Dez1|铁杵1|\n",
"Freestyle1|主演1|通道1|短信1|欲望1|盯1|重1|infinie1|这帮1|傻了眼1|原住民1|客气1|ass1|給1|小姐姐1|體1|高阁1|虎威1|烟雾1|当夜1|金1|好几亿1|响1|羡慕1|总会1|一两1|高跟鞋1|充气1|痛苦1|不明1|瑟1|ton1|改成1|板报1|黄耀明1|除了1|高举1|小报1|有限1|污1|自私1|完成1|小蝌蚪1|年少1|沉醉1|itchin1|真情1|MATSUI1|刽子手1|透透1|钓1|想着1|腰酸背痛1|热舞1|出街1|打算1|份儿1|做人1|娘娘1|拉稀1|附近1|看清楚1|锻炼1|\n",
"Break11|oh1|校服1|无限1|战国1|改变1|紫1|攒1|嗨1|隔1|老爷们儿1|玉米粒1|的哥1|下成1|finish1|開1|不在乎1|好玩1|net1|三百两1|师表1|马路1|PLPL1|奈何1|快给我1|牌坊1|药1|伤痕1|灌醉1|迷茫1|\n",
"Yo1|一只1|决意1|总有一天1|说时迟1|饱1|偷心1|破脸1|春药1|jtecla1|心脏1|白天1|我行1|英雄本色1|\n",
"11|色情1|碜1|\n",
"\n",
"\n",
"\n",
"011|昏暗1|酬1|公事1|发展1|春意盎然1|受到1|那条1|跳舞1|踞1|醒觉1|二日1|pur1|mifa1|风情1|体贴1|井底之蛙1|枕1|鴨1|阿里山1|露馅1|在外1|零食1|钢管1|空虚1|辉1|放牛吃草1|想买1|成群1|乐意1|第九1|背信1|年级1|消息1|进屋1|越岭1|从未1|冤家1|排长1|偶尔1|无畏1|少管1|恩公1|be\n",
"1|跌倒1|疏于1|半边天1|生理需要1|还给1|家人1|螢1|成家1|不屑1|亮眼1|忘记1|一九四1|宇1|扔1|Connar1|洗衣1|一朝1|一百1|混有1|degage1|致敬1|校区1|只怕1|医药1|猜1|dez1|塞满1|jve1|再者1|You1|讓1|珠泪1|乐器1|两天1|通1|SIAN1|愤怒1|代价1|作业本1|虚度1|懒得1|悲伤1|甜1|绝1|care\n",
"I1|手铐1|住民1|活活1|樣1|玛莉亚1|七章1|耶和华1|不安1|零1|所能1|哥们儿1|自以1|本分1|課1|早上1|希望1|送信儿1|光阴1|莫1|婚外1|精光1|杰出1|不讲理1|演唱会1|科学1|幕1|不露1|吓跑1|吐口1|成为1|放肆1|神1|不自在1|数字1|百两1|千个1|D1|責1|瞎1|上三1|疯子1|年纪轻轻1|颜1|步道1|Hey1|铭1|看出1|尖1|咕叨1|努力1|形状1|新闻1|北一1|到位1|牲畜1|撕1|别怕1|臭骂1|验尿1|sky\n",
"1|为何1|托1|红白1|卡1|\n"
]
}
],
"source": [
"# Let's count work frequencies\n",
"\n",
"import jieba\n",
"word_count = {}\n",
"for path in glob.glob('lyrics/*_lyrics_timestampRemoved.txt'):\n",
" f = open(path, 'r')\n",
" txt = f.read()\n",
" seg_list = jieba.cut(txt, cut_all=True)\n",
" for word in seg_list:\n",
" try:\n",
" word_count[word] += 1\n",
" except KeyError:\n",
" word_count[word] = 1\n",
" \n",
"result = ''\n",
"for item in sorted(word_count.items(), key=lambda x: x[1], reverse=True):\n",
" if item[0]:\n",
" result += item[0] + str(item[1]) + '|'\n",
"print(result)"
]
}
],
"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.4.3"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment