25_Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 数据分析\n",
    "分析人人都是PM文章"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# export\n",
    "from pymongo import MongoClient\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# export\n",
    "client = MongoClient('mongodb://127.0.0.1:27017')\n",
    "db = client.crawler\n",
    "art_coll = db.rrpm_articals"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(list(art_coll.find().limit(1000)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_all = pd.DataFrame(list(art_coll.find()))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "找到对应领域最有阅读价值的，以及这些文章的内在规律\n",
    "\n",
    "哪些内容更容易火，那先得需要一个火的指标，就是各个值的加权值\n",
    "预测一篇文章的各项指标\n",
    "\n",
    "就比如哪些标题，会有高views，需要综合发布时间，或者按每年划分\n",
    "或者按年分布，哪一年views最多，然后最多的tags是啥\n",
    "\n",
    "\n",
    "哪些内容会有高likes和stars\n",
    "\n",
    "\n",
    "\n",
    "什么样的文章容易火（浏览数，收藏数，喜欢数，互动数），相关的因素是什么？\n",
    "什么类型tag的文章容易火\n",
    "什么样的标题容易点击，views\n",
    "什么样的内容，容易like，star，以及评论\n",
    "\n",
    "找出最热文章，最热作者，平均每篇文章获赞最多，起标题最牛，分享呢？\n",
    "\n",
    "讨论的内容主要是和什么相关，高频词，各领域高频词\n",
    "\n",
    "https://pandas.pydata.org/docs/getting_started/index.html#getting-started"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 找出最火的文章"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_lite = df_all.filter(items=['title','publish_date','views','stars','likes','author_name','url'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>publish_date</th>\n",
       "      <th>views</th>\n",
       "      <th>stars</th>\n",
       "      <th>likes</th>\n",
       "      <th>author_name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>32649</td>\n",
       "      <td>绝密原型档案：看看专业产品经理的原型是什麽样</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2600000</td>\n",
       "      <td>2246</td>\n",
       "      <td>1902</td>\n",
       "      <td>GaraC</td>\n",
       "      <td>http://www.woshipm.com/rp/149653.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32671</td>\n",
       "      <td>Axure教程 axure新手入门基础（1）</td>\n",
       "      <td>2013-08-19</td>\n",
       "      <td>1900000</td>\n",
       "      <td>1533</td>\n",
       "      <td>847</td>\n",
       "      <td>Nairo</td>\n",
       "      <td>http://www.woshipm.com/rp/39203.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11172</td>\n",
       "      <td>丢掉“说明书”，用户喜欢容易上手的产品</td>\n",
       "      <td>2019-03-08</td>\n",
       "      <td>1200000</td>\n",
       "      <td>1011</td>\n",
       "      <td>51</td>\n",
       "      <td>小光蛋</td>\n",
       "      <td>http://www.woshipm.com/pd/2040605.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37719</td>\n",
       "      <td>未来5年，消费领域还会出现百亿美金的公司吗？</td>\n",
       "      <td>2019-03-08</td>\n",
       "      <td>1100000</td>\n",
       "      <td>529</td>\n",
       "      <td>74</td>\n",
       "      <td>李叫兽</td>\n",
       "      <td>http://www.woshipm.com/it/2041038.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5722</td>\n",
       "      <td>小白产品经理看产品：什么是互联网产品</td>\n",
       "      <td>2016-01-29</td>\n",
       "      <td>1000000</td>\n",
       "      <td>1187</td>\n",
       "      <td>56</td>\n",
       "      <td>华章图书</td>\n",
       "      <td>http://www.woshipm.com/pmd/277728.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8321</td>\n",
       "      <td>一个策划总监的自白：到底什么是策划？</td>\n",
       "      <td>2014-01-20</td>\n",
       "      <td>849000</td>\n",
       "      <td>376</td>\n",
       "      <td>899</td>\n",
       "      <td>师妹</td>\n",
       "      <td>http://www.woshipm.com/pmd/64236.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24354</td>\n",
       "      <td>推荐几个H5页面制作工具，自己选一下吧</td>\n",
       "      <td>2015-12-22</td>\n",
       "      <td>820000</td>\n",
       "      <td>1511</td>\n",
       "      <td>225</td>\n",
       "      <td>陈俊梁</td>\n",
       "      <td>http://www.woshipm.com/operate/249540.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18210</td>\n",
       "      <td>如何绘制业务流程图</td>\n",
       "      <td>2012-06-27</td>\n",
       "      <td>800000</td>\n",
       "      <td>1868</td>\n",
       "      <td>533</td>\n",
       "      <td>老曹</td>\n",
       "      <td>http://www.woshipm.com/pd/3795.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16683</td>\n",
       "      <td>【干货下载】Axure 元件库- 常用元素1056枚下载</td>\n",
       "      <td>2014-10-13</td>\n",
       "      <td>792000</td>\n",
       "      <td>305</td>\n",
       "      <td>525</td>\n",
       "      <td>人人都是产品经理</td>\n",
       "      <td>http://www.woshipm.com/pd/111131.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45232</td>\n",
       "      <td>产品经理岗位职责</td>\n",
       "      <td>2012-08-06</td>\n",
       "      <td>687000</td>\n",
       "      <td>555</td>\n",
       "      <td>705</td>\n",
       "      <td>老曹</td>\n",
       "      <td>http://www.woshipm.com/it/6054.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              title publish_date    views  stars  likes  \\\n",
       "32649        绝密原型档案：看看专业产品经理的原型是什麽样   2015-04-20  2600000   2246   1902   \n",
       "32671        Axure教程 axure新手入门基础（1）   2013-08-19  1900000   1533    847   \n",
       "11172           丢掉“说明书”，用户喜欢容易上手的产品   2019-03-08  1200000   1011     51   \n",
       "37719        未来5年，消费领域还会出现百亿美金的公司吗？   2019-03-08  1100000    529     74   \n",
       "5722             小白产品经理看产品：什么是互联网产品   2016-01-29  1000000   1187     56   \n",
       "8321             一个策划总监的自白：到底什么是策划？   2014-01-20   849000    376    899   \n",
       "24354           推荐几个H5页面制作工具，自己选一下吧   2015-12-22   820000   1511    225   \n",
       "18210                     如何绘制业务流程图   2012-06-27   800000   1868    533   \n",
       "16683  【干货下载】Axure 元件库- 常用元素1056枚下载   2014-10-13   792000    305    525   \n",
       "45232                      产品经理岗位职责   2012-08-06   687000    555    705   \n",
       "\n",
       "      author_name                                         url  \n",
       "32649       GaraC       http://www.woshipm.com/rp/149653.html  \n",
       "32671       Nairo        http://www.woshipm.com/rp/39203.html  \n",
       "11172         小光蛋      http://www.woshipm.com/pd/2040605.html  \n",
       "37719         李叫兽      http://www.woshipm.com/it/2041038.html  \n",
       "5722         华章图书      http://www.woshipm.com/pmd/277728.html  \n",
       "8321           师妹       http://www.woshipm.com/pmd/64236.html  \n",
       "24354         陈俊梁  http://www.woshipm.com/operate/249540.html  \n",
       "18210          老曹         http://www.woshipm.com/pd/3795.html  \n",
       "16683    人人都是产品经理       http://www.woshipm.com/pd/111131.html  \n",
       "45232          老曹         http://www.woshipm.com/it/6054.html  "
      ]
     },
     "execution_count": null,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_lite.sort_values(by='views',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>publish_date</th>\n",
       "      <th>views</th>\n",
       "      <th>stars</th>\n",
       "      <th>likes</th>\n",
       "      <th>author_name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>32656</td>\n",
       "      <td>Word产品需求文档，已经过时了</td>\n",
       "      <td>2015-09-29</td>\n",
       "      <td>518000</td>\n",
       "      <td>4464</td>\n",
       "      <td>2226</td>\n",
       "      <td>臻龙</td>\n",
       "      <td>http://www.woshipm.com/rp/211554.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54737</td>\n",
       "      <td>产品经理面试习题大汇总</td>\n",
       "      <td>2016-11-25</td>\n",
       "      <td>319000</td>\n",
       "      <td>3189</td>\n",
       "      <td>824</td>\n",
       "      <td>留言</td>\n",
       "      <td>http://www.woshipm.com/zhichang/459131.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33361</td>\n",
       "      <td>如何去做一份竞品分析报告</td>\n",
       "      <td>2016-02-18</td>\n",
       "      <td>392000</td>\n",
       "      <td>2953</td>\n",
       "      <td>381</td>\n",
       "      <td>梁嘉琪</td>\n",
       "      <td>http://www.woshipm.com/evaluating/283737.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13401</td>\n",
       "      <td>全面解读流程图｜附共享单车摩拜ofo案例分析</td>\n",
       "      <td>2017-10-18</td>\n",
       "      <td>301000</td>\n",
       "      <td>2897</td>\n",
       "      <td>867</td>\n",
       "      <td>臻龙</td>\n",
       "      <td>http://www.woshipm.com/pd/818876.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15282</td>\n",
       "      <td>在面试时候，如何简明扼要简述产品流程（附思维导图下载）</td>\n",
       "      <td>2016-04-06</td>\n",
       "      <td>65000</td>\n",
       "      <td>2724</td>\n",
       "      <td>356</td>\n",
       "      <td>Anne</td>\n",
       "      <td>http://www.woshipm.com/pd/313514.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34125</td>\n",
       "      <td>你会写报告？产品体验报告的思路应该是这样的！</td>\n",
       "      <td>2016-01-14</td>\n",
       "      <td>172000</td>\n",
       "      <td>2602</td>\n",
       "      <td>311</td>\n",
       "      <td>休言万事转头空</td>\n",
       "      <td>http://www.woshipm.com/evaluating/267888.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32649</td>\n",
       "      <td>绝密原型档案：看看专业产品经理的原型是什麽样</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2600000</td>\n",
       "      <td>2246</td>\n",
       "      <td>1902</td>\n",
       "      <td>GaraC</td>\n",
       "      <td>http://www.woshipm.com/rp/149653.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2311</td>\n",
       "      <td>结构化思考能力——产品经理的必备技能</td>\n",
       "      <td>2018-12-07</td>\n",
       "      <td>148000</td>\n",
       "      <td>2097</td>\n",
       "      <td>609</td>\n",
       "      <td>Chloe</td>\n",
       "      <td>http://www.woshipm.com/pmd/947740.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6079</td>\n",
       "      <td>三个步骤教你如何做好后台产品设计</td>\n",
       "      <td>2015-11-16</td>\n",
       "      <td>187000</td>\n",
       "      <td>2083</td>\n",
       "      <td>394</td>\n",
       "      <td>点融黑帮</td>\n",
       "      <td>http://www.woshipm.com/pmd/235272.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5919</td>\n",
       "      <td>干货流出｜腾讯内部几近满分的项目管理课程PPT</td>\n",
       "      <td>2015-12-26</td>\n",
       "      <td>107000</td>\n",
       "      <td>1957</td>\n",
       "      <td>151</td>\n",
       "      <td>米可</td>\n",
       "      <td>http://www.woshipm.com/pmd/256877.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                             title publish_date    views  stars  likes  \\\n",
       "32656             Word产品需求文档，已经过时了   2015-09-29   518000   4464   2226   \n",
       "54737                  产品经理面试习题大汇总   2016-11-25   319000   3189    824   \n",
       "33361                 如何去做一份竞品分析报告   2016-02-18   392000   2953    381   \n",
       "13401       全面解读流程图｜附共享单车摩拜ofo案例分析   2017-10-18   301000   2897    867   \n",
       "15282  在面试时候，如何简明扼要简述产品流程（附思维导图下载）   2016-04-06    65000   2724    356   \n",
       "34125       你会写报告？产品体验报告的思路应该是这样的！   2016-01-14   172000   2602    311   \n",
       "32649       绝密原型档案：看看专业产品经理的原型是什麽样   2015-04-20  2600000   2246   1902   \n",
       "2311            结构化思考能力——产品经理的必备技能   2018-12-07   148000   2097    609   \n",
       "6079              三个步骤教你如何做好后台产品设计   2015-11-16   187000   2083    394   \n",
       "5919       干货流出｜腾讯内部几近满分的项目管理课程PPT   2015-12-26   107000   1957    151   \n",
       "\n",
       "      author_name                                            url  \n",
       "32656          臻龙          http://www.woshipm.com/rp/211554.html  \n",
       "54737          留言    http://www.woshipm.com/zhichang/459131.html  \n",
       "33361         梁嘉琪  http://www.woshipm.com/evaluating/283737.html  \n",
       "13401          臻龙          http://www.woshipm.com/pd/818876.html  \n",
       "15282        Anne          http://www.woshipm.com/pd/313514.html  \n",
       "34125     休言万事转头空  http://www.woshipm.com/evaluating/267888.html  \n",
       "32649       GaraC          http://www.woshipm.com/rp/149653.html  \n",
       "2311        Chloe         http://www.woshipm.com/pmd/947740.html  \n",
       "6079         点融黑帮         http://www.woshipm.com/pmd/235272.html  \n",
       "5919           米可         http://www.woshipm.com/pmd/256877.html  "
      ]
     },
     "execution_count": null,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_lite.sort_values(by='stars',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>title</th>\n",
       "      <th>publish_date</th>\n",
       "      <th>views</th>\n",
       "      <th>stars</th>\n",
       "      <th>likes</th>\n",
       "      <th>author_name</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>32656</td>\n",
       "      <td>Word产品需求文档，已经过时了</td>\n",
       "      <td>2015-09-29</td>\n",
       "      <td>518000</td>\n",
       "      <td>4464</td>\n",
       "      <td>2226</td>\n",
       "      <td>臻龙</td>\n",
       "      <td>http://www.woshipm.com/rp/211554.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32649</td>\n",
       "      <td>绝密原型档案：看看专业产品经理的原型是什麽样</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2600000</td>\n",
       "      <td>2246</td>\n",
       "      <td>1902</td>\n",
       "      <td>GaraC</td>\n",
       "      <td>http://www.woshipm.com/rp/149653.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22007</td>\n",
       "      <td>交互设计初体验(iUED)</td>\n",
       "      <td>2014-11-24</td>\n",
       "      <td>11000</td>\n",
       "      <td>13</td>\n",
       "      <td>1406</td>\n",
       "      <td>朱帝</td>\n",
       "      <td>http://www.woshipm.com/ucd/121332.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7356</td>\n",
       "      <td>放大你的格局，你的人生将不可思议</td>\n",
       "      <td>2014-11-18</td>\n",
       "      <td>472000</td>\n",
       "      <td>61</td>\n",
       "      <td>1398</td>\n",
       "      <td>大城小蛙</td>\n",
       "      <td>http://www.woshipm.com/pmd/119538.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14480</td>\n",
       "      <td>支付风控系统设计：支付风控场景分析(一)</td>\n",
       "      <td>2016-12-12</td>\n",
       "      <td>66000</td>\n",
       "      <td>247</td>\n",
       "      <td>1011</td>\n",
       "      <td>凤凰牌老熊</td>\n",
       "      <td>http://www.woshipm.com/pd/502457.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16189</td>\n",
       "      <td>【干货】H5页面制作免费工具大集合</td>\n",
       "      <td>2015-05-26</td>\n",
       "      <td>532000</td>\n",
       "      <td>977</td>\n",
       "      <td>914</td>\n",
       "      <td>盼盼姐</td>\n",
       "      <td>http://www.woshipm.com/pd/156698.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8321</td>\n",
       "      <td>一个策划总监的自白：到底什么是策划？</td>\n",
       "      <td>2014-01-20</td>\n",
       "      <td>849000</td>\n",
       "      <td>376</td>\n",
       "      <td>899</td>\n",
       "      <td>师妹</td>\n",
       "      <td>http://www.woshipm.com/pmd/64236.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13401</td>\n",
       "      <td>全面解读流程图｜附共享单车摩拜ofo案例分析</td>\n",
       "      <td>2017-10-18</td>\n",
       "      <td>301000</td>\n",
       "      <td>2897</td>\n",
       "      <td>867</td>\n",
       "      <td>臻龙</td>\n",
       "      <td>http://www.woshipm.com/pd/818876.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32671</td>\n",
       "      <td>Axure教程 axure新手入门基础（1）</td>\n",
       "      <td>2013-08-19</td>\n",
       "      <td>1900000</td>\n",
       "      <td>1533</td>\n",
       "      <td>847</td>\n",
       "      <td>Nairo</td>\n",
       "      <td>http://www.woshipm.com/rp/39203.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54737</td>\n",
       "      <td>产品经理面试习题大汇总</td>\n",
       "      <td>2016-11-25</td>\n",
       "      <td>319000</td>\n",
       "      <td>3189</td>\n",
       "      <td>824</td>\n",
       "      <td>留言</td>\n",
       "      <td>http://www.woshipm.com/zhichang/459131.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        title publish_date    views  stars  likes author_name  \\\n",
       "32656        Word产品需求文档，已经过时了   2015-09-29   518000   4464   2226          臻龙   \n",
       "32649  绝密原型档案：看看专业产品经理的原型是什麽样   2015-04-20  2600000   2246   1902       GaraC   \n",
       "22007           交互设计初体验(iUED)   2014-11-24    11000     13   1406          朱帝   \n",
       "7356         放大你的格局，你的人生将不可思议   2014-11-18   472000     61   1398        大城小蛙   \n",
       "14480    支付风控系统设计：支付风控场景分析(一)   2016-12-12    66000    247   1011       凤凰牌老熊   \n",
       "16189       【干货】H5页面制作免费工具大集合   2015-05-26   532000    977    914         盼盼姐   \n",
       "8321       一个策划总监的自白：到底什么是策划？   2014-01-20   849000    376    899          师妹   \n",
       "13401  全面解读流程图｜附共享单车摩拜ofo案例分析   2017-10-18   301000   2897    867          臻龙   \n",
       "32671  Axure教程 axure新手入门基础（1）   2013-08-19  1900000   1533    847       Nairo   \n",
       "54737             产品经理面试习题大汇总   2016-11-25   319000   3189    824          留言   \n",
       "\n",
       "                                               url  \n",
       "32656        http://www.woshipm.com/rp/211554.html  \n",
       "32649        http://www.woshipm.com/rp/149653.html  \n",
       "22007       http://www.woshipm.com/ucd/121332.html  \n",
       "7356        http://www.woshipm.com/pmd/119538.html  \n",
       "14480        http://www.woshipm.com/pd/502457.html  \n",
       "16189        http://www.woshipm.com/pd/156698.html  \n",
       "8321         http://www.woshipm.com/pmd/64236.html  \n",
       "13401        http://www.woshipm.com/pd/818876.html  \n",
       "32671         http://www.woshipm.com/rp/39203.html  \n",
       "54737  http://www.woshipm.com/zhichang/459131.html  "
      ]
     },
     "execution_count": null,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_lite.sort_values(by='likes',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>views</th>\n",
       "      <th>stars</th>\n",
       "      <th>likes</th>\n",
       "      <th>count</th>\n",
       "      <th>views_per_artical</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>author_name</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",
       "      <td>jameson</td>\n",
       "      <td>3535159</td>\n",
       "      <td>7106</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>7106.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>螳螂财经</td>\n",
       "      <td>3543179</td>\n",
       "      <td>6650</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6650.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Kriston AI</td>\n",
       "      <td>3363847</td>\n",
       "      <td>5551</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>5551.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Rolia</td>\n",
       "      <td>3386622</td>\n",
       "      <td>4894</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4894.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>王撼宇</td>\n",
       "      <td>3525236</td>\n",
       "      <td>3532</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3532.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>Fanesa</td>\n",
       "      <td>3458037</td>\n",
       "      <td>3061</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3061.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>饭大官人</td>\n",
       "      <td>3518615</td>\n",
       "      <td>2261</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2261.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>董楼主</td>\n",
       "      <td>3588001</td>\n",
       "      <td>1325</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1325.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>小谭同学</td>\n",
       "      <td>3610696</td>\n",
       "      <td>1248</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1248.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>是个数据人</td>\n",
       "      <td>3556272</td>\n",
       "      <td>523</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>523.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 _id  views  stars  likes  count  views_per_artical\n",
       "author_name                                                        \n",
       "jameson      3535159   7106      6      0      1             7106.0\n",
       "螳螂财经         3543179   6650      5      1      1             6650.0\n",
       "Kriston AI   3363847   5551      2      2      1             5551.0\n",
       "Rolia        3386622   4894      9      1      1             4894.0\n",
       "王撼宇          3525236   3532      8      3      1             3532.0\n",
       "Fanesa       3458037   3061      4      0      1             3061.0\n",
       "饭大官人         3518615   2261      2      0      1             2261.0\n",
       "董楼主          3588001   1325      2      1      1             1325.0\n",
       "小谭同学         3610696   1248      2      0      1             1248.0\n",
       "是个数据人        3556272    523      8      1      1              523.0"
      ]
     },
     "execution_count": null,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "author_df = df.groupby('author_name').sum()\n",
    "\n",
    "author_df['count'] = df.groupby('author_name').count()._id\n",
    "\n",
    "author_df['views_per_artical'] = author_df['views']/author_df['count']\n",
    "\n",
    "author_df = author_df.sort_values(by='views_per_artical',ascending=False)\n",
    "\n",
    "author_df.count()\n",
    "\n",
    "author_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}