7.1 pandas 链家成交数据分析.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b45b9695",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4255fba9",
   "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)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d05b38a8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "107ebe87",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.concat(data_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "cdb952f3",
   "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": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ce294873",
   "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": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5f26fb75",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 162227 entries, 0 to 6680\n",
      "Data columns (total 14 columns):\n",
      " #   Column          Non-Null Count   Dtype  \n",
      "---  ------          --------------   -----  \n",
      " 0   cjtaoshu        162227 non-null  int64  \n",
      " 1   mendian         162214 non-null  object \n",
      " 2   cjzongjia       162226 non-null  float64\n",
      " 3   zhiwei          162226 non-null  object \n",
      " 4   haoping         162226 non-null  object \n",
      " 5   cjdanjia        162226 non-null  object \n",
      " 6   cjxiaoqu        162226 non-null  object \n",
      " 7   xingming        162226 non-null  object \n",
      " 8   cjzhouqi        162226 non-null  object \n",
      " 9   biaoqian        145553 non-null  object \n",
      " 10  cjlouceng       162226 non-null  object \n",
      " 11  cjshijian       162226 non-null  object \n",
      " 12  congyenianxian  162226 non-null  object \n",
      " 13  bankuai         160906 non-null  object \n",
      "dtypes: float64(1), int64(1), object(12)\n",
      "memory usage: 18.6+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c6b37842",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# 提取单价\n",
    "dj = data.cjdanjia.dropna().map(lambda x:round(float(x.replace('元/平',''))/10000, 1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "37dfa8a0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15.0"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dj.max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "83143a50",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dj.min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "7e0bb4db",
   "metadata": {},
   "outputs": [],
   "source": [
    "dj = dj[dj>0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "2089d55f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.1"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dj.min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "020b5356",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.889871966485709"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dj.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "43990cf6",
   "metadata": {},
   "outputs": [],
   "source": [
    "bins = [0,1,2,3,4,5,8,10,16]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "571af5ad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: >"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAkQAAAGdCAYAAADzOWwgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy88F64QAAAACXBIWXMAAA9hAAAPYQGoP6dpAAAt1UlEQVR4nO3de1TV9Z7/8dcGZCNHuRgCUijZxQuiApVSWXn0iA6rw8ycM6ccT7XUtFO2ypyYwslLNQRdVqfLNE5Tms3qYpRW5xRpZpF2MiVzq0CZHgEdDC1Ftgqhyef3hz/3tI+ibAG/wOf5WOu7lvvz/ezP5735yuK1Pt/LdhljjAAAACwW5HQBAAAATiMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsF+J0AZ1FU1OTdu/erZ49e8rlcjldDgAAaAFjjA4ePKiEhAQFBTW/DkQgaqHdu3crMTHR6TIAAMBZ2LVrly644IJm9xOIWqhnz56Sjv9AIyIiHK4GAAC0hNfrVWJiou/veHMIRC104jRZREQEgQgAgE7mTJe7cFE1AACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9HswYoCHzVijIHd7i/pUFWe1YDQAAaAusEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CEQAAsB6BCAAAWM+xQLRv3z7FxsaqsrLynM993XXXyeVyyeVyyePxnPP5AQBAx+JYIMrLy1N2draSkpJ8bTt37lRWVpbCw8MVGxurnJwc/fTTTwGNu3r1al1//fVKSEiQy+XSO++8c1KfZcuWaf369a38BAAAoKtw5MGM9fX1WrhwoVasWOFrO3bsmLKyshQfH6/PP/9c3333nW6++WZ169ZNjzzySIvHPnz4sIYNG6YpU6boH//xH0/Zp1evXvJ6va3+HAAAoGtwJBAVFRXJ7XZr5MiRvrYPP/xQ5eXl+uijjxQXF6fhw4fr4Ycf1n333af58+crNDS0RWNPmDBBEyZMaK/SAQBAF+TIKbM1a9YoPT3dr23t2rVKSUlRXFycry0zM1Ner1dlZWXnukQ1NjbK6/X6bQAAoGtyJBBVVVUpISHBr62mpsYvDEnyva6pqTlntZ2Qn5+vyMhI35aYmHjOawAAAOeGI4GooaFBYWFhTkzdYrm5uaqrq/Ntu3btcrokAADQThy5higmJka1tbV+bfHx8Sfd+bVnzx7fvnPN7XbL7Xaf83kBAMC558gKUWpqqsrLy/3aMjIytGXLFu3du9fXtnLlSkVERGjw4MHnukQAAGARRwJRZmamysrK/FaJxo0bp8GDB+umm27Spk2btGLFCj3wwAOaMWNGQCs1hw4dksfj8T1wsaKiQh6PRzt37mzrjwEAALoIRwJRSkqK0tLSVFhY6GsLDg7We++9p+DgYGVkZOj3v/+9br75Zj300EO+PpWVlXK5XCouLm527C+//FKpqalKTU2VJM2aNUupqamaO3duu30eAADQuTlyDZEkzZ07Vzk5OZo2bZqCgo7nsn79+qmoqKjZ91RUVCgqKkrDhg1rts91110nY0yb1wsAALouxwJRVlaWtm3bpurq6hbf0l5UVKTZs2crOjq6VXNPmDBBq1evbtUYAACg63AZC5dTqqur1dDQIEnq27dvi56C7fV6jz+PaGahgtzhLZ6rsiDrrOsEAACtc+Lvd11dnSIiIprt59gKkZPOP/98p0sAAAAdiGPfdg8AANBRWLlC1BqlD2aedskNAAB0PqwQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CEQAAsB6BCAAAWC/E6QI6myHzVijIHR7QeyoLstqpGgAA0BZYIQIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CEQAAsF7AgWjfvn2KjY1VZWVlO5RzbrhcLrlcLkVFRTldCgAA6AACDkR5eXnKzs5WUlKSr+2uu+5Senq63G63hg8ffsr3bd68WaNGjVJYWJgSExP12GOPBVzssmXLNG7cOJ133nlyuVzyeDyn7Ld27Vr98pe/1C9+8QtFRETommuuUUNDg2//d999p6eeeirg+QEAQNcUUCCqr6/XwoULNXXq1JP2TZkyRTfccMMp3+f1ejVu3Dj169dPGzZs0OOPP6758+frv//7vwMq9vDhw7r66qv16KOPNttn7dq1Gj9+vMaNG6f169erpKREd955p4KC/u+jxsfHKzIyMqC5AQBA1xXQk6qLiorkdrs1cuRIv/ZnnnlGkvT9999r8+bNJ73v1Vdf1ZEjR7Ro0SKFhoYqOTlZHo9HTz75pKZPn97i+W+66SZJOu3punvuuUd33XWX7r//fl/bgAEDWjwHAACwT0ArRGvWrFF6enrAk6xdu1bXXHONQkNDfW2ZmZnaunWramtrAx6vOXv37tW6desUGxurK6+8UnFxcbr22mv12WefBTxWY2OjvF6v3wYAALqmgAJRVVWVEhISAp6kpqZGcXFxfm0nXtfU1AQ8XnN27NghSZo/f76mTZum5cuXKy0tTWPGjNG2bdsCGis/P1+RkZG+LTExsc3qBAAAHUtAgaihoUFhYWHtVUurNTU1SZJuu+02TZ48WampqfrjH/+oAQMGaNGiRQGNlZubq7q6Ot+2a9eu9igZAAB0AAFdQxQTE3NWp7ji4+O1Z88ev7YTr+Pj4wMerzl9+vSRJA0ePNivfdCgQdq5c2dAY7ndbrnd7jarDQAAdFwBrRClpqaqvLw84EkyMjK0evVqHT161Ne2cuVKDRgwQNHR0QGP15ykpCQlJCRo69atfu3ffvut+vXr12bzAACAriWgQJSZmamysrKTVom2b98uj8ejmpoaNTQ0yOPxyOPx6MiRI5Kkf/7nf1ZoaKimTp2qsrIyvfHGG3r66ac1a9asgIrdv3+/PB6PL5Rt3brVN690/IGLOTk5euaZZ/TWW29p+/btmjNnjr755ptTPioAAABACvCUWUpKitLS0lRYWKjbbrvN137rrbfq008/9b1OTU2VJFVUVCgpKUmRkZH68MMPNWPGDKWnpysmJkZz5871u+W+uLhYo0eP9r3nVP70pz9p8uTJvtc33nijJGnevHmaP3++JGnmzJn68ccfdc8992j//v0aNmyYVq5cqYsuuiiQjwoAACziMsaYQN7w/vvvKycnR6WlpX4PO2ytl156SY888ojKy8vVrVu3Nhu3OYsXL9bMmTN14MCBFvX3er3H7zabWaggd3hAc1UWZJ1FhQAAoLVO/P2uq6tTREREs/0CWiGSpKysLG3btk3V1dVteit6UVGRHnnkkXMShnr06KGffvqpQ98xBwAAzp2AA5F0/LRUW3vzzTfbfMzmnPgOtODg4HM2JwAA6LjOKhB1dhdffLHTJQAAgA6k7S4CAgAA6KQIRAAAwHpWnjJrjdIHM097lToAAOh8WCECAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CEQAAsB6BCAAAWI9ABAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwXojTBXQ2Q+atUJA73OkyWqSyIMvpEgAA6BRYIQIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYL12CUT79u1TbGysKisr22P4VktKSpLL5ZLL5dKBAwecLgcAADisXQJRXl6esrOzlZSU5GsrKSnRmDFjFBUVpejoaGVmZmrTpk0BjVtWVqbf/OY3vkDz1FNPnbLfc889p6SkJIWFhWnEiBFav3693/6SkhItXbo00I8FAAC6qDYPRPX19Vq4cKGmTp3qazt06JDGjx+vvn37at26dfrss8/Us2dPZWZm6ujRowGN3b9/fxUUFCg+Pv6Ufd544w3NmjVL8+bN01dffaVhw4YpMzNTe/fu9fXp3bu3evXqdfYfEgAAdCltHoiKiorkdrs1cuRIX9s333yj/fv366GHHtKAAQOUnJysefPmac+ePaqqqmrx2Jdffrkef/xx3XjjjXK73afs8+STT2ratGmaPHmyBg8erP/6r/9SeHi4Fi1a1OrPBgAAuqY2D0Rr1qxRenq6X9uAAQN03nnnaeHChTpy5IgaGhq0cOFCDRo0yO+0WmsdOXJEGzZs0NixY31tQUFBGjt2rNauXRvQWI2NjfJ6vX4bAADomto8EFVVVSkhIcGvrWfPniouLtYrr7yi7t27q0ePHlq+fLk++OADhYS03beH/PDDDzp27Jji4uL82uPi4lRTUxPQWPn5+YqMjPRtiYmJbVYnAADoWNo8EDU0NCgsLOyktqlTp+qqq67SF198ob/85S8aMmSIsrKy1NDQ0NYltInc3FzV1dX5tl27djldEgAAaCdt/uWuMTExqq2t9Wt77bXXVFlZqbVr1yooKMjXFh0drXfffVc33nhjm80dHBysPXv2+LXv2bOn2Yuwm+N2u5u9TgkAAHQtbb5ClJqaqvLycr+2+vp6BQUFyeVy/d/E//91U1NTm80dGhqq9PR0rVq1ytfW1NSkVatWKSMjo83mAQAAXUubB6LMzEyVlZX5rRL96le/Um1trWbMmKGvv/5aZWVlmjx5skJCQjR69OgWj33kyBF5PB55PB4dOXJE1dXV8ng82r59u6/PrFmz9MILL+jll1/W119/rdtvv12HDx/W5MmT2/RzAgCArqPNA1FKSorS0tJUWFjoaxs4cKD+/Oc/a/PmzcrIyNCoUaO0e/duLV++XH369PH1c7lcWrx4cbNj7969W6mpqUpNTdV3332nJ554Qqmpqbr11lt9fW644QY98cQTmjt3roYPHy6Px6Ply5efdKE1AADACS5jjGnrQd9//33l5OSotLTUd83QmVRUVOjSSy9VeXm5LrnkkrYu6STFxcUaPXq0amtrFRUVdcb+Xq/3+N1mMwsV5A5v9/raQmVBltMlAADgqBN/v+vq6hQREdFsvza/qFqSsrKytG3bNlVXV7f4dvWioiJNnz79nISh5ORk7dixo93nAQAAnUO7BCJJmjlzZkD9Z8yY0T6FnEJRUZHvK0NOlxYBAIAd2i0QdWT9+vVzugQAANCBtMu33QMAAHQmBCIAAGA9K0+ZtUbpg5lcdwQAQBfDChEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CEQAAsB6BCAAAWI9ABAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1QpwuoLMZMm+FgtzhTpcBi1UWZDldAgB0OawQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwnmOBaN++fYqNjVVlZeU5n/u6666Ty+WSy+WSx+M55/MDAICOxbFAlJeXp+zsbCUlJfna7rrrLqWnp8vtdmv48OFnNe4LL7ygUaNGKTo6WtHR0Ro7dqzWr1/v12fZsmUntQEAAHs5Eojq6+u1cOFCTZ069aR9U6ZM0Q033HDWYxcXF2vixIn65JNPtHbtWiUmJmrcuHGqrq729enVq5d69+591nMAAICuxZEHMxYVFcntdmvkyJF+7c8884wk6fvvv9fmzZvPauxXX33V7/WLL76opUuXatWqVbr55pvPrmAAANClORKI1qxZo/T09HMyV319vY4ePapevXoF9L7GxkY1Njb6Xnu93rYuDQAAdBCOnDKrqqpSQkLCOZnrvvvuU0JCgsaOHRvQ+/Lz8xUZGenbEhMT26lCAADgNEcCUUNDg8LCwtp9noKCAi1ZskRvv/12wPPl5uaqrq7Ot+3ataudqgQAAE5z5JRZTEyMamtr23WOJ554QgUFBfroo480dOjQgN/vdrvldrvboTIAANDROLJClJqaqvLy8nYb/7HHHtPDDz+s5cuX67LLLmu3eQAAQNfgSCDKzMxUWVnZSatE27dvl8fjUU1NjRoaGuTxeOTxeHTkyJEWj/3oo49qzpw5WrRokZKSklRTU6OamhodOnSorT8GAADoIhwJRCkpKUpLS1NhYaFf+6233qrU1FQ9//zz+vbbb5WamqrU1FTt3r3b18flcmnx4sXNjr1gwQIdOXJEv/3tb9WnTx/f9sQTT7TXxwEAAJ2cI9cQSdLcuXOVk5OjadOmKSjoeC4rLi4+7XsqKioUEhKiq666qtk+TnwVCAAA6NwcC0RZWVnatm2bqqurW3xLe1FRkaZPn65LLrmkVXNPmDBBq1evbtUYAACg63AZY4zTRZxr1dXVamhokCT17dtXoaGhZ3yP1+s9/jyimYUKcoe3d4lAsyoLspwuAQA6jRN/v+vq6hQREdFsP8dWiJx0/vnnO10CAADoQBz7tnsAAICOgkAEAACsZ+Ups9YofTDztOcgAQBA58MKEQAAsB6BCAAAWI9ABAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPVCnC6gsxkyb4WC3OFOlwGgi6ssyHK6BMAqrBABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFjPsUC0b98+xcbGqrKy8pzPnZSUJJfLJZfLpQMHDpzz+QEAQMfiWCDKy8tTdna2kpKSTtq3b98+XXDBBWcVWObPn+8LOye2gQMH+vUpKSnR0qVLW1E9AADoShx5MGN9fb0WLlyoFStWnHL/1KlTNXToUFVXV5/V+MnJyfroo498r0NC/D9m79691atXr7MaGwAAdD2OrBAVFRXJ7XZr5MiRJ+1bsGCBDhw4oHvvvfesxw8JCVF8fLxvi4mJaU25AACgi3MkEK1Zs0bp6ekntZeXl+uhhx7S//zP/ygo6OxL27ZtmxISEtS/f39NmjRJO3fuDHiMxsZGeb1evw0AAHRNjgSiqqoqJSQk+LU1NjZq4sSJevzxx9W3b9+zHnvEiBFavHixli9frgULFqiiokKjRo3SwYMHAxonPz9fkZGRvi0xMfGsawIAAB2bI4GooaFBYWFhfm25ubkaNGiQfv/737dq7AkTJuif/umfNHToUGVmZqqoqEgHDhxQYWFhQOPk5uaqrq7Ot+3atatVdQEAgI7LkUAUExOj2tpav7aPP/5Yb775pkJCQhQSEqIxY8b4+s6bN++s54qKitKll16q7du3B/Q+t9utiIgIvw0AAHRNjtxllpqaqldeecWvbenSpWpoaPC9Likp0ZQpU7RmzRpddNFFZz3XoUOH9Ne//lU33XTTWY8BAAC6NkcCUWZmpnJzc1VbW6vo6GhJOin0/PDDD5KkQYMGKSoqqsVj33vvvbr++uvVr18/7d69W/PmzVNwcLAmTpzYZvUDAICuxZFTZikpKUpLSwv4up7Kykq5XC4VFxc32+d///d/NXHiRA0YMEC/+93vdN555+mLL75Q7969W1k1AADoqhxZIZKkuXPnKicnR9OmTTvlLfbXXXedjDF+bRUVFYqKitKwYcOaHXfJkiVtXisAAOjaHAtEWVlZ2rZtm6qrq1t8S3tRUZFmz57tO812tpKTk7Vjx45WjQEAALoOl/nbZRgLVFVV6ejRo5Kk/v37t+ghkF6v9/jziGYWKsgd3t4lArBcZUGW0yUAXcKJv991dXWnvWPcsRUiJ/Xr18/pEgAAQAfi2LfdAwAAdBRWrhC1RumDmTykEQCALoYVIgAAYD0CEQAAsB6BCAAAWI9ABAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOuFOF1AZzNk3goFucOdLgMAzqiyIMvpEoBOgxUiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrORaI9u3bp9jYWFVWVp7zua+77jq5XC65XC55PJ5zPj8AAOhYHAtEeXl5ys7OVlJSkq/tREj5+bZkyZKAxj127JjmzJmjCy+8UN27d9dFF12khx9+WMYYX59ly5Zp/fr1bfVRAABAJ+fIgxnr6+u1cOFCrVix4qR9L730ksaPH+97HRUVFdDYjz76qBYsWKCXX35ZycnJ+vLLLzV58mRFRkbqrrvukiT16tVLXq+3VZ8BAAB0HY4EoqKiIrndbo0cOfKkfVFRUYqPjz/rsT///HNlZ2crK+v4E1qTkpL0+uuvsyIEAACa5cgpszVr1ig9Pf2U+2bMmKGYmBhdccUVWrRokd+prpa48sortWrVKn377beSpE2bNumzzz7ThAkTAhqnsbFRXq/XbwMAAF2TIytEVVVVSkhIOKn9oYce0i9/+UuFh4frww8/1B133KFDhw75TnW1xP333y+v16uBAwcqODhYx44dU15eniZNmhRQjfn5+XrwwQcDeg8AAOicHAlEDQ0NCgsLO6l9zpw5vn+npqbq8OHDevzxxwMKRIWFhXr11Vf12muvKTk5WR6PRzNnzlRCQoJuueWWFo+Tm5urWbNm+V57vV4lJia2+P0AAKDzcCQQxcTEqLa29oz9RowYoYcffliNjY1yu90tGjsnJ0f333+/brzxRklSSkqKqqqqlJ+fH1AgcrvdLZ4TAAB0bo5cQ5Samqry8vIz9vN4PIqOjg4omNTX1ysoyP9jBQcHq6mpKeA6AQCAHRxZIcrMzFRubq5qa2sVHR0tSfrzn/+sPXv2aOTIkQoLC9PKlSv1yCOP6N577w1o7Ouvv155eXnq27evkpOTtXHjRj355JOaMmVKe3wUAADQBTiyQpSSkqK0tDQVFhb62rp166bnnntOGRkZGj58uJ5//nk9+eSTmjdvnq9PZWWlXC6XiouLmx372Wef1W9/+1vdcccdGjRokO69917ddtttevjhh9vzIwEAgE7MkRUiSZo7d65ycnI0bdo0BQUFafz48X4PZDyViooKRUVFadiwYc326dmzp5566ik99dRTbVwxAADoqhwLRFlZWdq2bZuqq6tbfPdWUVGRZs+e7TvNdrYmTJig1atXt2oMAADQdbhMoE8+7AKqq6vV0NAgSerbt69CQ0PP+B6v16vIyEglzixUkDu8vUsEgFarLMhyugTAcSf+ftfV1SkiIqLZfo6tEDnp/PPPd7oEAADQgTj2bfcAAAAdhZUrRK1R+mDmaZfcAABA58MKEQAAsB6BCAAAWI9ABAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPVCnC6gsxkyb4WC3OFOlwEAQIdQWZDldAltghUiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrORaI9u3bp9jYWFVWVp7zuZOSkuRyueRyuXTgwIFzPj8AAOhYHAtEeXl5ys7OVlJSkqTjAWn8+PFKSEiQ2+1WYmKi7rzzTnm93rOeo6CgQC6XSzNnzvRrLykp0dKlS1tRPQAA6EoceTBjfX29Fi5cqBUrVvjagoKClJ2drX//939X7969tX37ds2YMUP79+/Xa6+9FvAcJSUlev755zV06NCT9vXu3Vu9evVq1WcAAABdhyMrREVFRXK73Ro5cqSvLTo6Wrfffrsuu+wy9evXT2PGjNEdd9yhNWvWBDz+oUOHNGnSJL3wwguKjo5uy9IBAEAX5EggWrNmjdLT00/bZ/fu3Vq2bJmuvfbagMefMWOGsrKyNHbs2LMtUY2NjfJ6vX4bAADomhwJRFVVVUpISDjlvokTJyo8PFznn3++IiIi9OKLLwY09pIlS/TVV18pPz+/VTXm5+crMjLStyUmJrZqPAAA0HE5EogaGhoUFhZ2yn1//OMf9dVXX+ndd9/VX//6V82aNavF4+7atUt33323Xn311WbHb6nc3FzV1dX5tl27drVqPAAA0HE5clF1TEyMamtrT7kvPj5e8fHxGjhwoHr16qVRo0Zpzpw56tOnzxnH3bBhg/bu3au0tDRf27Fjx7R69Wr9x3/8hxobGxUcHNyiGt1ut9xud8s+EAAA6NQcCUSpqal65ZVXztivqalJ0vHreVpizJgx2rJli1/b5MmTNXDgQN13330tDkMAAMAujgSizMxM5ebmqra21ncXWFFRkfbs2aPLL79cPXr0UFlZmXJycnTVVVf5nlV0Jj179tSQIUP82n7xi1/ovPPOO6kdAADgBEeuIUpJSVFaWpoKCwt9bd27d9cLL7ygq6++WoMGDdI999yjX//613rvvfd8fSorK+VyuVRcXOxA1QAAoKtyZIVIkubOnaucnBxNmzZNQUFBGj16tD7//PPTvqeiokJRUVEaNmxYi+chPAEAgDNxLBBlZWVp27Ztqq6ubvEt7UVFRZo9e3arH7aYnJysHTt2tGoMAADQdbiMMcbpIs61qqoqHT16VJLUv39/BQWd+cyh1+s9/jyimYUKcoe3d4kAAHQKlQVZTpdwWif+ftfV1SkiIqLZfo6tEDmpX79+TpcAAAA6EMe+7R4AAKCjIBABAADrWXnKrDVKH8w87TlIAADQ+bBCBAAArEcgAgAA1iMQAQAA6xGIAACA9QhEAADAegQiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOsRiAAAgPUIRAAAwHoEIgAAYL0QpwvobIbMW6Egd7jTZQAA0GVUFmQ5XQIrRAAAAAQiAABgPQIRAACwHoEIAABYj0AEAACs51gg2rdvn2JjY1VZWXnO505KSpLL5ZLL5dKBAwfO+fwAAKBjcSwQ5eXlKTs7W0lJSZKkTZs2aeLEiUpMTFT37t01aNAgPf300wGPu2DBAg0dOlQRERGKiIhQRkaGPvjgA78+JSUlWrp0aVt8DAAA0AU48hyi+vp6LVy4UCtWrPC1bdiwQbGxsXrllVeUmJiozz//XNOnT1dwcLDuvPPOFo99wQUXqKCgQJdccomMMXr55ZeVnZ2tjRs3Kjk5WZLUu3dv9erVq80/FwAA6JwcCURFRUVyu90aOXKkr23KlCl+ffr376+1a9dq2bJlAQWi66+/3u91Xl6eFixYoC+++MIXiAAAAH7OkUC0Zs0apaenn7FfXV1dq1Zyjh07pjfffFOHDx9WRkZGQO9tbGxUY2Oj77XX6z3rOgAAQMfmSCCqqqpSQkLCaft8/vnneuONN/T+++8HPP6WLVuUkZGhH3/8UT169NDbb7+twYMHBzRGfn6+HnzwwYDnBgAAnY8jF1U3NDQoLCys2f2lpaXKzs7WvHnzNG7cuIDHHzBggDwej9atW6fbb79dt9xyi8rLywMaIzc3V3V1db5t165dAdcBAAA6B0dWiGJiYlRbW3vKfeXl5RozZoymT5+uBx544KzGDw0N1cUXXyxJSk9PV0lJiZ5++mk9//zzLR7D7XbL7Xaf1fwAAKBzcWSFKDU19ZQrNmVlZRo9erRuueUW5eXltdl8TU1NftcDAQAA/JwjgSgzM1NlZWV+q0SlpaUaPXq0xo0bp1mzZqmmpkY1NTX6/vvvAxo7NzdXq1evVmVlpbZs2aLc3FwVFxdr0qRJbf0xAABAF+FIIEpJSVFaWpoKCwt9bW+99Za+//57vfLKK+rTp49vu/zyy319Kisr5XK5VFxc3OzYe/fu1c0336wBAwZozJgxKikp0YoVK/SrX/2qPT8SAADoxBx7UvXcuXP19NNPq6mpSZI0f/58GWNO2n7+1R4VFRWKiorSsGHDmh134cKFqqysVGNjo/bu3auPPvqIMAQAAE7LkYuqJSkrK0vbtm1TdXW1EhMTW/SeoqIizZ49W9HR0a2aOzk5WTt27GjVGAAAoOtwGWOM00Wca1VVVTp69Kik40/EDgo680KZ1+tVZGSkEmcWKsgd3t4lAgBgjcqCrHYb+8Tf77q6OkVERDTbz7EVIif169fP6RIAAEAH4tg1RAAAAB0FgQgAAFjPylNmrVH6YOZpz0ECAIDOhxUiAABgPQIRAACwHoEIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9nlTdQsYYSce/NRcAAHQOJ/5un/g73hwCUQvt27dPkpSYmOhwJQAAIFAHDx5UZGRks/sJRC3Uq1cvSdLOnTtP+wNFx+D1epWYmKhdu3bx3XOdAMer8+GYdS42Hy9jjA4ePKiEhITT9iMQtVBQ0PHLrSIjI637z9SZRUREcLw6EY5X58Mx61xsPV4tWcjgomoAAGA9AhEAALAegaiF3G635s2bJ7fb7XQpaAGOV+fC8ep8OGadC8frzFzmTPehAQAAdHGsEAEAAOsRiAAAgPUIRAAAwHoEIgAAYD0CUQs899xzSkpKUlhYmEaMGKH169c7XVKXtHr1al1//fVKSEiQy+XSO++847ffGKO5c+eqT58+6t69u8aOHatt27b59dm/f78mTZqkiIgIRUVFaerUqTp06JBfn82bN2vUqFEKCwtTYmKiHnvssZNqefPNNzVw4ECFhYUpJSVFRUVFbf55O7P8/Hxdfvnl6tmzp2JjY/X3f//32rp1q1+fH3/8UTNmzNB5552nHj166De/+Y327Nnj12fnzp3KyspSeHi4YmNjlZOTo59++smvT3FxsdLS0uR2u3XxxRdr8eLFJ9XD7+iZLViwQEOHDvU9mC8jI0MffPCBbz/Hq2MrKCiQy+XSzJkzfW0cszZmcFpLliwxoaGhZtGiRaasrMxMmzbNREVFmT179jhdWpdTVFRk/u3f/s0sW7bMSDJvv/223/6CggITGRlp3nnnHbNp0ybz61//2lx44YWmoaHB12f8+PFm2LBh5osvvjBr1qwxF198sZk4caJvf11dnYmLizOTJk0ypaWl5vXXXzfdu3c3zz//vK/PX/7yFxMcHGwee+wxU15ebh544AHTrVs3s2XLlnb/GXQWmZmZ5qWXXjKlpaXG4/GYv/u7vzN9+/Y1hw4d8vX5wx/+YBITE82qVavMl19+aUaOHGmuvPJK3/6ffvrJDBkyxIwdO9Zs3LjRFBUVmZiYGJObm+vrs2PHDhMeHm5mzZplysvLzbPPPmuCg4PN8uXLfX34HW2ZP/3pT+b999833377rdm6dauZPXu26datmyktLTXGcLw6svXr15ukpCQzdOhQc/fdd/vaOWZti0B0BldccYWZMWOG7/WxY8dMQkKCyc/Pd7Cqru9vA1FTU5OJj483jz/+uK/twIEDxu12m9dff90YY0x5ebmRZEpKSnx9PvjgA+NyuUx1dbUxxpj//M//NNHR0aaxsdHX57777jMDBgzwvf7d735nsrKy/OoZMWKEue2229r0M3Yle/fuNZLMp59+aow5fmy6detm3nzzTV+fr7/+2kgya9euNcYcD8BBQUGmpqbG12fBggUmIiLCd3z+9V//1SQnJ/vNdcMNN5jMzEzfa35Hz150dLR58cUXOV4d2MGDB80ll1xiVq5caa699lpfIOKYtT1OmZ3GkSNHtGHDBo0dO9bXFhQUpLFjx2rt2rUOVmafiooK1dTU+B2LyMhIjRgxwncs1q5dq6ioKF122WW+PmPHjlVQUJDWrVvn63PNNdcoNDTU1yczM1Nbt25VbW2tr8/P5znRh2PevLq6Okn/9yXIGzZs0NGjR/1+jgMHDlTfvn39jldKSori4uJ8fTIzM+X1elVWVubrc7pjwe/o2Tl27JiWLFmiw4cPKyMjg+PVgc2YMUNZWVkn/Vw5Zm2PL3c9jR9++EHHjh3z+88kSXFxcfrmm28cqspONTU1knTKY3FiX01NjWJjY/32h4SEqFevXn59LrzwwpPGOLEvOjpaNTU1p50H/pqamjRz5kxdddVVGjJkiKTjP8vQ0FBFRUX59f3b43Wqn/OJfafr4/V61dDQoNraWn5HA7BlyxZlZGToxx9/VI8ePfT2229r8ODB8ng8HK8OaMmSJfrqq69UUlJy0j5+x9oegQhAq8yYMUOlpaX67LPPnC4FZzBgwAB5PB7V1dXprbfe0i233KJPP/3U6bJwCrt27dLdd9+tlStXKiwszOlyrMAps9OIiYlRcHDwSVft79mzR/Hx8Q5VZacTP+/THYv4+Hjt3bvXb/9PP/2k/fv3+/U51Rg/n6O5Phzzk915551677339Mknn+iCCy7wtcfHx+vIkSM6cOCAX/+/PV5neywiIiLUvXt3fkcDFBoaqosvvljp6enKz8/XsGHD9PTTT3O8OqANGzZo7969SktLU0hIiEJCQvTpp5/qmWeeUUhIiOLi4jhmbYxAdBqhoaFKT0/XqlWrfG1NTU1atWqVMjIyHKzMPhdeeKHi4+P9joXX69W6det8xyIjI0MHDhzQhg0bfH0+/vhjNTU1acSIEb4+q1ev1tGjR319Vq5cqQEDBig6OtrX5+fznOjDMf8/xhjdeeedevvtt/Xxxx+fdBoyPT1d3bp18/s5bt26VTt37vQ7Xlu2bPELsStXrlRERIQGDx7s63O6Y8HvaOs0NTWpsbGR49UBjRkzRlu2bJHH4/Ftl112mSZNmuT7N8esjTl9VXdHt2TJEuN2u83ixYtNeXm5mT59uomKivK7ah9t4+DBg2bjxo1m48aNRpJ58sknzcaNG01VVZUx5vht91FRUebdd981mzdvNtnZ2ae87T41NdWsW7fOfPbZZ+aSSy7xu+3+wIEDJi4uztx0002mtLTULFmyxISHh590231ISIh54oknzNdff23mzZvHbfd/4/bbbzeRkZGmuLjYfPfdd76tvr7e1+cPf/iD6du3r/n444/Nl19+aTIyMkxGRoZv/4lbgseNG2c8Ho9Zvny56d279ylvCc7JyTFff/21ee655055SzC/o2d2//33m08//dRUVFSYzZs3m/vvv9+4XC7z4YcfGmM4Xp3Bz+8yM4Zj1tYIRC3w7LPPmr59+5rQ0FBzxRVXmC+++MLpkrqkTz75xEg6abvllluMMcdvvZ8zZ46Ji4szbrfbjBkzxmzdutVvjH379pmJEyeaHj16mIiICDN58mRz8OBBvz6bNm0yV199tXG73eb88883BQUFJ9VSWFhoLr30UhMaGmqSk5PN+++/326fuzM61XGSZF566SVfn4aGBnPHHXeY6OhoEx4ebv7hH/7BfPfdd37jVFZWmgkTJpju3bubmJgY8y//8i/m6NGjfn0++eQTM3z4cBMaGmr69+/vN8cJ/I6e2ZQpU0y/fv1MaGio6d27txkzZowvDBnD8eoM/jYQcczalssYY5xZmwIAAOgYuIYIAABYj0AEAACsRyACAADWIxABAADrEYgAAID1CEQAAMB6BCIAAGA9AhEAALAegQgAAFiPQAQAAKxHIAIAANYjEAEAAOv9P32DqVfhUEyVAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "pd.cut(dj, bins).value_counts().plot.barh()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e81ae870",
   "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": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ed204449",
   "metadata": {},
   "outputs": [],
   "source": [
    "jjr_zongjia = data.groupby('xingming')['cjzongjia'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "a2c14062",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "xingming\n",
       "丁林冲    23269.80\n",
       "丁海军    18387.80\n",
       "丛艳菊    25195.50\n",
       "丛龙均    12055.58\n",
       "乔俊萍    16466.40\n",
       "         ...   \n",
       "齐树奎    11509.70\n",
       "齐浩     12488.00\n",
       "齐红卫    15641.80\n",
       "龙天吉    13063.80\n",
       "龙运江    11291.05\n",
       "Name: cjzongjia, Length: 1524, dtype: float64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jjr_zongjia[jjr_zongjia>10000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "084b9f0b",
   "metadata": {},
   "outputs": [],
   "source": [
    "bk_jjr_zongjia = data.groupby(['bankuai','xingming'])['cjzongjia'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "13d0411a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "bankuai  xingming\n",
       "CBD      李铁岗         14532.08\n",
       "         王东学         10232.70\n",
       "         王辰          12742.00\n",
       "七里庄      乔俊萍         16466.40\n",
       "         刘淼          11794.60\n",
       "                       ...   \n",
       "黄村北      陆新田         16453.98\n",
       "         陈盼          10758.20\n",
       "黄村火车站    王增强         17893.80\n",
       "龙泽       宋瑶          18462.00\n",
       "         王明旭         13067.00\n",
       "Name: cjzongjia, Length: 1448, dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bk_jjr_zongjia[bk_jjr_zongjia>10000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fb4fba52",
   "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": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "df19adef",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_nx = data.pivot_table('cjzongjia', index='xingming', columns='congyenianxian', aggfunc='sum')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "6d60d41f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Axes: >"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAGFCAYAAADTpKXkAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy88F64QAAAACXBIWXMAAA9hAAAPYQGoP6dpAABD+0lEQVR4nO3dd3hUZaIG8PdMS++9kA4JJISAIFWxUAULikhxFV3wild0FesurLpyXV1RVrnZdRdXI3cVUVhBRQSkC9IMJUBogYRUQnqbZNq5fwQjgQDJZJJvzsz7ex4eSOacmTcQ5s35zjnfJ8myLIOIiKiDVKIDEBGRMrFAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzCAiEiIquwQIiIyCosECIisgoLhIiIrMICISIiq7BAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzCAiEiIquwQIiIyCosECIisgoLhIiIrMICISIiq7BAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzCAiEiIquwQJxcSUkJBg0ahL1794qOQkQKwwJxchkZGWhsbET//v1FRyEihWGBKNC4ceOQkZFx3e3uuusuSJLU8mvUqFGtHq+rq8O7776LyspK9O/fHykpKYiNjUVycjJSUlLQq1cvREZGYsWKFV30lRCRkmlEB6CO+fTTT7F+/XpMnTr1utvu378fWVlZiIyMBABotdpWj7/yyisYNmwYVq9e3fI5X19fbNy4EQkJCTbNTUSOhwWiIBUVFZg3bx4SExOvu21hYSFkWUZKSkqbj2dmZiI9PR2ZmZm2jklEToJDWAoyb948TJo0CUOGDLnutnv37oXZbEZkZCQ8PDwwdepUVFZWAgAqKysxefJk/Pa3v0WfPn3a3F+WZZhMJjQ1Ndn0ayAix8EjEIXYsmULNm3ahKNHj2Lu3LkAgAEDBuDMmTNXbLts2TIcP34c/fr1w6JFi6BSqTBr1iy8/PLL+OCDD+Dl5YW33noLo0ePhlarRUJCAtRqNQCgtrYW48ePh1arhdlsRlpaGs+BEFGbJFmWZdEh6NoaGxuRmpqKxYsXY8KECZg5cyZuueUWjB49Gkaj8Yrtg4OD4e7u3upz27dvx7333ouysrJWn/f09ERubi4CAwMBNJ8D2b9/P8+BENF18QhEAV5//XUMGjQIEyZMaPX5iIiIdj9HcHAwysvL0dTUBJVKBVmWodFoWo48rsZiscBgMMDFxQWSJFmVn4gcE49AFCA2NhYXLlyARtPc9w0NDdBoNJg5cyb+9re/tbnPAw88gLlz52LEiBEAgI8//hgvv/wySkpK8N5772HJkiXQaDQtz/mL7OxsxMfHQ6fTAWguEJPJhC1btnSosIjI8bFAFKCgoAAmk6nl4+eeew5DhgzBzJkzW4aeLrdw4UKsWbMGixcvRllZGR5//HHMmTMHr7zyyjVfi0NYRNReHMJSgF/u4/iFp6cnAgMDr1oeAPDiiy/i7NmzGDduHLy8vPDEE0/g97///XVfy2w2w2w2dzozETk+HoFQKxqNBgcOHEDfvn1FR7GabLHAXF0Nc2UVzFWVMFdVwVxZ2fyrphay2QSYLYBsgWy2ABYLZIsZsMgtv0MlQe3hAZWnF1RenlB7erb+s5cXVJ6eUPv6QnVxuI/I2bBASHEsDQ0wnDsHQ24uDLl5MOTlwZifD1N5+cWSqAEslu4JI0lQBwZAFxEJbUREq1+6yAhow8MhsWDIQbFAyG6Zysqgz8qC4cyZVmVhKi0VHa39JAmaoCDoYmLgkpgI16REuCQmwaVnAlQuLqLTEXUKC4TsgqWxEY3HjkF/6DD0hw+h8dBhGIuKRMfqMpKLC/70Wk/EBSYiJTAFyQHJSPJPglatvf7ORHaCBUJCGAoK0bBvX0tZNJ48CVxypZnDi4/GlCmFrT7lpnFDv6B+GBQ6CDeG3ojkwGRoVSwUsl8sEOoWFoMBDfv2oX77DtRt3w7D2bOiIwlVffsAzL7x8DW3cdO4oX9wfwwKHYRBoYPQN7AvVBKnryP7wct4qcsYCgpRv2M76rZtR/3evZAbGkRHsht5odeeAQAA9CY9dhXtwq6iXQAAf1d/3Bx5M27rcRuGhg+Fq8a1q2MSXROPQMim9IcOoeb79ajbtg2GNiZ6pGb/ntsbX3uesnp/N40bhoYNxa1Rt+KWyFvg6+pru3BE7cQCoU5rOnUK1d+uRc1338GYny86jv2TJPzXC56oVOlt8nRqSY0bQm7AxLiJGBMzBh5aD5s8L9H1sEDIKqayMlR/8y2qV69G04kTouMoihQVgftnnO+S53bTuOH2qNtxV/xdGBw2mOdMqEuxQKjdZIMBtVu2ovqrr1D344/OddWUDdWNTMOjw450+euEeoRiYtxE3BV/F2J9Yrv89exZSUkJ7rzzTqSnp+PGG28UHcdh8CQ6XZepshJVn3+Oys+Ww3Thgug4ipcf1j13ppfUl+DDrA/xYdaHGBgyEA/2fhC3Rt1q90clVVVVOHHiBHr16gU/Pz+bPGdGRgYaGxvRv39/mzwfNeMRCF1V06lTqFi2DNVffwOZS9vazJdPJONLHzHDfhGeEZiWNA339rwXXjovIRmu5csvv8Ts2bPRo0cPnDlzBhkZGbj//vvbvf+4ceMwdepUzJw5s+VzdXV1iIuLg06ng6+vLwCgvr4e7u7ukCQJBoMBDQ0NeOedd/DAAw/Y+CtybCwQakWWZdTv2IGKjE9Qv2uX6DgO6akXfFGirhOawV3jjrvi78KM3jMQ4xMjNMsvqqurkZCQgE2bNiE1NRUZGRl49dVXkZub2679P/30Uzz44IP4+OOPWxXIvHnzkJOTg9WrV7d8jssW2AaHsAhA81Qi1avXoGLZMl5+24Wk8FCUqMuuv2EXazA14PMTn2PFiRUYGTkSj/d7HMmByUIz1dTU4K9//StSU1MBAAMGDEB5eXm79q2oqMC8efOQmJjY6vOZmZlIT09HZmamzfMSC8TpyQYDKld8gbJ//gPmC+Lf2BxdfWwIAPv5e5YhY2vBVmwt2IqbI2/GE/2eEFYkPXr0wIwZMwAARqMRixcvxqRJk9q177x58zBp0iTo9b9eGl1ZWYnJkyfjt7/9Lfr06dPmfrIst6yB48LJLTuMBeKkZLMZ1avXoCw93aEnLbQ3RRH2+ya1vWA7thdsx8jIkZiTNgfJAWKK5NChQ7jtttug0+mQnZ2Ne+65B1u3br1iu4ULF+LJJ5/Eli1bsGnTJhw9ehRz585tedzLywtvvfUWRo8eDa1Wi4SEBKjVzTMA1NbWYvz48dBqtTCbzUhLS8OKFSu660t0GDwH4mRkWUbt+vW48P4SDlUJsHpOCj7zPS46RruMjByJJ9KeQJ+Atn967yqyLCMzMxPPPPMMgoODkZ6e3urI4hf+/v7Q6XRITU3F4sWLMWHCBMycORO33HJLq3MgQPMqnrm5uS2rePIciG3wCMSJ1G3bhtL33kPTsWzRUZzWTs8S0RHabVvBNmwv2I474+/E0wOeRrB7cLe8riRJuOGGG/DJJ58gPj4eH374IUJCQtrc9g9/+AMGDRqECRMmXPGY0WiELMvQaDQtRx5XY7FYYDAY4OLiAkmSbPJ1OAMegTgB/eHDOP/WX6D/+WfRUZyaFBSI+2dViY5hFTeNGx5NeRQzk2d22SSO27Ztw7fffou3334bAFBYWIioqChUVlbC29u7zX1iY2Nx4cIFaDTNPws3NDRAo9Fg5syZSExMxJIlS6DRaFoe/0V2djbi4+Ohu7hapMVigclkwpYtWxAREdElX58jYoE4MHN1NUrfXYyqL7/sviVe6aqaBvfFb25T9tFfmEcYfjfgd7gj7g6bP3dxcTGSkpLw9ttvY/z48Zg/fz5KS0uxbt26q+5TUFAA0yUzIjz33HMYMmQIZs6c2TJc1RYOYdmGfd+SSlarWr0aOXdMQNWKFSwPO1Ec6SY6QqcV1xfjxR0v4sHvHsSRMttOxxIWFoaVK1fivffeQ3JyMhoaGrBs2bJr7hMZGYmYmJiWX56enggMDLxmeQBoufKKOodHIA6m6fRplLz6Ghr27xcdhS6z7rF++DjgqOgYNqOSVJieNB1z+8+Fu9ZddJwO0Wg0OHDgAPr27Ss6iqKxQByERa9HWXo6yj9ZBhiNouNQG155LhTZWvu5B8RWIjwj8Mchf8SwiGGio1A3Y4E4gNrNW1Cy8HWYiopFR6GrkPx8cf/jYqcv6Wp3xd+FFwa9AB8XH9FRqJvwHIiCWRoaUDR/PgqeeILlYecMceGiI3S5r3O+xl2r78K6s1c/6U2OhQWiUPqsLJyddC+qV64SHYXa4Xykc6wSWNFYgRe2v4DfbfkdqhqrRMehLsYCURjZYkHZ3/+O3GnTYcjLEx2H2ulEkHMtvrXp3Cbc9/V92F28W3QU6kIsEAUxFBQi7zcP4cJ773M1QIXZ4+N8C3GV6kvx2IbH8M7+d2C08MIOR8QCUYjqr7/G2Xvu4d3kCiR5eeKQVjlTmNiSDBkZRzPw8LqHUVBbIDoO2RgLxM5Z9HoUPv8Cil54EZY6x76Kx1GZ4iIhO/n0SlllWZjyzRR8n/u96ChkQywQO2YsLETutOmo+eYb0VGoEy70sL+lY0WoNdbi+W3P453978Aic3YER8ACsVMN+/bh7P1T0HRcGVN/09WdCuGb5aUyjmbgiR+eQI2hRnQU6iQWiB2qXL4ceY/+FuaKCtFRyAb2e7dvWVZnsrNoJ6avnY4zVVyTRslYIHZENhpR/MqrKHntT5yOxEFIbq7Y58IVH9uSV5OH6d9Nx5ZzW0RHISuxQOyEqbwceTMfaZ49lxyGOa4HTBKHsK6m3liPp7c8jQ8OfSA6ClmBBWIHGrOzcfb++3mJrgMqj+K8UNcjQ0b6wXT84cc/wGTh/U1KwgIRrGHfPuT95iHOZeWgzrS9Eiu14eucr/HU5qegN125/jnZJxaIQLVbt+Lc7Md4f4cD+9m3UnQERdlRuAOzNsxCdVO16CjUDiwQQaq/XYuCuU9BbmwUHYW6ilaLn1x593VHHb5wGA+tewgl9c55976SsEAEqPz8cxS98AKvtHJwclwPNElcNtUaZ6rPYMZ3M3C68rToKHQNLJBuVvaPf6Lk1de4TrkTqIr2Ex1B0UobSvHw9w/bfO11sh0WSDcqXbQIFxYvFh2DusnZEP736qwaQw0e2/gYjpY7zlryjoTf4d1AlmUUv/oqyj/8l+go1I0O+PFEsC3UGmrx2IbHkF2eLToKXYYF0g1K33wLVZ/zBkGnotFgpztPoNtKjaEGszfOxvEKzg1nT1ggXexCejoqPvlEdAzqblERqJMMolM4lOqmaszeMBsnKk6IjkIXsUC6UMWy/0PZkv8VHYMEqIkJEB3BIVU1VWHWhlksETvBAukiVV+txvk//1l0DBLkXKhadASHVdVUhf/a+F/Ir80XHcXpsUC6QM3GjSiePx+QZdFRSJBD/rWiIzi08sZyzPlhDiobeae/SCwQG6vftQtF854DzLyBzGlJEn704BTuXS2vJg9Pbn4SjSbO5iAKC8SG9AcPIv/JuZANPHnqzKTIcJSrGkTHcAqHLxzG89ufh9nCH9hEYIHYiKGgAPlznoDcwDcOZ1cXGyQ6glPZmr8V/7Pnf0THcEosEBsw19WjYM4cmCs5HktAfrhOdASn8+XJL/GPQ/8QHcPpsEA6SbZYUDRvHppOcdI3apYVUC86glP634P/i/W560XHcCoskE4q/Oe/Ubdtm+gYZEd4Al2cBTsX4FTlKdExnAYLpBNO7CnB2mNRqB01U3QUshNSWAiK1byEVxS9SY/fbfkdagw1oqM4BRaIlS6cq8XWfx+HyWDBPvMglEx5DbIkiY5FgjXEcQ1b0c7VnsNL21+CReaSCV2NBWIFfZ0B6z7Igsl48RtUBo6VBuL0tCWwePoKzUZiFYa7io5AaF4aN/1guugYDo8F0kGyLGPjR8dQW3HlzUv5RRIOjX0LxtgUAcnIHhwL5E1t9mLp4aXYdG6T6BgOjQXSQQd/yEf+sYqrPl5ZbsK+3k+iYdg93ReK7MYuz2LREegiGTL+8OMfkF/DObO6CgukAy6cq8XuNTnX3a6xwYy9rmNQfs9z3ZCK7IUU6I8zGt4LZE/qjfV46ceXYLKYREdxSCyQdjI2mbHhX0dhMbVvgkSLRcahqljkTX8Hso7j4s6gMS5cdARqw+ELh/HBoQ9Ex3BILJB22rHiJKrOd3yakpwiVxyd9FeYQqK7IBXZk5JId9ER6Co+zPoQB0oPiI7hcFgg7XBq/3lk77J+bLv0vBk/D/49mlJvtmEqsjfZgU2iI9BVmGUzXt7xMuoMdaKjOBQWyHXUlOux9dPOr35WX2PCnpBpqBnzWxukInu026tUdAS6hsK6Qizcs1B0DIfCArkGWZaxKSMbBr1tTsCZjBbsNwxA8QMLIau4Yp0jkXx9cEx3QXQMuo61Z9Zi7Zm1omM4DBbINRz7sQhFp6ps/rzZ5/1waur7sHhz3WxHYYiPEB2B2unPe/+MisarX4pP7ccCuYr66ib89NX1L9m1VkERcHD0n2GIT+2y16DuUxrpIToCtVN1UzX+su8vomM4BBbIVexYcRJNDV177XhVuRH7ej2BhuH3dunrUNc7EcT7DJRk7Zm12FW4S3QMxWOBtOHs4TLkZHbPeHaT3ow9LrejbNIL3fJ61DX2epeJjkAd9Kfdf4LepBcdQ9FYIJcxNJqwfXnnr7rqCNkCHK6MRu70xZBd3Lr1tanzJE8PHNBxChOlKawrxN8P/l10DEVjgVxm95ozqKsUcz3/mSIdjtyzGOawWCGvT9YxxUdC5kz+ivR/x/4PxyuOi46hWCyQS5w/W4MjWwuEZrhw3ox9A19CY9ptQnNQ+5VFeouOQFYyySa8tus1rh1iJRbIJXZ8cRJy+6a66lINtSbsCbof1eMeEx2F2uF0MN98lOxI+RGsOb1GdAxFYoFcdPrnUpw/az/LYJqNFvzc2A9FU9/gTYd2br8v7ylQuvcPvI8GY8fnunN2LBAAZpMFP63uuns+OuN4iQ9OPrAEZr9g0VGoDZKrK/a4FIqOQZ1Upi/D0qylomMoDgsEQNbWAtRcsN/L+QqLZRy8dSEMPQeIjkKXMcdFwiRxCEvpotzDkHpiC1At9hyo0jh9gTTWG7F/Xa7oGNdVXWHE3vjHUHfzFNFR6BIVUb6iI1An+Oi88aJnH6zOzsStJ7YAmznZYkc4fYHsX5eLpnpl3EVsaDRjn3okLtz7sugodNGZUNEJyBpalRYP+aZi7bkCPJj1PbQWY/MDh1cAJVliw3WA0WjEkCFDsHatmAkinbpAasr0yBJ82W5HyTKQVRGJM9Pfg8WV8y+JlulTJToCddBov2SsqTLj+QPfwkdf1fpB2QJsfEVIrrZUVVVhz549qKxse6nkVatWITc3F8OHD+/mZM2cukB2rznT7iVq7U1ukQZH7noXpogE0VGcl1aLXW7K+gHEmaV6x2GZKQDvZq5Dj/Lcq2+YswnI32fT116zZg3i4uKg0WiQlpaG7Ozs6+7z5ZdfIiYmBrNmzUJkZCS+/PLLVo9bLBYsXLgQsixjxIgRSElJQXx8PHr37o2UlBQkJSUhKioKixYtsunXcilJlu3hzofuV3W+AZ+9utsu7vvoDHdPDdKKVsI1c6PoKE5H7hWLB+7LFx2DriPCPQRPmz0w7vg2SGjnf/ieY4AZX15/u3bIycnBoEGD8MEHH2DkyJGYO3cuCgsLsXPnzqvuU11djYSEBGzatAmpqanIyMjAq6++itzc3JZtlixZgo8++giZmZmQpOapENLS0rBo0SKMGjXKJtmvx2mPQDI35Cm+PACgoc6EPf6TUHXHE6KjOJ2qaH/REegavLSeeMYrGV8fP4zxx7e2vzwA4NQGoMg2a6hnZ2fjzTffxJQpUxASEoI5c+bgwIFrP3dNTQ3++te/IjW1ebmHAQMGoLy8vOXx/Px8LFiwAG+++WZLeYjglAVSW9GIE7tLRMewGbNJRmZDMgqnvQlZrREdx2nkhjrlfx+7p5E0mOqXirWF5/Ho4XXQma2c2267bYZ+Jk6ciMce+3VWiRMnTqBnz57X3KdHjx6YMWMGgOYT5YsXL8akSZMAAAaDAZMnT8bw4cMxduzYNveXZRkmkwmNjY02+RquximHsHasOInDWxxz7DosTEKv9a9BXXFedBSH9/FTiVjnYZ83oDqrW/x645mCHMSVnrbBs0nAnJ1ASLINnquZwWBAcnIynn32Waxfvx5bt269YpuFCxfiySefBAAcOnQIt912G3Q6HbKzs+Hr6wtZlrFx40YkJCRg7NixkGUZrq6uAJqHy0JCQuDu7g6z2YzAwMBrDpV1ltMViL7WgGW/3wWT0XFv/vL20yI1eyl0x217IpAuoVZj9vNuqJa69ic8ap/eXtF4rqYRN+ba+Hu+zz3AlE9s9nQvv/wy1q1bh3379qGiogJ6/ZU3MPv7+8Pbu3mCTlmWkZmZiWeeeQbBwcFYuXJlq21TUlKQkZGBgQMHAuj+cyBON95xcFO+Q5cHANRUGrEn+lH0D+0Jz62fiY7jmKLCUS1xDRDRgl0D8RT8cGfWFqi6Ykbd7K+BCyeAoMROP9XmzZuRnp6O3bt3Q6vVIiQk5Lr7SJKEG264AZ988gni4+NRVVUFT09PmM1maLVaqNXXnifPYrHAaDRCq9VCpbL9kKtTDeI26U3Cp2vvLsYmC/ZJw1E6eb7oKA6pJiZIdASn5q5xx397p+DbnOO4O3tT15QH0HxfyE//2+mnOXv2LKZNm4b09HT06dPnuttv27YNzz//fMvHOp0OkiRBpVJhzZo16NOnD3r37g2z2YyZM2ciJSUFKSkpOHHiBGbPnt3ycd++fZGamop9+7pmNMKphrAy1+fhp6+cb8w6OtyM2DXzoaq3n9mGle7I9EH4U7RtrtKh9lNLatzj2wdPntqPwNpuOs+ncQWeOQZ4BFi1u16vx8CBAzF8+HC8++67LZ/38PC46hVUxcXFSEpKwttvv43x48dj/vz5KC0txbp16675WryMt4vIFhlHdzjnrKl5RWpk3fE2TD06fxhOzQ7714mO4HSG+Sbii3oXvJq5tvvKAwBMjcDPH1u9+4YNG3Ds2DEsXboUXl5eLb/y8vKuuk9YWBhWrlyJ9957D8nJyWhoaMCyZcuu+1pmsxlms9nqrB3lNOdAzh2rQE2Z857wLL9gwr7UZ5EWtgZue78THUfZJAk/ehSJTuE0Ejx7YF6DBSMOCLxZdt+/gOG/A6y4TP7uu++GNQM9o0ePxtGjRzu0j16vh8Fg6PBrWctpCuTIduc8+riUvt6EPV4T0W9iPPy+XSI6jmJJkWEoU5WKjuHwAlz88N/qYNx7ZDPUcvf9VN2m2iLgxFqgz91ic1zH6dO2uHy5/ZxiCKu2ohF5R8qvv6ETsJhlHKhLQv60v8Ci0YmOo0h1sVzcqyu5ql0w26cvvjubg/uPbhRfHr/Y96HoBHbHKQrk2I9FkC1Oc61Au5wq9sDxye/BHBAmOoriFIRrRUdwSBIk3OnXF9+UNeCpg2vh3mRn55nObgfKTolOYVccvkAsZguyd3K8ui0lJRZk3vQaDL2HiI6iKFn+XDvb1gb69MTyJi+8kbkWoVV2PNz8c4boBHbF4Qvk7OEy1Fd330klpamtMmJP1MOovf03oqMoxk5P3kBoKzEe4XhfE4WPD25CctER0XGuL2slYLGTITU74PAFcuxHHn1cj7HJgn2WITh//yuQBc7sqQRSaDAK1byfprP8dD542bM3vjq2H7ee+lF0nParKwHObBWdwm44dIHoaw3Iz257JS+6jAwcvRCMnGnvw+LpIzqN3WqI4xq2naFT6fCIb1+szTuH6VnrobEoYznpVg6vEJ3Abjh0geQcuMCT5x10rkiFw+P+AlP09adbcEbF4a6iIyjWOL9krKk04NkDa+HVWC06jvWyvwUM9aJT2AWHLpDT+zmluTUqykzYm/I09IMnio5id44FOu/NqNbq5x2Pf5v88HbmOkRWnBMdp/OM9cDxtaJT2AWHLZD66iYUnaoSHUOxGutN2ON5ByruekZ0FLuyy9NxFiLrapHuoViki8W/D21Bv/xDouPYFoexADhwgeRkljrEkrUiWcwyDtYk4Ny0RbDoXETHEU4V6I/T2grRMeyel9YTz3n1wdfHD2LsiW2i43SNnC1AHWcjcNgCOb2f/7i2crrYDdn3vgdzUKToKELp48JFR7BrGpUGM3xT8V1BCR4+/D20Zge+fF42A9nfiE4hnEMWSF1lI4rPKPgknR06X2LGz8MWoCllhOgowpyPcBcdwW7d5tcHq6uBlw58C98GJzlKO8FJSR2yQE7/XApw+Mrm6qpN2BM+A7WjZoqOIsTxIAf+idpKfbxi8JElGO9lfo/osjOi43Svs9uBplrRKYRyyALJzSoTHcFhmQwW7DMPQvGU15zupsPdXhwW/UWoWxDecE3A54d3YFDeftFxhJBlC2pz9oqOIZTDTedubDKjOIfDV11KBrJLA1E3bQniv54PVV2V6ERdTvLxxhEdC8RD447fusfhN8e2wNWoFx2n28kuPigMGoEfzAPwYXEcBh8JxDtOfMuUwxVI4clKWEwcv+oO+UUS6sa+hZTMJdCeVcA8Rp1giI8A4LwzsaolNe717YMnTu5DYN1x0XG6lcE3Dse9huOr+hR8VhKBpupfB24aT16ALMtXXZrW0TlcgeQfc5ITeHaistyEvb2fRP+w7+G+a7XoOF2mtIen6AjCjPBNwryiPCSccY6b52SVBjVBN2CvdjCWVSRhR4kvcJXbf8rqmnCksAZ9I51z+h/HK5BsFkh3a2owY6/rGPS9JwEBqxeJjtMlTgYpcM6mTurlGYV5dUYMO7BBdJQuZ3H1RWHg8JahqcK89t/3tPVEKQvEEdRWNKKyhGs1iGCxyDhUFYv46e8gauUfIBkca8qPfd7Os6JlkKs/npQCcM+RLVDJFtFxuozBNx7Z3sPwn7pUfFYSDmOVdcNQW09ewNzbe9o4nTI4VIFw+Eq8nCJX1E76K5K2/hma83mi49iE5OGBn3WOvyyAm9oVD3v2xCPHtsLdcFB0HJtrHpoaiD3aG/FJeW/sLPG56tBURxzKr4LeYIabTt35J1MYhyqQcywQu1B63oz6wb9HWu6ncDm8XXScTjPFRUCWHPceB5Wkwp2+fTA35yBCTjvWeQ6Lqx8KAofjB3N/LC2OR3GezuavYbLIOFxQhcFxATZ/bnvnMAUiyzIKT3DtD3tRX2PCnpBpSBvTE94b/iU6TqeURTnu+PZg3154rqQISWcc565qg19PHPMciv/Up2J5SZjVQ1MdkXmOBaJoVecb0FhvFB2DLmEyWrAfA9D7gViEfvkKJIUuBZoT7HjnAeI8I/FsAzDywA+io3SarNKiOngg9mhuREZ5En4q7v7CzzznnD+8OkyBlJzhMqP2Kvu8H2qnvo+Eb/8IVY3yTkbv81Fe5qvxd/HFE5pQ3Hd0szJXA7zI4uaPgoDh2Gjujw+L41Cca/uhqY44wAJRtvNnefe5PSsoAupG/xl9D/4N2pyDouO0m+Tqij2uyj+B7qJ2wYNevTArewc8Gw+LjmOVJr9eF4emUvB5STiMlfZz815ZnQHnyhsQFeBcE246TIGUnOURiL2rKjdib6/HkRa2ER4/rhIdp13MsZEwSbmiY1hNgoTxfsl4+uwRhCvsBLms0qIq+Ebs1gxERllv7Cn2Fh3pmjLPVTpdgTjEZIomgxkVRVyjWAma9Gbs1d2Gskkvio7SLpXRvqIjWG2ATwI+NfrgrczvEF6pjKVkLW4ByIu8C0tD/4ih5qXon/vfmHN6MPZU2Xd5APY/jGU0GjFkyBCsXWu7HyQc4gikrKAOsoXzXymFbAEOV0YhbvpiRK/6PaQm+52U70yI6AQdF+UehmeMOow6uFl0lHZp8kvEUa+hWFmbghUloTBXKvPn2sxzVaIjXNOqVauQm5uL4cOH2+w5lfkvdZnSPOeek1+pzhTpcOTuv8IcFis6ylX97FslOkK7eWu98IJnH6w+fgCjTu4QHeeqZLUOlaHD8V3kM5ji+gESi1/BvSfH4LPicJhl5b4lZRfXQG+wzZWGZWVliI2NRW5ubru2X7NmDeLi4qDRaJCWlobs7OxWj1ssFixcuBCyLGPEiBFISUlBfHw8evfujZSUFCQlJSEqKgqLFnVsKiKHOAK5cI7nP5TqQqkJ+wa+hLSCL+B6YJPoOK1pNNjlViA6xXVpVVpM9e6N/zr+I3z0R0XHaZPFLRDnAoZjgykNHxbHoTRXKzqSzZksMo4UVWNQjH+nnqesrAwTJ05sd3nk5OTgkUcewQcffICRI0di7ty5mDVrFnbu3NmyTXp6OrRaLUpKSlpmDk5LS8OiRYswatQoq7M6RIGUF/L8h5I11JqwJ3Ay0sYnwGfdP0TH+VVsDzRK+aJTXNNov2Q8k5eNHjnfio5yhSb/RBzxGIaVdcn4QsFDUx1x6nxdpwtk6tSpmD59Ovbs2dOu7bOzs/Hmm29iypQpAIA5c+ZgwoQJLY/n5+djwYIFWLFihc2nnXeIAqkq5QSKSmc2WvCzMRWJD7yB8JV/hGQWf49CVbQ/APsskL7ecXiusgYDMteJjtJCVutQGXQjftIMwscXkrC/yEt0pG53urSu08+xdOlSxMbG4umnn27X9hMnTmz18YkTJ9CzZ/PkjgaDAZMnT8bw4cMxduzYNveXZRlmsxkmkwmurq4dyqr4AqmvboKxUZl3ONOVTpz3Qd2U95Hw/atQV4pdATA31P5+Yg53C8bTFi+MP7QVEsRfOGJxC0RewAisN6bhX8WxuOCAQ1MdkXOh8wUSG3vlOcF77rkHW7duveLzCxcuxJNPPtnyscFgwDvvvINnn30WAKDVavH6668jISEBPXv2hCzLLSWRk5ODWbNmwd3dHWazGYGBga2GvdpD8QVSdZ5HH46msFhG3a0L0TfrA+hOZQrLcdDPfs6teWo9MMs1Bg8e2wIXk9ip8hv9k3DEcxi+rE3BypJgpxiaai9bHIG05R//+Af0+iuvVvT3bz1c9sorr8DDwwOzZs0CAEiShDFjxgAAXFxckJGRgYEDBwLgORAALBBHVV1hxN74x5AWthme27/o/gAqFXZ6FHb/615GI2lwn29vPHFiD/zrs6+/QxeQ1S6oDL4Ru9SD8NGFRGQ64dBUexVV67tkaveQkOtfT75582akp6dj9+7d0GqbjwRNJhPMZjO0Wi3U6mtnslgsMBqN0Gq1UKna90OB8guk1H7vIaDOMTSasU89Ein3JSBo1Rvd++JREaiWirv3NS8z0rc3ni3MQZyApWQt7s1DU98b+uOj4hhcOOvcQ1PtJctAXkU9kkK798bHs2fPYtq0aUhPT0efPn1aPr9mzRq88MIL0Gg00Gq1mDlzZstjOTk5mD17Njw8PC5ml2EymbBs2TIMHjy4Xa+r/ALhEYhDk2UgqzwCMdPfQ8x/fg9VY/dccVcbEwhATIEkeUXjudpGDD6wvltft9G/N7I8huKL2hSsPB8CucJ+5ppSknPlDd1aIHq9HhMnTsTdd9+NSZMmoa6ueRjNw8MD9913H+6777429+MQFlggziK3SIO6u95Fn51vQ1N4ustf71x49//XCHYNwFwpAHdlbe6WpWRltQsqggdjl3oQPr6QiMwizy5/TWdwrqJ735M2bNiAY8eO4dixY1i6dGnL58+ePYuYmJir7mc2m2E2d+4CJEUXiMUio6aMQ1jOoqzUhP39n0da6Cq4/ryhS1/rsF/XnAxti5vGDY+4x2Nm9la4Gbr2zcfiHoRc/xH43piGfxXHoJxDUzZnqwKR5fZdZXf33Xe3e9tL6fV6GAyGDu93KUUXiL7WAItZ/KWM1H0a6kzY43cP+k3oCd+16V3zIpKEnR5dP3ylklS4xzcZc0/tR2Bt160IqA9IRpb7EHxRm4JV54M5NNXFuvsIxFqnT3f+SF7xBULOx2ySkWnqg15T30TEl/NtftOhFBGKUvUFmz7n5Yb6JmJecQESu+AEuaxxRUXQYOxUD8RHpYk4WMihqe5UUi32MuvupOgCaahhgTizkyVeqJ3yPnqtfw3qivM2e9662GAAXVMgCZ498GyDBTcd2GjT5zV7BCPXbwTWGdPwcXE0h6YEqmpwnqW1FV0gehaI0ysullE/8nWkZi+F7vg+mzxnQbiLTZ7nUgEufvhvdTDuPbIZatk2MyfoA1Jw2H0IvqhJxn9KgyGXc2jKHlQ2OM/7kqILpKHWeZqerq6m0og90Y+if2hPeG79rNPPdzTAdmPYrmoX/MazF36bvR0eTYc69VyyxhXlwUPwozQQH13ohcMcmrJLTSZLl9xMaI8UXSA8AqFfGJss2CcNR/LkOASvXNip59rlWdLpPBIkTPRLwVNnDiG0E0vJmj1CcNZ/BNY19cNHxTGoPKPo/7JOo0pvgJvOTXSMLqfo78YGnkSnS8gycKQsDNHT30fsmvlQ1Xd8LispJAjn1J1bmnSgT088V3oeyZnWFYc+MAWH3Ibgi5oUfFUaxKEpBaqsNyLMhwVi13gVFrUlr0iNujveRvLud6HJP9GhffVxoQCsK5AYj3A806TFbQc7tjCWrHFDWfAQ7JAG4uPSXsgq8LDq9cl+VDnJeRCFFwjPgVDbyi+YsC/1WaSFrYHb3vbfY1EU0fGfGn11PnhcF44pRzdDa2nf96TZIxRn/Efgu6Y0fFQchWoOTTmUKr1zvDcp+rvWZKP1h8kx6etN2OM1Ef0mJsDv2/fbtU92YPuv4deqtJjh3Ruzj++Atz7rmtvKkC4OTQ3F5zV98DWHphyas1yJpegCMZu6fr4gUjaLWcaBukT0nPYXRHw5HyrTtf9j7/Js3/0kY/2S8bvco4i8xlKyzUNTQ7FDugH/Ku2FoxyachrOci+IsgvEyAKh9jlV7IHaye8hceOfoC5ve5oSKcAfp7Tl13yeVO84PF9RhbSrLCVr9gzDGb8R+K6pH4emnJjocyBGoxE33XQTFixY0Gp9dFtT9He3iUcg1AElJRbU3/Qa+p38GLpjP13xeFNcGIC2r9yKcA/B70zuGHdoa6vPNw9N9cVBtyFYXp2Mb0qDgLIuCE+K0tQF703/+c9/MHDgQERFRV1321WrViE3NxfDhw+3eY5LKbpAzCZOpEgdU1tlxJ4eDyEtLAFem/6v1WMlkVcOMXlpPfGYazSmH90MnbkJACBr3XEhqHlo6sPzvZBd4N4t2Uk5zBbbvjctX74cn3zyCcaPHw8AKCsrw6BBg7Bly5Yrpmy3WCxYuHAhZFnGiBEjADTPvKvT6aBWq2EymdDQ0ICnnnoKzz33XKdyKbpALBzCIis033Q4BMn3xyF45Z8gXZwK+0Tgr8MOGkmDKb59MOf4Lvg2HIPZMxwn/YZjbVM/fFQUhVoOTdE12LJAli9fjmXLluGrr76Cm5sbysrKMHHiROTm5ra5fXp6OrRaLUpKSiBJzRdq2GLxqLYo9n+BbJFhsXHLkxORgaMXglE77X3EfT0fqrpq7PYuBQDc6tcHz+SfRnBNPg4G3I/l6mR8eyGQQ1PUbrYqkOXLl+Pf//43vvrqK7i6ugIApk6diunTp2PPnj1XbJ+fn48FCxZgxYoVLeXRlRRbIDz/QbZwrkiFunF/QUr2UhgDa/CqKRVySRDmVE7G8ToOTZF1zFYs8HS5zz77DMuXL8eqVataygMAli5ditjYWDz99NOttjcYDJg8eTKGDx+OsWPHtvmcsizDbDbDZDK1ek5rSbI1S1nZAYPehKXPbBcdgxyEzk0NnY8WkABIgAS5+c+QAUlu/qMkX/mxBEiwXHyseXtJAmRYWu+D5u3kX54bAGD59TVgadkfEiDJFsho3laWmp9Lli/+DvliPvniSnRy8zwuFz/X8mf8+piMNj4PGbJF/vX15eZMrbZt2ddyxWvJsqX5cfmy7X/5/C/bypdva7n42paLX7Ei34KuKbLvANwx81Gr99+wYQNeffVVbNmyBS4ubc8OLUlSq2VrZVnGxo0bkZCQgLFjx0KW5ZaSyMnJQUhICNzd3WE2mxEYGIidO3dane8Xij0CUWl4ExbZjkFvhkFv7Y2pF1unFcefidVW5IulK6lkSNLFX5Caf1c1byOpLK2KvXm75r0lCc1/ln7d/5fybd5fbrXf5T8ESBcrTCVdLD1c+tyXFu4ln5NlyL88xy8/CMi//hDg7d6jU38nN910E/z8/PDVV19h6tSp7dpHkiSMGTMGAODi4oKMjAwMHDgQAM+BXEGtUYmOQEQ2IEFqPngxSw5zLBIQFdap/d3c3LBq1Srcf//9aGxsxMyZM6+7j8lkgtlshlarhVp97R9gLBYLjEYjtFotVCrr30sVWyCSJEGtUfFudCKyOyp153/AdXV1xapVq/DAAw9Ar9djzpw519x+zZo1eOGFF6DRaKDValuVTk5ODmbPng0Pj+ZL1WVZhslkwrJlyzB48GCrMyq2QABArWWBEJH9UalsM8Su0+nwxRdfYNq0adDr9Xj22Wevuu19992H++67r83HumoIS9HjQGqtouMTkYNSqW13jlar1eLzzz/Hvn37cOTIEauew2w2w2y2/eSzij4C0fA8CBHZIa2LbS+i0Gg0WL58eavPdeQCWr1eD4PB9vNzKbpAeARCRPbI1UMrOkIrp0+f7pLnVfQ7MAuEiOyRi7uifzZvN0W/A+tcea09EdkfFzs7Aukqii4Qd2+d6AhERFfgEYgCuHuxQIjI/ri68wjE7rnxCISI7JCLB49A7B6HsIjIHvEIRAFYIERkbzQ6ldNcIaror5JDWERkbzz9Or/OhlIoukB4Ep2I7I13IAtEETiERUT2xjvATXSEbqPoAtHo1HDzco6TVUSkDF48AlEO3xCuW01E9oNHIArCAiEie8JzIArCAiEie+IdyCMQxfBjgRCRndC5qu1uKveupPgC4REIEdkL7yDnOfoAHKBAvIPcbLb+MBFRZwRGeoqO0K0UXyBqtcqpLpsjIvsV2MNLdIRupfgCAQC/UA/REYiIEMQCUZ6gHs512EhEdkjiEJYihcT6iI5ARE7OO9ANOjfnWAfkF45RIDHeoiMQkZNzxpEQhygQV0+t010+R0T2JTDSuc5/AA5SIACPQohIrEAegSgXC4SIhJGAkFjnew9ynAJxwn88IrIPAeEecPN0vvWJHKZAAnt4QqXmHelE1P3Ce/mJjiCEwxSIRqtGUJTzncQiIvEiWSDKF5nonP+IRCSQBIT38hWdQgjHKpDe/qIjEJGTCYjwdKop3C/lUAUSFucDjc6hviQisnPOOnwFOFiBqLUqhCf4io5BRE7EWYevAAcrEACISg4QHYGInISkkhDe01d0DGEcrkCiU1ggRNQ9whN8nPb8B+CABeIb4s55sYioW8SmBYmOIJTDFQjAoxAi6h5xLBDHE+/k/6hE1PWCorzg5e/cy2k7ZIGE9/SFu4/zzUtDRN3H2Y8+AActEEklIWFAsOgYROTAWCAOWiAAkDAwRHQEInJQviHu8A/3EB1DOIctkNA4b6cfnySirhGXFig6gl1w2AKRJAkJN3AYi4hsr+cgjnAADlwgAJAwkAVCRLYVFOXllOuft8WhCyQ42hs+vKmQiGyo97Aw0RHshkMXCAAkDgkVHYGIHIRaq+Lw1SUcvkD6DA+HSsWlbomo8+LSgpx67qvLOXyBePi6ILYfr5ggos7j8FVrDl8gAJA8MkJ0BCJSOC9/V0QmOe/iUW1xigKJTPSDb4i76BhEpGBJQ0MhSRwOv5RTFIgkSUi+KVx0DCJSKJVKQu/hfA+5nFMUCAAkDQ2DRus0Xy4R2VD8DcGc2aINTvOO6uqh5Y2FRGSV/qOjREewS05TIADQ95ZI0RGISGEik/wQFMU7z9viVAUSHO2NHn38RccgIgVJ49HHVTlVgQDAwPExoiMQkUIERHggOplLZF+N0xVIeE9fhCX4iI5BRArQ73YefVyL0xUIwKMQIro+Dx8det3Iea+uxSkLJCo5AMHRPClGRFfXb1QU1BqnfItsN6f927mBRyFEdBXuPjr05RRI1+W0BRLbL5BrGhNRm24YFwONTi06ht1z2gKRJAmDJsSKjkFEdsbT34VTH7WT0xYIACTcEIzQOF6RRUS/GjQhluc+2snp/5aGT04QHYGI7IR/uAeShnLNj/Zy+gIJjfNBwg2cI4uIgCF3x3EF0w5w+gIBgKGT4qHS8JuGyJmFJfggtl+Q6BiKwgIB4B3ohlROtEjktCQJGHF/T9ExFIcFctHAO2Lg4qERHYOIBOhzUwSCo71Fx1AcFshFLu5aDLqDl/USORs3Ly2G3B0nOoYisUAu0feWCAREeoqOQUTdaOikBLh6aEXHUCQWyCVUahVufTAJEs+nEzmFsAQfJA0NFR1DsVgglwmJ8UbqrT1ExyCiLqZSSRg5LRESf2K0GgukDYPvjoNXgKvoGETUhfreFomACA5ZdwYLpA1aFzVGTk8UHYOIuoinnwtunMiLZjqLBXIV0ckB6DmIi8kQORwJuO03vaFz5WX7ncUCuYabpvTk1RlEDqbvyEj06OMvOoZDYIFcg5uXDjdN5d2pRI7CN8Qdw+6NFx3DYbBArqPXoFAkDuZlfkRKp1JJGPVIHy4UZUMskHa4eVov+AS5iY5BRJ1ww/hohMRwuhJbYoG0g85VgzGzkqFS83pxIiUKjvbCwDtiRMdwOCyQdgqO9sbguzhfDpHSaLQqjHqkD1Rqvt3ZGv9GO6D/mCj06O0nOgYRdcDI6YnwC/UQHcMhsUA6QJIk3D6zD9y8eGkvkRKk3BzBJWq7EAukgzx8XHD7zD6ccJHIzoXEemPEFF6G35VYIFaITg7AYK4fQGS33Ly0GPdYX6g1fIvrSvzbtdIN42I41QmRHZJUEsbOSoGnn4voKA6PBdIJtz2UhOBoL9ExiOgSQ++JR0QiL3bpDiyQTtBo1Rj/eCrcfXSioxARgPgBweg/Jkp0DKfBAukkTz8XjH+cY61EooXEemPUzN6iYzgVvuvZQGisD255kOuHEIniE+yGCf+dynmuuhkLxEaShoRhwNho0TGInI6blxZ3zk2DmyeHkrsbC8SGhk6KR9JQztxL1F00LmpMfLIfJzsVhAViY7c+mISYvgGiYxA5vObLdZMRHM0ZdkVhgdiYSq3C2NkpCI3zER2FyKGNnNYLMX0DRcdwaiyQLqDRqTHxyVQE9vAUHYXIId14ZyySb4oQHcPpsUC6iIu7Fnc9lQa/UHfRUYgcysAJMRg0IVZ0DAILpEu5eelw19Np8ApwFR2FyCEMvCMGg+/kPHT2ggXSxTz9XDFp3gBeJULUSQPviOGibnZGkmVZFh3CGdRXN2HNXw+isrhedBQixWF52CcWSDfS1xnw9XsHUZZfJzoKkWLcMD4aQ+6OFx2D2sAC6WZNDUZ8s+QQzp+tER2FyO7xyMO+sUAEMDSasDb9MIpOVYmOQmSXJAkYMaUnUm/tIToKXQMLRBCTwYx1/8jCuaMVoqMQ2RW1VoXRj/RB/IBg0VHoOlggApnNFmz99ASO7yoWHYXILri4a3DHnFSE9/QVHYXagQViBzLX5+Gn1TkA/yXIiXn6ueDOuWnwD/cQHYXaiQViJ3IyS/HDx8dgMlpERyHqdgERnpj4ZD+uY64wLBA7UppXg7V/O4yGaoPoKETdpkdvP4x9rC9c3DSio1AHsUDsTG1FI9amH0Z5Ie8VIcc3YGw0htwdB0kliY5CVmCB2CFDowkbPzqG3MNloqMQdQmtqxq3P9wb8f15pZWSsUDslCzLOLDhHPasOQOLhf9E5Dj8Qt0x/vG+8AvlyXKlY4HYueLTVdjwr6Ooq2wSHYWo0+L6B+H2h3tD58rzHY6ABaIA+joDfvg4G+eOlouOQmQVSQIG3x2HG8bFiI5CNsQCUQhZlpG5Pg97vj4LmUNapCCe/i4Y/UgfhPf0Ex2FbIwFojBFp5qHtOqrOKRF9q/nwGCMnJ4IF3et6CjUBVggCtRYb8SOL07i5J7zoqMQtUnnpsHND/RE4pAw0VGoC7FAFOzs4TJs+/Q46nnjIdmRyCQ/3PZQb3j5cylnR8cCUbimBiN+/OIUju8uER2FnJxGp8KwexOQMjICksQbA50BC8RB5GaVYeunJ3huhISI7huAmx/oBe9AN9FRqBuxQBxIk96EnStPIXtXMWf2pW7h6e+Cm+7vhbj+QaKjkAAsEAdUcqYaO1acRGlerego5KBUagn9bu+BQRNioXVRi45DgrBAHJQsyzj+UzF+Wn0G+hqeZCfbCe/pi5HTErluB7FAHJ1Bb8L+73JxaEs+LCb+U5P13H10GDYpnpfmUgsWiJOoOt+AnStPITeL06FQx7i4azBgbDRSb42ERsfhKvoVC8TJ5B+rwJ5vzuD82RrRUcjOaXQqpN7aAwPGRvFOcmoTC8RJ5R0tx95vzqI0l0VCralUEnqPCMegCTHw8OESs3R1LBAnl5tVhn3fnuUVWwRJAhIGhuDGO2PhG+wuOg4pAAuEALBInJlGq0LSsDCkjeoBnyAWB7UfC4RayTtajsOb83HuWAVvRnRwrp5a9L0lEn1viYCbp050HFIgFgi1qbKkHllbCnB8dwmMTWbRcciGvIPc0H9UDyQNDeNVVdQpLBC6pia9Cdk7i5C1tQA1ZY2i45C1JCAy0Q8pN0cgLi0IkoqTHVLnsUCoXWSLjNwj5cjaWoCC7Arwu0YZPP1ckDQsDL2HhnGiQ7I5Fgh1WF1lI07sKcGJ3SWoLGkQHYcuo9JIiE0NQp/hYejR259HG9RlWCDUKefP1uDk3hKc+rmUc24JFhzthV43hqLX4BCeFKduwQIhm7BYZBQer8TJ/eeRe7gMjXVG0ZEcnqSSEBbvg7j+QYhLC+IKgNTtWCBkc7JFxvncGuRmlSE3qxzlBXWiIzkMlUZCZKI/4vsHIbZfINy8eKRB4rBAqMvVVTYiN6sceVllKDhRCZPBIjqSovgEuyEi0Q+RiX6ITg6Azk0jOhIRABYIdTOT0YziU9UozqlCcU41zp+t4X0ml/Hyd0VEoi8iE/0QkegHTz8OTZF9YoGQUBaLjPKCupZCKcmpRl2l86zrrtao4B/ugaAengiJ80FELz/4BPFyW1IGFgjZndqKRpTl16K8qB4VRfWoKK5HVUkDzCZlD31pXdUIjPREUA8vBPbwQlCUF/zC3KFWq0RHI7IKC8TOGI1G3HTTTViwYAEmTJjQba9bV1eHhoYGBAcHd9trdoTFIqO6tAEVxc2lUllcj9qKJtRXNaG+ugkWs318G2u0Knj6u8I70BU+Qe7wCXaDT5Ab/ELd4R3oBkniPRnkOHg2zs6sWrUKubm5GD58eIf3XblyJb7//nt8+OGHrT7/8MMPY9q0aRg3btxV983IyMCyZcuwd+/eDr9ud1CpJPiFesAv1APx/Vs/JssyGmoMqK9qQl1lU8vvDbUGGBtNMDaZYWw0w9Bk/vXjJvOVJ/MlQCVJgKr5d0nV/EvnqoaLuxauHhq4eGjh6n7xdw8tXNw1cPXUwtPXFV4BrnD35lVR5DxYIN3sqaeewpIlS1o+jo+Px+nTpwEAFosFCxcuhCzLGDFiBABAr9dDp9NBrVbDZDKhoaEBTz31FJ577jkAwPHjx7F69Wq89NJLGDp0KJ5++mn8z//8D/7whz+0vMaqVatwyy23XDOXi4sL3NyUOfYuSRI8fFzg4eOC4Oj27ydbZFjMMiRV8z0VPDog6hgWSDfbv38/1q5di2HDhgEA1OpfZ0NNT0+HVqtFSUlJy5tZWloaFi1ahFGjRrX5fGfPnsXf//53vPTSS4iIiMDKlStx66234sYbb8To0aNhsVjQ2NiIxMTEa+aSJOd7A5VUEtSc5oPIaiyQbmQymXD06FHcfPPN8PT0bPVYfn4+FixYgBUrVnTojVyr1bbafujQoViwYAE+/fRTjB49GiUlJTCbzejRo0e78lVVVbV8bDabYTab7fa8CBGJxQLpRllZWbBYLEhLS0NhYSFGjhyJf/7znwgNDcXkyZMxfPhwjB07ts19ZVmG2WyGyWSCq+u17wt48cUXW45s8vPz4ebmhoiIiOvm27lzJ/z8/Fp9LiQkBCUlJe38ConImbBAutGxY8eQmJiIJUuWIDAwEM888wwee+wxrFu3Dq+//joSEhLQs2dPyLLcUhI5OTmYNWsW3N3dYTabERgYiJ07d17zdTSaX/9Zjxw5gqSkJKhU179U9KabbsKGDRtaPjYYDDAaOacVEbWNBdKNZsyYgRkzZrR8/Le//Q2xsbGora3FmDFjADSfzM7IyMDAgQMBXP8cyOX++c9/4pFHHoFWqwUA/PDDDy3nW65HpVK1Orq53pEOETk33sEkUHBwMCwWC4qLi9HU1ASLxdLqpHpbLBZLy7aXe/311/H888/j6NGjAICCggKsXr26VWkREdkKj0C60fPPP4/+/ftj+vTpAICffvoJKpUK+/fvxx133AGNRgOtVouZM2e27JOTk4PZs2fDw8MDQPO5EJPJhGXLlmHw4MEt282fPx8ZGRnYuXMnUlJSYLFY8Pjjj6OxsRGbN2/G0KFDu/VrJSLHxwLpRv369cP8+fMREhICs9mMuXPn4qGHHrpiaOtS1xvCamxsRF5eHj777DP8+OOPiImJQU1NDR599FHk5ubi66+/xowZM6DT6fD888935ZdHRE6GBdKNHnzwQRw9ehT33Xcf1Go1HnzwQbzxxhvX3OeXS2mvZv/+/YiJicG2bdsQERGBb7/9Fs888wxCQkKwZcsWBAUFYe3atRgzZgyCg4Px8MMPo6KiArW1tXBxcWl5npqaGhgMhiuuuLJYLDAajYiO7sAdekTkFDgXlp1LSEjA4sWLceedd7b5eFNTE0pLSxEUFIRhw4bhyJEjeOGFF/DHP/4ROt2v02p8/PHHWL58OdavX4833ngDr732WqvHr8ZsNsPb2xvnz5+32ddERI6BBeJAtm7diujoaMTGxrb5uMViadflvERE7cECISIiq/DHUSIisgoLhIiIrMICISIiq7BAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzCAiEiIquwQIiIyCosECIisgoLhIiIrMICISIiq7BAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzCAiEiIquwQIiIyCosECIisgoLhIiIrMICISIiq7BAiIjIKiwQIiKyCguEiIiswgIhIiKrsECIiMgqLBAiIrIKC4SIiKzy/6j18DsNmvivAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.rcParams['font.sans-serif']=['SimHei']\n",
    "(data_nx>10000).sum().plot.pie()  # 布尔值也可以用来计数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ff469557",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "回龙观     6023\n",
       "望京      4122\n",
       "北苑      3254\n",
       "天通苑     3083\n",
       "顺义城     2873\n",
       "        ... \n",
       "三河        11\n",
       "建国门外      10\n",
       "百善镇        9\n",
       "海淀其它       8\n",
       "农展馆        6\n",
       "Name: bankuai, Length: 220, dtype: int64"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.bankuai.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "a532d056",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "162227"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "2387d102",
   "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",
       "    <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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6676</th>\n",
       "      <td>5</td>\n",
       "      <td>夏威夷南岸店</td>\n",
       "      <td>65.0</td>\n",
       "      <td>经纪人</td>\n",
       "      <td>100% 17</td>\n",
       "      <td>12467元/平</td>\n",
       "      <td>福城上上城二季 1室--厅 52平</td>\n",
       "      <td>武晓影</td>\n",
       "      <td>73</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>南/低楼层/18层</td>\n",
       "      <td>签约时间：2015-12-02</td>\n",
       "      <td>1-2年</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6677</th>\n",
       "      <td>4</td>\n",
       "      <td>加州水郡店</td>\n",
       "      <td>193.0</td>\n",
       "      <td>经纪人</td>\n",
       "      <td>95% 21</td>\n",
       "      <td>36156元/平</td>\n",
       "      <td>大宁山庄四区 1室1厅 53平</td>\n",
       "      <td>董玉俏</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南/中楼层/6层</td>\n",
       "      <td>签约时间：2016-10-16</td>\n",
       "      <td>&lt;1年</td>\n",
       "      <td>长阳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6678</th>\n",
       "      <td>4</td>\n",
       "      <td>加州水郡店</td>\n",
       "      <td>295.0</td>\n",
       "      <td>经纪人</td>\n",
       "      <td>95% 21</td>\n",
       "      <td>33909元/平</td>\n",
       "      <td>加州水郡三期 2室1厅 87平</td>\n",
       "      <td>董玉俏</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南 北/高楼层/15层</td>\n",
       "      <td>签约时间：2016-09-24</td>\n",
       "      <td>&lt;1年</td>\n",
       "      <td>长阳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6679</th>\n",
       "      <td>4</td>\n",
       "      <td>加州水郡店</td>\n",
       "      <td>310.0</td>\n",
       "      <td>经纪人</td>\n",
       "      <td>95% 21</td>\n",
       "      <td>21075元/平</td>\n",
       "      <td>加州水郡三期 3室2厅 147平</td>\n",
       "      <td>董玉俏</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>东 南 北/低楼层/14层</td>\n",
       "      <td>签约时间：2016-09-17</td>\n",
       "      <td>&lt;1年</td>\n",
       "      <td>长阳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6680</th>\n",
       "      <td>4</td>\n",
       "      <td>加州水郡店</td>\n",
       "      <td>120.0</td>\n",
       "      <td>经纪人</td>\n",
       "      <td>95% 21</td>\n",
       "      <td>25494元/平</td>\n",
       "      <td>新建巷小区 1室1厅 47平</td>\n",
       "      <td>董玉俏</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>南/中楼层/4层</td>\n",
       "      <td>签约时间：2016-09-14</td>\n",
       "      <td>&lt;1年</td>\n",
       "      <td>长阳</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162227 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      cjtaoshu mendian  cjzongjia zhiwei  haoping  cjdanjia  \\\n",
       "0           37   红莲北里店      251.0    店经理  97% 141  43997元/平   \n",
       "1           37   红莲北里店      159.0    店经理  97% 141  36969元/平   \n",
       "2           37   红莲北里店      257.0    店经理  97% 141  39046元/平   \n",
       "3           37   红莲北里店      243.0    店经理  97% 141  41313元/平   \n",
       "4           37   红莲北里店      372.5    店经理  97% 141  42053元/平   \n",
       "...        ...     ...        ...    ...      ...       ...   \n",
       "6676         5  夏威夷南岸店       65.0    经纪人  100% 17  12467元/平   \n",
       "6677         4   加州水郡店      193.0    经纪人   95% 21  36156元/平   \n",
       "6678         4   加州水郡店      295.0    经纪人   95% 21  33909元/平   \n",
       "6679         4   加州水郡店      310.0    经纪人   95% 21  21075元/平   \n",
       "6680         4   加州水郡店      120.0    经纪人   95% 21  25494元/平   \n",
       "\n",
       "               cjxiaoqu xingming cjzhouqi        biaoqian        cjlouceng  \\\n",
       "0         红莲北里 3室1厅 57平      郭海龙       36  房东信赖;销售达人;带看活跃       南 北/高楼层/6层   \n",
       "1         红莲南里 1室1厅 43平      郭海龙       36  房东信赖;销售达人;带看活跃         南/高楼层/7层   \n",
       "2        常青藤嘉园 1室1厅 65平      郭海龙       36  房东信赖;销售达人;带看活跃        北/低楼层/16层   \n",
       "3         红莲北里 2室1厅 58平      郭海龙       36  房东信赖;销售达人;带看活跃       南 北/高楼层/6层   \n",
       "4       广安门外大街 3室1厅 88平      郭海龙       36  房东信赖;销售达人;带看活跃  东 南 西 北/中楼层/18层   \n",
       "...                 ...      ...      ...             ...              ...   \n",
       "6676  福城上上城二季 1室--厅 52平      武晓影       73            客户热评        南/低楼层/18层   \n",
       "6677    大宁山庄四区 1室1厅 53平      董玉俏        6             NaN         南/中楼层/6层   \n",
       "6678    加州水郡三期 2室1厅 87平      董玉俏        6             NaN      南 北/高楼层/15层   \n",
       "6679   加州水郡三期 3室2厅 147平      董玉俏        6             NaN    东 南 北/低楼层/14层   \n",
       "6680     新建巷小区 1室1厅 47平      董玉俏        6             NaN         南/中楼层/4层   \n",
       "\n",
       "            cjshijian congyenianxian bankuai  \n",
       "0     签约时间：2015-05-24           4-5年     马连道  \n",
       "1     签约时间：2015-05-10           4-5年     马连道  \n",
       "2     签约时间：2015-04-26           4-5年     马连道  \n",
       "3     签约时间：2015-04-04           4-5年     马连道  \n",
       "4     签约时间：2015-04-01           4-5年     马连道  \n",
       "...               ...            ...     ...  \n",
       "6676  签约时间：2015-12-02           1-2年     NaN  \n",
       "6677  签约时间：2016-10-16            <1年      长阳  \n",
       "6678  签约时间：2016-09-24            <1年      长阳  \n",
       "6679  签约时间：2016-09-17            <1年      长阳  \n",
       "6680  签约时间：2016-09-14            <1年      长阳  \n",
       "\n",
       "[162227 rows x 14 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "65cda519",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\luhe\\AppData\\Local\\Temp\\ipykernel_32204\\211611998.py:2: 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['cjdanjia'] = data.cjdanjia.str.replace('元/平','').astype(np.float32).map(lambda x: round(x/10000, 2))\n"
     ]
    }
   ],
   "source": [
    "data = data.dropna()\n",
    "data['cjdanjia'] = data.cjdanjia.str.replace('元/平','').astype(np.float32).map(lambda x: round(x/10000, 2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "34ed9273",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('bankuai')['cjdanjia'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "72124df1",
   "metadata": {},
   "outputs": [],
   "source": [
    "data_1 = data.groupby('bankuai')[['cjdanjia']].mean() # [[]] 返回dataframe [] 返回series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "d4448996",
   "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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>bankuai</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>西四</th>\n",
       "      <td>11.226667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金融街</th>\n",
       "      <td>8.019610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西单</th>\n",
       "      <td>7.344132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>东四</th>\n",
       "      <td>7.110909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>金宝街</th>\n",
       "      <td>7.016438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>良乡</th>\n",
       "      <td>2.055625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>观音寺</th>\n",
       "      <td>2.050459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>阎村</th>\n",
       "      <td>2.039714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>马驹桥</th>\n",
       "      <td>1.977965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>三河</th>\n",
       "      <td>1.726364</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>219 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          cjdanjia\n",
       "bankuai           \n",
       "西四       11.226667\n",
       "金融街       8.019610\n",
       "西单        7.344132\n",
       "东四        7.110909\n",
       "金宝街       7.016438\n",
       "...            ...\n",
       "良乡        2.055625\n",
       "观音寺       2.050459\n",
       "阎村        2.039714\n",
       "马驹桥       1.977965\n",
       "三河        1.726364\n",
       "\n",
       "[219 rows x 1 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_1.sort_values(by='cjdanjia', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "5ca594a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['cjdanjia'], dtype='object')"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_1.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "9672f66c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def top(group, n=5):\n",
    "    return group.sort_values('cjdanjia', ascending=False)[:n]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "a9353e33",
   "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></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",
       "    <tr>\n",
       "      <th>xingming</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">丁丽</th>\n",
       "      <th>26358</th>\n",
       "      <td>11</td>\n",
       "      <td>西潞苑北店</td>\n",
       "      <td>150.0</td>\n",
       "      <td>高级经纪人</td>\n",
       "      <td>100% 58</td>\n",
       "      <td>4.56</td>\n",
       "      <td>西潞苑小区 1室--厅 32平</td>\n",
       "      <td>丁丽</td>\n",
       "      <td>40</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>西/中楼层/4层</td>\n",
       "      <td>签约时间：2016-07-04</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>北关</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26353</th>\n",
       "      <td>11</td>\n",
       "      <td>西潞苑北店</td>\n",
       "      <td>300.0</td>\n",
       "      <td>高级经纪人</td>\n",
       "      <td>100% 58</td>\n",
       "      <td>4.08</td>\n",
       "      <td>西潞苑小区 2室1厅 73平</td>\n",
       "      <td>丁丽</td>\n",
       "      <td>40</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>南 北/中楼层/6层</td>\n",
       "      <td>签约时间：2016-09-27</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>北关</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26354</th>\n",
       "      <td>11</td>\n",
       "      <td>西潞苑北店</td>\n",
       "      <td>295.0</td>\n",
       "      <td>高级经纪人</td>\n",
       "      <td>100% 58</td>\n",
       "      <td>3.64</td>\n",
       "      <td>翠福园 1室1厅 81平</td>\n",
       "      <td>丁丽</td>\n",
       "      <td>40</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>签约时间：2016-09-19</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>北关</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26357</th>\n",
       "      <td>11</td>\n",
       "      <td>西潞苑北店</td>\n",
       "      <td>460.0</td>\n",
       "      <td>高级经纪人</td>\n",
       "      <td>100% 58</td>\n",
       "      <td>3.23</td>\n",
       "      <td>京贸国际公寓 3室2厅 142平</td>\n",
       "      <td>丁丽</td>\n",
       "      <td>40</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>东 南/中楼层/28层</td>\n",
       "      <td>签约时间：2016-08-08</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>北关</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26356</th>\n",
       "      <td>11</td>\n",
       "      <td>西潞苑北店</td>\n",
       "      <td>307.0</td>\n",
       "      <td>高级经纪人</td>\n",
       "      <td>100% 58</td>\n",
       "      <td>3.17</td>\n",
       "      <td>西潞苑小区 2室1厅 96平</td>\n",
       "      <td>丁丽</td>\n",
       "      <td>40</td>\n",
       "      <td>客户热评</td>\n",
       "      <td>南 北/低楼层/6层</td>\n",
       "      <td>签约时间：2016-08-08</td>\n",
       "      <td>5年以上</td>\n",
       "      <td>北关</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">龚振武</th>\n",
       "      <th>27769</th>\n",
       "      <td>28</td>\n",
       "      <td>仓上南门店</td>\n",
       "      <td>344.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 138</td>\n",
       "      <td>3.70</td>\n",
       "      <td>西辛南区 3室1厅 93平</td>\n",
       "      <td>龚振武</td>\n",
       "      <td>34</td>\n",
       "      <td>房东信赖;销售达人</td>\n",
       "      <td>南 北/中楼层/6层</td>\n",
       "      <td>签约时间：2016-09-18</td>\n",
       "      <td>3-4年</td>\n",
       "      <td>顺义城</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27770</th>\n",
       "      <td>28</td>\n",
       "      <td>仓上南门店</td>\n",
       "      <td>259.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 138</td>\n",
       "      <td>3.57</td>\n",
       "      <td>裕龙四区 2室1厅 72平</td>\n",
       "      <td>龚振武</td>\n",
       "      <td>34</td>\n",
       "      <td>房东信赖;销售达人</td>\n",
       "      <td>南 北/中楼层/6层</td>\n",
       "      <td>签约时间：2016-09-02</td>\n",
       "      <td>3-4年</td>\n",
       "      <td>顺义城</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27771</th>\n",
       "      <td>28</td>\n",
       "      <td>仓上南门店</td>\n",
       "      <td>242.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 138</td>\n",
       "      <td>2.91</td>\n",
       "      <td>石园北区 2室1厅 83平</td>\n",
       "      <td>龚振武</td>\n",
       "      <td>34</td>\n",
       "      <td>房东信赖;销售达人</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>签约时间：2016-08-20</td>\n",
       "      <td>3-4年</td>\n",
       "      <td>顺义城</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27772</th>\n",
       "      <td>28</td>\n",
       "      <td>仓上南门店</td>\n",
       "      <td>188.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 138</td>\n",
       "      <td>2.90</td>\n",
       "      <td>仓上小区 2室1厅 64平</td>\n",
       "      <td>龚振武</td>\n",
       "      <td>34</td>\n",
       "      <td>房东信赖;销售达人</td>\n",
       "      <td>南 北/中楼层/6层</td>\n",
       "      <td>签约时间：2016-07-24</td>\n",
       "      <td>3-4年</td>\n",
       "      <td>顺义城</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27776</th>\n",
       "      <td>28</td>\n",
       "      <td>仓上南门店</td>\n",
       "      <td>174.0</td>\n",
       "      <td>店经理</td>\n",
       "      <td>97% 138</td>\n",
       "      <td>2.87</td>\n",
       "      <td>仓上小区 1室1厅 60平</td>\n",
       "      <td>龚振武</td>\n",
       "      <td>34</td>\n",
       "      <td>房东信赖;销售达人</td>\n",
       "      <td>南 北/高楼层/6层</td>\n",
       "      <td>签约时间：2016-03-12</td>\n",
       "      <td>3-4年</td>\n",
       "      <td>顺义城</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29423 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                cjtaoshu mendian  cjzongjia zhiwei  haoping  cjdanjia  \\\n",
       "xingming                                                                \n",
       "丁丽       26358        11   西潞苑北店      150.0  高级经纪人  100% 58      4.56   \n",
       "         26353        11   西潞苑北店      300.0  高级经纪人  100% 58      4.08   \n",
       "         26354        11   西潞苑北店      295.0  高级经纪人  100% 58      3.64   \n",
       "         26357        11   西潞苑北店      460.0  高级经纪人  100% 58      3.23   \n",
       "         26356        11   西潞苑北店      307.0  高级经纪人  100% 58      3.17   \n",
       "...                  ...     ...        ...    ...      ...       ...   \n",
       "龚振武      27769        28   仓上南门店      344.0    店经理  97% 138      3.70   \n",
       "         27770        28   仓上南门店      259.0    店经理  97% 138      3.57   \n",
       "         27771        28   仓上南门店      242.0    店经理  97% 138      2.91   \n",
       "         27772        28   仓上南门店      188.0    店经理  97% 138      2.90   \n",
       "         27776        28   仓上南门店      174.0    店经理  97% 138      2.87   \n",
       "\n",
       "                        cjxiaoqu xingming cjzhouqi   biaoqian    cjlouceng  \\\n",
       "xingming                                                                     \n",
       "丁丽       26358   西潞苑小区 1室--厅 32平       丁丽       40       客户热评     西/中楼层/4层   \n",
       "         26353    西潞苑小区 2室1厅 73平       丁丽       40       客户热评   南 北/中楼层/6层   \n",
       "         26354      翠福园 1室1厅 81平       丁丽       40       客户热评   南 北/高楼层/6层   \n",
       "         26357  京贸国际公寓 3室2厅 142平       丁丽       40       客户热评  东 南/中楼层/28层   \n",
       "         26356    西潞苑小区 2室1厅 96平       丁丽       40       客户热评   南 北/低楼层/6层   \n",
       "...                          ...      ...      ...        ...          ...   \n",
       "龚振武      27769     西辛南区 3室1厅 93平      龚振武       34  房东信赖;销售达人   南 北/中楼层/6层   \n",
       "         27770     裕龙四区 2室1厅 72平      龚振武       34  房东信赖;销售达人   南 北/中楼层/6层   \n",
       "         27771     石园北区 2室1厅 83平      龚振武       34  房东信赖;销售达人   南 北/高楼层/6层   \n",
       "         27772     仓上小区 2室1厅 64平      龚振武       34  房东信赖;销售达人   南 北/中楼层/6层   \n",
       "         27776     仓上小区 1室1厅 60平      龚振武       34  房东信赖;销售达人   南 北/高楼层/6层   \n",
       "\n",
       "                      cjshijian congyenianxian bankuai  \n",
       "xingming                                                \n",
       "丁丽       26358  签约时间：2016-07-04           5年以上      北关  \n",
       "         26353  签约时间：2016-09-27           5年以上      北关  \n",
       "         26354  签约时间：2016-09-19           5年以上      北关  \n",
       "         26357  签约时间：2016-08-08           5年以上      北关  \n",
       "         26356  签约时间：2016-08-08           5年以上      北关  \n",
       "...                         ...            ...     ...  \n",
       "龚振武      27769  签约时间：2016-09-18           3-4年     顺义城  \n",
       "         27770  签约时间：2016-09-02           3-4年     顺义城  \n",
       "         27771  签约时间：2016-08-20           3-4年     顺义城  \n",
       "         27772  签约时间：2016-07-24           3-4年     顺义城  \n",
       "         27776  签约时间：2016-03-12           3-4年     顺义城  \n",
       "\n",
       "[29423 rows x 14 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.groupby('xingming').apply(top)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6613a510",
   "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
}