analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"http://bokeh.pydata.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"4584cb21-3829-4ac0-a0a9-2012f37bc6df\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(global) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof (window._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "    window._bokeh_onload_callbacks = [];\n",
       "    window._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "\n",
       "  \n",
       "  if (typeof (window._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    window._bokeh_timeout = Date.now() + 5000;\n",
       "    window._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    if (window.Bokeh !== undefined) {\n",
       "      var el = document.getElementById(\"4584cb21-3829-4ac0-a0a9-2012f37bc6df\");\n",
       "      el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
       "    } else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function run_callbacks() {\n",
       "    window._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "    delete window._bokeh_onload_callbacks\n",
       "    console.info(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(js_urls, callback) {\n",
       "    window._bokeh_onload_callbacks.push(callback);\n",
       "    if (window._bokeh_is_loading > 0) {\n",
       "      console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    window._bokeh_is_loading = js_urls.length;\n",
       "    for (var i = 0; i < js_urls.length; i++) {\n",
       "      var url = js_urls[i];\n",
       "      var s = document.createElement('script');\n",
       "      s.src = url;\n",
       "      s.async = false;\n",
       "      s.onreadystatechange = s.onload = function() {\n",
       "        window._bokeh_is_loading--;\n",
       "        if (window._bokeh_is_loading === 0) {\n",
       "          console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
       "          run_callbacks()\n",
       "        }\n",
       "      };\n",
       "      s.onerror = function() {\n",
       "        console.warn(\"failed to load library \" + url);\n",
       "      };\n",
       "      console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "    }\n",
       "  };var element = document.getElementById(\"4584cb21-3829-4ac0-a0a9-2012f37bc6df\");\n",
       "  if (element == null) {\n",
       "    console.log(\"Bokeh: ERROR: autoload.js configured with elementid '4584cb21-3829-4ac0-a0a9-2012f37bc6df' but no matching script tag was found. \")\n",
       "    return false;\n",
       "  }\n",
       "\n",
       "  var js_urls = [\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.js\", \"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.js\"];\n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "    },\n",
       "    \n",
       "    function(Bokeh) {\n",
       "      \n",
       "      document.getElementById(\"4584cb21-3829-4ac0-a0a9-2012f37bc6df\").textContent = \"BokehJS is loading...\";\n",
       "    },\n",
       "    function(Bokeh) {\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-0.12.5.min.css\");\n",
       "      console.log(\"Bokeh: injecting CSS: https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "      Bokeh.embed.inject_css(\"https://cdn.pydata.org/bokeh/release/bokeh-widgets-0.12.5.min.css\");\n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if ((window.Bokeh !== undefined) || (force === true)) {\n",
       "      for (var i = 0; i < inline_js.length; i++) {\n",
       "        inline_js[i](window.Bokeh);\n",
       "      }if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < window._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!window._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      window._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"4584cb21-3829-4ac0-a0a9-2012f37bc6df\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (window._bokeh_is_loading === 0) {\n",
       "    console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(js_urls, function() {\n",
       "      console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(this));"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# 初始化环境\n",
    "import pandas as pd\n",
    "from bokeh.plotting import figure, output_notebook, show\n",
    "from pymongo import MongoClient\n",
    "\n",
    "output_notebook()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# 数据库\n",
    "client = MongoClient()\n",
    "db = client[\"tgod-test\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 贴吧信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'_id': ObjectId('5913223d88063fb50af34247'),\n",
       " 'avatar': 'http://imgsrc.baidu.com/forum/pic/item/b219ebc4b74543a9d5cb69011f178a82b801142e.jpg',\n",
       " 'first_class': '中小学',\n",
       " 'id': '135131',\n",
       " 'is_exists': True,\n",
       " 'member_num': 4521,\n",
       " 'name': '程集中学',\n",
       " 'post_num': 169053,\n",
       " 'second_class': '安徽中小学',\n",
       " 'slogan': '榜上有名，脚下有路。',\n",
       " 'thread_num': 6607}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# forum = db[\"Forum\"].find_one({\"name\":\"程集中学\"})\n",
    "forum = db[\"Forum\"].find_one({\"id\":\"135131\"})\n",
    "forum"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 贴吧帖子列表"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>last_time</th>\n",
       "      <th>view_num</th>\n",
       "      <th>reply_num</th>\n",
       "      <th>title</th>\n",
       "      <th>author_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>create_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-04-14 11:03:56+08:00</th>\n",
       "      <td>133110193</td>\n",
       "      <td>2017-02-23 21:58:44</td>\n",
       "      <td>202</td>\n",
       "      <td>45</td>\n",
       "      <td>程集中学的师弟师妹们，努力啊！不要落后宿松中学</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-05-30 01:00:37+08:00</th>\n",
       "      <td>522512814</td>\n",
       "      <td>2017-04-06 12:09:08</td>\n",
       "      <td>204</td>\n",
       "      <td>80</td>\n",
       "      <td>程集中学五十年校庆</td>\n",
       "      <td>42112741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-06-09 10:20:00+08:00</th>\n",
       "      <td>2370245904</td>\n",
       "      <td>2017-02-06 15:16:09</td>\n",
       "      <td>196</td>\n",
       "      <td>12</td>\n",
       "      <td>桐城中学的一副对联，大家来看看我对的是否可以</td>\n",
       "      <td>164360233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-12-14 23:36:51+08:00</th>\n",
       "      <td>2432708455</td>\n",
       "      <td>2017-03-18 17:43:56</td>\n",
       "      <td>20057</td>\n",
       "      <td>2345</td>\n",
       "      <td>【刷】想要升级加速的速进。</td>\n",
       "      <td>678168683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-12-25 17:01:35+08:00</th>\n",
       "      <td>420809696</td>\n",
       "      <td>2017-03-04 12:11:40</td>\n",
       "      <td>1738</td>\n",
       "      <td>557</td>\n",
       "      <td>程集老师大比拼~~~选出你心中的好老师！</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-03-18 03:39:04+08:00</th>\n",
       "      <td>2432106502</td>\n",
       "      <td>2016-12-01 02:07:39</td>\n",
       "      <td>384</td>\n",
       "      <td>121</td>\n",
       "      <td>【吧规δ导航】请新老人同戳！</td>\n",
       "      <td>678168683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-03-22 22:59:45+08:00</th>\n",
       "      <td>611883273</td>\n",
       "      <td>2017-04-06 12:07:26</td>\n",
       "      <td>2783</td>\n",
       "      <td>1003</td>\n",
       "      <td>大家都来写上自己班主任的名字，看看哪个老师的门生最多</td>\n",
       "      <td>96779394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-07-12 05:54:59+08:00</th>\n",
       "      <td>3160495781</td>\n",
       "      <td>2017-04-30 07:36:55</td>\n",
       "      <td>233</td>\n",
       "      <td>14</td>\n",
       "      <td>各位学长学姐我今年考661分能进程集吗</td>\n",
       "      <td>1265751532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-07-13 00:11:44+08:00</th>\n",
       "      <td>3161858875</td>\n",
       "      <td>2017-01-31 07:57:49</td>\n",
       "      <td>911</td>\n",
       "      <td>116</td>\n",
       "      <td>输入#(pic,QQ号,600,600)</td>\n",
       "      <td>939241639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-08-24 16:09:49+08:00</th>\n",
       "      <td>3253474623</td>\n",
       "      <td>2017-03-08 12:38:26</td>\n",
       "      <td>743</td>\n",
       "      <td>93</td>\n",
       "      <td>不怎么好的程集——一个14年毕业生的独白</td>\n",
       "      <td>975381369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-03-22 05:16:25+08:00</th>\n",
       "      <td>3651813745</td>\n",
       "      <td>2017-02-06 16:32:41</td>\n",
       "      <td>620</td>\n",
       "      <td>77</td>\n",
       "      <td>戳进来~快点戳进来！！！</td>\n",
       "      <td>1167694342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-06-15 05:11:03+08:00</th>\n",
       "      <td>3828474449</td>\n",
       "      <td>2017-03-22 02:18:43</td>\n",
       "      <td>1181</td>\n",
       "      <td>154</td>\n",
       "      <td>盘点那些非211的实力却超半数211工程的大学</td>\n",
       "      <td>1000551287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-06 05:12:41+08:00</th>\n",
       "      <td>3874664499</td>\n",
       "      <td>2017-01-13 14:36:11</td>\n",
       "      <td>720</td>\n",
       "      <td>92</td>\n",
       "      <td>怎么比较程集中学和宿松中学</td>\n",
       "      <td>1732445244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-25 05:46:04+08:00</th>\n",
       "      <td>3919584524</td>\n",
       "      <td>2017-04-06 12:06:01</td>\n",
       "      <td>945</td>\n",
       "      <td>123</td>\n",
       "      <td>2010届运动会【五年前的程集中学】</td>\n",
       "      <td>1167694342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-30 22:12:06+08:00</th>\n",
       "      <td>3933617147</td>\n",
       "      <td>2017-03-16 10:21:38</td>\n",
       "      <td>3333</td>\n",
       "      <td>416</td>\n",
       "      <td>数学老师</td>\n",
       "      <td>1145202556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-11 23:57:07+08:00</th>\n",
       "      <td>3965531701</td>\n",
       "      <td>2017-01-31 09:13:20</td>\n",
       "      <td>811</td>\n",
       "      <td>105</td>\n",
       "      <td>学习雷锋，本人帮找各种电影资源，总有你需要的</td>\n",
       "      <td>979659057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-14 12:21:05+08:00</th>\n",
       "      <td>3972263787</td>\n",
       "      <td>2017-04-07 15:03:24</td>\n",
       "      <td>280</td>\n",
       "      <td>26</td>\n",
       "      <td>告别贴</td>\n",
       "      <td>814211223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-15 14:24:14+08:00</th>\n",
       "      <td>3975003914</td>\n",
       "      <td>2017-04-07 15:02:47</td>\n",
       "      <td>384</td>\n",
       "      <td>43</td>\n",
       "      <td>不知道他在学校过的怎么样</td>\n",
       "      <td>1000551287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-02 17:07:05+08:00</th>\n",
       "      <td>4017190359</td>\n",
       "      <td>2017-04-07 15:03:55</td>\n",
       "      <td>935</td>\n",
       "      <td>122</td>\n",
       "      <td>说说你最喜欢的歌词（诗词）</td>\n",
       "      <td>1189098715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-05 13:37:21+08:00</th>\n",
       "      <td>4023423945</td>\n",
       "      <td>2017-05-06 06:59:52</td>\n",
       "      <td>455</td>\n",
       "      <td>54</td>\n",
       "      <td>程集中学校友报道帖！</td>\n",
       "      <td>645729153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-22 04:44:04+08:00</th>\n",
       "      <td>4498163220</td>\n",
       "      <td>2017-03-13 11:23:05</td>\n",
       "      <td>643</td>\n",
       "      <td>84</td>\n",
       "      <td>大学报考指南</td>\n",
       "      <td>2194407898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-27 16:16:36+08:00</th>\n",
       "      <td>4511068955</td>\n",
       "      <td>2017-03-04 16:05:19</td>\n",
       "      <td>464</td>\n",
       "      <td>58</td>\n",
       "      <td>程中会员记录贴</td>\n",
       "      <td>412759743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-05-15 15:35:05+08:00</th>\n",
       "      <td>4549477620</td>\n",
       "      <td>2017-05-08 07:17:47</td>\n",
       "      <td>345</td>\n",
       "      <td>40</td>\n",
       "      <td>兔走乌飞，几度夕阳。</td>\n",
       "      <td>1044545954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-06-06 07:16:54+08:00</th>\n",
       "      <td>4594259280</td>\n",
       "      <td>2017-03-14 08:11:46</td>\n",
       "      <td>306</td>\n",
       "      <td>34</td>\n",
       "      <td>安徽大学，明智之选</td>\n",
       "      <td>883103909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-01 15:16:27+08:00</th>\n",
       "      <td>4644750692</td>\n",
       "      <td>2017-05-10 06:07:00</td>\n",
       "      <td>566</td>\n",
       "      <td>74</td>\n",
       "      <td>程集有哪些好班主任(理科)望师</td>\n",
       "      <td>1804472799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-07 07:18:58+08:00</th>\n",
       "      <td>4656021068</td>\n",
       "      <td>2017-02-20 08:18:19</td>\n",
       "      <td>417</td>\n",
       "      <td>52</td>\n",
       "      <td>王雪峰</td>\n",
       "      <td>804557789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-21 14:37:22+08:00</th>\n",
       "      <td>4685071518</td>\n",
       "      <td>2017-03-16 02:36:35</td>\n",
       "      <td>161</td>\n",
       "      <td>9</td>\n",
       "      <td>有安大的学长学姐没</td>\n",
       "      <td>2059767040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-27 06:49:09+08:00</th>\n",
       "      <td>4696273378</td>\n",
       "      <td>2017-01-19 03:50:38</td>\n",
       "      <td>270</td>\n",
       "      <td>29</td>\n",
       "      <td>你们建了几个新生群？</td>\n",
       "      <td>2456263507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-03 03:45:23+08:00</th>\n",
       "      <td>4709732618</td>\n",
       "      <td>2017-05-10 06:04:30</td>\n",
       "      <td>169</td>\n",
       "      <td>11</td>\n",
       "      <td>程集中学有哪些奇葩的班主任？</td>\n",
       "      <td>2681148995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-17 07:20:42+08:00</th>\n",
       "      <td>4735618380</td>\n",
       "      <td>2017-02-09 08:30:19</td>\n",
       "      <td>221</td>\n",
       "      <td>21</td>\n",
       "      <td>有人认识余佳男吗</td>\n",
       "      <td>941212633</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-01 17:25:37+08:00</th>\n",
       "      <td>5003651024</td>\n",
       "      <td>2017-03-02 02:04:11</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>学弟学妹们能把16年录取榜拍照</td>\n",
       "      <td>1067350110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-02 10:54:46+08:00</th>\n",
       "      <td>5004616888</td>\n",
       "      <td>2017-03-04 11:34:57</td>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>伟大的班主任们（重点在后面）</td>\n",
       "      <td>2695393683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-02 15:06:26+08:00</th>\n",
       "      <td>5004944944</td>\n",
       "      <td>2017-03-25 15:39:59</td>\n",
       "      <td>186</td>\n",
       "      <td>21</td>\n",
       "      <td>程集面临大整改！！！</td>\n",
       "      <td>1053034378</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-04 04:10:58+08:00</th>\n",
       "      <td>5006870454</td>\n",
       "      <td>2017-03-24 08:57:10</td>\n",
       "      <td>158</td>\n",
       "      <td>16</td>\n",
       "      <td>啦啦啦~</td>\n",
       "      <td>2614021914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-04 09:02:45+08:00</th>\n",
       "      <td>5007235686</td>\n",
       "      <td>2017-03-09 07:01:13</td>\n",
       "      <td>87</td>\n",
       "      <td>0</td>\n",
       "      <td>求助大家了！</td>\n",
       "      <td>2465777061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-04 11:39:17+08:00</th>\n",
       "      <td>5007425604</td>\n",
       "      <td>2017-03-24 15:43:32</td>\n",
       "      <td>214</td>\n",
       "      <td>26</td>\n",
       "      <td>关于高一高二周末不补课</td>\n",
       "      <td>2020174157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-06 17:17:49+08:00</th>\n",
       "      <td>5010654003</td>\n",
       "      <td>2017-05-03 05:08:22</td>\n",
       "      <td>126</td>\n",
       "      <td>10</td>\n",
       "      <td>12届毕业学长路过</td>\n",
       "      <td>850457019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-08 17:21:34+08:00</th>\n",
       "      <td>5013532656</td>\n",
       "      <td>2017-04-04 16:11:55</td>\n",
       "      <td>98</td>\n",
       "      <td>4</td>\n",
       "      <td>程中的学子们，加油吧</td>\n",
       "      <td>1657235799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-10 11:01:46+08:00</th>\n",
       "      <td>5016066279</td>\n",
       "      <td>2017-03-13 04:37:17</td>\n",
       "      <td>102</td>\n",
       "      <td>5</td>\n",
       "      <td>求学妹学弟的帮忙</td>\n",
       "      <td>954617219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-11 16:41:33+08:00</th>\n",
       "      <td>5017944261</td>\n",
       "      <td>2017-03-12 02:49:22</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>老人冒个泡</td>\n",
       "      <td>96779394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-15 07:50:42+08:00</th>\n",
       "      <td>5023239434</td>\n",
       "      <td>2017-04-17 12:43:23</td>\n",
       "      <td>96</td>\n",
       "      <td>4</td>\n",
       "      <td>有福州大学城的么</td>\n",
       "      <td>2131034825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-17 06:36:02+08:00</th>\n",
       "      <td>5026229563</td>\n",
       "      <td>2017-03-18 02:50:06</td>\n",
       "      <td>88</td>\n",
       "      <td>2</td>\n",
       "      <td>安庆二模</td>\n",
       "      <td>811672168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-22 08:30:04+08:00</th>\n",
       "      <td>5034421746</td>\n",
       "      <td>2017-04-29 09:25:59</td>\n",
       "      <td>533</td>\n",
       "      <td>76</td>\n",
       "      <td>程集中学江风老师个人画展</td>\n",
       "      <td>2020174157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-23 15:16:41+08:00</th>\n",
       "      <td>5036747599</td>\n",
       "      <td>2017-04-02 14:09:06</td>\n",
       "      <td>101</td>\n",
       "      <td>6</td>\n",
       "      <td>朱原野～朱原野</td>\n",
       "      <td>1748504112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-23 17:50:34+08:00</th>\n",
       "      <td>5036910830</td>\n",
       "      <td>2017-03-25 16:28:46</td>\n",
       "      <td>110</td>\n",
       "      <td>8</td>\n",
       "      <td>15级上海大二学长路过</td>\n",
       "      <td>2059146387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-28 05:02:12+08:00</th>\n",
       "      <td>5043991568</td>\n",
       "      <td>2017-04-05 12:09:15</td>\n",
       "      <td>91</td>\n",
       "      <td>4</td>\n",
       "      <td>程集中学2017高三二模考试分数揭哓</td>\n",
       "      <td>2938987687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-29 07:25:52+08:00</th>\n",
       "      <td>5045915730</td>\n",
       "      <td>2017-04-04 01:37:29</td>\n",
       "      <td>90</td>\n",
       "      <td>4</td>\n",
       "      <td>会考</td>\n",
       "      <td>1223010605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-01 03:51:20+08:00</th>\n",
       "      <td>5050633390</td>\n",
       "      <td>2017-04-01 14:25:26</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>程集中学今天放假吗</td>\n",
       "      <td>2962264011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-03 06:58:50+08:00</th>\n",
       "      <td>5054039676</td>\n",
       "      <td>2017-04-03 18:07:20</td>\n",
       "      <td>96</td>\n",
       "      <td>6</td>\n",
       "      <td>咳咳 各位老板多多指教本帖子 谢谢</td>\n",
       "      <td>1250743971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-16 02:12:59+08:00</th>\n",
       "      <td>5074927815</td>\n",
       "      <td>2017-05-07 02:29:31</td>\n",
       "      <td>237</td>\n",
       "      <td>33</td>\n",
       "      <td>程中学子们加油！</td>\n",
       "      <td>2533429322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-22 16:27:30+08:00</th>\n",
       "      <td>5085329351</td>\n",
       "      <td>2017-04-24 08:02:11</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>为一个帅帅的学弟加油</td>\n",
       "      <td>903991487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26 01:20:01+08:00</th>\n",
       "      <td>5089954317</td>\n",
       "      <td>2017-05-02 01:53:17</td>\n",
       "      <td>64</td>\n",
       "      <td>2</td>\n",
       "      <td>(*￣︶￣)一年一度高考季要来了，关于择校你造吗？</td>\n",
       "      <td>2474873955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26 12:08:55+08:00</th>\n",
       "      <td>5090778414</td>\n",
       "      <td>2017-05-05 00:25:21</td>\n",
       "      <td>114</td>\n",
       "      <td>13</td>\n",
       "      <td>夏天又到了，今年毕业季可能回去看看吧</td>\n",
       "      <td>613167107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-30 07:34:21+08:00</th>\n",
       "      <td>5095700692</td>\n",
       "      <td>2017-05-01 07:58:40</td>\n",
       "      <td>63</td>\n",
       "      <td>3</td>\n",
       "      <td>各位学姐学长们，请问一下要考进程集中学要多少分？拜托告知。</td>\n",
       "      <td>3019933854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 04:57:30+08:00</th>\n",
       "      <td>5100914721</td>\n",
       "      <td>2017-05-04 04:57:30</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>11年毕业的路过</td>\n",
       "      <td>1033333156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 06:18:43+08:00</th>\n",
       "      <td>5101024076</td>\n",
       "      <td>2017-05-07 15:25:36</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>求助 日本留学</td>\n",
       "      <td>2650557629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 15:25:30+08:00</th>\n",
       "      <td>5101933105</td>\n",
       "      <td>2017-05-09 16:06:37</td>\n",
       "      <td>56</td>\n",
       "      <td>3</td>\n",
       "      <td>找人</td>\n",
       "      <td>1161408985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 15:40:04+08:00</th>\n",
       "      <td>5101957291</td>\n",
       "      <td>2017-05-09 06:39:21</td>\n",
       "      <td>151</td>\n",
       "      <td>22</td>\n",
       "      <td>某班主任狂妄自大，自以为是！</td>\n",
       "      <td>710342877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-05 08:23:42+08:00</th>\n",
       "      <td>5102937422</td>\n",
       "      <td>2017-05-07 10:46:02</td>\n",
       "      <td>86</td>\n",
       "      <td>10</td>\n",
       "      <td>有在吉林大学的校友吗？13届程中学子在长春，求回复</td>\n",
       "      <td>1714613991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-10 10:20:37+08:00</th>\n",
       "      <td>5110118072</td>\n",
       "      <td>2017-05-10 12:06:31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>长的丑就要多读书。</td>\n",
       "      <td>714103838</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>99 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   id           last_time view_num  reply_num  \\\n",
       "create_time                                                                     \n",
       "2012-04-14 11:03:56+08:00   133110193 2017-02-23 21:58:44      202         45   \n",
       "2012-05-30 01:00:37+08:00   522512814 2017-04-06 12:09:08      204         80   \n",
       "2013-06-09 10:20:00+08:00  2370245904 2017-02-06 15:16:09      196         12   \n",
       "2013-12-14 23:36:51+08:00  2432708455 2017-03-18 17:43:56    20057       2345   \n",
       "2013-12-25 17:01:35+08:00   420809696 2017-03-04 12:11:40     1738        557   \n",
       "2014-03-18 03:39:04+08:00  2432106502 2016-12-01 02:07:39      384        121   \n",
       "2014-03-22 22:59:45+08:00   611883273 2017-04-06 12:07:26     2783       1003   \n",
       "2014-07-12 05:54:59+08:00  3160495781 2017-04-30 07:36:55      233         14   \n",
       "2014-07-13 00:11:44+08:00  3161858875 2017-01-31 07:57:49      911        116   \n",
       "2014-08-24 16:09:49+08:00  3253474623 2017-03-08 12:38:26      743         93   \n",
       "2015-03-22 05:16:25+08:00  3651813745 2017-02-06 16:32:41      620         77   \n",
       "2015-06-15 05:11:03+08:00  3828474449 2017-03-22 02:18:43     1181        154   \n",
       "2015-07-06 05:12:41+08:00  3874664499 2017-01-13 14:36:11      720         92   \n",
       "2015-07-25 05:46:04+08:00  3919584524 2017-04-06 12:06:01      945        123   \n",
       "2015-07-30 22:12:06+08:00  3933617147 2017-03-16 10:21:38     3333        416   \n",
       "2015-08-11 23:57:07+08:00  3965531701 2017-01-31 09:13:20      811        105   \n",
       "2015-08-14 12:21:05+08:00  3972263787 2017-04-07 15:03:24      280         26   \n",
       "2015-08-15 14:24:14+08:00  3975003914 2017-04-07 15:02:47      384         43   \n",
       "2015-09-02 17:07:05+08:00  4017190359 2017-04-07 15:03:55      935        122   \n",
       "2015-09-05 13:37:21+08:00  4023423945 2017-05-06 06:59:52      455         54   \n",
       "2016-04-22 04:44:04+08:00  4498163220 2017-03-13 11:23:05      643         84   \n",
       "2016-04-27 16:16:36+08:00  4511068955 2017-03-04 16:05:19      464         58   \n",
       "2016-05-15 15:35:05+08:00  4549477620 2017-05-08 07:17:47      345         40   \n",
       "2016-06-06 07:16:54+08:00  4594259280 2017-03-14 08:11:46      306         34   \n",
       "2016-07-01 15:16:27+08:00  4644750692 2017-05-10 06:07:00      566         74   \n",
       "2016-07-07 07:18:58+08:00  4656021068 2017-02-20 08:18:19      417         52   \n",
       "2016-07-21 14:37:22+08:00  4685071518 2017-03-16 02:36:35      161          9   \n",
       "2016-07-27 06:49:09+08:00  4696273378 2017-01-19 03:50:38      270         29   \n",
       "2016-08-03 03:45:23+08:00  4709732618 2017-05-10 06:04:30      169         11   \n",
       "2016-08-17 07:20:42+08:00  4735618380 2017-02-09 08:30:19      221         21   \n",
       "...                               ...                 ...      ...        ...   \n",
       "2017-03-01 17:25:37+08:00  5003651024 2017-03-02 02:04:11       90          1   \n",
       "2017-03-02 10:54:46+08:00  5004616888 2017-03-04 11:34:57      100          4   \n",
       "2017-03-02 15:06:26+08:00  5004944944 2017-03-25 15:39:59      186         21   \n",
       "2017-03-04 04:10:58+08:00  5006870454 2017-03-24 08:57:10      158         16   \n",
       "2017-03-04 09:02:45+08:00  5007235686 2017-03-09 07:01:13       87          0   \n",
       "2017-03-04 11:39:17+08:00  5007425604 2017-03-24 15:43:32      214         26   \n",
       "2017-03-06 17:17:49+08:00  5010654003 2017-05-03 05:08:22      126         10   \n",
       "2017-03-08 17:21:34+08:00  5013532656 2017-04-04 16:11:55       98          4   \n",
       "2017-03-10 11:01:46+08:00  5016066279 2017-03-13 04:37:17      102          5   \n",
       "2017-03-11 16:41:33+08:00  5017944261 2017-03-12 02:49:22       87          1   \n",
       "2017-03-15 07:50:42+08:00  5023239434 2017-04-17 12:43:23       96          4   \n",
       "2017-03-17 06:36:02+08:00  5026229563 2017-03-18 02:50:06       88          2   \n",
       "2017-03-22 08:30:04+08:00  5034421746 2017-04-29 09:25:59      533         76   \n",
       "2017-03-23 15:16:41+08:00  5036747599 2017-04-02 14:09:06      101          6   \n",
       "2017-03-23 17:50:34+08:00  5036910830 2017-03-25 16:28:46      110          8   \n",
       "2017-03-28 05:02:12+08:00  5043991568 2017-04-05 12:09:15       91          4   \n",
       "2017-03-29 07:25:52+08:00  5045915730 2017-04-04 01:37:29       90          4   \n",
       "2017-04-01 03:51:20+08:00  5050633390 2017-04-01 14:25:26       89          4   \n",
       "2017-04-03 06:58:50+08:00  5054039676 2017-04-03 18:07:20       96          6   \n",
       "2017-04-16 02:12:59+08:00  5074927815 2017-05-07 02:29:31      237         33   \n",
       "2017-04-22 16:27:30+08:00  5085329351 2017-04-24 08:02:11       65          1   \n",
       "2017-04-26 01:20:01+08:00  5089954317 2017-05-02 01:53:17       64          2   \n",
       "2017-04-26 12:08:55+08:00  5090778414 2017-05-05 00:25:21      114         13   \n",
       "2017-04-30 07:34:21+08:00  5095700692 2017-05-01 07:58:40       63          3   \n",
       "2017-05-04 04:57:30+08:00  5100914721 2017-05-04 04:57:30       48          0   \n",
       "2017-05-04 06:18:43+08:00  5101024076 2017-05-07 15:25:36       61          4   \n",
       "2017-05-04 15:25:30+08:00  5101933105 2017-05-09 16:06:37       56          3   \n",
       "2017-05-04 15:40:04+08:00  5101957291 2017-05-09 06:39:21      151         22   \n",
       "2017-05-05 08:23:42+08:00  5102937422 2017-05-07 10:46:02       86         10   \n",
       "2017-05-10 10:20:37+08:00  5110118072 2017-05-10 12:06:31       21          1   \n",
       "\n",
       "                                                   title   author_id  \n",
       "create_time                                                           \n",
       "2012-04-14 11:03:56+08:00        程集中学的师弟师妹们，努力啊！不要落后宿松中学           0  \n",
       "2012-05-30 01:00:37+08:00                      程集中学五十年校庆    42112741  \n",
       "2013-06-09 10:20:00+08:00         桐城中学的一副对联，大家来看看我对的是否可以   164360233  \n",
       "2013-12-14 23:36:51+08:00                  【刷】想要升级加速的速进。   678168683  \n",
       "2013-12-25 17:01:35+08:00           程集老师大比拼~~~选出你心中的好老师！           0  \n",
       "2014-03-18 03:39:04+08:00                 【吧规δ导航】请新老人同戳！   678168683  \n",
       "2014-03-22 22:59:45+08:00     大家都来写上自己班主任的名字，看看哪个老师的门生最多    96779394  \n",
       "2014-07-12 05:54:59+08:00            各位学长学姐我今年考661分能进程集吗  1265751532  \n",
       "2014-07-13 00:11:44+08:00           输入#(pic,QQ号,600,600)   939241639  \n",
       "2014-08-24 16:09:49+08:00           不怎么好的程集——一个14年毕业生的独白   975381369  \n",
       "2015-03-22 05:16:25+08:00                   戳进来~快点戳进来！！！  1167694342  \n",
       "2015-06-15 05:11:03+08:00        盘点那些非211的实力却超半数211工程的大学  1000551287  \n",
       "2015-07-06 05:12:41+08:00                  怎么比较程集中学和宿松中学  1732445244  \n",
       "2015-07-25 05:46:04+08:00             2010届运动会【五年前的程集中学】  1167694342  \n",
       "2015-07-30 22:12:06+08:00                           数学老师  1145202556  \n",
       "2015-08-11 23:57:07+08:00         学习雷锋，本人帮找各种电影资源，总有你需要的   979659057  \n",
       "2015-08-14 12:21:05+08:00                            告别贴   814211223  \n",
       "2015-08-15 14:24:14+08:00                   不知道他在学校过的怎么样  1000551287  \n",
       "2015-09-02 17:07:05+08:00                  说说你最喜欢的歌词（诗词）  1189098715  \n",
       "2015-09-05 13:37:21+08:00                     程集中学校友报道帖！   645729153  \n",
       "2016-04-22 04:44:04+08:00                         大学报考指南  2194407898  \n",
       "2016-04-27 16:16:36+08:00                        程中会员记录贴   412759743  \n",
       "2016-05-15 15:35:05+08:00                     兔走乌飞，几度夕阳。  1044545954  \n",
       "2016-06-06 07:16:54+08:00                      安徽大学，明智之选   883103909  \n",
       "2016-07-01 15:16:27+08:00                程集有哪些好班主任(理科)望师  1804472799  \n",
       "2016-07-07 07:18:58+08:00                            王雪峰   804557789  \n",
       "2016-07-21 14:37:22+08:00                      有安大的学长学姐没  2059767040  \n",
       "2016-07-27 06:49:09+08:00                     你们建了几个新生群？  2456263507  \n",
       "2016-08-03 03:45:23+08:00                 程集中学有哪些奇葩的班主任？  2681148995  \n",
       "2016-08-17 07:20:42+08:00                       有人认识余佳男吗   941212633  \n",
       "...                                                  ...         ...  \n",
       "2017-03-01 17:25:37+08:00                学弟学妹们能把16年录取榜拍照  1067350110  \n",
       "2017-03-02 10:54:46+08:00                 伟大的班主任们（重点在后面）  2695393683  \n",
       "2017-03-02 15:06:26+08:00                     程集面临大整改！！！  1053034378  \n",
       "2017-03-04 04:10:58+08:00                           啦啦啦~  2614021914  \n",
       "2017-03-04 09:02:45+08:00                         求助大家了！  2465777061  \n",
       "2017-03-04 11:39:17+08:00                    关于高一高二周末不补课  2020174157  \n",
       "2017-03-06 17:17:49+08:00                      12届毕业学长路过   850457019  \n",
       "2017-03-08 17:21:34+08:00                     程中的学子们，加油吧  1657235799  \n",
       "2017-03-10 11:01:46+08:00                       求学妹学弟的帮忙   954617219  \n",
       "2017-03-11 16:41:33+08:00                          老人冒个泡    96779394  \n",
       "2017-03-15 07:50:42+08:00                       有福州大学城的么  2131034825  \n",
       "2017-03-17 06:36:02+08:00                           安庆二模   811672168  \n",
       "2017-03-22 08:30:04+08:00                   程集中学江风老师个人画展  2020174157  \n",
       "2017-03-23 15:16:41+08:00                        朱原野～朱原野  1748504112  \n",
       "2017-03-23 17:50:34+08:00                    15级上海大二学长路过  2059146387  \n",
       "2017-03-28 05:02:12+08:00             程集中学2017高三二模考试分数揭哓  2938987687  \n",
       "2017-03-29 07:25:52+08:00                             会考  1223010605  \n",
       "2017-04-01 03:51:20+08:00                      程集中学今天放假吗  2962264011  \n",
       "2017-04-03 06:58:50+08:00              咳咳 各位老板多多指教本帖子 谢谢  1250743971  \n",
       "2017-04-16 02:12:59+08:00                       程中学子们加油！  2533429322  \n",
       "2017-04-22 16:27:30+08:00                     为一个帅帅的学弟加油   903991487  \n",
       "2017-04-26 01:20:01+08:00      (*￣︶￣)一年一度高考季要来了，关于择校你造吗？  2474873955  \n",
       "2017-04-26 12:08:55+08:00             夏天又到了，今年毕业季可能回去看看吧   613167107  \n",
       "2017-04-30 07:34:21+08:00  各位学姐学长们，请问一下要考进程集中学要多少分？拜托告知。  3019933854  \n",
       "2017-05-04 04:57:30+08:00                       11年毕业的路过  1033333156  \n",
       "2017-05-04 06:18:43+08:00                        求助 日本留学  2650557629  \n",
       "2017-05-04 15:25:30+08:00                             找人  1161408985  \n",
       "2017-05-04 15:40:04+08:00                 某班主任狂妄自大，自以为是！   710342877  \n",
       "2017-05-05 08:23:42+08:00      有在吉林大学的校友吗？13届程中学子在长春，求回复  1714613991  \n",
       "2017-05-10 10:20:37+08:00                      长的丑就要多读书。   714103838  \n",
       "\n",
       "[99 rows x 6 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "threads = db[\"Thread\"].find().sort(\"create_time\")\n",
    "# http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.html#pandas.DataFrame\n",
    "threads_df = pd.DataFrame(list(threads), columns=[\"id\", \"create_time\", \"last_time\", \"view_num\", \"reply_num\", \"title\", \"author_id\"])\n",
    "threads_df.set_index(\"create_time\", inplace=True)\n",
    "threads_df.tz_localize(\"Asia/Shanghai\", copy=False)\n",
    "threads_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 贴吧发帖趋势"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <div class=\"bk-plotdiv\" id=\"1c431052-7d52-49c4-8c4d-caab4725b21b\"></div>\n",
       "    </div>\n",
       "<script type=\"text/javascript\">\n",
       "  \n",
       "  (function(global) {\n",
       "    function now() {\n",
       "      return new Date();\n",
       "    }\n",
       "  \n",
       "    var force = false;\n",
       "  \n",
       "    if (typeof (window._bokeh_onload_callbacks) === \"undefined\" || force === true) {\n",
       "      window._bokeh_onload_callbacks = [];\n",
       "      window._bokeh_is_loading = undefined;\n",
       "    }\n",
       "  \n",
       "  \n",
       "    \n",
       "    if (typeof (window._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "      window._bokeh_timeout = Date.now() + 0;\n",
       "      window._bokeh_failed_load = false;\n",
       "    }\n",
       "  \n",
       "    var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "       \"<div style='background-color: #fdd'>\\n\"+\n",
       "       \"<p>\\n\"+\n",
       "       \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "       \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "       \"</p>\\n\"+\n",
       "       \"<ul>\\n\"+\n",
       "       \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "       \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "       \"</ul>\\n\"+\n",
       "       \"<code>\\n\"+\n",
       "       \"from bokeh.resources import INLINE\\n\"+\n",
       "       \"output_notebook(resources=INLINE)\\n\"+\n",
       "       \"</code>\\n\"+\n",
       "       \"</div>\"}};\n",
       "  \n",
       "    function display_loaded() {\n",
       "      if (window.Bokeh !== undefined) {\n",
       "        var el = document.getElementById(\"1c431052-7d52-49c4-8c4d-caab4725b21b\");\n",
       "        el.textContent = \"BokehJS \" + Bokeh.version + \" successfully loaded.\";\n",
       "      } else if (Date.now() < window._bokeh_timeout) {\n",
       "        setTimeout(display_loaded, 100)\n",
       "      }\n",
       "    }\n",
       "  \n",
       "    function run_callbacks() {\n",
       "      window._bokeh_onload_callbacks.forEach(function(callback) { callback() });\n",
       "      delete window._bokeh_onload_callbacks\n",
       "      console.info(\"Bokeh: all callbacks have finished\");\n",
       "    }\n",
       "  \n",
       "    function load_libs(js_urls, callback) {\n",
       "      window._bokeh_onload_callbacks.push(callback);\n",
       "      if (window._bokeh_is_loading > 0) {\n",
       "        console.log(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "        return null;\n",
       "      }\n",
       "      if (js_urls == null || js_urls.length === 0) {\n",
       "        run_callbacks();\n",
       "        return null;\n",
       "      }\n",
       "      console.log(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "      window._bokeh_is_loading = js_urls.length;\n",
       "      for (var i = 0; i < js_urls.length; i++) {\n",
       "        var url = js_urls[i];\n",
       "        var s = document.createElement('script');\n",
       "        s.src = url;\n",
       "        s.async = false;\n",
       "        s.onreadystatechange = s.onload = function() {\n",
       "          window._bokeh_is_loading--;\n",
       "          if (window._bokeh_is_loading === 0) {\n",
       "            console.log(\"Bokeh: all BokehJS libraries loaded\");\n",
       "            run_callbacks()\n",
       "          }\n",
       "        };\n",
       "        s.onerror = function() {\n",
       "          console.warn(\"failed to load library \" + url);\n",
       "        };\n",
       "        console.log(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "        document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "      }\n",
       "    };var element = document.getElementById(\"1c431052-7d52-49c4-8c4d-caab4725b21b\");\n",
       "    if (element == null) {\n",
       "      console.log(\"Bokeh: ERROR: autoload.js configured with elementid '1c431052-7d52-49c4-8c4d-caab4725b21b' but no matching script tag was found. \")\n",
       "      return false;\n",
       "    }\n",
       "  \n",
       "    var js_urls = [];\n",
       "  \n",
       "    var inline_js = [\n",
       "      function(Bokeh) {\n",
       "        (function() {\n",
       "          var fn = function() {\n",
       "            var docs_json = {\"3c8104e4-4406-4a29-889b-d7b9708555c3\":{\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"884ed175-a674-4548-b4fb-615dd9b6fb26\",\"type\":\"LinearAxis\"}],\"left\":[{\"id\":\"fca6d232-9d28-4bc6-a36b-0cd723c9028c\",\"type\":\"LinearAxis\"}],\"renderers\":[{\"id\":\"884ed175-a674-4548-b4fb-615dd9b6fb26\",\"type\":\"LinearAxis\"},{\"id\":\"0e156085-91c5-416b-ad63-997ebe6c36e5\",\"type\":\"Grid\"},{\"id\":\"fca6d232-9d28-4bc6-a36b-0cd723c9028c\",\"type\":\"LinearAxis\"},{\"id\":\"5d951817-8f90-4b38-80ae-ac0ddb4d5532\",\"type\":\"Grid\"},{\"id\":\"ede791bb-461f-472d-b479-df5ae00743e2\",\"type\":\"BoxAnnotation\"},{\"id\":\"bba9ef7c-5599-4c5e-a4ea-94afd68ea38c\",\"type\":\"GlyphRenderer\"}],\"title\":{\"id\":\"3bb39a2b-311f-4ac2-9b24-1ad7a890619a\",\"type\":\"Title\"},\"tool_events\":{\"id\":\"b205f21b-3920-492e-9ad0-7fade84c78c1\",\"type\":\"ToolEvents\"},\"toolbar\":{\"id\":\"9cc01e33-c174-48a2-adae-b59bb978ce63\",\"type\":\"Toolbar\"},\"x_range\":{\"id\":\"5436ab73-272d-48eb-b114-9c616e2934e0\",\"type\":\"DataRange1d\"},\"y_range\":{\"id\":\"a767c73c-e178-466a-8f2c-8f79e38a5aff\",\"type\":\"DataRange1d\"}},\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"active_drag\":\"auto\",\"active_scroll\":\"auto\",\"active_tap\":\"auto\",\"tools\":[{\"id\":\"02d9e6fe-30b7-4348-8666-6cceb0bea276\",\"type\":\"PanTool\"},{\"id\":\"102c549d-1ec1-408b-91d5-26ae5503eb89\",\"type\":\"WheelZoomTool\"},{\"id\":\"0ddeb090-9706-4ff6-9c97-feb40dfc0ac6\",\"type\":\"BoxZoomTool\"},{\"id\":\"a3cbf3f2-147f-4971-89b0-ba0fa967355d\",\"type\":\"SaveTool\"},{\"id\":\"b6e73dce-21d4-4602-9f04-ff1d119dcba6\",\"type\":\"ResetTool\"},{\"id\":\"33e47d04-0f2e-4061-8313-da2f3451e74f\",\"type\":\"HelpTool\"}]},\"id\":\"9cc01e33-c174-48a2-adae-b59bb978ce63\",\"type\":\"Toolbar\"},{\"attributes\":{\"formatter\":{\"id\":\"11fb703a-30ad-4167-aaa0-70937d89e131\",\"type\":\"BasicTickFormatter\"},\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"d7d666d2-ad0c-4565-baab-c9f4c6f7a502\",\"type\":\"BasicTicker\"}},\"id\":\"fca6d232-9d28-4bc6-a36b-0cd723c9028c\",\"type\":\"LinearAxis\"},{\"attributes\":{\"dimension\":1,\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"d7d666d2-ad0c-4565-baab-c9f4c6f7a502\",\"type\":\"BasicTicker\"}},\"id\":\"5d951817-8f90-4b38-80ae-ac0ddb4d5532\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"d7d666d2-ad0c-4565-baab-c9f4c6f7a502\",\"type\":\"BasicTicker\"},{\"attributes\":{\"plot\":null,\"text\":\"\"},\"id\":\"3bb39a2b-311f-4ac2-9b24-1ad7a890619a\",\"type\":\"Title\"},{\"attributes\":{\"callback\":null},\"id\":\"5436ab73-272d-48eb-b114-9c616e2934e0\",\"type\":\"DataRange1d\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"b6e73dce-21d4-4602-9f04-ff1d119dcba6\",\"type\":\"ResetTool\"},{\"attributes\":{\"overlay\":{\"id\":\"ede791bb-461f-472d-b479-df5ae00743e2\",\"type\":\"BoxAnnotation\"},\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"0ddeb090-9706-4ff6-9c97-feb40dfc0ac6\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"2374ca1e-3c7c-4fe8-9c9c-20ee81128166\",\"type\":\"BasicTicker\"}},\"id\":\"0e156085-91c5-416b-ad63-997ebe6c36e5\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"b205f21b-3920-492e-9ad0-7fade84c78c1\",\"type\":\"ToolEvents\"},{\"attributes\":{},\"id\":\"2374ca1e-3c7c-4fe8-9c9c-20ee81128166\",\"type\":\"BasicTicker\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"33e47d04-0f2e-4061-8313-da2f3451e74f\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"11fb703a-30ad-4167-aaa0-70937d89e131\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"9edae727-704b-495d-9355-463c81a8f882\",\"type\":\"Line\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"102c549d-1ec1-408b-91d5-26ae5503eb89\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"data_source\":{\"id\":\"4a3cb959-1fe1-4b46-8795-8746f534c96c\",\"type\":\"ColumnDataSource\"},\"glyph\":{\"id\":\"9edae727-704b-495d-9355-463c81a8f882\",\"type\":\"Line\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"f696a61e-ae4a-434c-af02-3d4cb5548893\",\"type\":\"Line\"},\"selection_glyph\":null},\"id\":\"bba9ef7c-5599-4c5e-a4ea-94afd68ea38c\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"formatter\":{\"id\":\"184c9867-a3dd-4625-86d4-a08ea1ed3798\",\"type\":\"DatetimeTickFormatter\"},\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"},\"ticker\":{\"id\":\"2374ca1e-3c7c-4fe8-9c9c-20ee81128166\",\"type\":\"BasicTicker\"}},\"id\":\"884ed175-a674-4548-b4fb-615dd9b6fb26\",\"type\":\"LinearAxis\"},{\"attributes\":{\"line_alpha\":{\"value\":0.1},\"line_color\":{\"value\":\"#1f77b4\"},\"x\":{\"field\":\"x\"},\"y\":{\"field\":\"y\"}},\"id\":\"f696a61e-ae4a-434c-af02-3d4cb5548893\",\"type\":\"Line\"},{\"attributes\":{\"callback\":null},\"id\":\"a767c73c-e178-466a-8f2c-8f79e38a5aff\",\"type\":\"DataRange1d\"},{\"attributes\":{\"days\":[\"%d %B %Y\"],\"hours\":[\"%d %B %Y\"],\"months\":[\"%d %B %Y\"],\"years\":[\"%d %B %Y\"]},\"id\":\"184c9867-a3dd-4625-86d4-a08ea1ed3798\",\"type\":\"DatetimeTickFormatter\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"a3cbf3f2-147f-4971-89b0-ba0fa967355d\",\"type\":\"SaveTool\"},{\"attributes\":{\"callback\":null,\"column_names\":[\"x\",\"y\"],\"data\":{\"x\":{\"__ndarray__\":\"AADAR+1vc0IAAACa53lzQgAAgIaPg3NCAADA2ImNc0IAAAArhJdzQgAAgBcsoXNCAADAaSarc0IAAEBWzrRzQgAAgKjIvnNCAADA+sLIc0IAAMAbxtFzQgAAAG7A23NCAACAWmjlc0IAAMCsYu9zQgAAQJkK+XNCAACA6wQDdEIAAMA9/wx0QgAAQCqnFnRCAACAfKEgdEIAAABpSSp0QgAAQLtDNHRCAACADT4+dEIAAIAuQUd0QgAAwIA7UXRCAABAbeNadEIAAIC/3WR0QgAAAKyFbnRCAABA/n94dEIAAIBQeoJ0QgAAAD0ijHRCAABAjxyWdEIAAMB7xJ90QgAAAM6+qXRCAABAILmzdEIAAEBBvLx0QgAAgJO2xnRCAAAAgF7QdEIAAEDSWNp0QgAAwL4A5HRCAAAAEfvtdEIAAEBj9fd0QgAAwE+dAXVCAAAAopcLdUIAAICOPxV1QgAAwOA5H3VCAAAAMzQpdUIAAMC5iTJ1QgAAAAyEPHVCAACA+CtGdUIAAMBKJlB1QgAAQDfOWXVCAACAichjdUIAAMDbwm11QgAAQMhqd3VCAACAGmWBdUIAAAAHDYt1QgAAQFkHlXVCAACAqwGfdUIAAIDMBKh1QgAAwB7/sXVCAABAC6e7dUIAAIBdocV1Qg==\",\"dtype\":\"float64\",\"shape\":[62]},\"y\":[1,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,2,0,0,2,0,0,0,2,1,0,0,0,0,0,0,1,0,0,1,3,3,2,0,0,0,0,0,0,2,1,1,4,2,3,3,2,8,13,10,17,7,6]}},\"id\":\"4a3cb959-1fe1-4b46-8795-8746f534c96c\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"plot\":{\"id\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\",\"subtype\":\"Figure\",\"type\":\"Plot\"}},\"id\":\"02d9e6fe-30b7-4348-8666-6cceb0bea276\",\"type\":\"PanTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":{\"value\":0.5},\"fill_color\":{\"value\":\"lightgrey\"},\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":{\"value\":1.0},\"line_color\":{\"value\":\"black\"},\"line_dash\":[4,4],\"line_width\":{\"value\":2},\"plot\":null,\"render_mode\":\"css\",\"right_units\":\"screen\",\"top_units\":\"screen\"},\"id\":\"ede791bb-461f-472d-b479-df5ae00743e2\",\"type\":\"BoxAnnotation\"}],\"root_ids\":[\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\"]},\"title\":\"Bokeh Application\",\"version\":\"0.12.5\"}};\n",
       "            var render_items = [{\"docid\":\"3c8104e4-4406-4a29-889b-d7b9708555c3\",\"elementid\":\"1c431052-7d52-49c4-8c4d-caab4725b21b\",\"modelid\":\"7db60a9f-08b4-49f2-93f6-c705b4fe8002\"}];\n",
       "            \n",
       "            Bokeh.embed.embed_items(docs_json, render_items);\n",
       "          };\n",
       "          if (document.readyState != \"loading\") fn();\n",
       "          else document.addEventListener(\"DOMContentLoaded\", fn);\n",
       "        })();\n",
       "      },\n",
       "      function(Bokeh) {\n",
       "      }\n",
       "    ];\n",
       "  \n",
       "    function run_inline_js() {\n",
       "      \n",
       "      if ((window.Bokeh !== undefined) || (force === true)) {\n",
       "        for (var i = 0; i < inline_js.length; i++) {\n",
       "          inline_js[i](window.Bokeh);\n",
       "        }if (force === true) {\n",
       "          display_loaded();\n",
       "        }} else if (Date.now() < window._bokeh_timeout) {\n",
       "        setTimeout(run_inline_js, 100);\n",
       "      } else if (!window._bokeh_failed_load) {\n",
       "        console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "        window._bokeh_failed_load = true;\n",
       "      } else if (force !== true) {\n",
       "        var cell = $(document.getElementById(\"1c431052-7d52-49c4-8c4d-caab4725b21b\")).parents('.cell').data().cell;\n",
       "        cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "      }\n",
       "  \n",
       "    }\n",
       "  \n",
       "    if (window._bokeh_is_loading === 0) {\n",
       "      console.log(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "      run_inline_js();\n",
       "    } else {\n",
       "      load_libs(js_urls, function() {\n",
       "        console.log(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "        run_inline_js();\n",
       "      });\n",
       "    }\n",
       "  }(this));\n",
       "</script>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "c = threads_df.resample(\"M\").count()\n",
    "p = figure()\n",
    "p.line(c.index, c[\"id\"])\n",
    "from bokeh.models import DatetimeTickFormatter\n",
    "p.xaxis.formatter=DatetimeTickFormatter(\n",
    "        hours=[\"%d %B %Y\"],\n",
    "        days=[\"%d %B %Y\"],\n",
    "        months=[\"%d %B %Y\"],\n",
    "        years=[\"%d %B %Y\"],\n",
    "    )\n",
    "show(p)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 热门帖子排行"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>last_time</th>\n",
       "      <th>view_num</th>\n",
       "      <th>reply_num</th>\n",
       "      <th>title</th>\n",
       "      <th>author_id</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>create_time</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2013-12-14 23:36:51+08:00</th>\n",
       "      <td>2432708455</td>\n",
       "      <td>2017-03-18 17:43:56</td>\n",
       "      <td>20057</td>\n",
       "      <td>2345</td>\n",
       "      <td>【刷】想要升级加速的速进。</td>\n",
       "      <td>678168683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-03-22 22:59:45+08:00</th>\n",
       "      <td>611883273</td>\n",
       "      <td>2017-04-06 12:07:26</td>\n",
       "      <td>2783</td>\n",
       "      <td>1003</td>\n",
       "      <td>大家都来写上自己班主任的名字，看看哪个老师的门生最多</td>\n",
       "      <td>96779394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013-12-25 17:01:35+08:00</th>\n",
       "      <td>420809696</td>\n",
       "      <td>2017-03-04 12:11:40</td>\n",
       "      <td>1738</td>\n",
       "      <td>557</td>\n",
       "      <td>程集老师大比拼~~~选出你心中的好老师！</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-30 22:12:06+08:00</th>\n",
       "      <td>3933617147</td>\n",
       "      <td>2017-03-16 10:21:38</td>\n",
       "      <td>3333</td>\n",
       "      <td>416</td>\n",
       "      <td>数学老师</td>\n",
       "      <td>1145202556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-06-15 05:11:03+08:00</th>\n",
       "      <td>3828474449</td>\n",
       "      <td>2017-03-22 02:18:43</td>\n",
       "      <td>1181</td>\n",
       "      <td>154</td>\n",
       "      <td>盘点那些非211的实力却超半数211工程的大学</td>\n",
       "      <td>1000551287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-25 05:46:04+08:00</th>\n",
       "      <td>3919584524</td>\n",
       "      <td>2017-04-06 12:06:01</td>\n",
       "      <td>945</td>\n",
       "      <td>123</td>\n",
       "      <td>2010届运动会【五年前的程集中学】</td>\n",
       "      <td>1167694342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-02 17:07:05+08:00</th>\n",
       "      <td>4017190359</td>\n",
       "      <td>2017-04-07 15:03:55</td>\n",
       "      <td>935</td>\n",
       "      <td>122</td>\n",
       "      <td>说说你最喜欢的歌词（诗词）</td>\n",
       "      <td>1189098715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-03-18 03:39:04+08:00</th>\n",
       "      <td>2432106502</td>\n",
       "      <td>2016-12-01 02:07:39</td>\n",
       "      <td>384</td>\n",
       "      <td>121</td>\n",
       "      <td>【吧规δ导航】请新老人同戳！</td>\n",
       "      <td>678168683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-07-13 00:11:44+08:00</th>\n",
       "      <td>3161858875</td>\n",
       "      <td>2017-01-31 07:57:49</td>\n",
       "      <td>911</td>\n",
       "      <td>116</td>\n",
       "      <td>输入#(pic,QQ号,600,600)</td>\n",
       "      <td>939241639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-03 04:17:53+08:00</th>\n",
       "      <td>4806839204</td>\n",
       "      <td>2017-01-15 11:32:50</td>\n",
       "      <td>849</td>\n",
       "      <td>115</td>\n",
       "      <td>我大十班的进来戳一个</td>\n",
       "      <td>1282788709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-11 23:57:07+08:00</th>\n",
       "      <td>3965531701</td>\n",
       "      <td>2017-01-31 09:13:20</td>\n",
       "      <td>811</td>\n",
       "      <td>105</td>\n",
       "      <td>学习雷锋，本人帮找各种电影资源，总有你需要的</td>\n",
       "      <td>979659057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-08-24 16:09:49+08:00</th>\n",
       "      <td>3253474623</td>\n",
       "      <td>2017-03-08 12:38:26</td>\n",
       "      <td>743</td>\n",
       "      <td>93</td>\n",
       "      <td>不怎么好的程集——一个14年毕业生的独白</td>\n",
       "      <td>975381369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-07-06 05:12:41+08:00</th>\n",
       "      <td>3874664499</td>\n",
       "      <td>2017-01-13 14:36:11</td>\n",
       "      <td>720</td>\n",
       "      <td>92</td>\n",
       "      <td>怎么比较程集中学和宿松中学</td>\n",
       "      <td>1732445244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-22 04:44:04+08:00</th>\n",
       "      <td>4498163220</td>\n",
       "      <td>2017-03-13 11:23:05</td>\n",
       "      <td>643</td>\n",
       "      <td>84</td>\n",
       "      <td>大学报考指南</td>\n",
       "      <td>2194407898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-05-30 01:00:37+08:00</th>\n",
       "      <td>522512814</td>\n",
       "      <td>2017-04-06 12:09:08</td>\n",
       "      <td>204</td>\n",
       "      <td>80</td>\n",
       "      <td>程集中学五十年校庆</td>\n",
       "      <td>42112741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-03-22 05:16:25+08:00</th>\n",
       "      <td>3651813745</td>\n",
       "      <td>2017-02-06 16:32:41</td>\n",
       "      <td>620</td>\n",
       "      <td>77</td>\n",
       "      <td>戳进来~快点戳进来！！！</td>\n",
       "      <td>1167694342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-11-28 00:53:40+08:00</th>\n",
       "      <td>4878824427</td>\n",
       "      <td>2017-05-10 06:08:02</td>\n",
       "      <td>568</td>\n",
       "      <td>77</td>\n",
       "      <td>2016年运动会</td>\n",
       "      <td>990261283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-22 08:30:04+08:00</th>\n",
       "      <td>5034421746</td>\n",
       "      <td>2017-04-29 09:25:59</td>\n",
       "      <td>533</td>\n",
       "      <td>76</td>\n",
       "      <td>程集中学江风老师个人画展</td>\n",
       "      <td>2020174157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-01 15:16:27+08:00</th>\n",
       "      <td>4644750692</td>\n",
       "      <td>2017-05-10 06:07:00</td>\n",
       "      <td>566</td>\n",
       "      <td>74</td>\n",
       "      <td>程集有哪些好班主任(理科)望师</td>\n",
       "      <td>1804472799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-27 16:16:36+08:00</th>\n",
       "      <td>4511068955</td>\n",
       "      <td>2017-03-04 16:05:19</td>\n",
       "      <td>464</td>\n",
       "      <td>58</td>\n",
       "      <td>程中会员记录贴</td>\n",
       "      <td>412759743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-09-05 13:37:21+08:00</th>\n",
       "      <td>4023423945</td>\n",
       "      <td>2017-05-06 06:59:52</td>\n",
       "      <td>455</td>\n",
       "      <td>54</td>\n",
       "      <td>程集中学校友报道帖！</td>\n",
       "      <td>645729153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-07-07 07:18:58+08:00</th>\n",
       "      <td>4656021068</td>\n",
       "      <td>2017-02-20 08:18:19</td>\n",
       "      <td>417</td>\n",
       "      <td>52</td>\n",
       "      <td>王雪峰</td>\n",
       "      <td>804557789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-27 07:21:54+08:00</th>\n",
       "      <td>4916492301</td>\n",
       "      <td>2017-04-06 12:10:52</td>\n",
       "      <td>374</td>\n",
       "      <td>49</td>\n",
       "      <td>地震后的程集</td>\n",
       "      <td>2419752079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-15 16:12:04+08:00</th>\n",
       "      <td>4941118843</td>\n",
       "      <td>2017-03-09 15:33:31</td>\n",
       "      <td>357</td>\n",
       "      <td>47</td>\n",
       "      <td>【故事贴】询问贴也是可以的</td>\n",
       "      <td>907946306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-11-22 16:14:33+08:00</th>\n",
       "      <td>4872529203</td>\n",
       "      <td>2017-03-01 03:11:45</td>\n",
       "      <td>361</td>\n",
       "      <td>46</td>\n",
       "      <td>三年程集</td>\n",
       "      <td>2743396768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-04-14 11:03:56+08:00</th>\n",
       "      <td>133110193</td>\n",
       "      <td>2017-02-23 21:58:44</td>\n",
       "      <td>202</td>\n",
       "      <td>45</td>\n",
       "      <td>程集中学的师弟师妹们，努力啊！不要落后宿松中学</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-08-15 14:24:14+08:00</th>\n",
       "      <td>3975003914</td>\n",
       "      <td>2017-04-07 15:02:47</td>\n",
       "      <td>384</td>\n",
       "      <td>43</td>\n",
       "      <td>不知道他在学校过的怎么样</td>\n",
       "      <td>1000551287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-05-15 15:35:05+08:00</th>\n",
       "      <td>4549477620</td>\n",
       "      <td>2017-05-08 07:17:47</td>\n",
       "      <td>345</td>\n",
       "      <td>40</td>\n",
       "      <td>兔走乌飞，几度夕阳。</td>\n",
       "      <td>1044545954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-20 11:22:55+08:00</th>\n",
       "      <td>4947448458</td>\n",
       "      <td>2017-02-08 15:48:17</td>\n",
       "      <td>305</td>\n",
       "      <td>39</td>\n",
       "      <td>强势回归</td>\n",
       "      <td>2020174157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-06-06 07:16:54+08:00</th>\n",
       "      <td>4594259280</td>\n",
       "      <td>2017-03-14 08:11:46</td>\n",
       "      <td>306</td>\n",
       "      <td>34</td>\n",
       "      <td>安徽大学，明智之选</td>\n",
       "      <td>883103909</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-27 13:53:58+08:00</th>\n",
       "      <td>4957653329</td>\n",
       "      <td>2017-01-29 12:41:52</td>\n",
       "      <td>122</td>\n",
       "      <td>7</td>\n",
       "      <td>【过年好】2016过去了，2017来了</td>\n",
       "      <td>2020174157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-03 06:52:40+08:00</th>\n",
       "      <td>4964647025</td>\n",
       "      <td>2017-04-02 06:30:59</td>\n",
       "      <td>121</td>\n",
       "      <td>7</td>\n",
       "      <td>借读</td>\n",
       "      <td>2643168930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-23 15:16:41+08:00</th>\n",
       "      <td>5036747599</td>\n",
       "      <td>2017-04-02 14:09:06</td>\n",
       "      <td>101</td>\n",
       "      <td>6</td>\n",
       "      <td>朱原野～朱原野</td>\n",
       "      <td>1748504112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-30 10:04:47+08:00</th>\n",
       "      <td>4920582196</td>\n",
       "      <td>2017-01-16 14:46:59</td>\n",
       "      <td>124</td>\n",
       "      <td>6</td>\n",
       "      <td>今晚是不是有元旦晚会？？</td>\n",
       "      <td>873136447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-03 06:58:50+08:00</th>\n",
       "      <td>5054039676</td>\n",
       "      <td>2017-04-03 18:07:20</td>\n",
       "      <td>96</td>\n",
       "      <td>6</td>\n",
       "      <td>咳咳 各位老板多多指教本帖子 谢谢</td>\n",
       "      <td>1250743971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-10 11:01:46+08:00</th>\n",
       "      <td>5016066279</td>\n",
       "      <td>2017-03-13 04:37:17</td>\n",
       "      <td>102</td>\n",
       "      <td>5</td>\n",
       "      <td>求学妹学弟的帮忙</td>\n",
       "      <td>954617219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-22 06:05:41+08:00</th>\n",
       "      <td>4950581839</td>\n",
       "      <td>2017-01-27 06:56:15</td>\n",
       "      <td>115</td>\n",
       "      <td>5</td>\n",
       "      <td>好久没水了，我竟然十级了</td>\n",
       "      <td>10382709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-01 03:51:20+08:00</th>\n",
       "      <td>5050633390</td>\n",
       "      <td>2017-04-01 14:25:26</td>\n",
       "      <td>89</td>\n",
       "      <td>4</td>\n",
       "      <td>程集中学今天放假吗</td>\n",
       "      <td>2962264011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-29 07:25:52+08:00</th>\n",
       "      <td>5045915730</td>\n",
       "      <td>2017-04-04 01:37:29</td>\n",
       "      <td>90</td>\n",
       "      <td>4</td>\n",
       "      <td>会考</td>\n",
       "      <td>1223010605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-02 10:54:46+08:00</th>\n",
       "      <td>5004616888</td>\n",
       "      <td>2017-03-04 11:34:57</td>\n",
       "      <td>100</td>\n",
       "      <td>4</td>\n",
       "      <td>伟大的班主任们（重点在后面）</td>\n",
       "      <td>2695393683</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-28 05:02:12+08:00</th>\n",
       "      <td>5043991568</td>\n",
       "      <td>2017-04-05 12:09:15</td>\n",
       "      <td>91</td>\n",
       "      <td>4</td>\n",
       "      <td>程集中学2017高三二模考试分数揭哓</td>\n",
       "      <td>2938987687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-08 17:21:34+08:00</th>\n",
       "      <td>5013532656</td>\n",
       "      <td>2017-04-04 16:11:55</td>\n",
       "      <td>98</td>\n",
       "      <td>4</td>\n",
       "      <td>程中的学子们，加油吧</td>\n",
       "      <td>1657235799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 06:18:43+08:00</th>\n",
       "      <td>5101024076</td>\n",
       "      <td>2017-05-07 15:25:36</td>\n",
       "      <td>61</td>\n",
       "      <td>4</td>\n",
       "      <td>求助 日本留学</td>\n",
       "      <td>2650557629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-01 10:53:39+08:00</th>\n",
       "      <td>4923148760</td>\n",
       "      <td>2017-01-15 11:28:30</td>\n",
       "      <td>115</td>\n",
       "      <td>4</td>\n",
       "      <td>#2016年最后一天#</td>\n",
       "      <td>2654215169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-15 07:50:42+08:00</th>\n",
       "      <td>5023239434</td>\n",
       "      <td>2017-04-17 12:43:23</td>\n",
       "      <td>96</td>\n",
       "      <td>4</td>\n",
       "      <td>有福州大学城的么</td>\n",
       "      <td>2131034825</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-30 07:34:21+08:00</th>\n",
       "      <td>5095700692</td>\n",
       "      <td>2017-05-01 07:58:40</td>\n",
       "      <td>63</td>\n",
       "      <td>3</td>\n",
       "      <td>各位学姐学长们，请问一下要考进程集中学要多少分？拜托告知。</td>\n",
       "      <td>3019933854</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 15:25:30+08:00</th>\n",
       "      <td>5101933105</td>\n",
       "      <td>2017-05-09 16:06:37</td>\n",
       "      <td>56</td>\n",
       "      <td>3</td>\n",
       "      <td>找人</td>\n",
       "      <td>1161408985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-17 06:36:02+08:00</th>\n",
       "      <td>5026229563</td>\n",
       "      <td>2017-03-18 02:50:06</td>\n",
       "      <td>88</td>\n",
       "      <td>2</td>\n",
       "      <td>安庆二模</td>\n",
       "      <td>811672168</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-03 06:54:35+08:00</th>\n",
       "      <td>4964649193</td>\n",
       "      <td>2017-02-06 13:15:02</td>\n",
       "      <td>100</td>\n",
       "      <td>2</td>\n",
       "      <td>程集</td>\n",
       "      <td>2643168930</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26 01:20:01+08:00</th>\n",
       "      <td>5089954317</td>\n",
       "      <td>2017-05-02 01:53:17</td>\n",
       "      <td>64</td>\n",
       "      <td>2</td>\n",
       "      <td>(*￣︶￣)一年一度高考季要来了，关于择校你造吗？</td>\n",
       "      <td>2474873955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-01 17:25:37+08:00</th>\n",
       "      <td>5003651024</td>\n",
       "      <td>2017-03-02 02:04:11</td>\n",
       "      <td>90</td>\n",
       "      <td>1</td>\n",
       "      <td>学弟学妹们能把16年录取榜拍照</td>\n",
       "      <td>1067350110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-22 16:27:30+08:00</th>\n",
       "      <td>5085329351</td>\n",
       "      <td>2017-04-24 08:02:11</td>\n",
       "      <td>65</td>\n",
       "      <td>1</td>\n",
       "      <td>为一个帅帅的学弟加油</td>\n",
       "      <td>903991487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-11 16:41:33+08:00</th>\n",
       "      <td>5017944261</td>\n",
       "      <td>2017-03-12 02:49:22</td>\n",
       "      <td>87</td>\n",
       "      <td>1</td>\n",
       "      <td>老人冒个泡</td>\n",
       "      <td>96779394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-11 08:44:17+08:00</th>\n",
       "      <td>4975962076</td>\n",
       "      <td>2017-02-11 14:17:20</td>\n",
       "      <td>95</td>\n",
       "      <td>1</td>\n",
       "      <td>程集中学，高一有开学考试吗？每个寒暑假后都有开学考试吗？</td>\n",
       "      <td>2393971476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-23 14:20:23+08:00</th>\n",
       "      <td>4994792590</td>\n",
       "      <td>2017-02-25 02:11:25</td>\n",
       "      <td>92</td>\n",
       "      <td>1</td>\n",
       "      <td>寻找石海强</td>\n",
       "      <td>2159723312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-10 10:20:37+08:00</th>\n",
       "      <td>5110118072</td>\n",
       "      <td>2017-05-10 12:06:31</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>长的丑就要多读书。</td>\n",
       "      <td>714103838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04 04:57:30+08:00</th>\n",
       "      <td>5100914721</td>\n",
       "      <td>2017-05-04 04:57:30</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>11年毕业的路过</td>\n",
       "      <td>1033333156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-15 13:58:56+08:00</th>\n",
       "      <td>4982353225</td>\n",
       "      <td>2017-02-15 13:58:56</td>\n",
       "      <td>92</td>\n",
       "      <td>0</td>\n",
       "      <td>有木有人有前几天高三第一次考试</td>\n",
       "      <td>1546803348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-04 09:02:45+08:00</th>\n",
       "      <td>5007235686</td>\n",
       "      <td>2017-03-09 07:01:13</td>\n",
       "      <td>87</td>\n",
       "      <td>0</td>\n",
       "      <td>求助大家了！</td>\n",
       "      <td>2465777061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-27 01:14:59+08:00</th>\n",
       "      <td>4999459814</td>\n",
       "      <td>2017-02-27 01:14:59</td>\n",
       "      <td>88</td>\n",
       "      <td>0</td>\n",
       "      <td>3月10-11号江南十校联考助考</td>\n",
       "      <td>2381178142</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>99 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   id           last_time view_num  reply_num  \\\n",
       "create_time                                                                     \n",
       "2013-12-14 23:36:51+08:00  2432708455 2017-03-18 17:43:56    20057       2345   \n",
       "2014-03-22 22:59:45+08:00   611883273 2017-04-06 12:07:26     2783       1003   \n",
       "2013-12-25 17:01:35+08:00   420809696 2017-03-04 12:11:40     1738        557   \n",
       "2015-07-30 22:12:06+08:00  3933617147 2017-03-16 10:21:38     3333        416   \n",
       "2015-06-15 05:11:03+08:00  3828474449 2017-03-22 02:18:43     1181        154   \n",
       "2015-07-25 05:46:04+08:00  3919584524 2017-04-06 12:06:01      945        123   \n",
       "2015-09-02 17:07:05+08:00  4017190359 2017-04-07 15:03:55      935        122   \n",
       "2014-03-18 03:39:04+08:00  2432106502 2016-12-01 02:07:39      384        121   \n",
       "2014-07-13 00:11:44+08:00  3161858875 2017-01-31 07:57:49      911        116   \n",
       "2016-10-03 04:17:53+08:00  4806839204 2017-01-15 11:32:50      849        115   \n",
       "2015-08-11 23:57:07+08:00  3965531701 2017-01-31 09:13:20      811        105   \n",
       "2014-08-24 16:09:49+08:00  3253474623 2017-03-08 12:38:26      743         93   \n",
       "2015-07-06 05:12:41+08:00  3874664499 2017-01-13 14:36:11      720         92   \n",
       "2016-04-22 04:44:04+08:00  4498163220 2017-03-13 11:23:05      643         84   \n",
       "2012-05-30 01:00:37+08:00   522512814 2017-04-06 12:09:08      204         80   \n",
       "2015-03-22 05:16:25+08:00  3651813745 2017-02-06 16:32:41      620         77   \n",
       "2016-11-28 00:53:40+08:00  4878824427 2017-05-10 06:08:02      568         77   \n",
       "2017-03-22 08:30:04+08:00  5034421746 2017-04-29 09:25:59      533         76   \n",
       "2016-07-01 15:16:27+08:00  4644750692 2017-05-10 06:07:00      566         74   \n",
       "2016-04-27 16:16:36+08:00  4511068955 2017-03-04 16:05:19      464         58   \n",
       "2015-09-05 13:37:21+08:00  4023423945 2017-05-06 06:59:52      455         54   \n",
       "2016-07-07 07:18:58+08:00  4656021068 2017-02-20 08:18:19      417         52   \n",
       "2016-12-27 07:21:54+08:00  4916492301 2017-04-06 12:10:52      374         49   \n",
       "2017-01-15 16:12:04+08:00  4941118843 2017-03-09 15:33:31      357         47   \n",
       "2016-11-22 16:14:33+08:00  4872529203 2017-03-01 03:11:45      361         46   \n",
       "2012-04-14 11:03:56+08:00   133110193 2017-02-23 21:58:44      202         45   \n",
       "2015-08-15 14:24:14+08:00  3975003914 2017-04-07 15:02:47      384         43   \n",
       "2016-05-15 15:35:05+08:00  4549477620 2017-05-08 07:17:47      345         40   \n",
       "2017-01-20 11:22:55+08:00  4947448458 2017-02-08 15:48:17      305         39   \n",
       "2016-06-06 07:16:54+08:00  4594259280 2017-03-14 08:11:46      306         34   \n",
       "...                               ...                 ...      ...        ...   \n",
       "2017-01-27 13:53:58+08:00  4957653329 2017-01-29 12:41:52      122          7   \n",
       "2017-02-03 06:52:40+08:00  4964647025 2017-04-02 06:30:59      121          7   \n",
       "2017-03-23 15:16:41+08:00  5036747599 2017-04-02 14:09:06      101          6   \n",
       "2016-12-30 10:04:47+08:00  4920582196 2017-01-16 14:46:59      124          6   \n",
       "2017-04-03 06:58:50+08:00  5054039676 2017-04-03 18:07:20       96          6   \n",
       "2017-03-10 11:01:46+08:00  5016066279 2017-03-13 04:37:17      102          5   \n",
       "2017-01-22 06:05:41+08:00  4950581839 2017-01-27 06:56:15      115          5   \n",
       "2017-04-01 03:51:20+08:00  5050633390 2017-04-01 14:25:26       89          4   \n",
       "2017-03-29 07:25:52+08:00  5045915730 2017-04-04 01:37:29       90          4   \n",
       "2017-03-02 10:54:46+08:00  5004616888 2017-03-04 11:34:57      100          4   \n",
       "2017-03-28 05:02:12+08:00  5043991568 2017-04-05 12:09:15       91          4   \n",
       "2017-03-08 17:21:34+08:00  5013532656 2017-04-04 16:11:55       98          4   \n",
       "2017-05-04 06:18:43+08:00  5101024076 2017-05-07 15:25:36       61          4   \n",
       "2017-01-01 10:53:39+08:00  4923148760 2017-01-15 11:28:30      115          4   \n",
       "2017-03-15 07:50:42+08:00  5023239434 2017-04-17 12:43:23       96          4   \n",
       "2017-04-30 07:34:21+08:00  5095700692 2017-05-01 07:58:40       63          3   \n",
       "2017-05-04 15:25:30+08:00  5101933105 2017-05-09 16:06:37       56          3   \n",
       "2017-03-17 06:36:02+08:00  5026229563 2017-03-18 02:50:06       88          2   \n",
       "2017-02-03 06:54:35+08:00  4964649193 2017-02-06 13:15:02      100          2   \n",
       "2017-04-26 01:20:01+08:00  5089954317 2017-05-02 01:53:17       64          2   \n",
       "2017-03-01 17:25:37+08:00  5003651024 2017-03-02 02:04:11       90          1   \n",
       "2017-04-22 16:27:30+08:00  5085329351 2017-04-24 08:02:11       65          1   \n",
       "2017-03-11 16:41:33+08:00  5017944261 2017-03-12 02:49:22       87          1   \n",
       "2017-02-11 08:44:17+08:00  4975962076 2017-02-11 14:17:20       95          1   \n",
       "2017-02-23 14:20:23+08:00  4994792590 2017-02-25 02:11:25       92          1   \n",
       "2017-05-10 10:20:37+08:00  5110118072 2017-05-10 12:06:31       21          1   \n",
       "2017-05-04 04:57:30+08:00  5100914721 2017-05-04 04:57:30       48          0   \n",
       "2017-02-15 13:58:56+08:00  4982353225 2017-02-15 13:58:56       92          0   \n",
       "2017-03-04 09:02:45+08:00  5007235686 2017-03-09 07:01:13       87          0   \n",
       "2017-02-27 01:14:59+08:00  4999459814 2017-02-27 01:14:59       88          0   \n",
       "\n",
       "                                                   title   author_id  \n",
       "create_time                                                           \n",
       "2013-12-14 23:36:51+08:00                  【刷】想要升级加速的速进。   678168683  \n",
       "2014-03-22 22:59:45+08:00     大家都来写上自己班主任的名字，看看哪个老师的门生最多    96779394  \n",
       "2013-12-25 17:01:35+08:00           程集老师大比拼~~~选出你心中的好老师！           0  \n",
       "2015-07-30 22:12:06+08:00                           数学老师  1145202556  \n",
       "2015-06-15 05:11:03+08:00        盘点那些非211的实力却超半数211工程的大学  1000551287  \n",
       "2015-07-25 05:46:04+08:00             2010届运动会【五年前的程集中学】  1167694342  \n",
       "2015-09-02 17:07:05+08:00                  说说你最喜欢的歌词（诗词）  1189098715  \n",
       "2014-03-18 03:39:04+08:00                 【吧规δ导航】请新老人同戳！   678168683  \n",
       "2014-07-13 00:11:44+08:00           输入#(pic,QQ号,600,600)   939241639  \n",
       "2016-10-03 04:17:53+08:00                     我大十班的进来戳一个  1282788709  \n",
       "2015-08-11 23:57:07+08:00         学习雷锋，本人帮找各种电影资源，总有你需要的   979659057  \n",
       "2014-08-24 16:09:49+08:00           不怎么好的程集——一个14年毕业生的独白   975381369  \n",
       "2015-07-06 05:12:41+08:00                  怎么比较程集中学和宿松中学  1732445244  \n",
       "2016-04-22 04:44:04+08:00                         大学报考指南  2194407898  \n",
       "2012-05-30 01:00:37+08:00                      程集中学五十年校庆    42112741  \n",
       "2015-03-22 05:16:25+08:00                   戳进来~快点戳进来！！！  1167694342  \n",
       "2016-11-28 00:53:40+08:00                       2016年运动会   990261283  \n",
       "2017-03-22 08:30:04+08:00                   程集中学江风老师个人画展  2020174157  \n",
       "2016-07-01 15:16:27+08:00                程集有哪些好班主任(理科)望师  1804472799  \n",
       "2016-04-27 16:16:36+08:00                        程中会员记录贴   412759743  \n",
       "2015-09-05 13:37:21+08:00                     程集中学校友报道帖！   645729153  \n",
       "2016-07-07 07:18:58+08:00                            王雪峰   804557789  \n",
       "2016-12-27 07:21:54+08:00                         地震后的程集  2419752079  \n",
       "2017-01-15 16:12:04+08:00                  【故事贴】询问贴也是可以的   907946306  \n",
       "2016-11-22 16:14:33+08:00                           三年程集  2743396768  \n",
       "2012-04-14 11:03:56+08:00        程集中学的师弟师妹们，努力啊！不要落后宿松中学           0  \n",
       "2015-08-15 14:24:14+08:00                   不知道他在学校过的怎么样  1000551287  \n",
       "2016-05-15 15:35:05+08:00                     兔走乌飞，几度夕阳。  1044545954  \n",
       "2017-01-20 11:22:55+08:00                           强势回归  2020174157  \n",
       "2016-06-06 07:16:54+08:00                      安徽大学，明智之选   883103909  \n",
       "...                                                  ...         ...  \n",
       "2017-01-27 13:53:58+08:00            【过年好】2016过去了，2017来了  2020174157  \n",
       "2017-02-03 06:52:40+08:00                             借读  2643168930  \n",
       "2017-03-23 15:16:41+08:00                        朱原野～朱原野  1748504112  \n",
       "2016-12-30 10:04:47+08:00                   今晚是不是有元旦晚会？？   873136447  \n",
       "2017-04-03 06:58:50+08:00              咳咳 各位老板多多指教本帖子 谢谢  1250743971  \n",
       "2017-03-10 11:01:46+08:00                       求学妹学弟的帮忙   954617219  \n",
       "2017-01-22 06:05:41+08:00                   好久没水了，我竟然十级了    10382709  \n",
       "2017-04-01 03:51:20+08:00                      程集中学今天放假吗  2962264011  \n",
       "2017-03-29 07:25:52+08:00                             会考  1223010605  \n",
       "2017-03-02 10:54:46+08:00                 伟大的班主任们（重点在后面）  2695393683  \n",
       "2017-03-28 05:02:12+08:00             程集中学2017高三二模考试分数揭哓  2938987687  \n",
       "2017-03-08 17:21:34+08:00                     程中的学子们，加油吧  1657235799  \n",
       "2017-05-04 06:18:43+08:00                        求助 日本留学  2650557629  \n",
       "2017-01-01 10:53:39+08:00                    #2016年最后一天#  2654215169  \n",
       "2017-03-15 07:50:42+08:00                       有福州大学城的么  2131034825  \n",
       "2017-04-30 07:34:21+08:00  各位学姐学长们，请问一下要考进程集中学要多少分？拜托告知。  3019933854  \n",
       "2017-05-04 15:25:30+08:00                             找人  1161408985  \n",
       "2017-03-17 06:36:02+08:00                           安庆二模   811672168  \n",
       "2017-02-03 06:54:35+08:00                             程集  2643168930  \n",
       "2017-04-26 01:20:01+08:00      (*￣︶￣)一年一度高考季要来了，关于择校你造吗？  2474873955  \n",
       "2017-03-01 17:25:37+08:00                学弟学妹们能把16年录取榜拍照  1067350110  \n",
       "2017-04-22 16:27:30+08:00                     为一个帅帅的学弟加油   903991487  \n",
       "2017-03-11 16:41:33+08:00                          老人冒个泡    96779394  \n",
       "2017-02-11 08:44:17+08:00   程集中学，高一有开学考试吗？每个寒暑假后都有开学考试吗？  2393971476  \n",
       "2017-02-23 14:20:23+08:00                          寻找石海强  2159723312  \n",
       "2017-05-10 10:20:37+08:00                      长的丑就要多读书。   714103838  \n",
       "2017-05-04 04:57:30+08:00                       11年毕业的路过  1033333156  \n",
       "2017-02-15 13:58:56+08:00                有木有人有前几天高三第一次考试  1546803348  \n",
       "2017-03-04 09:02:45+08:00                         求助大家了！  2465777061  \n",
       "2017-02-27 01:14:59+08:00               3月10-11号江南十校联考助考  2381178142  \n",
       "\n",
       "[99 rows x 6 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "threads_df.sort_values(by=\"reply_num\", ascending=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 活跃用户排行"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}