Data Exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "schema_play = ['uid','device','song_id','song_type','song_name','singer','play_time','song_length','paid_flag','file_name']\n",
    "df = pd.read_csv('../music_box_data/data/play/20170303_1_play.log.fn',delimiter='\\t',header=None,index_col=None,names=schema_play)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "uid                               NaN\n",
       "device                          [ar ]\n",
       "song_id                    [4540711 ]\n",
       "song_type                        [0 ]\n",
       "song_name                  [主啊_我赞美你 ]\n",
       "singer                        [网络歌手 ]\n",
       "play_time                      [178 ]\n",
       "song_length                    [178 ]\n",
       "paid_flag                         NaN\n",
       "file_name      [ 20170303_1_play.log]\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[1].str.split(',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>154750654.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>10740680</td>\n",
       "      <td>0</td>\n",
       "      <td>胸是软绵绵的</td>\n",
       "      <td>MC马克</td>\n",
       "      <td>76</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>154711780.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4540711</td>\n",
       "      <td>0</td>\n",
       "      <td>主啊_我赞美你</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>178</td>\n",
       "      <td>178</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>154745979.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6309425</td>\n",
       "      <td>0</td>\n",
       "      <td>匆匆那年(小品)</td>\n",
       "      <td>刘金霏&amp;徐滔&amp;侯振鹏&amp;陈印泉&amp;陈曦[相声]</td>\n",
       "      <td>1104</td>\n",
       "      <td>1104</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>154537507.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6664755</td>\n",
       "      <td>0</td>\n",
       "      <td>有一种爱叫做不离不弃</td>\n",
       "      <td>六哲&amp;孟杨</td>\n",
       "      <td>14</td>\n",
       "      <td>277</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>154559161.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>11119785</td>\n",
       "      <td>0</td>\n",
       "      <td>There Are Witches Among Us \\/ The Bank \\/ The ...</td>\n",
       "      <td>James Newton Howard</td>\n",
       "      <td>32</td>\n",
       "      <td>414</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>154762843.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9950164</td>\n",
       "      <td>0</td>\n",
       "      <td>刚好遇见你</td>\n",
       "      <td>李玉刚</td>\n",
       "      <td>199</td>\n",
       "      <td>200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>154830377.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>999306</td>\n",
       "      <td>0</td>\n",
       "      <td>春風 SHUN PU</td>\n",
       "      <td>豊崎愛生</td>\n",
       "      <td>251</td>\n",
       "      <td>252</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>154502573.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6989312</td>\n",
       "      <td>0</td>\n",
       "      <td>三生三世十里桃花</td>\n",
       "      <td>高迪</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>154819087.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>585675</td>\n",
       "      <td>0</td>\n",
       "      <td>Soul</td>\n",
       "      <td>信乐团</td>\n",
       "      <td>253</td>\n",
       "      <td>254</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>154831720.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4849640</td>\n",
       "      <td>0</td>\n",
       "      <td>时间煮雨-(电影《小时代3：刺金时代》片尾曲)</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>7</td>\n",
       "      <td>248</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           uid device    song_id song_type  \\\n",
       "0  154750654.0    ar   10740680         0    \n",
       "1  154711780.0    ar    4540711         0    \n",
       "2  154745979.0    ar    6309425         0    \n",
       "3  154537507.0    ar    6664755         0    \n",
       "4  154559161.0    ip   11119785         0    \n",
       "5  154762843.0    ar    9950164         0    \n",
       "6  154830377.0    ar     999306         0    \n",
       "7  154502573.0    ar    6989312         0    \n",
       "8  154819087.0    ar     585675         0    \n",
       "9  154831720.0    ar    4849640         0    \n",
       "\n",
       "                                           song_name                  singer  \\\n",
       "0                                            胸是软绵绵的                    MC马克    \n",
       "1                                           主啊_我赞美你                    网络歌手    \n",
       "2                                          匆匆那年(小品)   刘金霏&徐滔&侯振鹏&陈印泉&陈曦[相声]    \n",
       "3                                        有一种爱叫做不离不弃                   六哲&孟杨    \n",
       "4  There Are Witches Among Us \\/ The Bank \\/ The ...    James Newton Howard    \n",
       "5                                             刚好遇见你                     李玉刚    \n",
       "6                                        春風 SHUN PU                    豊崎愛生    \n",
       "7                                          三生三世十里桃花                      高迪    \n",
       "8                                              Soul                     信乐团    \n",
       "9                           时间煮雨-(电影《小时代3：刺金时代》片尾曲)                     吴亦凡    \n",
       "\n",
       "  play_time song_length  paid_flag             file_name  \n",
       "0       76           0         0.0   20170303_1_play.log  \n",
       "1      178         178         0.0   20170303_1_play.log  \n",
       "2     1104        1104         0.0   20170303_1_play.log  \n",
       "3       14         277         0.0   20170303_1_play.log  \n",
       "4       32         414         0.0   20170303_1_play.log  \n",
       "5      199         200         0.0   20170303_1_play.log  \n",
       "6      251         252         0.0   20170303_1_play.log  \n",
       "7      100         100         0.0   20170303_1_play.log  \n",
       "8      253         254         0.0   20170303_1_play.log  \n",
       "9        7         248         0.0   20170303_1_play.log  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# add new feature - date\n",
    "def get_date(file_name):\n",
    "    tmp_list = str(file_name).split('_')\n",
    "    return tmp_list[0]\n",
    "df['date'] = df['file_name'].map(get_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "uid                     1.68513e+06\n",
       "device                          ar \n",
       "song_id                    4189309 \n",
       "song_type                        1 \n",
       "song_name            快四(一曲相送 东旺制作) \n",
       "singer                         图桠格 \n",
       "play_time                291445468 \n",
       "song_length                     -1 \n",
       "paid_flag                         0\n",
       "file_name       20170303_1_play.log\n",
       "date                       20170303\n",
       "Name: 350467, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[350467]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 211,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "uid            float64\n",
       "device          object\n",
       "song_id         object\n",
       "song_type       object\n",
       "song_name       object\n",
       "singer          object\n",
       "play_time       object\n",
       "song_length     object\n",
       "paid_flag      float64\n",
       "file_name       object\n",
       "date            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 211,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# convert play_time & song_length data type from object to float, invalid parsing will be set as NaN\n",
    "df_play = df.copy()\n",
    "df_play['play_time'] = pd.to_numeric(df_play['play_time'], errors='coerce')\n",
    "df_play['song_length'] = pd.to_numeric(df_play['song_length'], errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 210,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "uid            float64\n",
       "device          object\n",
       "song_id         object\n",
       "song_type       object\n",
       "song_name       object\n",
       "singer          object\n",
       "play_time      float64\n",
       "song_length    float64\n",
       "paid_flag      float64\n",
       "file_name       object\n",
       "date            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 210,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# problem here: song_length cannot transfer to float\n",
    "df_play.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5013.3919630676746, 291445468.0, -0.091001285000000001, 140.0)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# statistics of play_time\n",
    "df_play.play_time.mean(),df_play.play_time.max(),df_play.play_time.min(),df_play.play_time.median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 219,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "350467"
      ]
     },
     "execution_count": 219,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get the row number of max in column play_time\n",
    "df_play.play_time.idxmax(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>501633</td>\n",
       "      <td>1</td>\n",
       "      <td>美丽的香格里拉</td>\n",
       "      <td>天籁组合</td>\n",
       "      <td>205218.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>20874724</td>\n",
       "      <td>1</td>\n",
       "      <td>寂寞</td>\n",
       "      <td>郭美美</td>\n",
       "      <td>273549.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>578</th>\n",
       "      <td>154602677.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>19321221</td>\n",
       "      <td>1</td>\n",
       "      <td>很奇怪我爱你</td>\n",
       "      <td>张杰</td>\n",
       "      <td>394152.0</td>\n",
       "      <td>394.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>610</th>\n",
       "      <td>154572841.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3434894</td>\n",
       "      <td>1</td>\n",
       "      <td>Bang Bang Bang(DJ 4qiao Remix)</td>\n",
       "      <td>英文慢摇</td>\n",
       "      <td>285884.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>154660090.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1273340</td>\n",
       "      <td>1</td>\n",
       "      <td>Let's Buy Happiness</td>\n",
       "      <td>Boys Noize</td>\n",
       "      <td>295724.0</td>\n",
       "      <td>293.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>731</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>任逍遥-巫娜</td>\n",
       "      <td>巫娜</td>\n",
       "      <td>327262.0</td>\n",
       "      <td>327.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>154046770.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5237384</td>\n",
       "      <td>1</td>\n",
       "      <td>逆流成河</td>\n",
       "      <td>金南玲</td>\n",
       "      <td>125202.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>154814755.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7186091</td>\n",
       "      <td>1</td>\n",
       "      <td>心锁</td>\n",
       "      <td>冷漠&amp;杨小曼</td>\n",
       "      <td>255936.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1014314</td>\n",
       "      <td>1</td>\n",
       "      <td>你的眼睛</td>\n",
       "      <td>许茹芸&amp;熊天平</td>\n",
       "      <td>287881.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>873</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1127698</td>\n",
       "      <td>1</td>\n",
       "      <td>奔跑</td>\n",
       "      <td>羽·泉</td>\n",
       "      <td>196963.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>915</th>\n",
       "      <td>31350521.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7922570</td>\n",
       "      <td>1</td>\n",
       "      <td>微微一笑很倾城-(电视剧《微微一笑很倾城》片尾曲)</td>\n",
       "      <td>杨洋</td>\n",
       "      <td>204939.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1083</th>\n",
       "      <td>154705043.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9921609</td>\n",
       "      <td>1</td>\n",
       "      <td>彼岸-(电视剧《兰陵王妃》主题曲)</td>\n",
       "      <td>董贞</td>\n",
       "      <td>241905.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1187</th>\n",
       "      <td>154771880.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6982270</td>\n",
       "      <td>1</td>\n",
       "      <td>Temple</td>\n",
       "      <td>G-Dragon&amp;M.I.A.&amp;Baauer</td>\n",
       "      <td>183531.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1302</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9853314</td>\n",
       "      <td>1</td>\n",
       "      <td>流着泪说分手</td>\n",
       "      <td>苏立生</td>\n",
       "      <td>275760.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1386</th>\n",
       "      <td>154833762.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>20870992</td>\n",
       "      <td>1</td>\n",
       "      <td>盛夏光年</td>\n",
       "      <td>林忆莲</td>\n",
       "      <td>222965.0</td>\n",
       "      <td>223.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1409</th>\n",
       "      <td>154515640.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4224604</td>\n",
       "      <td>1</td>\n",
       "      <td>无底线</td>\n",
       "      <td>本兮</td>\n",
       "      <td>211452.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1419</th>\n",
       "      <td>154812842.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9950164</td>\n",
       "      <td>1</td>\n",
       "      <td>刚好遇见你</td>\n",
       "      <td>李玉刚</td>\n",
       "      <td>199876.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1460</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>408642</td>\n",
       "      <td>1</td>\n",
       "      <td>Knock Knock</td>\n",
       "      <td>Lenka</td>\n",
       "      <td>220775.0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Dream It Possible</td>\n",
       "      <td>张靓颖</td>\n",
       "      <td>219107.0</td>\n",
       "      <td>219.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1515</th>\n",
       "      <td>154421367.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>许嵩 - 多余的解释 [mqms2]</td>\n",
       "      <td>未知歌手</td>\n",
       "      <td>274943.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1588</th>\n",
       "      <td>154812842.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9950164</td>\n",
       "      <td>1</td>\n",
       "      <td>刚好遇见你</td>\n",
       "      <td>李玉刚</td>\n",
       "      <td>199876.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1611</th>\n",
       "      <td>154819740.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>119495</td>\n",
       "      <td>1</td>\n",
       "      <td>忘不掉的伤</td>\n",
       "      <td>姜玉阳</td>\n",
       "      <td>249568.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>501633</td>\n",
       "      <td>1</td>\n",
       "      <td>美丽的香格里拉</td>\n",
       "      <td>天籁组合</td>\n",
       "      <td>205166.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1719</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>20866497</td>\n",
       "      <td>1</td>\n",
       "      <td>向天再要500话</td>\n",
       "      <td>上海彩虹室内合唱团</td>\n",
       "      <td>193492.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1733</th>\n",
       "      <td>154046770.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5237384</td>\n",
       "      <td>1</td>\n",
       "      <td>逆流成河</td>\n",
       "      <td>金南玲</td>\n",
       "      <td>125295.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1863</th>\n",
       "      <td>154579632.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6987249</td>\n",
       "      <td>1</td>\n",
       "      <td>这个年纪</td>\n",
       "      <td>齐一</td>\n",
       "      <td>284428.0</td>\n",
       "      <td>284.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1898</th>\n",
       "      <td>154693758.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4952486</td>\n",
       "      <td>1</td>\n",
       "      <td>小情歌 (Live)</td>\n",
       "      <td>苏打绿</td>\n",
       "      <td>277801.0</td>\n",
       "      <td>278.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2140</th>\n",
       "      <td>154572841.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>901858</td>\n",
       "      <td>1</td>\n",
       "      <td>Bang Bang Bang</td>\n",
       "      <td>MBLAQ</td>\n",
       "      <td>211023.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2286</th>\n",
       "      <td>154605005.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6633172</td>\n",
       "      <td>1</td>\n",
       "      <td>爱如星火</td>\n",
       "      <td>杨小曼&amp;冷漠</td>\n",
       "      <td>260461.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2401</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1127698</td>\n",
       "      <td>1</td>\n",
       "      <td>奔跑</td>\n",
       "      <td>羽·泉</td>\n",
       "      <td>196702.0</td>\n",
       "      <td>197.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850819</th>\n",
       "      <td>154425585.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>706535</td>\n",
       "      <td>1</td>\n",
       "      <td>孤单的身影寂寞的夜</td>\n",
       "      <td>刘凤瑶</td>\n",
       "      <td>290249.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850871</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6449273</td>\n",
       "      <td>0</td>\n",
       "      <td>绅士</td>\n",
       "      <td>薛之谦</td>\n",
       "      <td>103575.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850923</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>15249349</td>\n",
       "      <td>1</td>\n",
       "      <td>凉凉-(电视剧《三生三世十里桃花》片尾曲)</td>\n",
       "      <td>张碧晨&amp;杨宗纬</td>\n",
       "      <td>333122.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850977</th>\n",
       "      <td>154629900.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>15249349</td>\n",
       "      <td>1</td>\n",
       "      <td>凉凉-(电视剧《三生三世十里桃花》片尾曲)</td>\n",
       "      <td>张碧晨&amp;杨宗纬</td>\n",
       "      <td>333928.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851028</th>\n",
       "      <td>28638487.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6561202</td>\n",
       "      <td>1</td>\n",
       "      <td>大梦想家 (现场版)</td>\n",
       "      <td>TFBOYS</td>\n",
       "      <td>110109.0</td>\n",
       "      <td>194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851127</th>\n",
       "      <td>154819740.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>825131</td>\n",
       "      <td>1</td>\n",
       "      <td>子时过</td>\n",
       "      <td>姜玉阳</td>\n",
       "      <td>211952.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851156</th>\n",
       "      <td>154709374.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5946238</td>\n",
       "      <td>0</td>\n",
       "      <td>湛江 Dj 浩仔 什么爱叫地久天长 Club 中文 7辑</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>98506.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851263</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7089537</td>\n",
       "      <td>0</td>\n",
       "      <td>初学者</td>\n",
       "      <td>薛之谦</td>\n",
       "      <td>114741.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851443</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>125802</td>\n",
       "      <td>1</td>\n",
       "      <td>曹操</td>\n",
       "      <td>林俊杰</td>\n",
       "      <td>240977.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851538</th>\n",
       "      <td>154578229.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4199996</td>\n",
       "      <td>0</td>\n",
       "      <td>多喜欢你</td>\n",
       "      <td>晓雨</td>\n",
       "      <td>92074.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851556</th>\n",
       "      <td>154667416.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5225755</td>\n",
       "      <td>1</td>\n",
       "      <td>想你</td>\n",
       "      <td>金贵晟</td>\n",
       "      <td>282427.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851569</th>\n",
       "      <td>154725429.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3695405</td>\n",
       "      <td>1</td>\n",
       "      <td>白牡丹令</td>\n",
       "      <td>王秀</td>\n",
       "      <td>93495.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851842</th>\n",
       "      <td>154046770.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6749476</td>\n",
       "      <td>1</td>\n",
       "      <td>胡琴情歌-(单曲)</td>\n",
       "      <td>大庆小芳</td>\n",
       "      <td>236379.0</td>\n",
       "      <td>236.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851951</th>\n",
       "      <td>154581537.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6619401</td>\n",
       "      <td>1</td>\n",
       "      <td>明月</td>\n",
       "      <td>萌萌哒天团</td>\n",
       "      <td>190401.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851978</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9849616</td>\n",
       "      <td>1</td>\n",
       "      <td>最孤独的人</td>\n",
       "      <td>梦然</td>\n",
       "      <td>228407.0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851992</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6723472</td>\n",
       "      <td>1</td>\n",
       "      <td>当我孤独的时候还可以抱着你(Mix)</td>\n",
       "      <td>郑源&amp;DJ小飏</td>\n",
       "      <td>269584.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852051</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>14471593</td>\n",
       "      <td>1</td>\n",
       "      <td>追梦赤子心</td>\n",
       "      <td>阿啊龙哥哥</td>\n",
       "      <td>318996.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852292</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6663002</td>\n",
       "      <td>0</td>\n",
       "      <td>一半</td>\n",
       "      <td>薛之谦</td>\n",
       "      <td>122179.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852334</th>\n",
       "      <td>154627529.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>831653</td>\n",
       "      <td>1</td>\n",
       "      <td>极度放松睡眠轻音乐 鸟叫水声 催眠舒压音乐</td>\n",
       "      <td>轻音乐</td>\n",
       "      <td>298725.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852487</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6176523</td>\n",
       "      <td>1</td>\n",
       "      <td>Good Boy (2014MAMA In HK)</td>\n",
       "      <td>G-Dragon&amp;太阳</td>\n",
       "      <td>298692.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852526</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6700608</td>\n",
       "      <td>1</td>\n",
       "      <td>Love Yourself</td>\n",
       "      <td>Justin Bieber</td>\n",
       "      <td>233193.0</td>\n",
       "      <td>234.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852544</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1719569</td>\n",
       "      <td>0</td>\n",
       "      <td>伏笔</td>\n",
       "      <td>薛之谦</td>\n",
       "      <td>94970.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852548</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3194721</td>\n",
       "      <td>1</td>\n",
       "      <td>彩色的黑</td>\n",
       "      <td>吉克隽逸</td>\n",
       "      <td>246429.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852551</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7056885</td>\n",
       "      <td>1</td>\n",
       "      <td>雅俗共赏</td>\n",
       "      <td>许嵩</td>\n",
       "      <td>249528.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852552</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3973065</td>\n",
       "      <td>1</td>\n",
       "      <td>泡沫</td>\n",
       "      <td>G.E.M.邓紫棋</td>\n",
       "      <td>258502.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852556</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>240306</td>\n",
       "      <td>1</td>\n",
       "      <td>Innocence</td>\n",
       "      <td>Avril Lavigne</td>\n",
       "      <td>232267.0</td>\n",
       "      <td>233.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852599</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>678775</td>\n",
       "      <td>1</td>\n",
       "      <td>着魔</td>\n",
       "      <td>张杰</td>\n",
       "      <td>214495.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852653</th>\n",
       "      <td>154783495.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4243754</td>\n",
       "      <td>1</td>\n",
       "      <td>淋雨一直走</td>\n",
       "      <td>张韵涵</td>\n",
       "      <td>205114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852783</th>\n",
       "      <td>154712030.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7259837</td>\n",
       "      <td>1</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>宇西</td>\n",
       "      <td>216105.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852803</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>257344</td>\n",
       "      <td>1</td>\n",
       "      <td>军港之夜</td>\n",
       "      <td>苏小明</td>\n",
       "      <td>180791.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30929 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid device    song_id song_type  \\\n",
       "130        1685126.0    ar     501633         1    \n",
       "385        1685126.0    ar   20874724         1    \n",
       "578      154602677.0    ar   19321221         1    \n",
       "610      154572841.0    ar    3434894         1    \n",
       "648      154660090.0    ar    1273340         1    \n",
       "731        1685126.0    ar          0         1    \n",
       "811      154046770.0    ar    5237384         1    \n",
       "820      154814755.0    ar    7186091         1    \n",
       "840              0.0    ar    1014314         1    \n",
       "873              0.0    ar    1127698         1    \n",
       "915       31350521.0    ar    7922570         1    \n",
       "1083     154705043.0    ar    9921609         1    \n",
       "1187     154771880.0    ar    6982270         1    \n",
       "1302       1685126.0    ar    9853314         1    \n",
       "1386     154833762.0    ar   20870992         1    \n",
       "1409     154515640.0    ar    4224604         1    \n",
       "1419     154812842.0    ar    9950164         1    \n",
       "1460             0.0    ar     408642         1    \n",
       "1468      37025504.0    ar          0         1    \n",
       "1515     154421367.0    ar          0         1    \n",
       "1588     154812842.0    ar    9950164         1    \n",
       "1611     154819740.0    ar     119495         1    \n",
       "1673       1685126.0    ar     501633         1    \n",
       "1719       1685126.0    ar   20866497         1    \n",
       "1733     154046770.0    ar    5237384         1    \n",
       "1863     154579632.0    ar    6987249         1    \n",
       "1898     154693758.0    ar    4952486         1    \n",
       "2140     154572841.0    ar     901858         1    \n",
       "2286     154605005.0    ar    6633172         1    \n",
       "2401             0.0    ar    1127698         1    \n",
       "...              ...    ...        ...       ...   \n",
       "1850819  154425585.0    ar     706535         1    \n",
       "1850871    1685126.0    ar    6449273         0    \n",
       "1850923    1685126.0    ar   15249349         1    \n",
       "1850977  154629900.0    ar   15249349         1    \n",
       "1851028   28638487.0    ar    6561202         1    \n",
       "1851127  154819740.0    ar     825131         1    \n",
       "1851156  154709374.0    ar    5946238         0    \n",
       "1851263    1685126.0    ar    7089537         0    \n",
       "1851443    1685126.0    ar     125802         1    \n",
       "1851538  154578229.0    ar    4199996         0    \n",
       "1851556  154667416.0    ar    5225755         1    \n",
       "1851569  154725429.0    ar    3695405         1    \n",
       "1851842  154046770.0    ar    6749476         1    \n",
       "1851951  154581537.0    ar    6619401         1    \n",
       "1851978    1685126.0    ar    9849616         1    \n",
       "1851992    1749320.0    ar    6723472         1    \n",
       "1852051          0.0    ar   14471593         1    \n",
       "1852292    1685126.0    ar    6663002         0    \n",
       "1852334  154627529.0    ar     831653         1    \n",
       "1852487    1685126.0    ar    6176523         1    \n",
       "1852526    1685126.0    ar    6700608         1    \n",
       "1852544    1685126.0    ar    1719569         0    \n",
       "1852548    1685126.0    ar    3194721         1    \n",
       "1852551    1685126.0    ar    7056885         1    \n",
       "1852552    1685126.0    ar    3973065         1    \n",
       "1852556    1685126.0    ar     240306         1    \n",
       "1852599    1749320.0    ar     678775         1    \n",
       "1852653  154783495.0    ar    4243754         1    \n",
       "1852783  154712030.0    ar    7259837         1    \n",
       "1852803    1685126.0    ar     257344         1    \n",
       "\n",
       "                               song_name                   singer  play_time  \\\n",
       "130                             美丽的香格里拉                     天籁组合    205218.0   \n",
       "385                                  寂寞                      郭美美    273549.0   \n",
       "578                              很奇怪我爱你                       张杰    394152.0   \n",
       "610      Bang Bang Bang(DJ 4qiao Remix)                     英文慢摇    285884.0   \n",
       "648                 Let's Buy Happiness               Boys Noize    295724.0   \n",
       "731                              任逍遥-巫娜                       巫娜    327262.0   \n",
       "811                                逆流成河                      金南玲    125202.0   \n",
       "820                                  心锁                   冷漠&杨小曼    255936.0   \n",
       "840                                你的眼睛                  许茹芸&熊天平    287881.0   \n",
       "873                                  奔跑                      羽·泉    196963.0   \n",
       "915           微微一笑很倾城-(电视剧《微微一笑很倾城》片尾曲)                       杨洋    204939.0   \n",
       "1083                  彼岸-(电视剧《兰陵王妃》主题曲)                       董贞    241905.0   \n",
       "1187                             Temple   G-Dragon&M.I.A.&Baauer    183531.0   \n",
       "1302                             流着泪说分手                      苏立生    275760.0   \n",
       "1386                               盛夏光年                      林忆莲    222965.0   \n",
       "1409                                无底线                       本兮    211452.0   \n",
       "1419                              刚好遇见你                      李玉刚    199876.0   \n",
       "1460                        Knock Knock                    Lenka    220775.0   \n",
       "1468                  Dream It Possible                      张靓颖    219107.0   \n",
       "1515                 许嵩 - 多余的解释 [mqms2]                     未知歌手    274943.0   \n",
       "1588                              刚好遇见你                      李玉刚    199876.0   \n",
       "1611                              忘不掉的伤                      姜玉阳    249568.0   \n",
       "1673                            美丽的香格里拉                     天籁组合    205166.0   \n",
       "1719                           向天再要500话                上海彩虹室内合唱团    193492.0   \n",
       "1733                               逆流成河                      金南玲    125295.0   \n",
       "1863                               这个年纪                       齐一    284428.0   \n",
       "1898                         小情歌 (Live)                      苏打绿    277801.0   \n",
       "2140                     Bang Bang Bang                    MBLAQ    211023.0   \n",
       "2286                               爱如星火                   杨小曼&冷漠    260461.0   \n",
       "2401                                 奔跑                      羽·泉    196702.0   \n",
       "...                                  ...                      ...        ...   \n",
       "1850819                       孤单的身影寂寞的夜                      刘凤瑶    290249.0   \n",
       "1850871                              绅士                      薛之谦    103575.0   \n",
       "1850923           凉凉-(电视剧《三生三世十里桃花》片尾曲)                  张碧晨&杨宗纬    333122.0   \n",
       "1850977           凉凉-(电视剧《三生三世十里桃花》片尾曲)                  张碧晨&杨宗纬    333928.0   \n",
       "1851028                      大梦想家 (现场版)                   TFBOYS    110109.0   \n",
       "1851127                             子时过                      姜玉阳    211952.0   \n",
       "1851156    湛江 Dj 浩仔 什么爱叫地久天长 Club 中文 7辑                     网络歌手     98506.0   \n",
       "1851263                             初学者                      薛之谦    114741.0   \n",
       "1851443                              曹操                      林俊杰    240977.0   \n",
       "1851538                            多喜欢你                       晓雨     92074.0   \n",
       "1851556                              想你                      金贵晟    282427.0   \n",
       "1851569                            白牡丹令                       王秀     93495.0   \n",
       "1851842                       胡琴情歌-(单曲)                     大庆小芳    236379.0   \n",
       "1851951                              明月                    萌萌哒天团    190401.0   \n",
       "1851978                           最孤独的人                       梦然    228407.0   \n",
       "1851992              当我孤独的时候还可以抱着你(Mix)                  郑源&DJ小飏    269584.0   \n",
       "1852051                           追梦赤子心                    阿啊龙哥哥    318996.0   \n",
       "1852292                              一半                      薛之谦    122179.0   \n",
       "1852334           极度放松睡眠轻音乐 鸟叫水声 催眠舒压音乐                      轻音乐    298725.0   \n",
       "1852487       Good Boy (2014MAMA In HK)              G-Dragon&太阳    298692.0   \n",
       "1852526                   Love Yourself            Justin Bieber    233193.0   \n",
       "1852544                              伏笔                      薛之谦     94970.0   \n",
       "1852548                            彩色的黑                     吉克隽逸    246429.0   \n",
       "1852551                            雅俗共赏                       许嵩    249528.0   \n",
       "1852552                              泡沫                G.E.M.邓紫棋    258502.0   \n",
       "1852556                       Innocence            Avril Lavigne    232267.0   \n",
       "1852599                              着魔                       张杰    214495.0   \n",
       "1852653                           淋雨一直走                      张韵涵    205114.0   \n",
       "1852783                            告白气球                       宇西    216105.0   \n",
       "1852803                            军港之夜                      苏小明    180791.0   \n",
       "\n",
       "         song_length  paid_flag             file_name       date  \n",
       "130              0.0        0.0   20170303_1_play.log   20170303  \n",
       "385            273.0        0.0   20170303_1_play.log   20170303  \n",
       "578            394.0        0.0   20170303_1_play.log   20170303  \n",
       "610              0.0        0.0   20170303_1_play.log   20170303  \n",
       "648            293.0        0.0   20170303_1_play.log   20170303  \n",
       "731            327.0        0.0   20170303_1_play.log   20170303  \n",
       "811            125.0        0.0   20170303_1_play.log   20170303  \n",
       "820              0.0        0.0   20170303_1_play.log   20170303  \n",
       "840              0.0        0.0   20170303_1_play.log   20170303  \n",
       "873            197.0        0.0   20170303_1_play.log   20170303  \n",
       "915              0.0        0.0   20170303_1_play.log   20170303  \n",
       "1083             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1187             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1302           276.0        0.0   20170303_1_play.log   20170303  \n",
       "1386           223.0        0.0   20170303_1_play.log   20170303  \n",
       "1409             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1419             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1460           222.0        0.0   20170303_1_play.log   20170303  \n",
       "1468           219.0        0.0   20170303_1_play.log   20170303  \n",
       "1515           275.0        0.0   20170303_1_play.log   20170303  \n",
       "1588             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1611             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1673             0.0        0.0   20170303_1_play.log   20170303  \n",
       "1719           194.0        0.0   20170303_1_play.log   20170303  \n",
       "1733           125.0        0.0   20170303_1_play.log   20170303  \n",
       "1863           284.0        0.0   20170303_1_play.log   20170303  \n",
       "1898           278.0        0.0   20170303_1_play.log   20170303  \n",
       "2140             0.0        0.0   20170303_1_play.log   20170303  \n",
       "2286             0.0        0.0   20170303_1_play.log   20170303  \n",
       "2401           197.0        0.0   20170303_1_play.log   20170303  \n",
       "...              ...        ...                   ...        ...  \n",
       "1850819          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1850871          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1850923          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1850977          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851028        194.0        0.0   20170303_1_play.log   20170303  \n",
       "1851127          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851156          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851263          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851443          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851538          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851556          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851569          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851842        236.0        0.0   20170303_1_play.log   20170303  \n",
       "1851951          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1851978        228.0        0.0   20170303_1_play.log   20170303  \n",
       "1851992        270.0        0.0   20170303_1_play.log   20170303  \n",
       "1852051          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852292          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852334        300.0        0.0   20170303_1_play.log   20170303  \n",
       "1852487          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852526        234.0        0.0   20170303_1_play.log   20170303  \n",
       "1852544          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852548          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852551          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852552        273.0        0.0   20170303_1_play.log   20170303  \n",
       "1852556        233.0        0.0   20170303_1_play.log   20170303  \n",
       "1852599          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852653          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852783          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852803          0.0        0.0   20170303_1_play.log   20170303  \n",
       "\n",
       "[30929 rows x 11 columns]"
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many rows are over 86400 second (24 hours) in play_time\n",
    "df_play.loc[df_play['play_time'] > 86400]  #30929 rows\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1086643</th>\n",
       "      <td>154657020.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>20272138</td>\n",
       "      <td>2</td>\n",
       "      <td>种族天赋rap！不要让黑人玩儿守望先锋！</td>\n",
       "      <td>小可儿</td>\n",
       "      <td>-0.091001</td>\n",
       "      <td>69.161667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1122181</th>\n",
       "      <td>154597706.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>7212494</td>\n",
       "      <td>2</td>\n",
       "      <td>葫芦娃</td>\n",
       "      <td>大张伟</td>\n",
       "      <td>-0.013977</td>\n",
       "      <td>189.660000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1122184</th>\n",
       "      <td>154597706.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>7212494</td>\n",
       "      <td>2</td>\n",
       "      <td>葫芦娃</td>\n",
       "      <td>大张伟</td>\n",
       "      <td>-0.013977</td>\n",
       "      <td>189.660000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1795294</th>\n",
       "      <td>154740876.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6819236</td>\n",
       "      <td>2</td>\n",
       "      <td>不完美小孩</td>\n",
       "      <td>TFBOYS</td>\n",
       "      <td>-0.010199</td>\n",
       "      <td>267.561667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1795335</th>\n",
       "      <td>154740876.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4070224</td>\n",
       "      <td>2</td>\n",
       "      <td>魔法城堡{动画电影《洛克王国3</td>\n",
       "      <td>TFBOYS</td>\n",
       "      <td>-0.010199</td>\n",
       "      <td>267.561667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid device    song_id song_type              song_name  \\\n",
       "1086643  154657020.0    ip   20272138         2   种族天赋rap！不要让黑人玩儿守望先锋！    \n",
       "1122181  154597706.0    ip    7212494         2                    葫芦娃    \n",
       "1122184  154597706.0    ip    7212494         2                    葫芦娃    \n",
       "1795294  154740876.0    ip    6819236         2                  不完美小孩    \n",
       "1795335  154740876.0    ip    4070224         2        魔法城堡{动画电影《洛克王国3    \n",
       "\n",
       "          singer  play_time  song_length  paid_flag             file_name  \\\n",
       "1086643     小可儿   -0.091001    69.161667        0.0   20170303_1_play.log   \n",
       "1122181     大张伟   -0.013977   189.660000        0.0   20170303_1_play.log   \n",
       "1122184     大张伟   -0.013977   189.660000        0.0   20170303_1_play.log   \n",
       "1795294  TFBOYS   -0.010199   267.561667        0.0   20170303_1_play.log   \n",
       "1795335  TFBOYS   -0.010199   267.561667        0.0   20170303_1_play.log   \n",
       "\n",
       "              date  \n",
       "1086643   20170303  \n",
       "1122181   20170303  \n",
       "1122184   20170303  \n",
       "1795294   20170303  \n",
       "1795335   20170303  "
      ]
     },
     "execution_count": 231,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many rows are less than 0 second in play_time\n",
    "df_play.loc[df_play['play_time'] < 0]  \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(242.99012957746075, 274944.0, -1.0, 233.0)"
      ]
     },
     "execution_count": 244,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# statistics of song_length\n",
    "df_play.song_length.mean(),df_play.song_length.max(),df_play.song_length.min(),df_play.song_length.median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>154750654.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>10740680</td>\n",
       "      <td>0</td>\n",
       "      <td>胸是软绵绵的</td>\n",
       "      <td>MC马克</td>\n",
       "      <td>76.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1635733</td>\n",
       "      <td>0</td>\n",
       "      <td>无限可能</td>\n",
       "      <td>丢火车乐队</td>\n",
       "      <td>245.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>696542</td>\n",
       "      <td>0</td>\n",
       "      <td>蓝精灵</td>\n",
       "      <td>儿童歌曲</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>154825738.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>229871</td>\n",
       "      <td>0</td>\n",
       "      <td>真爱你的云</td>\n",
       "      <td>黄国俊</td>\n",
       "      <td>306.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>154479534.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4781125</td>\n",
       "      <td>0</td>\n",
       "      <td>2008 年最嗨最劲加快全中文串烧 51音 dj</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>14174.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>154491154.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4498859</td>\n",
       "      <td>0</td>\n",
       "      <td>情人节(爱情歌曲)</td>\n",
       "      <td>吴克群</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>154479534.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4720145</td>\n",
       "      <td>0</td>\n",
       "      <td>dj 晓东 dj2011 年 最嗨最劲加快全中文串烧</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>3906.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4205975</td>\n",
       "      <td>0</td>\n",
       "      <td>奢香夫人(二妞音像 二妞音像)</td>\n",
       "      <td>凤凰传奇</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>501633</td>\n",
       "      <td>1</td>\n",
       "      <td>美丽的香格里拉</td>\n",
       "      <td>天籁组合</td>\n",
       "      <td>205218.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>154479534.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4720145</td>\n",
       "      <td>0</td>\n",
       "      <td>dj 晓东 dj2011 年 最嗨最劲加快全中文串烧</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>5477.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>154802255.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>156522</td>\n",
       "      <td>0</td>\n",
       "      <td>简单爱</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>154802255.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>15249349</td>\n",
       "      <td>0</td>\n",
       "      <td>凉凉-(电视剧《三生三世十里桃花》片尾曲)</td>\n",
       "      <td>张碧晨&amp;杨宗纬</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>154415149.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>492209</td>\n",
       "      <td>0</td>\n",
       "      <td>冬天的秘密</td>\n",
       "      <td>周传雄</td>\n",
       "      <td>266.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>610674</td>\n",
       "      <td>0</td>\n",
       "      <td>想你的习惯</td>\n",
       "      <td>小宇</td>\n",
       "      <td>254.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>154427910.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>576245</td>\n",
       "      <td>0</td>\n",
       "      <td>004岳飞传</td>\n",
       "      <td>刘兰芳</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>154617392.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6418102</td>\n",
       "      <td>0</td>\n",
       "      <td>默-(电影《何以笙箫默》插曲)</td>\n",
       "      <td>那英</td>\n",
       "      <td>324.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>154415149.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>8339943</td>\n",
       "      <td>0</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>周二珂</td>\n",
       "      <td>266.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>154415149.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>93157</td>\n",
       "      <td>0</td>\n",
       "      <td>江南</td>\n",
       "      <td>林俊杰</td>\n",
       "      <td>266.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>154732740.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6698910</td>\n",
       "      <td>0</td>\n",
       "      <td>I'll Be Back(33秒铃声版)</td>\n",
       "      <td>张玮</td>\n",
       "      <td>33.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>154593328.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6522717</td>\n",
       "      <td>0</td>\n",
       "      <td>回忆总想哭</td>\n",
       "      <td>姜玉阳&amp;南宫嘉骏</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>154415149.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>20273752</td>\n",
       "      <td>0</td>\n",
       "      <td>就算没有如果-(电视剧《三生三世十里桃花》插曲)</td>\n",
       "      <td>香香</td>\n",
       "      <td>266.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>154491154.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>485780</td>\n",
       "      <td>0</td>\n",
       "      <td>好男人</td>\n",
       "      <td>陈小春</td>\n",
       "      <td>53.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>154427910.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>576255</td>\n",
       "      <td>0</td>\n",
       "      <td>014岳飞传</td>\n",
       "      <td>刘兰芳</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1223975</td>\n",
       "      <td>0</td>\n",
       "      <td>邂逅</td>\n",
       "      <td>陈瑞</td>\n",
       "      <td>218.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>154578231.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3569565</td>\n",
       "      <td>0</td>\n",
       "      <td>走在冷风中(Bonus Track)</td>\n",
       "      <td>刘思涵</td>\n",
       "      <td>214.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7792912</td>\n",
       "      <td>0</td>\n",
       "      <td>你不来我不老</td>\n",
       "      <td>高安/西单女孩</td>\n",
       "      <td>286.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>154427910.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>576249</td>\n",
       "      <td>0</td>\n",
       "      <td>008岳飞传</td>\n",
       "      <td>刘兰芳</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>11880750</td>\n",
       "      <td>0</td>\n",
       "      <td>白首相依-(电视剧《锦绣未央》插曲)</td>\n",
       "      <td>金池&amp;孙伯纶</td>\n",
       "      <td>243.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>154427910.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>576245</td>\n",
       "      <td>0</td>\n",
       "      <td>004岳飞传</td>\n",
       "      <td>刘兰芳</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>154604187.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1081994</td>\n",
       "      <td>0</td>\n",
       "      <td>许诺(《白蛇传说》电影主题曲)</td>\n",
       "      <td>林峯&amp;黄圣依</td>\n",
       "      <td>247.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852855</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6994556</td>\n",
       "      <td>0</td>\n",
       "      <td>马头琴的传说</td>\n",
       "      <td>龚玥</td>\n",
       "      <td>272.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852860</th>\n",
       "      <td>154789354.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6427523</td>\n",
       "      <td>0</td>\n",
       "      <td>Victory</td>\n",
       "      <td>Two Steps From Hell</td>\n",
       "      <td>159.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852869</th>\n",
       "      <td>154811144.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6710687</td>\n",
       "      <td>0</td>\n",
       "      <td>Purely Sky ?私だけの空?</td>\n",
       "      <td>荒川ちか</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852870</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5008438</td>\n",
       "      <td>0</td>\n",
       "      <td>伤不起的爱情伤不起的你 - 铃声 dj 版</td>\n",
       "      <td>彭清</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852878</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>908195</td>\n",
       "      <td>0</td>\n",
       "      <td>当你</td>\n",
       "      <td>林俊杰</td>\n",
       "      <td>251.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852887</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>340126</td>\n",
       "      <td>0</td>\n",
       "      <td>别再说你爱着我</td>\n",
       "      <td>段千寻</td>\n",
       "      <td>244.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852890</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4403634</td>\n",
       "      <td>0</td>\n",
       "      <td>永远放你在心底</td>\n",
       "      <td>晨熙&amp;司徒兰芳</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852894</th>\n",
       "      <td>154747302.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>10842636</td>\n",
       "      <td>0</td>\n",
       "      <td>恋西游</td>\n",
       "      <td>TF BOYS</td>\n",
       "      <td>170.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852895</th>\n",
       "      <td>154550090.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6468891</td>\n",
       "      <td>1</td>\n",
       "      <td>演员</td>\n",
       "      <td>薛之谦</td>\n",
       "      <td>907.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852898</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6175607</td>\n",
       "      <td>1</td>\n",
       "      <td>可惜没如果 (OS版)</td>\n",
       "      <td>林俊杰</td>\n",
       "      <td>900.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852911</th>\n",
       "      <td>0.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9820661</td>\n",
       "      <td>0</td>\n",
       "      <td>爱是一个疯字(43秒铃声版)</td>\n",
       "      <td>杨洋</td>\n",
       "      <td>3420.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852918</th>\n",
       "      <td>154753599.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9950164</td>\n",
       "      <td>0</td>\n",
       "      <td>刚好遇见你</td>\n",
       "      <td>李玉刚</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852920</th>\n",
       "      <td>154622699.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>555138</td>\n",
       "      <td>0</td>\n",
       "      <td>我想大声告诉你</td>\n",
       "      <td>樊凡</td>\n",
       "      <td>265.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852924</th>\n",
       "      <td>37025504.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3228339</td>\n",
       "      <td>0</td>\n",
       "      <td>北京 北京</td>\n",
       "      <td>汪峰</td>\n",
       "      <td>73.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852928</th>\n",
       "      <td>154542409.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6639432</td>\n",
       "      <td>0</td>\n",
       "      <td>Everybody(Radio Edit)</td>\n",
       "      <td>Backstreet Boys</td>\n",
       "      <td>136.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852929</th>\n",
       "      <td>154680517.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5405749</td>\n",
       "      <td>0</td>\n",
       "      <td>别让爱你的人流泪</td>\n",
       "      <td>雨宗林</td>\n",
       "      <td>220.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852932</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6698121</td>\n",
       "      <td>0</td>\n",
       "      <td>Checkin Da Cutz fds</td>\n",
       "      <td>Orbit1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852936</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6698121</td>\n",
       "      <td>0</td>\n",
       "      <td>Checkin Da Cutz fds</td>\n",
       "      <td>Orbit1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852938</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5453576</td>\n",
       "      <td>0</td>\n",
       "      <td>泡沫(DJTerry Electro Mix)</td>\n",
       "      <td>艾歌</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852944</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4224840</td>\n",
       "      <td>0</td>\n",
       "      <td>Disco(岑溪 阿庆 2012嗨死算了 串烧)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852949</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>20671407</td>\n",
       "      <td>0</td>\n",
       "      <td>我已收起锋芒</td>\n",
       "      <td>MC阿峰</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852954</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6630538</td>\n",
       "      <td>0</td>\n",
       "      <td>时速157MB重鼓点喊麦喊麦DJ(DJ版)</td>\n",
       "      <td>MC小月</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852958</th>\n",
       "      <td>154775296.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9820875</td>\n",
       "      <td>0</td>\n",
       "      <td>余罪</td>\n",
       "      <td>MC魏小然</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852965</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4131086</td>\n",
       "      <td>0</td>\n",
       "      <td>乔巴</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852974</th>\n",
       "      <td>154635733.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4614613</td>\n",
       "      <td>0</td>\n",
       "      <td>云南山歌 云南小哥四川妹</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852976</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6148333</td>\n",
       "      <td>0</td>\n",
       "      <td>不想回家的女人(DJ版)</td>\n",
       "      <td>何鹏&amp;张津涤</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852982</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3529588</td>\n",
       "      <td>0</td>\n",
       "      <td>L.O.V.E.</td>\n",
       "      <td>Ashlee Simpson</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852989</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9845684</td>\n",
       "      <td>0</td>\n",
       "      <td>你的过去我不介意(2016 Extended Mix)</td>\n",
       "      <td>DJ阿远</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852994</th>\n",
       "      <td>154635733.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4427850</td>\n",
       "      <td>0</td>\n",
       "      <td>云南山歌 说说钱来讲讲钱</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>1007.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852996</th>\n",
       "      <td>154530853.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6910826</td>\n",
       "      <td>0</td>\n",
       "      <td>Maximizer</td>\n",
       "      <td>Alex S</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>223210 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid device    song_id song_type  \\\n",
       "0        154750654.0    ar   10740680         0    \n",
       "21        37025504.0    ar    1635733         0    \n",
       "22         1685126.0    ar     696542         0    \n",
       "33       154825738.0    ar     229871         0    \n",
       "53       154479534.0    ar    4781125         0    \n",
       "80       154491154.0    ar    4498859         0    \n",
       "89       154479534.0    ar    4720145         0    \n",
       "129        1685126.0    ar    4205975         0    \n",
       "130        1685126.0    ar     501633         1    \n",
       "140      154479534.0    ar    4720145         0    \n",
       "144      154802255.0    ar     156522         0    \n",
       "150      154802255.0    ar   15249349         0    \n",
       "153      154415149.0    ar     492209         0    \n",
       "162        1685126.0    ar     610674         0    \n",
       "166      154427910.0    ar     576245         0    \n",
       "183      154617392.0    ar    6418102         0    \n",
       "216      154415149.0    ar    8339943         0    \n",
       "242      154415149.0    ar      93157         0    \n",
       "246      154732740.0    ar    6698910         0    \n",
       "254      154593328.0    ip    6522717         0    \n",
       "258      154415149.0    ar   20273752         0    \n",
       "260      154491154.0    ar     485780         0    \n",
       "263      154427910.0    ar     576255         0    \n",
       "267        1685126.0    ar    1223975         0    \n",
       "283      154578231.0    ar    3569565         0    \n",
       "292       37025504.0    ar    7792912         0    \n",
       "319      154427910.0    ar     576249         0    \n",
       "321       37025504.0    ar   11880750         0    \n",
       "343      154427910.0    ar     576245         0    \n",
       "345      154604187.0    ar    1081994         0    \n",
       "...              ...    ...        ...       ...   \n",
       "1852855   37025504.0    ar    6994556         0    \n",
       "1852860  154789354.0    ar    6427523         0    \n",
       "1852869  154811144.0    ar    6710687         0    \n",
       "1852870    1685126.0    ar    5008438         0    \n",
       "1852878    1685126.0    ar     908195         0    \n",
       "1852887   37025504.0    ar     340126         0    \n",
       "1852890    1685126.0    ar    4403634         0    \n",
       "1852894  154747302.0    ar   10842636         0    \n",
       "1852895  154550090.0    ar    6468891         1    \n",
       "1852898          0.0    ar    6175607         1    \n",
       "1852911          0.0    ar    9820661         0    \n",
       "1852918  154753599.0    ar    9950164         0    \n",
       "1852920  154622699.0    ar     555138         0    \n",
       "1852924   37025504.0    ar    3228339         0    \n",
       "1852928  154542409.0    ar    6639432         0    \n",
       "1852929  154680517.0    ar    5405749         0    \n",
       "1852932  154530853.0    ar    6698121         0    \n",
       "1852936  154530853.0    ar    6698121         0    \n",
       "1852938  154530853.0    ar    5453576         0    \n",
       "1852944  154530853.0    ar    4224840         0    \n",
       "1852949  154530853.0    ar   20671407         0    \n",
       "1852954  154530853.0    ar    6630538         0    \n",
       "1852958  154775296.0    ar    9820875         0    \n",
       "1852965    1685126.0    ar    4131086         0    \n",
       "1852974  154635733.0    ar    4614613         0    \n",
       "1852976  154530853.0    ar    6148333         0    \n",
       "1852982  154530853.0    ar    3529588         0    \n",
       "1852989  154530853.0    ar    9845684         0    \n",
       "1852994  154635733.0    ar    4427850         0    \n",
       "1852996  154530853.0    ar    6910826         0    \n",
       "\n",
       "                            song_name                singer  play_time  \\\n",
       "0                             胸是软绵绵的                  MC马克        76.0   \n",
       "21                              无限可能                 丢火车乐队       245.0   \n",
       "22                               蓝精灵                  儿童歌曲        98.0   \n",
       "33                             真爱你的云                   黄国俊       306.0   \n",
       "53          2008 年最嗨最劲加快全中文串烧 51音 dj                  DJ舞曲     14174.0   \n",
       "80                         情人节(爱情歌曲)                   吴克群        63.0   \n",
       "89        dj 晓东 dj2011 年 最嗨最劲加快全中文串烧                  网络歌手      3906.0   \n",
       "129                  奢香夫人(二妞音像 二妞音像)                  凤凰传奇       255.0   \n",
       "130                          美丽的香格里拉                  天籁组合    205218.0   \n",
       "140       dj 晓东 dj2011 年 最嗨最劲加快全中文串烧                  网络歌手      5477.0   \n",
       "144                              简单爱                   周杰伦         0.0   \n",
       "150            凉凉-(电视剧《三生三世十里桃花》片尾曲)               张碧晨&杨宗纬         0.0   \n",
       "153                            冬天的秘密                   周传雄       266.0   \n",
       "162                            想你的习惯                    小宇       254.0   \n",
       "166                           004岳飞传                   刘兰芳         0.0   \n",
       "183                  默-(电影《何以笙箫默》插曲)                    那英       324.0   \n",
       "216                             告白气球                   周二珂       266.0   \n",
       "242                               江南                   林俊杰       266.0   \n",
       "246             I'll Be Back(33秒铃声版)                    张玮        33.0   \n",
       "254                            回忆总想哭              姜玉阳&南宫嘉骏         0.0   \n",
       "258         就算没有如果-(电视剧《三生三世十里桃花》插曲)                    香香       266.0   \n",
       "260                              好男人                   陈小春        53.0   \n",
       "263                           014岳飞传                   刘兰芳         0.0   \n",
       "267                               邂逅                    陈瑞       218.0   \n",
       "283               走在冷风中(Bonus Track)                   刘思涵       214.0   \n",
       "292                           你不来我不老               高安/西单女孩       286.0   \n",
       "319                           008岳飞传                   刘兰芳         0.0   \n",
       "321               白首相依-(电视剧《锦绣未央》插曲)                金池&孙伯纶       243.0   \n",
       "343                           004岳飞传                   刘兰芳         0.0   \n",
       "345                  许诺(《白蛇传说》电影主题曲)                林峯&黄圣依       247.0   \n",
       "...                               ...                   ...        ...   \n",
       "1852855                       马头琴的传说                    龚玥       272.0   \n",
       "1852860                      Victory   Two Steps From Hell       159.0   \n",
       "1852869           Purely Sky ?私だけの空?                  荒川ちか         0.0   \n",
       "1852870        伤不起的爱情伤不起的你 - 铃声 dj 版                    彭清        14.0   \n",
       "1852878                           当你                   林俊杰       251.0   \n",
       "1852887                      别再说你爱着我                   段千寻       244.0   \n",
       "1852890                      永远放你在心底               晨熙&司徒兰芳        71.0   \n",
       "1852894                          恋西游               TF BOYS       170.0   \n",
       "1852895                           演员                   薛之谦       907.0   \n",
       "1852898                  可惜没如果 (OS版)                   林俊杰       900.0   \n",
       "1852911               爱是一个疯字(43秒铃声版)                    杨洋      3420.0   \n",
       "1852918                        刚好遇见你                   李玉刚        21.0   \n",
       "1852920                      我想大声告诉你                    樊凡       265.0   \n",
       "1852924                        北京 北京                    汪峰        73.0   \n",
       "1852928        Everybody(Radio Edit)       Backstreet Boys       136.0   \n",
       "1852929                     别让爱你的人流泪                   雨宗林       220.0   \n",
       "1852932          Checkin Da Cutz fds                Orbit1         0.0   \n",
       "1852936          Checkin Da Cutz fds                Orbit1         0.0   \n",
       "1852938      泡沫(DJTerry Electro Mix)                    艾歌         0.0   \n",
       "1852944     Disco(岑溪 阿庆 2012嗨死算了 串烧)                  DJ舞曲         0.0   \n",
       "1852949                       我已收起锋芒                  MC阿峰         0.0   \n",
       "1852954        时速157MB重鼓点喊麦喊麦DJ(DJ版)                  MC小月         0.0   \n",
       "1852958                           余罪                 MC魏小然        75.0   \n",
       "1852965                           乔巴                   海贼王         4.0   \n",
       "1852974                 云南山歌 云南小哥四川妹                  网络歌手       255.0   \n",
       "1852976                 不想回家的女人(DJ版)                何鹏&张津涤         0.0   \n",
       "1852982                     L.O.V.E.        Ashlee Simpson         0.0   \n",
       "1852989  你的过去我不介意(2016 Extended Mix)                  DJ阿远         0.0   \n",
       "1852994                 云南山歌 说说钱来讲讲钱                  网络歌手      1007.0   \n",
       "1852996                    Maximizer                Alex S         0.0   \n",
       "\n",
       "         song_length  paid_flag             file_name       date  \n",
       "0                0.0        0.0   20170303_1_play.log   20170303  \n",
       "21               0.0        0.0   20170303_1_play.log   20170303  \n",
       "22               0.0        0.0   20170303_1_play.log   20170303  \n",
       "33               0.0        0.0   20170303_1_play.log   20170303  \n",
       "53               0.0        0.0   20170303_1_play.log   20170303  \n",
       "80               0.0        0.0   20170303_1_play.log   20170303  \n",
       "89               0.0        0.0   20170303_1_play.log   20170303  \n",
       "129              0.0        0.0   20170303_1_play.log   20170303  \n",
       "130              0.0        0.0   20170303_1_play.log   20170303  \n",
       "140              0.0        0.0   20170303_1_play.log   20170303  \n",
       "144              0.0        0.0   20170303_1_play.log   20170303  \n",
       "150              0.0        0.0   20170303_1_play.log   20170303  \n",
       "153              0.0        0.0   20170303_1_play.log   20170303  \n",
       "162              0.0        0.0   20170303_1_play.log   20170303  \n",
       "166              0.0        0.0   20170303_1_play.log   20170303  \n",
       "183              0.0        0.0   20170303_1_play.log   20170303  \n",
       "216              0.0        0.0   20170303_1_play.log   20170303  \n",
       "242              0.0        0.0   20170303_1_play.log   20170303  \n",
       "246              0.0        0.0   20170303_1_play.log   20170303  \n",
       "254              0.0        0.0   20170303_1_play.log   20170303  \n",
       "258              0.0        0.0   20170303_1_play.log   20170303  \n",
       "260              0.0        0.0   20170303_1_play.log   20170303  \n",
       "263              0.0        0.0   20170303_1_play.log   20170303  \n",
       "267              0.0        0.0   20170303_1_play.log   20170303  \n",
       "283              0.0        0.0   20170303_1_play.log   20170303  \n",
       "292              0.0        0.0   20170303_1_play.log   20170303  \n",
       "319              0.0        0.0   20170303_1_play.log   20170303  \n",
       "321              0.0        0.0   20170303_1_play.log   20170303  \n",
       "343              0.0        0.0   20170303_1_play.log   20170303  \n",
       "345              0.0        0.0   20170303_1_play.log   20170303  \n",
       "...              ...        ...                   ...        ...  \n",
       "1852855          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852860          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852869          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852870          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852878          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852887          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852890          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852894          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852895          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852898          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852911          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852918          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852920          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852924          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852928          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852929          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852932          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852936          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852938          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852944          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852949          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852954          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852958          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852965          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852974          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852976          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852982          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852989          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852994          0.0        0.0   20170303_1_play.log   20170303  \n",
       "1852996          0.0        0.0   20170303_1_play.log   20170303  \n",
       "\n",
       "[223210 rows x 11 columns]"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many rows are equals 0 second in song_length\n",
    "df_play.loc[df_play['song_length'] == 0] # 223210 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 245,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48929</th>\n",
       "      <td>154823377.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6851407</td>\n",
       "      <td>1</td>\n",
       "      <td>梦回还-(动漫《狐妖小红娘 第二季》OP)</td>\n",
       "      <td>动漫原声</td>\n",
       "      <td>1541.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48936</th>\n",
       "      <td>154823377.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6851407</td>\n",
       "      <td>1</td>\n",
       "      <td>梦回还-(动漫《狐妖小红娘 第二季》OP)</td>\n",
       "      <td>动漫原声</td>\n",
       "      <td>216.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154248</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>19205.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155943</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>67079.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158247</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>101881.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158386</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6017146</td>\n",
       "      <td>1</td>\n",
       "      <td>适合婴儿听的歌曲 Mp3</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>6919.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158668</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4246388</td>\n",
       "      <td>1</td>\n",
       "      <td>娃哈哈(婴幼儿歌曲大全 App,X240 0)</td>\n",
       "      <td>儿歌</td>\n",
       "      <td>11735.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158762</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4678227</td>\n",
       "      <td>1</td>\n",
       "      <td>超清脆的八音盒音乐 可爱的婴儿呢喃 未知</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>4850.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158897</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6994473</td>\n",
       "      <td>1</td>\n",
       "      <td>婴儿发出的笑声</td>\n",
       "      <td>儿童歌曲</td>\n",
       "      <td>6076.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158989</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6994476</td>\n",
       "      <td>1</td>\n",
       "      <td>听力训练</td>\n",
       "      <td>儿童歌曲</td>\n",
       "      <td>3842.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159097</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4378806</td>\n",
       "      <td>1</td>\n",
       "      <td>婴儿</td>\n",
       "      <td>英文歌曲</td>\n",
       "      <td>3861.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159184</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>12413872</td>\n",
       "      <td>1</td>\n",
       "      <td>贝多芬</td>\n",
       "      <td>贝多芬</td>\n",
       "      <td>3665.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159213</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4434999</td>\n",
       "      <td>1</td>\n",
       "      <td>婴儿 安抚音乐</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>1179.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159399</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4474395</td>\n",
       "      <td>1</td>\n",
       "      <td>潜能开发 右脑开发 波右脑激活音乐</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>9665.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159792</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4625213</td>\n",
       "      <td>1</td>\n",
       "      <td>开发右脑音乐阿尔法脑波</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>15940.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159868</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>14196710</td>\n",
       "      <td>1</td>\n",
       "      <td>开发右脑音乐 脑波 output</td>\n",
       "      <td>纯音乐</td>\n",
       "      <td>4537.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160076</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5680093</td>\n",
       "      <td>1</td>\n",
       "      <td>四字佛号 净空老法师诵念</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>10388.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160161</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4562075</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念诵四字佛号(慢版)mp3</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>4150.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160317</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5606293</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念诵四字佛号</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>8571.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160496</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4476983</td>\n",
       "      <td>1</td>\n",
       "      <td>净空老法师念佛佛号</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>8019.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160648</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5638883</td>\n",
       "      <td>1</td>\n",
       "      <td>阿弥陀佛四字佛号 净空法师念诵</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>8807.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161006</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5606293</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念诵四字佛号</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>15419.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161757</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4476983</td>\n",
       "      <td>1</td>\n",
       "      <td>净空老法师念佛佛号</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>26240.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161876</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5638883</td>\n",
       "      <td>1</td>\n",
       "      <td>阿弥陀佛四字佛号 净空法师念诵</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>8862.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162695</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4476983</td>\n",
       "      <td>1</td>\n",
       "      <td>净空老法师念佛佛号</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>32488.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163372</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5638883</td>\n",
       "      <td>1</td>\n",
       "      <td>阿弥陀佛四字佛号 净空法师念诵</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>33804.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164188</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>38121.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169212</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>232783.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170281</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6408308</td>\n",
       "      <td>1</td>\n",
       "      <td>净空法师念佛 阿弥陀佛</td>\n",
       "      <td>净空法师</td>\n",
       "      <td>50701.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175016</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4496800</td>\n",
       "      <td>0</td>\n",
       "      <td>健身气功 八段锦口令</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>8562.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1815019</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>13314046</td>\n",
       "      <td>1</td>\n",
       "      <td>Myanmar</td>\n",
       "      <td>Paul Mark</td>\n",
       "      <td>2588.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1815415</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>8577692</td>\n",
       "      <td>0</td>\n",
       "      <td>Gate of Heaven (Myanmar Cut)</td>\n",
       "      <td>Mahoroba</td>\n",
       "      <td>1395.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1817243</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>14212498</td>\n",
       "      <td>1</td>\n",
       "      <td>Myanmar</td>\n",
       "      <td>Ah Moon</td>\n",
       "      <td>2934.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1817862</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1334698</td>\n",
       "      <td>0</td>\n",
       "      <td>Weaving (Myanmar)</td>\n",
       "      <td>Robert Millis</td>\n",
       "      <td>2042.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1817998</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7421727</td>\n",
       "      <td>1</td>\n",
       "      <td>Myanmar</td>\n",
       "      <td>London Philharmonic Orchestra</td>\n",
       "      <td>1466.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818082</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5973366</td>\n",
       "      <td>0</td>\n",
       "      <td>007 Leaders - Myanmar and America</td>\n",
       "      <td>经济学人</td>\n",
       "      <td>1833.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818140</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4566559</td>\n",
       "      <td>0</td>\n",
       "      <td>4 Myanmar Passes Investment Law</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>2737.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818212</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>14186395</td>\n",
       "      <td>0</td>\n",
       "      <td>Osi</td>\n",
       "      <td>Myanmar Cultural Show Ensemble</td>\n",
       "      <td>2203.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818289</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>8620528</td>\n",
       "      <td>0</td>\n",
       "      <td>The Lost Temple (Myanmar Cut)</td>\n",
       "      <td>Sean Hayman</td>\n",
       "      <td>2534.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818388</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>13014088</td>\n",
       "      <td>0</td>\n",
       "      <td>The Secrets Of Myanmar Vol. 1 (Continuous Mix)</td>\n",
       "      <td>DJ Maretimo</td>\n",
       "      <td>1832.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818466</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>21094553</td>\n",
       "      <td>0</td>\n",
       "      <td>Song Of Elune</td>\n",
       "      <td>World of Warcraft</td>\n",
       "      <td>5990.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818523</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>913313</td>\n",
       "      <td>0</td>\n",
       "      <td>Love Song</td>\n",
       "      <td>浜崎あゆみ</td>\n",
       "      <td>2679.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818596</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6332699</td>\n",
       "      <td>0</td>\n",
       "      <td>myanmar song</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818789</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4076644</td>\n",
       "      <td>0</td>\n",
       "      <td>The Lazy Song</td>\n",
       "      <td>Bruno Mars</td>\n",
       "      <td>1804.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1818882</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4183152</td>\n",
       "      <td>0</td>\n",
       "      <td>Banana</td>\n",
       "      <td>G.NA</td>\n",
       "      <td>1992.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819035</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>14172229</td>\n",
       "      <td>0</td>\n",
       "      <td>SAYANG NA SAYANG</td>\n",
       "      <td>Aegis</td>\n",
       "      <td>1094.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819163</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1037083</td>\n",
       "      <td>0</td>\n",
       "      <td>A Bitter Day</td>\n",
       "      <td>泫雅&amp;龙俊亨&amp;G.NA</td>\n",
       "      <td>1268.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819225</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1829801</td>\n",
       "      <td>1</td>\n",
       "      <td>You Belong With Me</td>\n",
       "      <td>电影原声</td>\n",
       "      <td>4122.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819275</th>\n",
       "      <td>1749320.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>10677339</td>\n",
       "      <td>1</td>\n",
       "      <td>Back to December</td>\n",
       "      <td>Taylor Swift</td>\n",
       "      <td>3061.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1834457</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>8131548</td>\n",
       "      <td>0</td>\n",
       "      <td>怪我咯</td>\n",
       "      <td>童可可</td>\n",
       "      <td>66281.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1836287</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4356032</td>\n",
       "      <td>0</td>\n",
       "      <td>淋雨一直走</td>\n",
       "      <td>童可可</td>\n",
       "      <td>43439.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1840610</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>2836723</td>\n",
       "      <td>0</td>\n",
       "      <td>淋雨一直走(Keep Walking)</td>\n",
       "      <td>张韶涵</td>\n",
       "      <td>197009.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1841745</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>21234447</td>\n",
       "      <td>0</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>MC文功</td>\n",
       "      <td>15472.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1841999</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>21234486</td>\n",
       "      <td>0</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>正少</td>\n",
       "      <td>10536.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1842340</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>8339943</td>\n",
       "      <td>0</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>周二珂</td>\n",
       "      <td>14648.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1843814</th>\n",
       "      <td>154560786.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6703178</td>\n",
       "      <td>0</td>\n",
       "      <td>灵主(画江湖之灵主主题曲MV)</td>\n",
       "      <td>3</td>\n",
       "      <td>116442.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1845701</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>11428224</td>\n",
       "      <td>0</td>\n",
       "      <td>告白气球</td>\n",
       "      <td>宇西</td>\n",
       "      <td>129350.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850667</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7177682</td>\n",
       "      <td>0</td>\n",
       "      <td>我不是潘金莲</td>\n",
       "      <td>张地</td>\n",
       "      <td>39878.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850765</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>15807836</td>\n",
       "      <td>1</td>\n",
       "      <td>三生三世-(电视剧《三生三世十里桃花》主题曲)</td>\n",
       "      <td>张杰</td>\n",
       "      <td>4299.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851849</th>\n",
       "      <td>154450000.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>15249349</td>\n",
       "      <td>1</td>\n",
       "      <td>凉凉-(电视剧《三生三世十里桃花》片尾曲)</td>\n",
       "      <td>张碧晨&amp;杨宗纬</td>\n",
       "      <td>39914.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>545 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid device    song_id song_type  \\\n",
       "48929    154823377.0    ar    6851407         1    \n",
       "48936    154823377.0    ar    6851407         1    \n",
       "154248     1685126.0    ar    6408308         1    \n",
       "155943     1685126.0    ar    6408308         1    \n",
       "158247     1685126.0    ar    6408308         1    \n",
       "158386     1685126.0    ar    6017146         1    \n",
       "158668     1685126.0    ar    4246388         1    \n",
       "158762     1685126.0    ar    4678227         1    \n",
       "158897     1685126.0    ar    6994473         1    \n",
       "158989     1685126.0    ar    6994476         1    \n",
       "159097     1685126.0    ar    4378806         1    \n",
       "159184     1685126.0    ar   12413872         1    \n",
       "159213     1685126.0    ar    4434999         1    \n",
       "159399     1685126.0    ar    4474395         1    \n",
       "159792     1685126.0    ar    4625213         1    \n",
       "159868     1685126.0    ar   14196710         1    \n",
       "160076     1685126.0    ar    5680093         1    \n",
       "160161     1685126.0    ar    4562075         1    \n",
       "160317     1685126.0    ar    5606293         1    \n",
       "160496     1685126.0    ar    4476983         1    \n",
       "160648     1685126.0    ar    5638883         1    \n",
       "161006     1685126.0    ar    5606293         1    \n",
       "161757     1685126.0    ar    4476983         1    \n",
       "161876     1685126.0    ar    5638883         1    \n",
       "162695     1685126.0    ar    4476983         1    \n",
       "163372     1685126.0    ar    5638883         1    \n",
       "164188     1685126.0    ar    6408308         1    \n",
       "169212     1685126.0    ar    6408308         1    \n",
       "170281     1685126.0    ar    6408308         1    \n",
       "175016     1685126.0    ar    4496800         0    \n",
       "...              ...    ...        ...       ...   \n",
       "1815019    1749320.0    ar   13314046         1    \n",
       "1815415    1749320.0    ar    8577692         0    \n",
       "1817243    1749320.0    ar   14212498         1    \n",
       "1817862    1749320.0    ar    1334698         0    \n",
       "1817998    1749320.0    ar    7421727         1    \n",
       "1818082    1749320.0    ar    5973366         0    \n",
       "1818140    1749320.0    ar    4566559         0    \n",
       "1818212    1749320.0    ar   14186395         0    \n",
       "1818289    1749320.0    ar    8620528         0    \n",
       "1818388    1749320.0    ar   13014088         0    \n",
       "1818466    1749320.0    ar   21094553         0    \n",
       "1818523    1749320.0    ar     913313         0    \n",
       "1818596    1749320.0    ar    6332699         0    \n",
       "1818789    1749320.0    ar    4076644         0    \n",
       "1818882    1749320.0    ar    4183152         0    \n",
       "1819035    1749320.0    ar   14172229         0    \n",
       "1819163    1749320.0    ar    1037083         0    \n",
       "1819225    1749320.0    ar    1829801         1    \n",
       "1819275    1749320.0    ar   10677339         1    \n",
       "1834457  154450000.0    ar    8131548         0    \n",
       "1836287  154450000.0    ar    4356032         0    \n",
       "1840610  154450000.0    ar    2836723         0    \n",
       "1841745  154450000.0    ar   21234447         0    \n",
       "1841999  154450000.0    ar   21234486         0    \n",
       "1842340  154450000.0    ar    8339943         0    \n",
       "1843814  154560786.0    ar    6703178         0    \n",
       "1845701  154450000.0    ar   11428224         0    \n",
       "1850667  154450000.0    ar    7177682         0    \n",
       "1850765  154450000.0    ar   15807836         1    \n",
       "1851849  154450000.0    ar   15249349         1    \n",
       "\n",
       "                                               song_name  \\\n",
       "48929                             梦回还-(动漫《狐妖小红娘 第二季》OP)    \n",
       "48936                             梦回还-(动漫《狐妖小红娘 第二季》OP)    \n",
       "154248                                      净空法师念佛 阿弥陀佛    \n",
       "155943                                      净空法师念佛 阿弥陀佛    \n",
       "158247                                      净空法师念佛 阿弥陀佛    \n",
       "158386                                     适合婴儿听的歌曲 Mp3    \n",
       "158668                          娃哈哈(婴幼儿歌曲大全 App,X240 0)    \n",
       "158762                             超清脆的八音盒音乐 可爱的婴儿呢喃 未知    \n",
       "158897                                          婴儿发出的笑声    \n",
       "158989                                             听力训练    \n",
       "159097                                               婴儿    \n",
       "159184                                              贝多芬    \n",
       "159213                                          婴儿 安抚音乐    \n",
       "159399                                潜能开发 右脑开发 波右脑激活音乐    \n",
       "159792                                      开发右脑音乐阿尔法脑波    \n",
       "159868                                 开发右脑音乐 脑波 output    \n",
       "160076                                     四字佛号 净空老法师诵念    \n",
       "160161                                净空法师念诵四字佛号(慢版)mp3    \n",
       "160317                                       净空法师念诵四字佛号    \n",
       "160496                                        净空老法师念佛佛号    \n",
       "160648                                  阿弥陀佛四字佛号 净空法师念诵    \n",
       "161006                                       净空法师念诵四字佛号    \n",
       "161757                                        净空老法师念佛佛号    \n",
       "161876                                  阿弥陀佛四字佛号 净空法师念诵    \n",
       "162695                                        净空老法师念佛佛号    \n",
       "163372                                  阿弥陀佛四字佛号 净空法师念诵    \n",
       "164188                                      净空法师念佛 阿弥陀佛    \n",
       "169212                                      净空法师念佛 阿弥陀佛    \n",
       "170281                                      净空法师念佛 阿弥陀佛    \n",
       "175016                                       健身气功 八段锦口令    \n",
       "...                                                  ...   \n",
       "1815019                                         Myanmar    \n",
       "1815415                    Gate of Heaven (Myanmar Cut)    \n",
       "1817243                                         Myanmar    \n",
       "1817862                               Weaving (Myanmar)    \n",
       "1817998                                         Myanmar    \n",
       "1818082               007 Leaders - Myanmar and America    \n",
       "1818140                 4 Myanmar Passes Investment Law    \n",
       "1818212                                             Osi    \n",
       "1818289                   The Lost Temple (Myanmar Cut)    \n",
       "1818388  The Secrets Of Myanmar Vol. 1 (Continuous Mix)    \n",
       "1818466                                   Song Of Elune    \n",
       "1818523                                       Love Song    \n",
       "1818596                                    myanmar song    \n",
       "1818789                                   The Lazy Song    \n",
       "1818882                                          Banana    \n",
       "1819035                                SAYANG NA SAYANG    \n",
       "1819163                                    A Bitter Day    \n",
       "1819225                              You Belong With Me    \n",
       "1819275                                Back to December    \n",
       "1834457                                             怪我咯    \n",
       "1836287                                           淋雨一直走    \n",
       "1840610                             淋雨一直走(Keep Walking)    \n",
       "1841745                                            告白气球    \n",
       "1841999                                            告白气球    \n",
       "1842340                                            告白气球    \n",
       "1843814                                 灵主(画江湖之灵主主题曲MV)    \n",
       "1845701                                            告白气球    \n",
       "1850667                                          我不是潘金莲    \n",
       "1850765                         三生三世-(电视剧《三生三世十里桃花》主题曲)    \n",
       "1851849                           凉凉-(电视剧《三生三世十里桃花》片尾曲)    \n",
       "\n",
       "                                  singer  play_time  song_length  paid_flag  \\\n",
       "48929                              动漫原声      1541.0         -1.0        0.0   \n",
       "48936                              动漫原声       216.0         -1.0        0.0   \n",
       "154248                             净空法师     19205.0         -1.0        0.0   \n",
       "155943                             净空法师     67079.0         -1.0        0.0   \n",
       "158247                             净空法师    101881.0         -1.0        0.0   \n",
       "158386                             网络歌手      6919.0         -1.0        0.0   \n",
       "158668                               儿歌     11735.0         -1.0        0.0   \n",
       "158762                             网络歌手      4850.0         -1.0        0.0   \n",
       "158897                             儿童歌曲      6076.0         -1.0        0.0   \n",
       "158989                             儿童歌曲      3842.0         -1.0        0.0   \n",
       "159097                             英文歌曲      3861.0         -1.0        0.0   \n",
       "159184                              贝多芬      3665.0         -1.0        0.0   \n",
       "159213                             网络歌手      1179.0         -1.0        0.0   \n",
       "159399                             网络歌手      9665.0         -1.0        0.0   \n",
       "159792                             网络歌手     15940.0         -1.0        0.0   \n",
       "159868                              纯音乐      4537.0         -1.0        0.0   \n",
       "160076                             网络歌手     10388.0         -1.0        0.0   \n",
       "160161                             网络歌手      4150.0         -1.0        0.0   \n",
       "160317                             网络歌手      8571.0         -1.0        0.0   \n",
       "160496                             网络歌手      8019.0         -1.0        0.0   \n",
       "160648                             网络歌手      8807.0         -1.0        0.0   \n",
       "161006                             网络歌手     15419.0         -1.0        0.0   \n",
       "161757                             网络歌手     26240.0         -1.0        0.0   \n",
       "161876                             网络歌手      8862.0         -1.0        0.0   \n",
       "162695                             网络歌手     32488.0         -1.0        0.0   \n",
       "163372                             网络歌手     33804.0         -1.0        0.0   \n",
       "164188                             净空法师     38121.0         -1.0        0.0   \n",
       "169212                             净空法师    232783.0         -1.0        0.0   \n",
       "170281                             净空法师     50701.0         -1.0        0.0   \n",
       "175016                             网络歌手      8562.0         -1.0        0.0   \n",
       "...                                  ...        ...          ...        ...   \n",
       "1815019                       Paul Mark      2588.0         -1.0        0.0   \n",
       "1815415                        Mahoroba      1395.0         -1.0        0.0   \n",
       "1817243                         Ah Moon      2934.0         -1.0        0.0   \n",
       "1817862                   Robert Millis      2042.0         -1.0        0.0   \n",
       "1817998   London Philharmonic Orchestra      1466.0         -1.0        0.0   \n",
       "1818082                            经济学人      1833.0         -1.0        0.0   \n",
       "1818140                            网络歌手      2737.0         -1.0        0.0   \n",
       "1818212  Myanmar Cultural Show Ensemble      2203.0         -1.0        0.0   \n",
       "1818289                     Sean Hayman      2534.0         -1.0        0.0   \n",
       "1818388                     DJ Maretimo      1832.0         -1.0        0.0   \n",
       "1818466               World of Warcraft      5990.0         -1.0        0.0   \n",
       "1818523                           浜崎あゆみ      2679.0         -1.0        0.0   \n",
       "1818596                            网络歌手      1876.0         -1.0        0.0   \n",
       "1818789                      Bruno Mars      1804.0         -1.0        0.0   \n",
       "1818882                            G.NA      1992.0         -1.0        0.0   \n",
       "1819035                           Aegis      1094.0         -1.0        0.0   \n",
       "1819163                     泫雅&龙俊亨&G.NA      1268.0         -1.0        0.0   \n",
       "1819225                            电影原声      4122.0         -1.0        0.0   \n",
       "1819275                    Taylor Swift      3061.0         -1.0        0.0   \n",
       "1834457                             童可可     66281.0         -1.0        0.0   \n",
       "1836287                             童可可     43439.0         -1.0        0.0   \n",
       "1840610                             张韶涵    197009.0         -1.0        0.0   \n",
       "1841745                            MC文功     15472.0         -1.0        0.0   \n",
       "1841999                              正少     10536.0         -1.0        0.0   \n",
       "1842340                             周二珂     14648.0         -1.0        0.0   \n",
       "1843814                               3    116442.0         -1.0        0.0   \n",
       "1845701                              宇西    129350.0         -1.0        0.0   \n",
       "1850667                              张地     39878.0         -1.0        0.0   \n",
       "1850765                              张杰      4299.0         -1.0        0.0   \n",
       "1851849                         张碧晨&杨宗纬     39914.0         -1.0        0.0   \n",
       "\n",
       "                    file_name       date  \n",
       "48929     20170303_1_play.log   20170303  \n",
       "48936     20170303_1_play.log   20170303  \n",
       "154248    20170303_1_play.log   20170303  \n",
       "155943    20170303_1_play.log   20170303  \n",
       "158247    20170303_1_play.log   20170303  \n",
       "158386    20170303_1_play.log   20170303  \n",
       "158668    20170303_1_play.log   20170303  \n",
       "158762    20170303_1_play.log   20170303  \n",
       "158897    20170303_1_play.log   20170303  \n",
       "158989    20170303_1_play.log   20170303  \n",
       "159097    20170303_1_play.log   20170303  \n",
       "159184    20170303_1_play.log   20170303  \n",
       "159213    20170303_1_play.log   20170303  \n",
       "159399    20170303_1_play.log   20170303  \n",
       "159792    20170303_1_play.log   20170303  \n",
       "159868    20170303_1_play.log   20170303  \n",
       "160076    20170303_1_play.log   20170303  \n",
       "160161    20170303_1_play.log   20170303  \n",
       "160317    20170303_1_play.log   20170303  \n",
       "160496    20170303_1_play.log   20170303  \n",
       "160648    20170303_1_play.log   20170303  \n",
       "161006    20170303_1_play.log   20170303  \n",
       "161757    20170303_1_play.log   20170303  \n",
       "161876    20170303_1_play.log   20170303  \n",
       "162695    20170303_1_play.log   20170303  \n",
       "163372    20170303_1_play.log   20170303  \n",
       "164188    20170303_1_play.log   20170303  \n",
       "169212    20170303_1_play.log   20170303  \n",
       "170281    20170303_1_play.log   20170303  \n",
       "175016    20170303_1_play.log   20170303  \n",
       "...                       ...        ...  \n",
       "1815019   20170303_1_play.log   20170303  \n",
       "1815415   20170303_1_play.log   20170303  \n",
       "1817243   20170303_1_play.log   20170303  \n",
       "1817862   20170303_1_play.log   20170303  \n",
       "1817998   20170303_1_play.log   20170303  \n",
       "1818082   20170303_1_play.log   20170303  \n",
       "1818140   20170303_1_play.log   20170303  \n",
       "1818212   20170303_1_play.log   20170303  \n",
       "1818289   20170303_1_play.log   20170303  \n",
       "1818388   20170303_1_play.log   20170303  \n",
       "1818466   20170303_1_play.log   20170303  \n",
       "1818523   20170303_1_play.log   20170303  \n",
       "1818596   20170303_1_play.log   20170303  \n",
       "1818789   20170303_1_play.log   20170303  \n",
       "1818882   20170303_1_play.log   20170303  \n",
       "1819035   20170303_1_play.log   20170303  \n",
       "1819163   20170303_1_play.log   20170303  \n",
       "1819225   20170303_1_play.log   20170303  \n",
       "1819275   20170303_1_play.log   20170303  \n",
       "1834457   20170303_1_play.log   20170303  \n",
       "1836287   20170303_1_play.log   20170303  \n",
       "1840610   20170303_1_play.log   20170303  \n",
       "1841745   20170303_1_play.log   20170303  \n",
       "1841999   20170303_1_play.log   20170303  \n",
       "1842340   20170303_1_play.log   20170303  \n",
       "1843814   20170303_1_play.log   20170303  \n",
       "1845701   20170303_1_play.log   20170303  \n",
       "1850667   20170303_1_play.log   20170303  \n",
       "1850765   20170303_1_play.log   20170303  \n",
       "1851849   20170303_1_play.log   20170303  \n",
       "\n",
       "[545 rows x 11 columns]"
      ]
     },
     "execution_count": 245,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many rows are less than 0 second in song_length\n",
    "df_play.loc[df_play['song_length'] < 0] # 545 rows\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_type</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>play_time</th>\n",
       "      <th>song_length</th>\n",
       "      <th>paid_flag</th>\n",
       "      <th>file_name</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>154840730.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6953953</td>\n",
       "      <td>0</td>\n",
       "      <td>001“鸡”和“鸡鸡”</td>\n",
       "      <td>郭德纲、于谦</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>2201.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>154731880.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3296853</td>\n",
       "      <td>0</td>\n",
       "      <td>回龙传08</td>\n",
       "      <td>吴宗俭</td>\n",
       "      <td>2443.0</td>\n",
       "      <td>2444.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>154713913.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6225438</td>\n",
       "      <td>0</td>\n",
       "      <td>小苹果+兄弟抱一下(全中文高潮气氛包房慢摇)</td>\n",
       "      <td>慢摇串烧</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3326.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>594</th>\n",
       "      <td>154731880.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4167842</td>\n",
       "      <td>0</td>\n",
       "      <td>曲剧 陈三两爬堂 b</td>\n",
       "      <td>张新芳</td>\n",
       "      <td>21.0</td>\n",
       "      <td>2446.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>626</th>\n",
       "      <td>154713913.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6861547</td>\n",
       "      <td>0</td>\n",
       "      <td>你把真心给了谁做了谁的宝贝Club包房慢摇串烧</td>\n",
       "      <td>群星</td>\n",
       "      <td>316.0</td>\n",
       "      <td>3660.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>641</th>\n",
       "      <td>154713913.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6221185</td>\n",
       "      <td>0</td>\n",
       "      <td>我说亲爱的+不要逃避+我们结婚啦2015</td>\n",
       "      <td>慢摇串烧</td>\n",
       "      <td>316.0</td>\n",
       "      <td>3840.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>154713913.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6281602</td>\n",
       "      <td>0</td>\n",
       "      <td>咱们结婚吧(打造2015 劲爽全中文慢摇串烧)</td>\n",
       "      <td>慢摇串烧</td>\n",
       "      <td>316.0</td>\n",
       "      <td>4390.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>908</th>\n",
       "      <td>154618802.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6732750</td>\n",
       "      <td>0</td>\n",
       "      <td>《歪批三国》</td>\n",
       "      <td>苗阜</td>\n",
       "      <td>99.0</td>\n",
       "      <td>2863.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>916</th>\n",
       "      <td>154618802.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3377887</td>\n",
       "      <td>0</td>\n",
       "      <td>官场风流001</td>\n",
       "      <td>旧雨</td>\n",
       "      <td>142.0</td>\n",
       "      <td>1942.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1698</th>\n",
       "      <td>154730892.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6593201</td>\n",
       "      <td>0</td>\n",
       "      <td>哥们车载CD专辑喊麦(DJ版)</td>\n",
       "      <td>MC佳佳</td>\n",
       "      <td>2126.0</td>\n",
       "      <td>3775.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1837</th>\n",
       "      <td>154698514.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>7206559</td>\n",
       "      <td>0</td>\n",
       "      <td>文儿大展歌喉带你回味各种曲风20160719直播回放</td>\n",
       "      <td>文儿&amp;DJ专区</td>\n",
       "      <td>3049.0</td>\n",
       "      <td>5942.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1867</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3080171</td>\n",
       "      <td>0</td>\n",
       "      <td>济公传第16集</td>\n",
       "      <td>郭德纲</td>\n",
       "      <td>2375.0</td>\n",
       "      <td>2376.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2057</th>\n",
       "      <td>154430328.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>243814</td>\n",
       "      <td>0</td>\n",
       "      <td>世纪风ii</td>\n",
       "      <td>李伯清</td>\n",
       "      <td>9.0</td>\n",
       "      <td>2725.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2126</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6641764</td>\n",
       "      <td>0</td>\n",
       "      <td>醉美旋律精品加快中文车载DJ串烧(DJ版)</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4020.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2128</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4424125</td>\n",
       "      <td>0</td>\n",
       "      <td>DJ2012情人节优美车载DJ串烧</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3532.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2130</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4753851</td>\n",
       "      <td>0</td>\n",
       "      <td>dj ae leen 12 月最新重低音车载 dj 中文串烧</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4320.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2134</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6641683</td>\n",
       "      <td>0</td>\n",
       "      <td>2015强劲音爆精品舞动精灵慢摇车载(DJ版)</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3511.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2136</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4782629</td>\n",
       "      <td>0</td>\n",
       "      <td>全中文车载 dj</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3530.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2151</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>5694261</td>\n",
       "      <td>0</td>\n",
       "      <td>伤心男人慢摇车载 Dj 嗨</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4080.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2156</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4750756</td>\n",
       "      <td>0</td>\n",
       "      <td>dj打造珍藏精品车载dj串烧</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2158</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4719520</td>\n",
       "      <td>0</td>\n",
       "      <td>粤语老歌车载 dj 舞曲串烧 cd</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4620.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2167</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4721980</td>\n",
       "      <td>0</td>\n",
       "      <td>dj2012 天籁之声车载 dj 音乐大碟</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3168.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2172</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6619280</td>\n",
       "      <td>0</td>\n",
       "      <td>2010时尚Club精品车载(DJ版)</td>\n",
       "      <td>哓杰&amp;Dj阿涛puck&amp;DJ Kenny</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3600.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2175</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4778137</td>\n",
       "      <td>0</td>\n",
       "      <td>dj2012天籁之声车载dj音乐大碟(流畅)</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3167.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2561</th>\n",
       "      <td>154474992.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6122619</td>\n",
       "      <td>0</td>\n",
       "      <td>天籁之声车载Dj音乐大碟 (绝版全粤语)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>3788.0</td>\n",
       "      <td>3804.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3392</th>\n",
       "      <td>154618802.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6960216</td>\n",
       "      <td>0</td>\n",
       "      <td>05窦公训女_张九龄岳云鹏孙越</td>\n",
       "      <td>岳云鹏&amp;孙越</td>\n",
       "      <td>2573.0</td>\n",
       "      <td>2573.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4298</th>\n",
       "      <td>32166203.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6861998</td>\n",
       "      <td>0</td>\n",
       "      <td>DJ中文串烧慢摇音乐舞曲</td>\n",
       "      <td>群星</td>\n",
       "      <td>17.0</td>\n",
       "      <td>4463.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4347</th>\n",
       "      <td>32166203.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6861578</td>\n",
       "      <td>0</td>\n",
       "      <td>车载精选全中文慢摇串烧</td>\n",
       "      <td>群星</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4422.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4489</th>\n",
       "      <td>154536586.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6861580</td>\n",
       "      <td>0</td>\n",
       "      <td>首首动听全新伤感车载慢摇DJ舞曲</td>\n",
       "      <td>群星</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4236.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4622</th>\n",
       "      <td>154650488.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4742679</td>\n",
       "      <td>0</td>\n",
       "      <td>dj 舞曲 极品好听酒吧电音串烧 震撼你的心灵 版本</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>3738.0</td>\n",
       "      <td>3824.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1848277</th>\n",
       "      <td>154781441.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3249330</td>\n",
       "      <td>0</td>\n",
       "      <td>成长的烦恼(20110510北工大演出)</td>\n",
       "      <td>曹云金&amp;刘云天</td>\n",
       "      <td>39.0</td>\n",
       "      <td>2841.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1848416</th>\n",
       "      <td>154617263.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4780093</td>\n",
       "      <td>0</td>\n",
       "      <td>阳山 dj 志信 劲爆重低音 车载进口低音炮专用大碟</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>520.0</td>\n",
       "      <td>4429.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1848509</th>\n",
       "      <td>154433038.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6698368</td>\n",
       "      <td>0</td>\n",
       "      <td>汽车专用CD伤感情歌(女人篇)国粤语慢摇串烧(DJ版)</td>\n",
       "      <td>佛山DJ明仔</td>\n",
       "      <td>2585.0</td>\n",
       "      <td>3802.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1848593</th>\n",
       "      <td>154765390.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6672943</td>\n",
       "      <td>0</td>\n",
       "      <td>最新车载音乐3D环绕立体声音乐(DJ版)</td>\n",
       "      <td>孙露</td>\n",
       "      <td>40.0</td>\n",
       "      <td>3927.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849134</th>\n",
       "      <td>154598440.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6733035</td>\n",
       "      <td>0</td>\n",
       "      <td>全剧《三娘教子》-张亮剧院</td>\n",
       "      <td>张亮剧场</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3216.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849165</th>\n",
       "      <td>154770901.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6978003</td>\n",
       "      <td>0</td>\n",
       "      <td>12台上涮火锅_郭德纲于谦</td>\n",
       "      <td>郭德纲</td>\n",
       "      <td>2162.0</td>\n",
       "      <td>2163.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849251</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4261294</td>\n",
       "      <td>0</td>\n",
       "      <td>小欢最新推出宝丽金经典回忆版慢摇串烧</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4405.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849380</th>\n",
       "      <td>154617263.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3454877</td>\n",
       "      <td>0</td>\n",
       "      <td>Dj成少(11月全新火爆电音全中文串烧推荐版)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>35.0</td>\n",
       "      <td>4166.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849426</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6697141</td>\n",
       "      <td>0</td>\n",
       "      <td>中场商业House唱腔潮榜串烧(48Min DJ版)</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2910.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849632</th>\n",
       "      <td>154829060.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4172473</td>\n",
       "      <td>0</td>\n",
       "      <td>c 大鼓书 吕洞宾三戏牡丹 b</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>3163.0</td>\n",
       "      <td>3163.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849772</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4244110</td>\n",
       "      <td>0</td>\n",
       "      <td>不再联系(流行中文舞曲串烧大碟 重重)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>404.0</td>\n",
       "      <td>3751.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849791</th>\n",
       "      <td>154593687.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4965542</td>\n",
       "      <td>0</td>\n",
       "      <td>舞厅热播中文伤感情歌串烧 一万个不愿意</td>\n",
       "      <td>群星</td>\n",
       "      <td>526.0</td>\n",
       "      <td>4200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849801</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>3455273</td>\n",
       "      <td>0</td>\n",
       "      <td>本站为常平客户订做(中英文超嗨串烧)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4525.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1849849</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>3455500</td>\n",
       "      <td>0</td>\n",
       "      <td>长塘风仔音乐工作室(徐浩精选全新英文串烧)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4112.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850066</th>\n",
       "      <td>154761299.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>7074348</td>\n",
       "      <td>0</td>\n",
       "      <td>皇宫1号私人会所优美唱腔上头容易下头难</td>\n",
       "      <td>小豪</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3749.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850201</th>\n",
       "      <td>154416414.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>19557700</td>\n",
       "      <td>0</td>\n",
       "      <td>天佑鬼畜登场亮瞎眼20170123直播回放(下)</td>\n",
       "      <td>MC天佑&amp;DJ专区</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2526.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850451</th>\n",
       "      <td>155601942.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6028910</td>\n",
       "      <td>0</td>\n",
       "      <td>Dj 战小浩 战小浩个人推荐 首张欧美车载大碟</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>3264.0</td>\n",
       "      <td>3264.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850477</th>\n",
       "      <td>1685126.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6664337</td>\n",
       "      <td>0</td>\n",
       "      <td>全中文国粤语CLUB音乐包房及车载专用气氛慢摇极品DJ嗨嗨串烧(DJ版)</td>\n",
       "      <td>Dj火柴</td>\n",
       "      <td>166.0</td>\n",
       "      <td>3817.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1850665</th>\n",
       "      <td>154848640.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4721462</td>\n",
       "      <td>0</td>\n",
       "      <td>dj(广州罗岗石桥混音 5月中文摇头 www.vvvdj)</td>\n",
       "      <td>小黑</td>\n",
       "      <td>39.0</td>\n",
       "      <td>3690.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851181</th>\n",
       "      <td>154819429.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>新歌连播</td>\n",
       "      <td>微信搜索：嗨音社</td>\n",
       "      <td>3736.0</td>\n",
       "      <td>3737.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851311</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>7108122</td>\n",
       "      <td>0</td>\n",
       "      <td>2016倾力打造(许多年后依然爱你)中文超爽节奏CD靓碟(Ax Kq Love)</td>\n",
       "      <td>DJ伟帅</td>\n",
       "      <td>577.0</td>\n",
       "      <td>3817.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851362</th>\n",
       "      <td>154617263.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4323272</td>\n",
       "      <td>0</td>\n",
       "      <td>08年最新火爆全中文串烧</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>55.0</td>\n",
       "      <td>3709.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851479</th>\n",
       "      <td>155150037.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>1246378</td>\n",
       "      <td>0</td>\n",
       "      <td>中国人的成功宝典01</td>\n",
       "      <td>曾仕强</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3497.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851499</th>\n",
       "      <td>154816694.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6736837</td>\n",
       "      <td>0</td>\n",
       "      <td>因果——影留言</td>\n",
       "      <td>沙石奕站</td>\n",
       "      <td>3849.0</td>\n",
       "      <td>4805.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1851803</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>7196596</td>\n",
       "      <td>0</td>\n",
       "      <td>因为爱所以爱 潮流DJ经典</td>\n",
       "      <td>DjFany</td>\n",
       "      <td>1388.0</td>\n",
       "      <td>4249.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852119</th>\n",
       "      <td>154826954.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4349040</td>\n",
       "      <td>0</td>\n",
       "      <td>1(迪厅舞曲大全 远远)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3720.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852229</th>\n",
       "      <td>154826954.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>4782245</td>\n",
       "      <td>0</td>\n",
       "      <td>dj 迪厅舞曲专用漫摇</td>\n",
       "      <td>网络歌手</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3840.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852407</th>\n",
       "      <td>154790333.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>4702577</td>\n",
       "      <td>0</td>\n",
       "      <td>嗨房专用中文串烧(DJ版)</td>\n",
       "      <td>DJ舞曲</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3897.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852593</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6991078</td>\n",
       "      <td>0</td>\n",
       "      <td>2016是不是我对你不够好精品串烧</td>\n",
       "      <td>DJ建斌</td>\n",
       "      <td>1901.0</td>\n",
       "      <td>3766.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1852778</th>\n",
       "      <td>154806584.0</td>\n",
       "      <td>ip</td>\n",
       "      <td>6694432</td>\n",
       "      <td>0</td>\n",
       "      <td>全中文Club劲爆音乐车载定制版(DJ版)</td>\n",
       "      <td>DJ细波</td>\n",
       "      <td>7.0</td>\n",
       "      <td>3867.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20170303_1_play.log</td>\n",
       "      <td>20170303</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10717 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 uid device    song_id song_type  \\\n",
       "349      154840730.0    ip    6953953         0    \n",
       "366      154731880.0    ar    3296853         0    \n",
       "485      154713913.0    ar    6225438         0    \n",
       "594      154731880.0    ar    4167842         0    \n",
       "626      154713913.0    ar    6861547         0    \n",
       "641      154713913.0    ar    6221185         0    \n",
       "658      154713913.0    ar    6281602         0    \n",
       "908      154618802.0    ar    6732750         0    \n",
       "916      154618802.0    ar    3377887         0    \n",
       "1698     154730892.0    ar    6593201         0    \n",
       "1837     154698514.0    ip    7206559         0    \n",
       "1867       1685126.0    ar    3080171         0    \n",
       "2057     154430328.0    ip     243814         0    \n",
       "2126     154536586.0    ar    6641764         0    \n",
       "2128     154536586.0    ar    4424125         0    \n",
       "2130     154536586.0    ar    4753851         0    \n",
       "2134     154536586.0    ar    6641683         0    \n",
       "2136     154536586.0    ar    4782629         0    \n",
       "2151     154536586.0    ar    5694261         0    \n",
       "2156     154536586.0    ar    4750756         0    \n",
       "2158     154536586.0    ar    4719520         0    \n",
       "2167     154536586.0    ar    4721980         0    \n",
       "2172     154536586.0    ar    6619280         0    \n",
       "2175     154536586.0    ar    4778137         0    \n",
       "2561     154474992.0    ip    6122619         0    \n",
       "3392     154618802.0    ar    6960216         0    \n",
       "4298      32166203.0    ar    6861998         0    \n",
       "4347      32166203.0    ar    6861578         0    \n",
       "4489     154536586.0    ar    6861580         0    \n",
       "4622     154650488.0    ar    4742679         0    \n",
       "...              ...    ...        ...       ...   \n",
       "1848277  154781441.0    ar    3249330         0    \n",
       "1848416  154617263.0    ar    4780093         0    \n",
       "1848509  154433038.0    ar    6698368         0    \n",
       "1848593  154765390.0    ar    6672943         0    \n",
       "1849134  154598440.0    ar    6733035         0    \n",
       "1849165  154770901.0    ar    6978003         0    \n",
       "1849251  154806584.0    ip    4261294         0    \n",
       "1849380  154617263.0    ar    3454877         0    \n",
       "1849426  154806584.0    ip    6697141         0    \n",
       "1849632  154829060.0    ar    4172473         0    \n",
       "1849772  154806584.0    ip    4244110         0    \n",
       "1849791  154593687.0    ip    4965542         0    \n",
       "1849801  154806584.0    ip    3455273         0    \n",
       "1849849  154806584.0    ip    3455500         0    \n",
       "1850066  154761299.0    ar    7074348         0    \n",
       "1850201  154416414.0    ar   19557700         0    \n",
       "1850451  155601942.0    ar    6028910         0    \n",
       "1850477    1685126.0    ar    6664337         0    \n",
       "1850665  154848640.0    ar    4721462         0    \n",
       "1851181  154819429.0    ar          0         1    \n",
       "1851311  154806584.0    ip    7108122         0    \n",
       "1851362  154617263.0    ar    4323272         0    \n",
       "1851479  155150037.0    ar    1246378         0    \n",
       "1851499  154816694.0    ar    6736837         0    \n",
       "1851803  154806584.0    ip    7196596         0    \n",
       "1852119  154826954.0    ip    4349040         0    \n",
       "1852229  154826954.0    ip    4782245         0    \n",
       "1852407  154790333.0    ar    4702577         0    \n",
       "1852593  154806584.0    ip    6991078         0    \n",
       "1852778  154806584.0    ip    6694432         0    \n",
       "\n",
       "                                         song_name                 singer  \\\n",
       "349                                   001“鸡”和“鸡鸡”                 郭德纲、于谦    \n",
       "366                                         回龙传08                    吴宗俭    \n",
       "485                        小苹果+兄弟抱一下(全中文高潮气氛包房慢摇)                   慢摇串烧    \n",
       "594                                    曲剧 陈三两爬堂 b                    张新芳    \n",
       "626                       你把真心给了谁做了谁的宝贝Club包房慢摇串烧                     群星    \n",
       "641                          我说亲爱的+不要逃避+我们结婚啦2015                   慢摇串烧    \n",
       "658                       咱们结婚吧(打造2015 劲爽全中文慢摇串烧)                   慢摇串烧    \n",
       "908                                        《歪批三国》                     苗阜    \n",
       "916                                       官场风流001                     旧雨    \n",
       "1698                              哥们车载CD专辑喊麦(DJ版)                   MC佳佳    \n",
       "1837                   文儿大展歌喉带你回味各种曲风20160719直播回放                文儿&DJ专区    \n",
       "1867                                      济公传第16集                    郭德纲    \n",
       "2057                                        世纪风ii                    李伯清    \n",
       "2126                        醉美旋律精品加快中文车载DJ串烧(DJ版)                   网络歌手    \n",
       "2128                            DJ2012情人节优美车载DJ串烧                   网络歌手    \n",
       "2130               dj ae leen 12 月最新重低音车载 dj 中文串烧                   网络歌手    \n",
       "2134                      2015强劲音爆精品舞动精灵慢摇车载(DJ版)                   网络歌手    \n",
       "2136                                     全中文车载 dj                   网络歌手    \n",
       "2151                                伤心男人慢摇车载 Dj 嗨                   网络歌手    \n",
       "2156                               dj打造珍藏精品车载dj串烧                   网络歌手    \n",
       "2158                            粤语老歌车载 dj 舞曲串烧 cd                   网络歌手    \n",
       "2167                        dj2012 天籁之声车载 dj 音乐大碟                   网络歌手    \n",
       "2172                          2010时尚Club精品车载(DJ版)   哓杰&Dj阿涛puck&DJ Kenny    \n",
       "2175                       dj2012天籁之声车载dj音乐大碟(流畅)                   网络歌手    \n",
       "2561                         天籁之声车载Dj音乐大碟 (绝版全粤语)                   DJ舞曲    \n",
       "3392                              05窦公训女_张九龄岳云鹏孙越                 岳云鹏&孙越    \n",
       "4298                                 DJ中文串烧慢摇音乐舞曲                     群星    \n",
       "4347                                  车载精选全中文慢摇串烧                     群星    \n",
       "4489                             首首动听全新伤感车载慢摇DJ舞曲                     群星    \n",
       "4622                   dj 舞曲 极品好听酒吧电音串烧 震撼你的心灵 版本                   网络歌手    \n",
       "...                                            ...                    ...   \n",
       "1848277                      成长的烦恼(20110510北工大演出)                曹云金&刘云天    \n",
       "1848416                阳山 dj 志信 劲爆重低音 车载进口低音炮专用大碟                   网络歌手    \n",
       "1848509               汽车专用CD伤感情歌(女人篇)国粤语慢摇串烧(DJ版)                 佛山DJ明仔    \n",
       "1848593                      最新车载音乐3D环绕立体声音乐(DJ版)                     孙露    \n",
       "1849134                             全剧《三娘教子》-张亮剧院                   张亮剧场    \n",
       "1849165                             12台上涮火锅_郭德纲于谦                    郭德纲    \n",
       "1849251                        小欢最新推出宝丽金经典回忆版慢摇串烧                   DJ舞曲    \n",
       "1849380                   Dj成少(11月全新火爆电音全中文串烧推荐版)                   DJ舞曲    \n",
       "1849426                中场商业House唱腔潮榜串烧(48Min DJ版)                   网络歌手    \n",
       "1849632                           c 大鼓书 吕洞宾三戏牡丹 b                   网络歌手    \n",
       "1849772                       不再联系(流行中文舞曲串烧大碟 重重)                   DJ舞曲    \n",
       "1849791                      舞厅热播中文伤感情歌串烧 一万个不愿意                      群星    \n",
       "1849801                        本站为常平客户订做(中英文超嗨串烧)                   DJ舞曲    \n",
       "1849849                     长塘风仔音乐工作室(徐浩精选全新英文串烧)                   DJ舞曲    \n",
       "1850066                       皇宫1号私人会所优美唱腔上头容易下头难                     小豪    \n",
       "1850201                  天佑鬼畜登场亮瞎眼20170123直播回放(下)              MC天佑&DJ专区    \n",
       "1850451                   Dj 战小浩 战小浩个人推荐 首张欧美车载大碟                   网络歌手    \n",
       "1850477      全中文国粤语CLUB音乐包房及车载专用气氛慢摇极品DJ嗨嗨串烧(DJ版)                   Dj火柴    \n",
       "1850665             dj(广州罗岗石桥混音 5月中文摇头 www.vvvdj)                     小黑    \n",
       "1851181                                      新歌连播               微信搜索：嗨音社    \n",
       "1851311  2016倾力打造(许多年后依然爱你)中文超爽节奏CD靓碟(Ax Kq Love)                   DJ伟帅    \n",
       "1851362                              08年最新火爆全中文串烧                   DJ舞曲    \n",
       "1851479                                中国人的成功宝典01                    曾仕强    \n",
       "1851499                                   因果——影留言                   沙石奕站    \n",
       "1851803                             因为爱所以爱 潮流DJ经典                 DjFany    \n",
       "1852119                              1(迪厅舞曲大全 远远)                   DJ舞曲    \n",
       "1852229                               dj 迪厅舞曲专用漫摇                   网络歌手    \n",
       "1852407                             嗨房专用中文串烧(DJ版)                   DJ舞曲    \n",
       "1852593                         2016是不是我对你不够好精品串烧                   DJ建斌    \n",
       "1852778                     全中文Club劲爆音乐车载定制版(DJ版)                   DJ细波    \n",
       "\n",
       "         play_time  song_length  paid_flag             file_name       date  \n",
       "349         2201.0       2201.0        0.0   20170303_1_play.log   20170303  \n",
       "366         2443.0       2444.0        0.0   20170303_1_play.log   20170303  \n",
       "485            5.0       3326.0        0.0   20170303_1_play.log   20170303  \n",
       "594           21.0       2446.0        0.0   20170303_1_play.log   20170303  \n",
       "626          316.0       3660.0        0.0   20170303_1_play.log   20170303  \n",
       "641          316.0       3840.0        0.0   20170303_1_play.log   20170303  \n",
       "658          316.0       4390.0        0.0   20170303_1_play.log   20170303  \n",
       "908           99.0       2863.0        0.0   20170303_1_play.log   20170303  \n",
       "916          142.0       1942.0        0.0   20170303_1_play.log   20170303  \n",
       "1698        2126.0       3775.0        0.0   20170303_1_play.log   20170303  \n",
       "1837        3049.0       5942.0        0.0   20170303_1_play.log   20170303  \n",
       "1867        2375.0       2376.0        0.0   20170303_1_play.log   20170303  \n",
       "2057           9.0       2725.0        0.0   20170303_1_play.log   20170303  \n",
       "2126           0.0       4020.0        0.0   20170303_1_play.log   20170303  \n",
       "2128           0.0       3532.0        0.0   20170303_1_play.log   20170303  \n",
       "2130           0.0       4320.0        0.0   20170303_1_play.log   20170303  \n",
       "2134           0.0       3511.0        0.0   20170303_1_play.log   20170303  \n",
       "2136           0.0       3530.0        0.0   20170303_1_play.log   20170303  \n",
       "2151           0.0       4080.0        0.0   20170303_1_play.log   20170303  \n",
       "2156           0.0       3476.0        0.0   20170303_1_play.log   20170303  \n",
       "2158           0.0       4620.0        0.0   20170303_1_play.log   20170303  \n",
       "2167           0.0       3168.0        0.0   20170303_1_play.log   20170303  \n",
       "2172           0.0       3600.0        0.0   20170303_1_play.log   20170303  \n",
       "2175           0.0       3167.0        0.0   20170303_1_play.log   20170303  \n",
       "2561        3788.0       3804.0        0.0   20170303_1_play.log   20170303  \n",
       "3392        2573.0       2573.0        0.0   20170303_1_play.log   20170303  \n",
       "4298          17.0       4463.0        0.0   20170303_1_play.log   20170303  \n",
       "4347           1.0       4422.0        0.0   20170303_1_play.log   20170303  \n",
       "4489           8.0       4236.0        0.0   20170303_1_play.log   20170303  \n",
       "4622        3738.0       3824.0        0.0   20170303_1_play.log   20170303  \n",
       "...            ...          ...        ...                   ...        ...  \n",
       "1848277       39.0       2841.0        0.0   20170303_1_play.log   20170303  \n",
       "1848416      520.0       4429.0        0.0   20170303_1_play.log   20170303  \n",
       "1848509     2585.0       3802.0        0.0   20170303_1_play.log   20170303  \n",
       "1848593       40.0       3927.0        0.0   20170303_1_play.log   20170303  \n",
       "1849134        0.0       3216.0        0.0   20170303_1_play.log   20170303  \n",
       "1849165     2162.0       2163.0        0.0   20170303_1_play.log   20170303  \n",
       "1849251       37.0       4405.0        0.0   20170303_1_play.log   20170303  \n",
       "1849380       35.0       4166.0        0.0   20170303_1_play.log   20170303  \n",
       "1849426        6.0       2910.0        0.0   20170303_1_play.log   20170303  \n",
       "1849632     3163.0       3163.0        0.0   20170303_1_play.log   20170303  \n",
       "1849772      404.0       3751.0        0.0   20170303_1_play.log   20170303  \n",
       "1849791      526.0       4200.0        0.0   20170303_1_play.log   20170303  \n",
       "1849801        0.0       4525.0        0.0   20170303_1_play.log   20170303  \n",
       "1849849        1.0       4112.0        0.0   20170303_1_play.log   20170303  \n",
       "1850066       20.0       3749.0        0.0   20170303_1_play.log   20170303  \n",
       "1850201        0.0       2526.0        0.0   20170303_1_play.log   20170303  \n",
       "1850451     3264.0       3264.0        0.0   20170303_1_play.log   20170303  \n",
       "1850477      166.0       3817.0        0.0   20170303_1_play.log   20170303  \n",
       "1850665       39.0       3690.0        0.0   20170303_1_play.log   20170303  \n",
       "1851181     3736.0       3737.0        0.0   20170303_1_play.log   20170303  \n",
       "1851311      577.0       3817.0        0.0   20170303_1_play.log   20170303  \n",
       "1851362       55.0       3709.0        0.0   20170303_1_play.log   20170303  \n",
       "1851479        1.0       3497.0        0.0   20170303_1_play.log   20170303  \n",
       "1851499     3849.0       4805.0        0.0   20170303_1_play.log   20170303  \n",
       "1851803     1388.0       4249.0        0.0   20170303_1_play.log   20170303  \n",
       "1852119        1.0       3720.0        0.0   20170303_1_play.log   20170303  \n",
       "1852229        2.0       3840.0        0.0   20170303_1_play.log   20170303  \n",
       "1852407        3.0       3897.0        0.0   20170303_1_play.log   20170303  \n",
       "1852593     1901.0       3766.0        0.0   20170303_1_play.log   20170303  \n",
       "1852778        7.0       3867.0        0.0   20170303_1_play.log   20170303  \n",
       "\n",
       "[10717 rows x 11 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# how many rows are more than 1800 second (30 min) in song_length\n",
    "df_play.loc[df_play['song_length'] > 1800] # 10717 rows\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "schema_down = ['uid','device','song_id','song_name','singer','paid_flag']\n",
    "df_down = pd.read_csv('../music_box_data/data/down/20170330_1_down.log',delimiter='\\t',header=None,index_col=None,names=schema_down)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>song_id</th>\n",
       "      <th>song_name</th>\n",
       "      <th>singer</th>\n",
       "      <th>paid_flag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>442554</td>\n",
       "      <td>小酒窝</td>\n",
       "      <td>林俊杰&amp;蔡卓妍</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6334611</td>\n",
       "      <td>社会摇</td>\n",
       "      <td>萧全</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9867382</td>\n",
       "      <td>台阶</td>\n",
       "      <td>武艺</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6660691</td>\n",
       "      <td>一次就好-(电影《夏洛特烦恼》暖水曲)</td>\n",
       "      <td>杨宗纬</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>157606</td>\n",
       "      <td>一路上有你</td>\n",
       "      <td>张学友</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3372481</td>\n",
       "      <td>十年 (OT：明年今日)</td>\n",
       "      <td>陈奕迅</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>3216525</td>\n",
       "      <td>你不知道的事(Live版)</td>\n",
       "      <td>王力宏</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6427523</td>\n",
       "      <td>Victory</td>\n",
       "      <td>Two Steps From Hell</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>6538686</td>\n",
       "      <td>野子</td>\n",
       "      <td>流浪者</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>168019810.0</td>\n",
       "      <td>ar</td>\n",
       "      <td>9327383</td>\n",
       "      <td>なんでもないや-[没什么大不了](Movie Ver.)-(动画电影《你的名字。》片尾曲)</td>\n",
       "      <td>RADWIMPS</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           uid device  song_id  \\\n",
       "0  168019810.0    ar    442554   \n",
       "1  168019810.0    ar   6334611   \n",
       "2  168019810.0    ar   9867382   \n",
       "3  168019810.0    ar   6660691   \n",
       "4  168019810.0    ar    157606   \n",
       "5  168019810.0    ar   3372481   \n",
       "6  168019810.0    ar   3216525   \n",
       "7  168019810.0    ar   6427523   \n",
       "8  168019810.0    ar   6538686   \n",
       "9  168019810.0    ar   9327383   \n",
       "\n",
       "                                        song_name                singer  \\\n",
       "0                                            小酒窝               林俊杰&蔡卓妍    \n",
       "1                                            社会摇                    萧全    \n",
       "2                                             台阶                    武艺    \n",
       "3                            一次就好-(电影《夏洛特烦恼》暖水曲)                   杨宗纬    \n",
       "4                                          一路上有你                   张学友    \n",
       "5                                   十年 (OT：明年今日)                   陈奕迅    \n",
       "6                                  你不知道的事(Live版)                   王力宏    \n",
       "7                                        Victory   Two Steps From Hell    \n",
       "8                                             野子                   流浪者    \n",
       "9  なんでもないや-[没什么大不了](Movie Ver.)-(动画电影《你的名字。》片尾曲)              RADWIMPS    \n",
       "\n",
       "  paid_flag  \n",
       "0         0  \n",
       "1         0  \n",
       "2         0  \n",
       "3         0  \n",
       "4         0  \n",
       "5         0  \n",
       "6         0  \n",
       "7         0  \n",
       "8         0  \n",
       "9         0  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_down.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "schema_search = ['uid','device','search_time']\n",
    "df_search = pd.read_csv('../music_box_data/data/search/20170330_1_search.log',delimiter='\\t',header=None,index_col=None,names=schema_search)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>uid</th>\n",
       "      <th>device</th>\n",
       "      <th>search_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>nohup: ignoring input</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>168050208</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>167659521</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>168411725</td>\n",
       "      <td>ip</td>\n",
       "      <td>2017-03-30 00:00:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>167852824</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>168043780</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>168040163</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>167690057</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>167858657</td>\n",
       "      <td>ar</td>\n",
       "      <td>2017-03-30 00:00:05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>168020662</td>\n",
       "      <td>ip</td>\n",
       "      <td>2017-03-30 00:00:05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     uid device           search_time\n",
       "0  nohup: ignoring input    NaN                   NaN\n",
       "1             168050208     ar   2017-03-30 00:00:00 \n",
       "2             167659521     ar   2017-03-30 00:00:01 \n",
       "3             168411725     ip   2017-03-30 00:00:01 \n",
       "4             167852824     ar   2017-03-30 00:00:02 \n",
       "5             168043780     ar   2017-03-30 00:00:02 \n",
       "6             168040163     ar   2017-03-30 00:00:03 \n",
       "7             167690057     ar   2017-03-30 00:00:04 \n",
       "8             167858657     ar   2017-03-30 00:00:05 \n",
       "9             168020662     ip   2017-03-30 00:00:05 "
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_search.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "python27",
   "language": "python",
   "name": "python27"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}