10.1 多元回归模型 房产估价模型.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "903f1cfe",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "35200ea8",
   "metadata": {},
   "source": [
    "# 数据处理"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c60f7730",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_list = []\n",
    "for i in range(1,8):\n",
    "    try:\n",
    "        data = pd.read_csv('./dataset/lianjia{}.csv'.format(i), encoding='gbk')\n",
    "    except:\n",
    "        data = pd.read_csv('./dataset/lianjia{}.csv'.format(i))\n",
    "    finally:\n",
    "        data_list.append(data)\n",
    "data = pd.concat(data_list)\n",
    "data = data.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "488a5b15",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[data.cjshijian.str.contains('2015-')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f031bd30",
   "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>cjtaoshu</th>\n",
       "      <th>mendian</th>\n",
       "      <th>cjzongjia</th>\n",
       "      <th>zhiwei</th>\n",
       "      <th>haoping</th>\n",
       "      <th>cjdanjia</th>\n",
       "      <th>cjxiaoqu</th>\n",
       "      <th>xingming</th>\n",
       "      <th>cjzhouqi</th>\n",
       "      <th>biaoqian</th>\n",
       "      <th>cjlouceng</th>\n",
       "      <th>cjshijian</th>\n",
       "      <th>congyenianxian</th>\n",
       "      <th>bankuai</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>37</td>\n",
       "      <td>红莲北里店</td>\n",
       "      <td>251.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 141</td>\n",
       "      <td>43997元/平</td>\n",
       "      <td>红莲北里 3室1厅 57平</td>\n",
       "      <td>郭海龙</td>\n",
       "      <td>36</td>\n",
       "      <td>房东信赖;销售达人;带看活跃</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>签约时间：2015-05-24</td>\n",
       "      <td>4-5年</td>\n",
       "      <td>马连道</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>37</td>\n",
       "      <td>红莲北里店</td>\n",
       "      <td>159.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 141</td>\n",
       "      <td>36969元/平</td>\n",
       "      <td>红莲南里 1室1厅 43平</td>\n",
       "      <td>郭海龙</td>\n",
       "      <td>36</td>\n",
       "      <td>房东信赖;销售达人;带看活跃</td>\n",
       "      <td>南/高楼层/7层</td>\n",
       "      <td>签约时间：2015-05-10</td>\n",
       "      <td>4-5年</td>\n",
       "      <td>马连道</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37</td>\n",
       "      <td>红莲北里店</td>\n",
       "      <td>257.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 141</td>\n",
       "      <td>39046元/平</td>\n",
       "      <td>常青藤嘉园 1室1厅 65平</td>\n",
       "      <td>郭海龙</td>\n",
       "      <td>36</td>\n",
       "      <td>房东信赖;销售达人;带看活跃</td>\n",
       "      <td>北/低楼层/16层</td>\n",
       "      <td>签约时间：2015-04-26</td>\n",
       "      <td>4-5年</td>\n",
       "      <td>马连道</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>37</td>\n",
       "      <td>红莲北里店</td>\n",
       "      <td>243.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 141</td>\n",
       "      <td>41313元/平</td>\n",
       "      <td>红莲北里 2室1厅 58平</td>\n",
       "      <td>郭海龙</td>\n",
       "      <td>36</td>\n",
       "      <td>房东信赖;销售达人;带看活跃</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>签约时间：2015-04-04</td>\n",
       "      <td>4-5年</td>\n",
       "      <td>马连道</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>37</td>\n",
       "      <td>红莲北里店</td>\n",
       "      <td>372.5</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 141</td>\n",
       "      <td>42053元/平</td>\n",
       "      <td>广安门外大街 3室1厅 88平</td>\n",
       "      <td>郭海龙</td>\n",
       "      <td>36</td>\n",
       "      <td>房东信赖;销售达人;带看活跃</td>\n",
       "      <td>东 南 西 北/中楼层/18层</td>\n",
       "      <td>签约时间：2015-04-01</td>\n",
       "      <td>4-5年</td>\n",
       "      <td>马连道</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cjtaoshu mendian  cjzongjia zhiwei  haoping  cjdanjia         cjxiaoqu  \\\n",
       "0        37   红莲北里店      251.0    店经理  97% 141  43997元/平    红莲北里 3室1厅 57平   \n",
       "1        37   红莲北里店      159.0    店经理  97% 141  36969元/平    红莲南里 1室1厅 43平   \n",
       "2        37   红莲北里店      257.0    店经理  97% 141  39046元/平   常青藤嘉园 1室1厅 65平   \n",
       "3        37   红莲北里店      243.0    店经理  97% 141  41313元/平    红莲北里 2室1厅 58平   \n",
       "4        37   红莲北里店      372.5    店经理  97% 141  42053元/平  广安门外大街 3室1厅 88平   \n",
       "\n",
       "  xingming cjzhouqi        biaoqian        cjlouceng        cjshijian  \\\n",
       "0      郭海龙       36  房东信赖;销售达人;带看活跃       南 北/高楼层/6层  签约时间：2015-05-24   \n",
       "1      郭海龙       36  房东信赖;销售达人;带看活跃         南/高楼层/7层  签约时间：2015-05-10   \n",
       "2      郭海龙       36  房东信赖;销售达人;带看活跃        北/低楼层/16层  签约时间：2015-04-26   \n",
       "3      郭海龙       36  房东信赖;销售达人;带看活跃       南 北/高楼层/6层  签约时间：2015-04-04   \n",
       "4      郭海龙       36  房东信赖;销售达人;带看活跃  东 南 西 北/中楼层/18层  签约时间：2015-04-01   \n",
       "\n",
       "  congyenianxian bankuai  \n",
       "0           4-5年     马连道  \n",
       "1           4-5年     马连道  \n",
       "2           4-5年     马连道  \n",
       "3           4-5年     马连道  \n",
       "4           4-5年     马连道  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f9d2fe8e",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[['cjdanjia', 'cjxiaoqu', 'cjlouceng']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "08d40347",
   "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>cjdanjia</th>\n",
       "      <th>cjxiaoqu</th>\n",
       "      <th>cjlouceng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>43997元/平</td>\n",
       "      <td>红莲北里 3室1厅 57平</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>36969元/平</td>\n",
       "      <td>红莲南里 1室1厅 43平</td>\n",
       "      <td>南/高楼层/7层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>39046元/平</td>\n",
       "      <td>常青藤嘉园 1室1厅 65平</td>\n",
       "      <td>北/低楼层/16层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41313元/平</td>\n",
       "      <td>红莲北里 2室1厅 58平</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>42053元/平</td>\n",
       "      <td>广安门外大街 3室1厅 88平</td>\n",
       "      <td>东 南 西 北/中楼层/18层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6591</th>\n",
       "      <td>27835元/平</td>\n",
       "      <td>富力又一城C区 2室2厅 88平</td>\n",
       "      <td>南/高楼层/23层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6592</th>\n",
       "      <td>20820元/平</td>\n",
       "      <td>扬州水乡 3室1厅 122平</td>\n",
       "      <td>南 北/中楼层/5层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6593</th>\n",
       "      <td>20302元/平</td>\n",
       "      <td>扬州水乡 2室2厅 76平</td>\n",
       "      <td>南 北/低楼层/3层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6594</th>\n",
       "      <td>26948元/平</td>\n",
       "      <td>富力又一城A区 3室2厅 139平</td>\n",
       "      <td>南 北/中楼层/22层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6659</th>\n",
       "      <td>11829元/平</td>\n",
       "      <td>福城上上城三季 2室1厅 59平</td>\n",
       "      <td>北/中楼层/26层</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>42950 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      cjdanjia           cjxiaoqu        cjlouceng\n",
       "0     43997元/平      红莲北里 3室1厅 57平       南 北/高楼层/6层\n",
       "1     36969元/平      红莲南里 1室1厅 43平         南/高楼层/7层\n",
       "2     39046元/平     常青藤嘉园 1室1厅 65平        北/低楼层/16层\n",
       "3     41313元/平      红莲北里 2室1厅 58平       南 北/高楼层/6层\n",
       "4     42053元/平    广安门外大街 3室1厅 88平  东 南 西 北/中楼层/18层\n",
       "...        ...                ...              ...\n",
       "6591  27835元/平   富力又一城C区 2室2厅 88平        南/高楼层/23层\n",
       "6592  20820元/平     扬州水乡 3室1厅 122平       南 北/中楼层/5层\n",
       "6593  20302元/平      扬州水乡 2室2厅 76平       南 北/低楼层/3层\n",
       "6594  26948元/平  富力又一城A区 3室2厅 139平      南 北/中楼层/22层\n",
       "6659  11829元/平   福城上上城三季 2室1厅 59平        北/中楼层/26层\n",
       "\n",
       "[42950 rows x 3 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "7ff97613",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.cjdanjia = np.round(data.cjdanjia.str.replace('元/平','').astype(np.float32).map(lambda x:x/10000),2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "2f6a8122",
   "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>cjdanjia</th>\n",
       "      <th>cjxiaoqu</th>\n",
       "      <th>cjlouceng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4.40</td>\n",
       "      <td>红莲北里 3室1厅 57平</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.70</td>\n",
       "      <td>红莲南里 1室1厅 43平</td>\n",
       "      <td>南/高楼层/7层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.90</td>\n",
       "      <td>常青藤嘉园 1室1厅 65平</td>\n",
       "      <td>北/低楼层/16层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.13</td>\n",
       "      <td>红莲北里 2室1厅 58平</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4.21</td>\n",
       "      <td>广安门外大街 3室1厅 88平</td>\n",
       "      <td>东 南 西 北/中楼层/18层</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cjdanjia         cjxiaoqu        cjlouceng\n",
       "0      4.40    红莲北里 3室1厅 57平       南 北/高楼层/6层\n",
       "1      3.70    红莲南里 1室1厅 43平         南/高楼层/7层\n",
       "2      3.90   常青藤嘉园 1室1厅 65平        北/低楼层/16层\n",
       "3      4.13    红莲北里 2室1厅 58平       南 北/高楼层/6层\n",
       "4      4.21  广安门外大街 3室1厅 88平  东 南 西 北/中楼层/18层"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "23cd1de2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(data.cjxiaoqu.str.split().map(len) != 3).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "b4b6a80b",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[data.cjxiaoqu.str.split().map(len) == 3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f0e44566",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.assign(xiaoqu = data.cjxiaoqu.map(lambda x:x.split()[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "4cf48a4b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# data['xiaoqu'] = data.cjxiaoqu.map(lambda x:x.split()[0])  # 在一个复制的视图上进行操作"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2c089955",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.assign(huxing = data.cjxiaoqu.map(lambda x:x.split()[1]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a8cf5022",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.assign(mianji = data.cjxiaoqu.map(lambda x:x.split()[2]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "25ab16e9",
   "metadata": {},
   "outputs": [],
   "source": [
    "del data['cjxiaoqu']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "68912a80",
   "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>cjdanjia</th>\n",
       "      <th>cjlouceng</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4.40</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>红莲北里</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>57平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.70</td>\n",
       "      <td>南/高楼层/7层</td>\n",
       "      <td>红莲南里</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>43平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.90</td>\n",
       "      <td>北/低楼层/16层</td>\n",
       "      <td>常青藤嘉园</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>65平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.13</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>红莲北里</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>58平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4.21</td>\n",
       "      <td>东 南 西 北/中楼层/18层</td>\n",
       "      <td>广安门外大街</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>88平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6591</th>\n",
       "      <td>2.78</td>\n",
       "      <td>南/高楼层/23层</td>\n",
       "      <td>富力又一城C区</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>88平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6592</th>\n",
       "      <td>2.08</td>\n",
       "      <td>南 北/中楼层/5层</td>\n",
       "      <td>扬州水乡</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>122平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6593</th>\n",
       "      <td>2.03</td>\n",
       "      <td>南 北/低楼层/3层</td>\n",
       "      <td>扬州水乡</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>76平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6594</th>\n",
       "      <td>2.69</td>\n",
       "      <td>南 北/中楼层/22层</td>\n",
       "      <td>富力又一城A区</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>139平</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6659</th>\n",
       "      <td>1.18</td>\n",
       "      <td>北/中楼层/26层</td>\n",
       "      <td>福城上上城三季</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>59平</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>42947 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      cjdanjia        cjlouceng   xiaoqu huxing mianji\n",
       "0         4.40       南 北/高楼层/6层     红莲北里   3室1厅    57平\n",
       "1         3.70         南/高楼层/7层     红莲南里   1室1厅    43平\n",
       "2         3.90        北/低楼层/16层    常青藤嘉园   1室1厅    65平\n",
       "3         4.13       南 北/高楼层/6层     红莲北里   2室1厅    58平\n",
       "4         4.21  东 南 西 北/中楼层/18层   广安门外大街   3室1厅    88平\n",
       "...        ...              ...      ...    ...    ...\n",
       "6591      2.78        南/高楼层/23层  富力又一城C区   2室2厅    88平\n",
       "6592      2.08       南 北/中楼层/5层     扬州水乡   3室1厅   122平\n",
       "6593      2.03       南 北/低楼层/3层     扬州水乡   2室2厅    76平\n",
       "6594      2.69      南 北/中楼层/22层  富力又一城A区   3室2厅   139平\n",
       "6659      1.18        北/中楼层/26层  福城上上城三季   2室1厅    59平\n",
       "\n",
       "[42947 rows x 5 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "b7aa2290",
   "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>cjdanjia</th>\n",
       "      <th>cjlouceng</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [cjdanjia, cjlouceng, xiaoqu, huxing, mianji]\n",
       "Index: []"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data.cjlouceng.str.split('/').map(len) != 3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "72caf909",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.assign(chaoxiang = data.cjlouceng.map(lambda x:x.split('/')[0]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "b707eb39",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.assign(louceng = data.cjlouceng.map(lambda x:x.split('/')[1]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "7f1d775f",
   "metadata": {},
   "outputs": [],
   "source": [
    "del data['cjlouceng']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "7a8b2a9e",
   "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>cjdanjia</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "      <th>chaoxiang</th>\n",
       "      <th>louceng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4.40</td>\n",
       "      <td>红莲北里</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>57平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>高楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.70</td>\n",
       "      <td>红莲南里</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>43平</td>\n",
       "      <td>南</td>\n",
       "      <td>高楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.90</td>\n",
       "      <td>常青藤嘉园</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>65平</td>\n",
       "      <td>北</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.13</td>\n",
       "      <td>红莲北里</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>58平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>高楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4.21</td>\n",
       "      <td>广安门外大街</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>88平</td>\n",
       "      <td>东 南 西 北</td>\n",
       "      <td>中楼层</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>6591</th>\n",
       "      <td>2.78</td>\n",
       "      <td>富力又一城C区</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>88平</td>\n",
       "      <td>南</td>\n",
       "      <td>高楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6592</th>\n",
       "      <td>2.08</td>\n",
       "      <td>扬州水乡</td>\n",
       "      <td>3室1厅</td>\n",
       "      <td>122平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6593</th>\n",
       "      <td>2.03</td>\n",
       "      <td>扬州水乡</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>76平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6594</th>\n",
       "      <td>2.69</td>\n",
       "      <td>富力又一城A区</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>139平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6659</th>\n",
       "      <td>1.18</td>\n",
       "      <td>福城上上城三季</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>59平</td>\n",
       "      <td>北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>42947 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      cjdanjia   xiaoqu huxing mianji chaoxiang louceng\n",
       "0         4.40     红莲北里   3室1厅    57平       南 北     高楼层\n",
       "1         3.70     红莲南里   1室1厅    43平         南     高楼层\n",
       "2         3.90    常青藤嘉园   1室1厅    65平         北     低楼层\n",
       "3         4.13     红莲北里   2室1厅    58平       南 北     高楼层\n",
       "4         4.21   广安门外大街   3室1厅    88平   东 南 西 北     中楼层\n",
       "...        ...      ...    ...    ...       ...     ...\n",
       "6591      2.78  富力又一城C区   2室2厅    88平         南     高楼层\n",
       "6592      2.08     扬州水乡   3室1厅   122平       南 北     中楼层\n",
       "6593      2.03     扬州水乡   2室2厅    76平       南 北     低楼层\n",
       "6594      2.69  富力又一城A区   3室2厅   139平       南 北     中楼层\n",
       "6659      1.18  福城上上城三季   2室1厅    59平         北     中楼层\n",
       "\n",
       "[42947 rows x 6 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "5b3f658c",
   "metadata": {},
   "outputs": [],
   "source": [
    "top15 = data.xiaoqu.value_counts()[:15].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "e91c3a16",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[data.xiaoqu.isin(top15)]  # 取出成交量前十五的小区的成交数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "403dd40b",
   "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>cjdanjia</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "      <th>chaoxiang</th>\n",
       "      <th>louceng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>6.62</td>\n",
       "      <td>荣丰2008</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>32平</td>\n",
       "      <td>南</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>3.97</td>\n",
       "      <td>远洋山水</td>\n",
       "      <td>1室--厅</td>\n",
       "      <td>56平</td>\n",
       "      <td>东</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>3.01</td>\n",
       "      <td>北京像素北区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>57平</td>\n",
       "      <td>西南</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>2.90</td>\n",
       "      <td>北京像素北区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>58平</td>\n",
       "      <td>东北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>3.81</td>\n",
       "      <td>沿海赛洛城</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>64平</td>\n",
       "      <td>东</td>\n",
       "      <td>低楼层</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>3769</th>\n",
       "      <td>2.07</td>\n",
       "      <td>天通苑东一区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>96平</td>\n",
       "      <td>东</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4096</th>\n",
       "      <td>2.96</td>\n",
       "      <td>芍药居北里</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>56平</td>\n",
       "      <td>南</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4230</th>\n",
       "      <td>1.93</td>\n",
       "      <td>天通苑东一区</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>130平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4232</th>\n",
       "      <td>2.50</td>\n",
       "      <td>天通苑东一区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>76平</td>\n",
       "      <td>南 北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5379</th>\n",
       "      <td>1.94</td>\n",
       "      <td>天通苑东一区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>101平</td>\n",
       "      <td>东 南</td>\n",
       "      <td>高楼层</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1777 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      cjdanjia  xiaoqu huxing mianji chaoxiang louceng\n",
       "31        6.62  荣丰2008   1室1厅    32平         南     低楼层\n",
       "347       3.97    远洋山水  1室--厅    56平         东     中楼层\n",
       "388       3.01  北京像素北区   2室1厅    57平        西南     低楼层\n",
       "716       2.90  北京像素北区   2室1厅    58平        东北     中楼层\n",
       "260       3.81   沿海赛洛城   1室1厅    64平         东     低楼层\n",
       "...        ...     ...    ...    ...       ...     ...\n",
       "3769      2.07  天通苑东一区   2室1厅    96平         东     低楼层\n",
       "4096      2.96   芍药居北里   1室1厅    56平         南     低楼层\n",
       "4230      1.93  天通苑东一区   3室2厅   130平       南 北     中楼层\n",
       "4232      2.50  天通苑东一区   2室1厅    76平       南 北     中楼层\n",
       "5379      1.94  天通苑东一区   2室1厅   101平       东 南     高楼层\n",
       "\n",
       "[1777 rows x 6 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "cf9aeb52",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\luhe\\AppData\\Local\\Temp\\ipykernel_37224\\2622074155.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  data.mianji = data.mianji.str.replace('平','').astype(np.float32)\n"
     ]
    }
   ],
   "source": [
    "data.mianji = data.mianji.str.replace('平','').astype(np.float32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "3d8d3d47",
   "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>cjdanjia</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "      <th>chaoxiang</th>\n",
       "      <th>louceng</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>6.62</td>\n",
       "      <td>荣丰2008</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>32.0</td>\n",
       "      <td>南</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>3.97</td>\n",
       "      <td>远洋山水</td>\n",
       "      <td>1室--厅</td>\n",
       "      <td>56.0</td>\n",
       "      <td>东</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>3.01</td>\n",
       "      <td>北京像素北区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>57.0</td>\n",
       "      <td>西南</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>2.90</td>\n",
       "      <td>北京像素北区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>58.0</td>\n",
       "      <td>东北</td>\n",
       "      <td>中楼层</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>3.81</td>\n",
       "      <td>沿海赛洛城</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>64.0</td>\n",
       "      <td>东</td>\n",
       "      <td>低楼层</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     cjdanjia  xiaoqu huxing  mianji chaoxiang louceng\n",
       "31       6.62  荣丰2008   1室1厅    32.0         南     低楼层\n",
       "347      3.97    远洋山水  1室--厅    56.0         东     中楼层\n",
       "388      3.01  北京像素北区   2室1厅    57.0        西南     低楼层\n",
       "716      2.90  北京像素北区   2室1厅    58.0        东北     中楼层\n",
       "260      3.81   沿海赛洛城   1室1厅    64.0         东     低楼层"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "bd8e8954",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['荣丰2008', '远洋山水', '北京像素北区', '沿海赛洛城', '东亚上北中心', '天通西苑二区', '芍药居北里',\n",
       "       '北京新天地', '北京像素南区', '新龙城', '青年汇佳园', '天通苑中苑', '天通苑东一区', '海特花园小区',\n",
       "       '天通西苑三区'], dtype=object)"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.xiaoqu.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "d27db4a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['南', '东', '西南', '东北', '南 北', '西 南', '东 南', '东 南 北', '西北', '东 北',\n",
       "       '东 西', '西', '北', '西 北', '东南', '南 西', '东 南 西', '西 南 北', '南 北 西',\n",
       "       '东 西 北', '南 西 北', '西南 东北', '南 北 东', '暂无数据', '北 东南', '北 西南',\n",
       "       '东 西 南', '东 北 南'], dtype=object)"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.chaoxiang.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "d33308f3",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data[data.chaoxiang != '暂无数据']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "01eb9bb7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['南', '东', '西南', '东北', '南 北', '西 南', '东 南', '东 南 北', '西北', '东 北',\n",
       "       '东 西', '西', '北', '西 北', '东南', '南 西', '东 南 西', '西 南 北', '南 北 西',\n",
       "       '东 西 北', '南 西 北', '西南 东北', '南 北 东', '北 东南', '北 西南', '东 西 南',\n",
       "       '东 北 南'], dtype=object)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.chaoxiang.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "d8daba0d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['低楼层', '中楼层', '高楼层', '地下室'], dtype=object)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.louceng.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "8bcec92b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['1室1厅', '1室--厅', '2室1厅', '2室2厅', '3室2厅', '4室2厅', '1室2厅', '3室1厅',\n",
       "       '5室1厅', '3室--厅', '5室--厅', '4室1厅', '5室2厅', '3室3厅', '2室--厅', '2室3厅',\n",
       "       '4室--厅'], dtype=object)"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.huxing.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "f7274eea",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.join(pd.get_dummies(data[['xiaoqu','huxing','louceng']]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "ebaea627",
   "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>cjdanjia</th>\n",
       "      <th>xiaoqu</th>\n",
       "      <th>huxing</th>\n",
       "      <th>mianji</th>\n",
       "      <th>chaoxiang</th>\n",
       "      <th>louceng</th>\n",
       "      <th>xiaoqu_东亚上北中心</th>\n",
       "      <th>xiaoqu_北京像素北区</th>\n",
       "      <th>xiaoqu_北京像素南区</th>\n",
       "      <th>xiaoqu_北京新天地</th>\n",
       "      <th>...</th>\n",
       "      <th>huxing_4室--厅</th>\n",
       "      <th>huxing_4室1厅</th>\n",
       "      <th>huxing_4室2厅</th>\n",
       "      <th>huxing_5室--厅</th>\n",
       "      <th>huxing_5室1厅</th>\n",
       "      <th>huxing_5室2厅</th>\n",
       "      <th>louceng_中楼层</th>\n",
       "      <th>louceng_低楼层</th>\n",
       "      <th>louceng_地下室</th>\n",
       "      <th>louceng_高楼层</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>6.62</td>\n",
       "      <td>荣丰2008</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>32.0</td>\n",
       "      <td>南</td>\n",
       "      <td>低楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>3.86</td>\n",
       "      <td>芍药居北里</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>43.0</td>\n",
       "      <td>南</td>\n",
       "      <td>地下室</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>3.81</td>\n",
       "      <td>沿海赛洛城</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>64.0</td>\n",
       "      <td>东</td>\n",
       "      <td>低楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>3.32</td>\n",
       "      <td>沿海赛洛城</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>57.0</td>\n",
       "      <td>东</td>\n",
       "      <td>中楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>3.96</td>\n",
       "      <td>沿海赛洛城</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>105.0</td>\n",
       "      <td>南 北</td>\n",
       "      <td>中楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56956</th>\n",
       "      <td>3.59</td>\n",
       "      <td>新龙城</td>\n",
       "      <td>1室1厅</td>\n",
       "      <td>56.0</td>\n",
       "      <td>北</td>\n",
       "      <td>低楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56957</th>\n",
       "      <td>2.20</td>\n",
       "      <td>天通苑东一区</td>\n",
       "      <td>2室1厅</td>\n",
       "      <td>94.0</td>\n",
       "      <td>东南</td>\n",
       "      <td>中楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56960</th>\n",
       "      <td>3.11</td>\n",
       "      <td>新龙城</td>\n",
       "      <td>1室2厅</td>\n",
       "      <td>70.0</td>\n",
       "      <td>南</td>\n",
       "      <td>低楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56961</th>\n",
       "      <td>3.18</td>\n",
       "      <td>新龙城</td>\n",
       "      <td>3室2厅</td>\n",
       "      <td>111.0</td>\n",
       "      <td>南 北</td>\n",
       "      <td>高楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56962</th>\n",
       "      <td>2.83</td>\n",
       "      <td>新龙城</td>\n",
       "      <td>2室2厅</td>\n",
       "      <td>98.0</td>\n",
       "      <td>东 西</td>\n",
       "      <td>中楼层</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1852 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       cjdanjia  xiaoqu huxing  mianji chaoxiang louceng  xiaoqu_东亚上北中心  \\\n",
       "31         6.62  荣丰2008   1室1厅    32.0         南     低楼层              0   \n",
       "148        3.86   芍药居北里   1室1厅    43.0         南     地下室              0   \n",
       "260        3.81   沿海赛洛城   1室1厅    64.0         东     低楼层              0   \n",
       "261        3.32   沿海赛洛城   1室1厅    57.0         东     中楼层              0   \n",
       "285        3.96   沿海赛洛城   2室2厅   105.0       南 北     中楼层              0   \n",
       "...         ...     ...    ...     ...       ...     ...            ...   \n",
       "56956      3.59     新龙城   1室1厅    56.0         北     低楼层              0   \n",
       "56957      2.20  天通苑东一区   2室1厅    94.0        东南     中楼层              0   \n",
       "56960      3.11     新龙城   1室2厅    70.0         南     低楼层              0   \n",
       "56961      3.18     新龙城   3室2厅   111.0       南 北     高楼层              0   \n",
       "56962      2.83     新龙城   2室2厅    98.0       东 西     中楼层              0   \n",
       "\n",
       "       xiaoqu_北京像素北区  xiaoqu_北京像素南区  xiaoqu_北京新天地  ...  huxing_4室--厅  \\\n",
       "31                 0              0             0  ...             0   \n",
       "148                0              0             0  ...             0   \n",
       "260                0              0             0  ...             0   \n",
       "261                0              0             0  ...             0   \n",
       "285                0              0             0  ...             0   \n",
       "...              ...            ...           ...  ...           ...   \n",
       "56956              0              0             0  ...             0   \n",
       "56957              0              0             0  ...             0   \n",
       "56960              0              0             0  ...             0   \n",
       "56961              0              0             0  ...             0   \n",
       "56962              0              0             0  ...             0   \n",
       "\n",
       "       huxing_4室1厅  huxing_4室2厅  huxing_5室--厅  huxing_5室1厅  huxing_5室2厅  \\\n",
       "31               0            0             0            0            0   \n",
       "148              0            0             0            0            0   \n",
       "260              0            0             0            0            0   \n",
       "261              0            0             0            0            0   \n",
       "285              0            0             0            0            0   \n",
       "...            ...          ...           ...          ...          ...   \n",
       "56956            0            0             0            0            0   \n",
       "56957            0            0             0            0            0   \n",
       "56960            0            0             0            0            0   \n",
       "56961            0            0             0            0            0   \n",
       "56962            0            0             0            0            0   \n",
       "\n",
       "       louceng_中楼层  louceng_低楼层  louceng_地下室  louceng_高楼层  \n",
       "31               0            1            0            0  \n",
       "148              0            0            1            0  \n",
       "260              0            1            0            0  \n",
       "261              1            0            0            0  \n",
       "285              1            0            0            0  \n",
       "...            ...          ...          ...          ...  \n",
       "56956            0            1            0            0  \n",
       "56957            1            0            0            0  \n",
       "56960            0            1            0            0  \n",
       "56961            0            0            0            1  \n",
       "56962            1            0            0            0  \n",
       "\n",
       "[1852 rows x 42 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "ee745de3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data.chaoxiang.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "f3b5496c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['南', '东', '南 北', '东 西', '南 西', '南 北 西', '西南', '西 北', '东南', '东 北',\n",
       "       '东 南', '西 南', '东北', '东 南 北', '西北', '西', '北', '西南 东北', '西 南 北',\n",
       "       '东 南 西', '南 北 东', '南 西 北', '东 西 北', '东 西 南', '北 东南', '北 西南',\n",
       "       '东 北 南'], dtype=object)"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.chaoxiang.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "935fac99",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['dong'] = (data.chaoxiang.map(lambda x:'东' in x.split())).astype(np.int32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "f8f3688b",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['xi'] = (data.chaoxiang.map(lambda x:'西' in x.split())).astype(np.int32)\n",
    "data['nan'] = (data.chaoxiang.map(lambda x:'南' in x.split())).astype(np.int32)\n",
    "data['bei'] = (data.chaoxiang.map(lambda x:'北' in x.split())).astype(np.int32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "7be3ec44",
   "metadata": {},
   "outputs": [],
   "source": [
    "data['dongnan'] = (data.chaoxiang.map(lambda x:'东南' in x.split() or '南东' in x.split())).astype(np.int32)\n",
    "data['dongbei'] = (data.chaoxiang.map(lambda x:'东北' in x.split())).astype(np.int32)\n",
    "data['xinan'] = (data.chaoxiang.map(lambda x:'西南' in x.split())).astype(np.int32)\n",
    "data['xibei'] = (data.chaoxiang.map(lambda x:'西北' in x.split())).astype(np.int32)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "3d4bb953",
   "metadata": {},
   "outputs": [],
   "source": [
    "data.drop(data.columns[[1,2,4,5]], axis=1, inplace=True)  # 删除多列"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "118c3368",
   "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>cjdanjia</th>\n",
       "      <th>mianji</th>\n",
       "      <th>xiaoqu_东亚上北中心</th>\n",
       "      <th>xiaoqu_北京像素北区</th>\n",
       "      <th>xiaoqu_北京像素南区</th>\n",
       "      <th>xiaoqu_北京新天地</th>\n",
       "      <th>xiaoqu_天通苑东一区</th>\n",
       "      <th>xiaoqu_天通苑中苑</th>\n",
       "      <th>xiaoqu_天通西苑三区</th>\n",
       "      <th>xiaoqu_天通西苑二区</th>\n",
       "      <th>...</th>\n",
       "      <th>louceng_地下室</th>\n",
       "      <th>louceng_高楼层</th>\n",
       "      <th>dong</th>\n",
       "      <th>xi</th>\n",
       "      <th>nan</th>\n",
       "      <th>bei</th>\n",
       "      <th>dongnan</th>\n",
       "      <th>dongbei</th>\n",
       "      <th>xinan</th>\n",
       "      <th>xibei</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>6.62</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>3.86</td>\n",
       "      <td>43.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>3.81</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>3.32</td>\n",
       "      <td>57.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>3.96</td>\n",
       "      <td>105.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56956</th>\n",
       "      <td>3.59</td>\n",
       "      <td>56.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56957</th>\n",
       "      <td>2.20</td>\n",
       "      <td>94.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56960</th>\n",
       "      <td>3.11</td>\n",
       "      <td>70.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56961</th>\n",
       "      <td>3.18</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56962</th>\n",
       "      <td>2.83</td>\n",
       "      <td>98.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1852 rows × 46 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       cjdanjia  mianji  xiaoqu_东亚上北中心  xiaoqu_北京像素北区  xiaoqu_北京像素南区  \\\n",
       "31         6.62    32.0              0              0              0   \n",
       "148        3.86    43.0              0              0              0   \n",
       "260        3.81    64.0              0              0              0   \n",
       "261        3.32    57.0              0              0              0   \n",
       "285        3.96   105.0              0              0              0   \n",
       "...         ...     ...            ...            ...            ...   \n",
       "56956      3.59    56.0              0              0              0   \n",
       "56957      2.20    94.0              0              0              0   \n",
       "56960      3.11    70.0              0              0              0   \n",
       "56961      3.18   111.0              0              0              0   \n",
       "56962      2.83    98.0              0              0              0   \n",
       "\n",
       "       xiaoqu_北京新天地  xiaoqu_天通苑东一区  xiaoqu_天通苑中苑  xiaoqu_天通西苑三区  \\\n",
       "31                0              0             0              0   \n",
       "148               0              0             0              0   \n",
       "260               0              0             0              0   \n",
       "261               0              0             0              0   \n",
       "285               0              0             0              0   \n",
       "...             ...            ...           ...            ...   \n",
       "56956             0              0             0              0   \n",
       "56957             0              1             0              0   \n",
       "56960             0              0             0              0   \n",
       "56961             0              0             0              0   \n",
       "56962             0              0             0              0   \n",
       "\n",
       "       xiaoqu_天通西苑二区  ...  louceng_地下室  louceng_高楼层  dong  xi  nan  bei  \\\n",
       "31                 0  ...            0            0     0   0    1    0   \n",
       "148                0  ...            1            0     0   0    1    0   \n",
       "260                0  ...            0            0     1   0    0    0   \n",
       "261                0  ...            0            0     1   0    0    0   \n",
       "285                0  ...            0            0     0   0    1    1   \n",
       "...              ...  ...          ...          ...   ...  ..  ...  ...   \n",
       "56956              0  ...            0            0     0   0    0    1   \n",
       "56957              0  ...            0            0     0   0    0    0   \n",
       "56960              0  ...            0            0     0   0    1    0   \n",
       "56961              0  ...            0            1     0   0    1    1   \n",
       "56962              0  ...            0            0     1   1    0    0   \n",
       "\n",
       "       dongnan  dongbei  xinan  xibei  \n",
       "31           0        0      0      0  \n",
       "148          0        0      0      0  \n",
       "260          0        0      0      0  \n",
       "261          0        0      0      0  \n",
       "285          0        0      0      0  \n",
       "...        ...      ...    ...    ...  \n",
       "56956        0        0      0      0  \n",
       "56957        1        0      0      0  \n",
       "56960        0        0      0      0  \n",
       "56961        0        0      0      0  \n",
       "56962        0        0      0      0  \n",
       "\n",
       "[1852 rows x 46 columns]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "f29e8e16",
   "metadata": {},
   "outputs": [],
   "source": [
    "Y = data.cjdanjia\n",
    "X = data[[x for x in data.columns if x != 'cjdanjia']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "cfab17dd",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "27223e09",
   "metadata": {},
   "outputs": [],
   "source": [
    "X_train, X_test, Y_train, Y_test = train_test_split(X, Y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "e3301e03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((1389, 45), (1389, 45), (1389, 45))"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_train.shape, np.shape(X_train), np.shape(X_train.values)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3ff86993",
   "metadata": {},
   "source": [
    "# 模型构建"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "bfb14b58",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.linear_model import LinearRegression"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "91ca7008",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>#sk-container-id-1 {color: black;background-color: white;}#sk-container-id-1 pre{padding: 0;}#sk-container-id-1 div.sk-toggleable {background-color: white;}#sk-container-id-1 label.sk-toggleable__label {cursor: pointer;display: block;width: 100%;margin-bottom: 0;padding: 0.3em;box-sizing: border-box;text-align: center;}#sk-container-id-1 label.sk-toggleable__label-arrow:before {content: \"▸\";float: left;margin-right: 0.25em;color: #696969;}#sk-container-id-1 label.sk-toggleable__label-arrow:hover:before {color: black;}#sk-container-id-1 div.sk-estimator:hover label.sk-toggleable__label-arrow:before {color: black;}#sk-container-id-1 div.sk-toggleable__content {max-height: 0;max-width: 0;overflow: hidden;text-align: left;background-color: #f0f8ff;}#sk-container-id-1 div.sk-toggleable__content pre {margin: 0.2em;color: black;border-radius: 0.25em;background-color: #f0f8ff;}#sk-container-id-1 input.sk-toggleable__control:checked~div.sk-toggleable__content {max-height: 200px;max-width: 100%;overflow: auto;}#sk-container-id-1 input.sk-toggleable__control:checked~label.sk-toggleable__label-arrow:before {content: \"▾\";}#sk-container-id-1 div.sk-estimator input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 div.sk-label input.sk-toggleable__control:checked~label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 input.sk-hidden--visually {border: 0;clip: rect(1px 1px 1px 1px);clip: rect(1px, 1px, 1px, 1px);height: 1px;margin: -1px;overflow: hidden;padding: 0;position: absolute;width: 1px;}#sk-container-id-1 div.sk-estimator {font-family: monospace;background-color: #f0f8ff;border: 1px dotted black;border-radius: 0.25em;box-sizing: border-box;margin-bottom: 0.5em;}#sk-container-id-1 div.sk-estimator:hover {background-color: #d4ebff;}#sk-container-id-1 div.sk-parallel-item::after {content: \"\";width: 100%;border-bottom: 1px solid gray;flex-grow: 1;}#sk-container-id-1 div.sk-label:hover label.sk-toggleable__label {background-color: #d4ebff;}#sk-container-id-1 div.sk-serial::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: 0;}#sk-container-id-1 div.sk-serial {display: flex;flex-direction: column;align-items: center;background-color: white;padding-right: 0.2em;padding-left: 0.2em;position: relative;}#sk-container-id-1 div.sk-item {position: relative;z-index: 1;}#sk-container-id-1 div.sk-parallel {display: flex;align-items: stretch;justify-content: center;background-color: white;position: relative;}#sk-container-id-1 div.sk-item::before, #sk-container-id-1 div.sk-parallel-item::before {content: \"\";position: absolute;border-left: 1px solid gray;box-sizing: border-box;top: 0;bottom: 0;left: 50%;z-index: -1;}#sk-container-id-1 div.sk-parallel-item {display: flex;flex-direction: column;z-index: 1;position: relative;background-color: white;}#sk-container-id-1 div.sk-parallel-item:first-child::after {align-self: flex-end;width: 50%;}#sk-container-id-1 div.sk-parallel-item:last-child::after {align-self: flex-start;width: 50%;}#sk-container-id-1 div.sk-parallel-item:only-child::after {width: 0;}#sk-container-id-1 div.sk-dashed-wrapped {border: 1px dashed gray;margin: 0 0.4em 0.5em 0.4em;box-sizing: border-box;padding-bottom: 0.4em;background-color: white;}#sk-container-id-1 div.sk-label label {font-family: monospace;font-weight: bold;display: inline-block;line-height: 1.2em;}#sk-container-id-1 div.sk-label-container {text-align: center;}#sk-container-id-1 div.sk-container {/* jupyter's `normalize.less` sets `[hidden] { display: none; }` but bootstrap.min.css set `[hidden] { display: none !important; }` so we also need the `!important` here to be able to override the default hidden behavior on the sphinx rendered scikit-learn.org. See: https://github.com/scikit-learn/scikit-learn/issues/21755 */display: inline-block !important;position: relative;}#sk-container-id-1 div.sk-text-repr-fallback {display: none;}</style><div id=\"sk-container-id-1\" class=\"sk-top-container\"><div class=\"sk-text-repr-fallback\"><pre>LinearRegression()</pre><b>In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook. <br />On GitHub, the HTML representation is unable to render, please try loading this page with nbviewer.org.</b></div><div class=\"sk-container\" hidden><div class=\"sk-item\"><div class=\"sk-estimator sk-toggleable\"><input class=\"sk-toggleable__control sk-hidden--visually\" id=\"sk-estimator-id-1\" type=\"checkbox\" checked><label for=\"sk-estimator-id-1\" class=\"sk-toggleable__label sk-toggleable__label-arrow\">LinearRegression</label><div class=\"sk-toggleable__content\"><pre>LinearRegression()</pre></div></div></div></div></div>"
      ],
      "text/plain": [
       "LinearRegression()"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model = LinearRegression()\n",
    "model.fit(X_train, Y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "3c06abd4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([2.88930692, 2.18702685, 3.09215066, 5.60077986, 3.1446695 ,\n",
       "       2.81334289, 3.15894721, 2.88341255, 2.59406459, 3.13718779,\n",
       "       3.09890355, 3.94266293, 4.54801418, 4.12380235, 2.88298068,\n",
       "       1.64276032, 2.25719333, 2.91727812, 3.14990341, 3.12132228,\n",
       "       2.91782073, 4.12395826, 3.21298905, 4.3776082 , 4.45863177,\n",
       "       4.40336881, 5.61580841, 4.52473951, 1.89707664, 3.44991557,\n",
       "       2.86013707, 1.88660627, 2.34158972, 3.90453072, 2.32399401,\n",
       "       2.84144641, 2.26491649, 3.05376976, 2.59479674, 3.69823924,\n",
       "       2.02032487, 4.7988569 , 2.18480298, 2.74265351, 2.90527085,\n",
       "       5.68426945, 4.68275393, 2.96151831, 2.02535051, 2.87331006,\n",
       "       2.90551872, 1.92987324, 2.06823587, 4.16137405, 5.83492663,\n",
       "       5.72255926, 3.4556906 , 2.33197813, 1.68301742, 4.3907257 ,\n",
       "       3.0987552 , 1.90817551, 2.72476175, 4.8343082 , 1.97408436,\n",
       "       5.81261562, 4.99837467, 3.58828865, 4.01998491, 1.84160246,\n",
       "       3.91867821, 3.02866837, 2.70066011, 4.01315773, 1.72410622,\n",
       "       3.91502452, 2.1904887 , 2.15218865, 3.24714101, 1.7265179 ,\n",
       "       2.11885906, 2.84253505, 2.89180164, 1.84638364, 2.67883748,\n",
       "       5.54965856, 5.58694668, 2.33230816, 4.16909445, 2.5319447 ,\n",
       "       5.35051641, 3.11823421, 3.0197858 , 2.97515958, 2.49295024,\n",
       "       2.170784  , 1.58284992, 2.03240018, 5.71514912, 3.84622774,\n",
       "       1.96762505, 2.31453645, 3.11051205, 2.59114914, 2.4963921 ,\n",
       "       4.81731097, 2.07243033, 5.66216966, 3.84878284, 4.19535716,\n",
       "       2.21689596, 4.38883581, 2.97799911, 5.74773303, 4.34130865,\n",
       "       2.0959688 , 3.19631014, 2.31572739, 2.18581543, 1.12925083,\n",
       "       1.64200543, 3.3149907 , 4.29243196, 2.18799398, 1.65195083,\n",
       "       3.38046762, 1.70208896, 1.9149535 , 5.83550589, 2.95820366,\n",
       "       2.88930692, 2.42336621, 3.82327075, 3.94476193, 1.74876142,\n",
       "       3.79291025, 3.2944833 , 1.79519015, 1.90299705, 2.17815541,\n",
       "       3.19794446, 2.31851865, 2.37167891, 3.97757145, 3.43069861,\n",
       "       5.63334773, 3.46294194, 4.03752422, 2.44786159, 2.42087149,\n",
       "       2.32017392, 0.88662243, 3.64986573, 2.01966981, 3.11003043,\n",
       "       1.64937684, 2.81207564, 2.33479758, 4.630612  , 2.39017792,\n",
       "       2.88250567, 4.15760986, 3.21911197, 3.11241005, 3.08371061,\n",
       "       3.53407371, 3.43069861, 4.08756787, 4.07416414, 1.76      ,\n",
       "       3.33207645, 1.18740716, 4.36437609, 3.156443  , 4.22249245,\n",
       "       2.4464077 , 4.4844377 , 2.00417355, 2.39625572, 3.16899288,\n",
       "       2.70268949, 2.25542558, 5.82046129, 2.69538786, 2.45939537,\n",
       "       4.3386123 , 2.46045198, 2.53808403, 1.15858025, 2.46636772,\n",
       "       3.80682827, 1.80535806, 3.18192754, 2.89976305, 3.21298905,\n",
       "       3.20952107, 3.62203886, 1.70661345, 3.79068684, 3.25714958,\n",
       "       2.95820366, 4.18547547, 4.43614628, 3.08085735, 4.00561324,\n",
       "       2.50697822, 2.15468337, 4.76934697, 3.08862603, 2.5822012 ,\n",
       "       2.26838247, 3.07448425, 3.98226126, 2.26411347, 2.21462132,\n",
       "       3.0496679 , 5.83550589, 3.10968998, 1.76      , 5.17160329,\n",
       "       3.10996764, 2.61814386, 2.49455987, 3.07448425, 2.96524708,\n",
       "       2.3746172 , 2.97951644, 3.16899288, 5.66095824, 3.10303846,\n",
       "       0.55595774, 3.18239315, 2.83433114, 1.73062868, 2.75910815,\n",
       "       1.64707875, 2.0959688 , 2.50697822, 5.73268844, 3.021716  ,\n",
       "       3.17412653, 3.11003043, 3.42310669, 5.35213845, 2.80274743,\n",
       "       1.76602321, 0.69363135, 3.11882756, 4.46705584, 4.45960917,\n",
       "       5.69225886, 3.76059765, 2.7404175 , 2.84443163, 2.44933864,\n",
       "       3.92925864, 1.84638364, 2.51438231, 2.96559492, 2.95825242,\n",
       "       3.32457249, 5.76198715, 2.66005043, 2.17815541, 3.54785907,\n",
       "       5.66095824, 5.17081282, 2.32888576, 3.11629449, 2.91782073,\n",
       "       3.08862603, 4.8068463 , 1.8284089 , 2.69154307, 4.01315773,\n",
       "       3.02824742, 3.10768101, 5.24218823, 2.65318501, 2.40335425,\n",
       "       3.10627768, 3.04688977, 2.08248713, 4.08661187, 5.11718516,\n",
       "       3.10187164, 3.51770408, 3.10436635, 4.45960917, 2.99160751,\n",
       "       5.69183791, 1.8284089 , 3.20043918, 5.60077986, 3.39301749,\n",
       "       2.82817628, 2.67768645, 2.93481743, 3.53656843, 2.75939113,\n",
       "       3.66316029, 4.07204649, 2.53886629, 3.78525915, 2.33197813,\n",
       "       5.73739264, 2.13092051, 2.39931463, 5.71435864, 2.10235317,\n",
       "       2.96524708, 2.31476884, 2.09045263, 4.33532951, 3.10768101,\n",
       "       2.33197813, 2.56499121, 2.98482952, 2.67634276, 3.45063259,\n",
       "       4.82904373, 2.81938418, 3.06254309, 3.13157456, 2.39625572,\n",
       "       3.20366806, 3.20095835, 2.92693772, 2.53558931, 1.90817551,\n",
       "       1.89019544, 5.67679331, 4.08756078, 2.05590875, 1.96887576,\n",
       "       3.32641864, 2.33479758, 2.88341255, 2.77415275, 4.16362766,\n",
       "       5.42272338, 3.10706816, 2.78919735, 3.0706057 , 3.08371061,\n",
       "       1.78567341, 2.71845132, 4.19166153, 1.7582404 , 5.36117755,\n",
       "       3.37566999, 2.96380495, 5.74444784, 3.10996764, 2.17151321,\n",
       "       3.1678594 , 4.08288363, 5.36127774, 3.03791865, 4.16031801,\n",
       "       4.05365896, 3.59444439, 1.42381296, 4.58741261, 4.57910911,\n",
       "       2.19957673, 4.18816874, 3.9881515 , 0.97021862, 3.79068684,\n",
       "       3.00485943, 2.01694812, 2.26411347, 1.76088479, 2.97656291,\n",
       "       3.31590828, 2.40720111, 3.168828  , 4.05949661, 2.11788166,\n",
       "       4.42638516, 3.60290034, 2.46342096, 2.32813305, 3.13936684,\n",
       "       2.15468337, 3.3149907 , 2.32981344, 2.62160355, 1.86969485,\n",
       "       2.34421176, 1.51171514, 2.8239071 , 3.09123308, 2.25251794,\n",
       "       3.53687728, 1.77315252, 1.88934125, 3.72752914, 5.35213845,\n",
       "       2.10851867, 2.00970181, 2.36119672, 2.01694812, 3.1722403 ,\n",
       "       3.14990341, 1.98915909, 2.68027423, 3.11252515, 1.38097856,\n",
       "       2.34485803, 5.72825335, 3.13527549, 4.22028296, 2.62415186,\n",
       "       4.19474893, 4.0849574 , 2.41523254, 4.70090197, 3.83038615,\n",
       "       3.13406928, 3.13718681, 3.10996764, 1.23870645, 2.49295024,\n",
       "       3.02418729, 2.70311789, 3.11492003, 3.58050127, 2.32399401,\n",
       "       2.97998299, 1.5879584 , 3.10706816, 3.0174093 , 4.94237195,\n",
       "       3.27252764, 3.09996122, 2.70865919, 2.31207979, 4.48187715,\n",
       "       2.60434321, 4.16341645, 3.00485943, 5.73489793, 3.95624652,\n",
       "       4.04979631, 1.23969936, 3.15908194, 4.99837467, 2.7096911 ,\n",
       "       3.14813648, 5.16333668, 5.69225886, 2.27142744, 2.85764235,\n",
       "       1.74876142, 2.63264573, 2.20119005, 5.01152364, 2.26653596,\n",
       "       1.84107978, 2.32948341, 1.71719524])"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.predict(X_test)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2477e35a",
   "metadata": {},
   "source": [
    "# 模型评价"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "4aab9c20",
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn import metrics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "946370cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.3120292004271854"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "metrics.mean_squared_error(model.predict(X_test), Y_test)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3c4a8911",
   "metadata": {},
   "source": [
    "# 模型预测"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "894cb4ab",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_test = pd.Series(np.zeros(len([x for x in data.columns if x != 'cjdanjia'])),\n",
    "                      index = [x for x in data.columns if x != 'cjdanjia'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "b6772d5d",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_test.mianji = 80\n",
    "data_test.xiaoqu_天通西苑三区 = 1\n",
    "data_test.nan = 1\n",
    "data_test.bei = 1\n",
    "data_test.huxing_2室2厅 = 1\n",
    "data_test.louceng_高楼层 = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "adf43330",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "mianji           80.0\n",
       "xiaoqu_东亚上北中心     0.0\n",
       "xiaoqu_北京像素北区     0.0\n",
       "xiaoqu_北京像素南区     0.0\n",
       "xiaoqu_北京新天地      0.0\n",
       "xiaoqu_天通苑东一区     0.0\n",
       "xiaoqu_天通苑中苑      0.0\n",
       "xiaoqu_天通西苑三区     1.0\n",
       "xiaoqu_天通西苑二区     0.0\n",
       "xiaoqu_新龙城        0.0\n",
       "xiaoqu_沿海赛洛城      0.0\n",
       "xiaoqu_海特花园小区     0.0\n",
       "xiaoqu_芍药居北里      0.0\n",
       "xiaoqu_荣丰2008     0.0\n",
       "xiaoqu_远洋山水       0.0\n",
       "xiaoqu_青年汇佳园      0.0\n",
       "huxing_1室--厅      0.0\n",
       "huxing_1室1厅       0.0\n",
       "huxing_1室2厅       0.0\n",
       "huxing_2室--厅      0.0\n",
       "huxing_2室1厅       0.0\n",
       "huxing_2室2厅       1.0\n",
       "huxing_2室3厅       0.0\n",
       "huxing_3室--厅      0.0\n",
       "huxing_3室1厅       0.0\n",
       "huxing_3室2厅       0.0\n",
       "huxing_3室3厅       0.0\n",
       "huxing_4室--厅      0.0\n",
       "huxing_4室1厅       0.0\n",
       "huxing_4室2厅       0.0\n",
       "huxing_5室--厅      0.0\n",
       "huxing_5室1厅       0.0\n",
       "huxing_5室2厅       0.0\n",
       "louceng_中楼层       1.0\n",
       "louceng_低楼层       0.0\n",
       "louceng_地下室       0.0\n",
       "louceng_高楼层       1.0\n",
       "dong              0.0\n",
       "xi                0.0\n",
       "nan               1.0\n",
       "bei               1.0\n",
       "dongnan           0.0\n",
       "dongbei           0.0\n",
       "xinan             0.0\n",
       "xibei             0.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "60949127",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\luhe\\miniconda3\\lib\\site-packages\\sklearn\\base.py:420: UserWarning: X does not have valid feature names, but LinearRegression was fitted with feature names\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "array([3.25528068])"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model.predict(data_test.values.reshape(1,-1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "581aea7d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}