Evaluate.ipynb

{
 "metadata": {
  "name": ""
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import numpy as np\n",
      "from blist import sortedset\n",
      "from pyjudy import JudyLIntObj\n",
      "\n",
      "col_name = {0 : 'user_id', 1 : 'brand_id'}\n",
      "predict_df = pd.read_csv(\"data/season1/recommend.direct.txt\", header=None, delim_whitespace=True, encoding=\"gbk\").rename(columns=col_name)\n",
      "test_df = pd.read_csv(\"data/season1/test.csv\", encoding=\"gbk\")\n",
      "buy_df = test_df[test_df.type == 1]\n",
      "\n",
      "# \u9884\u6d4b\u96c6\u4e0e\u6d4b\u8bd5\u96c6\u4e2d\u7684\u7528\u6237\n",
      "predict_users = predict_df.user_id.unique()\n",
      "test_users = buy_df.user_id.unique()\n",
      "\n",
      "# \u9884\u6d4b\u96c6\u4e0e\u6d4b\u8bd5\u96c6\u4e2d\u7684\u7528\u6237\u8d2d\u4e70\u7269\u54c1\u5217\u8868\n",
      "predict_map = JudyLIntObj()\n",
      "test_map = JudyLIntObj()\n",
      "\n",
      "# \u9884\u6d4b\u96c6\u6309UID\u5206\u7ec4\n",
      "predict_df['brand_id'] = predict_df['brand_id'].astype(str)\n",
      "predict_gb = predict_df.groupby('user_id')\n",
      "for key, group in predict_gb:\n",
      "    user_id = int(key)\n",
      "    brand_ids = []\n",
      "    # \u628a\u5b57\u7b26\u4e32\u8f6c\u6362\u6210\u6574\u578b\u5217\u8868\n",
      "    for b_index in group.index:\n",
      "        brand_ids.extend([int(x.strip(' ')) for x in group.ix[b_index]['brand_id'].split(',')])\n",
      "    u_map = predict_map.get(user_id)\n",
      "    \n",
      "    # \u5b58\u653e\u7269\u54c1\u5217\u8868\n",
      "    try:\n",
      "        predict_map[user_id].update(sortedset(brand_ids))\n",
      "    except KeyError:\n",
      "        predict_map[user_id] = sortedset(brand_ids)\n",
      "\n",
      "# \u6d4b\u8bd5\u96c6\u6309UID\u5206\u7ec4\n",
      "test_gb = buy_df.groupby('user_id')\n",
      "for key, group in test_gb:\n",
      "    user_id = int(key)\n",
      "    brand_ids = []\n",
      "    # \u628a\u5b57\u7b26\u4e32\u8f6c\u6362\u6210\u6574\u578b\u5217\u8868\n",
      "    for b_index in group.index:\n",
      "        brand_ids.append(group.ix[b_index]['brand_id'])\n",
      "    u_map = test_map.get(user_id)\n",
      "    \n",
      "    # \u5b58\u653e\u7269\u54c1\u5217\u8868\n",
      "    if not u_map:\n",
      "        test_map[user_id] = sortedset(brand_ids)\n",
      "    else:\n",
      "        u_map.update(sortedset(brand_ids))\n",
      "\n",
      "# \u9884\u6d4b\u96c6\u4e0e\u6d4b\u8bd5\u96c6\u6709\u4e0d\u76f8\u4ea4\u7684\u7528\u6237\u4ee5\u7a7a\u5217\u8868\u5f62\u5f0f\u5b58\u653e\n",
      "for uid in sortedset(predict_map.keys()).difference(sortedset(test_map.keys())):\n",
      "    test_map[uid] = sortedset([])\n",
      "\n",
      "for uid in sortedset(test_map.keys()).difference(sortedset(predict_map.keys())):\n",
      "    predict_map[uid] = sortedset([])\n",
      "\n",
      "# \u51c6\u786e\u7387\n",
      "p_hit_brands = sum([len(predict_map[int(user_id)].intersection(test_map[int(user_id)])) for user_id in predict_users])\n",
      "p_brands = sum([len(predict_map[int(user_id)]) for user_id in test_users])\n",
      "precision = p_hit_brands / p_brands\n",
      "\n",
      "# \u53ec\u56de\u7387\n",
      "r_hit_brands = sum([len(predict_map[int(user_id)].intersection(test_map[int(user_id)])) for user_id in test_users])\n",
      "r_brands = sum([len(test_map[int(user_id)]) for user_id in test_users])\n",
      "recall = r_hit_brands / r_brands\n",
      "\n",
      "score = (2 * precision * recall) / (precision + recall)\n",
      "\n",
      "print \"\u51c6\u786e\u7387: %f\\n\u53ec\u56de\u7387: %f\\n\u603b\u5f97\u5206: %f\" % (precision, recall, score)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "\u51c6\u786e\u7387: 0.000000\n",
        "\u53ec\u56de\u7387: 0.000000\n",
        "\u603b\u5f97\u5206: 0.000000\n"
       ]
      }
     ],
     "prompt_number": 55
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# \u6a21\u578b\u6bd4\u8f83"
     ],
     "language": "python",
     "metadata": {},
     "outputs": []
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "predict_df[predict_df.user_id == 3963750]['brand_id']"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 56,
       "text": [
        "230    4949,18730,23662,251,18075,21067,19421,16818\n",
        "Name: brand_id, dtype: object"
       ]
      }
     ],
     "prompt_number": 56
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "test_df[test_df.type == 1]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>user_id</th>\n",
        "      <th>brand_id</th>\n",
        "      <th>type</th>\n",
        "      <th>visit_datetime</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>221 </th>\n",
        "      <td>  5780000</td>\n",
        "      <td>  1000</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>267 </th>\n",
        "      <td>  8170750</td>\n",
        "      <td>  1966</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>318 </th>\n",
        "      <td> 12015000</td>\n",
        "      <td> 26900</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>343 </th>\n",
        "      <td> 12015000</td>\n",
        "      <td> 15138</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>363 </th>\n",
        "      <td>  1971500</td>\n",
        "      <td>  8316</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>387 </th>\n",
        "      <td>  3963750</td>\n",
        "      <td>  4949</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>392 </th>\n",
        "      <td>  3963750</td>\n",
        "      <td>  4949</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>395 </th>\n",
        "      <td>  3963750</td>\n",
        "      <td>  4949</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>397 </th>\n",
        "      <td>  3963750</td>\n",
        "      <td>  4949</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>399 </th>\n",
        "      <td>  3963750</td>\n",
        "      <td>  4949</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>429 </th>\n",
        "      <td>   434750</td>\n",
        "      <td> 19394</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>430 </th>\n",
        "      <td>   434750</td>\n",
        "      <td> 19394</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>448 </th>\n",
        "      <td>  5254500</td>\n",
        "      <td> 21672</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>451 </th>\n",
        "      <td>  5254500</td>\n",
        "      <td> 25488</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>533 </th>\n",
        "      <td>  7703750</td>\n",
        "      <td> 18075</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>568 </th>\n",
        "      <td>  8149250</td>\n",
        "      <td> 11679</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>708 </th>\n",
        "      <td>  8757750</td>\n",
        "      <td> 26288</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>752 </th>\n",
        "      <td>  9288000</td>\n",
        "      <td> 11328</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>770 </th>\n",
        "      <td> 11391250</td>\n",
        "      <td> 28924</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>771 </th>\n",
        "      <td> 11391250</td>\n",
        "      <td> 28924</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>773 </th>\n",
        "      <td> 11391250</td>\n",
        "      <td> 28924</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>775 </th>\n",
        "      <td> 11391250</td>\n",
        "      <td> 28924</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>776 </th>\n",
        "      <td> 11391250</td>\n",
        "      <td> 28924</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>797 </th>\n",
        "      <td>  1661750</td>\n",
        "      <td>  3324</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>801 </th>\n",
        "      <td>  1661750</td>\n",
        "      <td>  1731</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>809 </th>\n",
        "      <td>  1661750</td>\n",
        "      <td> 22342</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>832 </th>\n",
        "      <td>  1832000</td>\n",
        "      <td> 10916</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>852 </th>\n",
        "      <td>  1832000</td>\n",
        "      <td> 25687</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>854 </th>\n",
        "      <td>  1832000</td>\n",
        "      <td> 25687</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>879 </th>\n",
        "      <td>  2771250</td>\n",
        "      <td>   476</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1031</th>\n",
        "      <td>  6257000</td>\n",
        "      <td> 23563</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1035</th>\n",
        "      <td>  6257000</td>\n",
        "      <td> 23563</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1037</th>\n",
        "      <td>  6257000</td>\n",
        "      <td> 21071</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1041</th>\n",
        "      <td>  6257000</td>\n",
        "      <td> 23628</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1089</th>\n",
        "      <td> 12008000</td>\n",
        "      <td> 24274</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1097</th>\n",
        "      <td> 12008000</td>\n",
        "      <td> 17647</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1182</th>\n",
        "      <td>  4770500</td>\n",
        "      <td>  2610</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1240</th>\n",
        "      <td>  8102000</td>\n",
        "      <td>   768</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1241</th>\n",
        "      <td>  8102000</td>\n",
        "      <td>   768</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1255</th>\n",
        "      <td>  9035750</td>\n",
        "      <td> 17977</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1256</th>\n",
        "      <td>  9035750</td>\n",
        "      <td> 17977</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1285</th>\n",
        "      <td> 11046750</td>\n",
        "      <td>  7169</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1299</th>\n",
        "      <td>  1904750</td>\n",
        "      <td>  9138</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1334</th>\n",
        "      <td>  1909250</td>\n",
        "      <td> 20516</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1336</th>\n",
        "      <td>  1909250</td>\n",
        "      <td> 20516</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1369</th>\n",
        "      <td>  1909250</td>\n",
        "      <td>  6326</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1375</th>\n",
        "      <td>  1909250</td>\n",
        "      <td>  6326</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1399</th>\n",
        "      <td>  1909250</td>\n",
        "      <td>   504</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1583</th>\n",
        "      <td>  4215750</td>\n",
        "      <td> 21085</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1784</th>\n",
        "      <td>  8040000</td>\n",
        "      <td> 11018</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1868</th>\n",
        "      <td> 10095000</td>\n",
        "      <td> 16624</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1922</th>\n",
        "      <td>  5898500</td>\n",
        "      <td>  7105</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1935</th>\n",
        "      <td>  7367000</td>\n",
        "      <td> 21336</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1937</th>\n",
        "      <td>  7367000</td>\n",
        "      <td> 21336</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1948</th>\n",
        "      <td>  7367000</td>\n",
        "      <td> 20297</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1952</th>\n",
        "      <td>  7687500</td>\n",
        "      <td>   619</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1956</th>\n",
        "      <td>  7687500</td>\n",
        "      <td> 12182</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1959</th>\n",
        "      <td>  7687500</td>\n",
        "      <td> 16453</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1964</th>\n",
        "      <td>  7687500</td>\n",
        "      <td> 14603</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2004</th>\n",
        "      <td> 10064500</td>\n",
        "      <td> 29099</td>\n",
        "      <td> 1</td>\n",
        "      <td> 8\u67081\u65e5</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th></th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>970 rows \u00d7 4 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 57,
       "text": [
        "       user_id  brand_id  type visit_datetime\n",
        "221    5780000      1000     1           8\u67081\u65e5\n",
        "267    8170750      1966     1           8\u67081\u65e5\n",
        "318   12015000     26900     1           8\u67081\u65e5\n",
        "343   12015000     15138     1           8\u67081\u65e5\n",
        "363    1971500      8316     1           8\u67081\u65e5\n",
        "387    3963750      4949     1           8\u67081\u65e5\n",
        "392    3963750      4949     1           8\u67081\u65e5\n",
        "395    3963750      4949     1           8\u67081\u65e5\n",
        "397    3963750      4949     1           8\u67081\u65e5\n",
        "399    3963750      4949     1           8\u67081\u65e5\n",
        "429     434750     19394     1           8\u67081\u65e5\n",
        "430     434750     19394     1           8\u67081\u65e5\n",
        "448    5254500     21672     1           8\u67081\u65e5\n",
        "451    5254500     25488     1           8\u67081\u65e5\n",
        "533    7703750     18075     1           8\u67081\u65e5\n",
        "568    8149250     11679     1           8\u67081\u65e5\n",
        "708    8757750     26288     1           8\u67081\u65e5\n",
        "752    9288000     11328     1           8\u67081\u65e5\n",
        "770   11391250     28924     1           8\u67081\u65e5\n",
        "771   11391250     28924     1           8\u67081\u65e5\n",
        "773   11391250     28924     1           8\u67081\u65e5\n",
        "775   11391250     28924     1           8\u67081\u65e5\n",
        "776   11391250     28924     1           8\u67081\u65e5\n",
        "797    1661750      3324     1           8\u67081\u65e5\n",
        "801    1661750      1731     1           8\u67081\u65e5\n",
        "809    1661750     22342     1           8\u67081\u65e5\n",
        "832    1832000     10916     1           8\u67081\u65e5\n",
        "852    1832000     25687     1           8\u67081\u65e5\n",
        "854    1832000     25687     1           8\u67081\u65e5\n",
        "879    2771250       476     1           8\u67081\u65e5\n",
        "1031   6257000     23563     1           8\u67081\u65e5\n",
        "1035   6257000     23563     1           8\u67081\u65e5\n",
        "1037   6257000     21071     1           8\u67081\u65e5\n",
        "1041   6257000     23628     1           8\u67081\u65e5\n",
        "1089  12008000     24274     1           8\u67081\u65e5\n",
        "1097  12008000     17647     1           8\u67081\u65e5\n",
        "1182   4770500      2610     1           8\u67081\u65e5\n",
        "1240   8102000       768     1           8\u67081\u65e5\n",
        "1241   8102000       768     1           8\u67081\u65e5\n",
        "1255   9035750     17977     1           8\u67081\u65e5\n",
        "1256   9035750     17977     1           8\u67081\u65e5\n",
        "1285  11046750      7169     1           8\u67081\u65e5\n",
        "1299   1904750      9138     1           8\u67081\u65e5\n",
        "1334   1909250     20516     1           8\u67081\u65e5\n",
        "1336   1909250     20516     1           8\u67081\u65e5\n",
        "1369   1909250      6326     1           8\u67081\u65e5\n",
        "1375   1909250      6326     1           8\u67081\u65e5\n",
        "1399   1909250       504     1           8\u67081\u65e5\n",
        "1583   4215750     21085     1           8\u67081\u65e5\n",
        "1784   8040000     11018     1           8\u67081\u65e5\n",
        "1868  10095000     16624     1           8\u67081\u65e5\n",
        "1922   5898500      7105     1           8\u67081\u65e5\n",
        "1935   7367000     21336     1           8\u67081\u65e5\n",
        "1937   7367000     21336     1           8\u67081\u65e5\n",
        "1948   7367000     20297     1           8\u67081\u65e5\n",
        "1952   7687500       619     1           8\u67081\u65e5\n",
        "1956   7687500     12182     1           8\u67081\u65e5\n",
        "1959   7687500     16453     1           8\u67081\u65e5\n",
        "1964   7687500     14603     1           8\u67081\u65e5\n",
        "2004  10064500     29099     1           8\u67081\u65e5\n",
        "           ...       ...   ...            ...\n",
        "\n",
        "[970 rows x 4 columns]"
       ]
      }
     ],
     "prompt_number": 57
    }
   ],
   "metadata": {}
  }
 ]
}