price_quantizer_stack_16_1-27.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from utilities import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "train = pd.read_csv('dataset/train.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_pred = pd.read_csv('output/stack_spopt-parea_16_1-27.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>building_id</th>\n",
       "      <th>total_price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>X5gsdTWGS3W7JJQB</td>\n",
       "      <td>1.347460e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BTshNOJyKHnT2YIT</td>\n",
       "      <td>3.891548e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>dhdymr0lV8N5kZOT</td>\n",
       "      <td>1.113206e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VEwyGGMcD56w5BOc</td>\n",
       "      <td>5.898886e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wmUeMoJZfsqaSX9b</td>\n",
       "      <td>1.064115e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>UEeCDaAJzPwdKKKA</td>\n",
       "      <td>1.202568e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>i0fgbPaQsDWs7Q87</td>\n",
       "      <td>4.759512e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>YunNwAhcqkf6YclI</td>\n",
       "      <td>1.077326e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>A2NotxtRY9MYoWMl</td>\n",
       "      <td>2.945286e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>kKvgBXiA50gRmQhP</td>\n",
       "      <td>3.056918e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           building_id   total_price\n",
       "0     X5gsdTWGS3W7JJQB  1.347460e+07\n",
       "1     BTshNOJyKHnT2YIT  3.891548e+06\n",
       "2     dhdymr0lV8N5kZOT  1.113206e+07\n",
       "3     VEwyGGMcD56w5BOc  5.898886e+06\n",
       "4     wmUeMoJZfsqaSX9b  1.064115e+06\n",
       "9995  UEeCDaAJzPwdKKKA  1.202568e+06\n",
       "9996  i0fgbPaQsDWs7Q87  4.759512e+07\n",
       "9997  YunNwAhcqkf6YclI  1.077326e+06\n",
       "9998  A2NotxtRY9MYoWMl  2.945286e+06\n",
       "9999  kKvgBXiA50gRmQhP  3.056918e+06"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (10000, 2)\n"
     ]
    }
   ],
   "source": [
    "test_pred.check()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "unique_prices = np.sort(train['total_price'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(16555,)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "unique_prices.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "def find_nearest(array, value):\n",
    "    return array[(np.fabs(array - value)).argmin()]\n",
    "\n",
    "def correct_prices(df, col):\n",
    "    return [find_nearest(unique_prices, x) for x in df[col]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "test_pred['total_price_corr'] = correct_prices(test_pred, 'total_price')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3425"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_pred['total_price_corr'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3425"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_pred['total_price_corr'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>building_id</th>\n",
       "      <th>total_price</th>\n",
       "      <th>total_price_corr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>X5gsdTWGS3W7JJQB</td>\n",
       "      <td>1.347460e+07</td>\n",
       "      <td>1.347944e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BTshNOJyKHnT2YIT</td>\n",
       "      <td>3.891548e+06</td>\n",
       "      <td>3.884641e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>dhdymr0lV8N5kZOT</td>\n",
       "      <td>1.113206e+07</td>\n",
       "      <td>1.112538e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>VEwyGGMcD56w5BOc</td>\n",
       "      <td>5.898886e+06</td>\n",
       "      <td>5.896158e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>wmUeMoJZfsqaSX9b</td>\n",
       "      <td>1.064115e+06</td>\n",
       "      <td>1.064118e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9995</th>\n",
       "      <td>UEeCDaAJzPwdKKKA</td>\n",
       "      <td>1.202568e+06</td>\n",
       "      <td>1.200435e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9996</th>\n",
       "      <td>i0fgbPaQsDWs7Q87</td>\n",
       "      <td>4.759512e+07</td>\n",
       "      <td>4.760189e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9997</th>\n",
       "      <td>YunNwAhcqkf6YclI</td>\n",
       "      <td>1.077326e+06</td>\n",
       "      <td>1.073922e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9998</th>\n",
       "      <td>A2NotxtRY9MYoWMl</td>\n",
       "      <td>2.945286e+06</td>\n",
       "      <td>2.948398e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9999</th>\n",
       "      <td>kKvgBXiA50gRmQhP</td>\n",
       "      <td>3.056918e+06</td>\n",
       "      <td>3.055521e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           building_id   total_price  total_price_corr\n",
       "0     X5gsdTWGS3W7JJQB  1.347460e+07      1.347944e+07\n",
       "1     BTshNOJyKHnT2YIT  3.891548e+06      3.884641e+06\n",
       "2     dhdymr0lV8N5kZOT  1.113206e+07      1.112538e+07\n",
       "3     VEwyGGMcD56w5BOc  5.898886e+06      5.896158e+06\n",
       "4     wmUeMoJZfsqaSX9b  1.064115e+06      1.064118e+06\n",
       "9995  UEeCDaAJzPwdKKKA  1.202568e+06      1.200435e+06\n",
       "9996  i0fgbPaQsDWs7Q87  4.759512e+07      4.760189e+07\n",
       "9997  YunNwAhcqkf6YclI  1.077326e+06      1.073922e+06\n",
       "9998  A2NotxtRY9MYoWMl  2.945286e+06      2.948398e+06\n",
       "9999  kKvgBXiA50gRmQhP  3.056918e+06      3.055521e+06"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (10000, 3)\n"
     ]
    }
   ],
   "source": [
    "test_pred.check()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "cv = pd.read_csv('output/model-19-lgb-search-bins-lr-0.0005-cv.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>building_id</th>\n",
       "      <th>total_price</th>\n",
       "      <th>total_price_predict</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>jre1pJhcQj91Kdky</td>\n",
       "      <td>14215011.0</td>\n",
       "      <td>1.272405e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>jcbuA8q3KPH9SzpS</td>\n",
       "      <td>7642884.5</td>\n",
       "      <td>9.475287e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EqWJpHmkXPyfHkB8</td>\n",
       "      <td>4807053.0</td>\n",
       "      <td>4.653431e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ihrMWGM8Nq99Uvu6</td>\n",
       "      <td>7493026.5</td>\n",
       "      <td>6.885630e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>jRhwzoVMFLFzxAX1</td>\n",
       "      <td>2846855.8</td>\n",
       "      <td>2.787730e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59995</th>\n",
       "      <td>QZSvDBvS2WqfYPDl</td>\n",
       "      <td>25950206.0</td>\n",
       "      <td>2.591887e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59996</th>\n",
       "      <td>JjHLg8Nh6k4Tbdci</td>\n",
       "      <td>37594868.0</td>\n",
       "      <td>3.747146e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59997</th>\n",
       "      <td>PiOgZqfsDVlTq1zs</td>\n",
       "      <td>15725224.0</td>\n",
       "      <td>1.468696e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59998</th>\n",
       "      <td>FQmlgGohzzWuKUzu</td>\n",
       "      <td>11815402.0</td>\n",
       "      <td>1.267313e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59999</th>\n",
       "      <td>zjzfMwXhDswdEaI2</td>\n",
       "      <td>18084996.0</td>\n",
       "      <td>1.720550e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            building_id  total_price  total_price_predict\n",
       "0      jre1pJhcQj91Kdky   14215011.0         1.272405e+07\n",
       "1      jcbuA8q3KPH9SzpS    7642884.5         9.475287e+06\n",
       "2      EqWJpHmkXPyfHkB8    4807053.0         4.653431e+06\n",
       "3      ihrMWGM8Nq99Uvu6    7493026.5         6.885630e+06\n",
       "4      jRhwzoVMFLFzxAX1    2846855.8         2.787730e+06\n",
       "59995  QZSvDBvS2WqfYPDl   25950206.0         2.591887e+07\n",
       "59996  JjHLg8Nh6k4Tbdci   37594868.0         3.747146e+07\n",
       "59997  PiOgZqfsDVlTq1zs   15725224.0         1.468696e+07\n",
       "59998  FQmlgGohzzWuKUzu   11815402.0         1.267313e+07\n",
       "59999  zjzfMwXhDswdEaI2   18084996.0         1.720550e+07"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (60000, 3)\n"
     ]
    }
   ],
   "source": [
    "cv.check()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "cv['total_price_predict_corr'] = correct_prices(cv, 'total_price_predict')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>building_id</th>\n",
       "      <th>total_price</th>\n",
       "      <th>total_price_predict</th>\n",
       "      <th>total_price_predict_corr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>jre1pJhcQj91Kdky</td>\n",
       "      <td>14215011.0</td>\n",
       "      <td>1.272405e+07</td>\n",
       "      <td>1.274052e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>jcbuA8q3KPH9SzpS</td>\n",
       "      <td>7642884.5</td>\n",
       "      <td>9.475287e+06</td>\n",
       "      <td>9.468665e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>EqWJpHmkXPyfHkB8</td>\n",
       "      <td>4807053.0</td>\n",
       "      <td>4.653431e+06</td>\n",
       "      <td>4.654223e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ihrMWGM8Nq99Uvu6</td>\n",
       "      <td>7493026.5</td>\n",
       "      <td>6.885630e+06</td>\n",
       "      <td>6.885496e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>jRhwzoVMFLFzxAX1</td>\n",
       "      <td>2846855.8</td>\n",
       "      <td>2.787730e+06</td>\n",
       "      <td>2.790265e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59995</th>\n",
       "      <td>QZSvDBvS2WqfYPDl</td>\n",
       "      <td>25950206.0</td>\n",
       "      <td>2.591887e+07</td>\n",
       "      <td>2.595019e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59996</th>\n",
       "      <td>JjHLg8Nh6k4Tbdci</td>\n",
       "      <td>37594868.0</td>\n",
       "      <td>3.747146e+07</td>\n",
       "      <td>3.754328e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59997</th>\n",
       "      <td>PiOgZqfsDVlTq1zs</td>\n",
       "      <td>15725224.0</td>\n",
       "      <td>1.468696e+07</td>\n",
       "      <td>1.468766e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59998</th>\n",
       "      <td>FQmlgGohzzWuKUzu</td>\n",
       "      <td>11815402.0</td>\n",
       "      <td>1.267313e+07</td>\n",
       "      <td>1.267279e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59999</th>\n",
       "      <td>zjzfMwXhDswdEaI2</td>\n",
       "      <td>18084996.0</td>\n",
       "      <td>1.720550e+07</td>\n",
       "      <td>1.720695e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            building_id  total_price  total_price_predict  \\\n",
       "0      jre1pJhcQj91Kdky   14215011.0         1.272405e+07   \n",
       "1      jcbuA8q3KPH9SzpS    7642884.5         9.475287e+06   \n",
       "2      EqWJpHmkXPyfHkB8    4807053.0         4.653431e+06   \n",
       "3      ihrMWGM8Nq99Uvu6    7493026.5         6.885630e+06   \n",
       "4      jRhwzoVMFLFzxAX1    2846855.8         2.787730e+06   \n",
       "59995  QZSvDBvS2WqfYPDl   25950206.0         2.591887e+07   \n",
       "59996  JjHLg8Nh6k4Tbdci   37594868.0         3.747146e+07   \n",
       "59997  PiOgZqfsDVlTq1zs   15725224.0         1.468696e+07   \n",
       "59998  FQmlgGohzzWuKUzu   11815402.0         1.267313e+07   \n",
       "59999  zjzfMwXhDswdEaI2   18084996.0         1.720550e+07   \n",
       "\n",
       "       total_price_predict_corr  \n",
       "0                  1.274052e+07  \n",
       "1                  9.468665e+06  \n",
       "2                  4.654223e+06  \n",
       "3                  6.885496e+06  \n",
       "4                  2.790265e+06  \n",
       "59995              2.595019e+07  \n",
       "59996              3.754328e+07  \n",
       "59997              1.468766e+07  \n",
       "59998              1.267279e+07  \n",
       "59999              1.720695e+07  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (60000, 4)\n"
     ]
    }
   ],
   "source": [
    "cv.check()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5911.874156331838"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal_score(cv['total_price'], cv['total_price_predict'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5916.8742051954005"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal_score(cv['total_price'], cv['total_price_predict_corr'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Test on stack_spopt-parea_16_1-27_smoothobj-cv-one.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "cv = pd.read_csv('output/stack_spopt-parea_16_1-27_smoothobj-cv-one.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>building_id</th>\n",
       "      <th>building_area</th>\n",
       "      <th>total_price</th>\n",
       "      <th>pred_1</th>\n",
       "      <th>log_pred_1</th>\n",
       "      <th>log_parea_pred_1</th>\n",
       "      <th>pred_2</th>\n",
       "      <th>log_pred_2</th>\n",
       "      <th>log_parea_pred_2</th>\n",
       "      <th>pred_3</th>\n",
       "      <th>...</th>\n",
       "      <th>pred_26</th>\n",
       "      <th>log_pred_26</th>\n",
       "      <th>log_parea_pred_26</th>\n",
       "      <th>pred_27</th>\n",
       "      <th>log_pred_27</th>\n",
       "      <th>log_parea_pred_27</th>\n",
       "      <th>log_total_price</th>\n",
       "      <th>log_parea_total_price</th>\n",
       "      <th>constant_1</th>\n",
       "      <th>total_price_pred</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e3mMIMR3JJqCaXz1</td>\n",
       "      <td>3.418175</td>\n",
       "      <td>6.476038e+05</td>\n",
       "      <td>6.331552e+05</td>\n",
       "      <td>13.358472</td>\n",
       "      <td>12.129369</td>\n",
       "      <td>717209.94</td>\n",
       "      <td>13.483125</td>\n",
       "      <td>12.254022</td>\n",
       "      <td>6.656891e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>6.452832e+05</td>\n",
       "      <td>13.377446</td>\n",
       "      <td>12.148343</td>\n",
       "      <td>6.477905e+05</td>\n",
       "      <td>13.381324</td>\n",
       "      <td>12.152221</td>\n",
       "      <td>13.381036</td>\n",
       "      <td>12.151933</td>\n",
       "      <td>1</td>\n",
       "      <td>6.194845e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LgwzgklNvy4QCtq5</td>\n",
       "      <td>4.041309</td>\n",
       "      <td>3.321452e+06</td>\n",
       "      <td>3.064324e+06</td>\n",
       "      <td>14.935338</td>\n",
       "      <td>13.538770</td>\n",
       "      <td>2899842.20</td>\n",
       "      <td>14.880167</td>\n",
       "      <td>13.483600</td>\n",
       "      <td>3.079196e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>3.164660e+06</td>\n",
       "      <td>14.967557</td>\n",
       "      <td>13.570989</td>\n",
       "      <td>3.127411e+06</td>\n",
       "      <td>14.955716</td>\n",
       "      <td>13.559149</td>\n",
       "      <td>15.015913</td>\n",
       "      <td>13.619345</td>\n",
       "      <td>1</td>\n",
       "      <td>3.062496e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ucIR2NLLsC3T650L</td>\n",
       "      <td>5.584279</td>\n",
       "      <td>9.570885e+06</td>\n",
       "      <td>9.827776e+06</td>\n",
       "      <td>16.100723</td>\n",
       "      <td>14.380769</td>\n",
       "      <td>9766813.00</td>\n",
       "      <td>16.094501</td>\n",
       "      <td>14.374546</td>\n",
       "      <td>9.814852e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>9.832843e+06</td>\n",
       "      <td>16.101239</td>\n",
       "      <td>14.381284</td>\n",
       "      <td>9.745913e+06</td>\n",
       "      <td>16.092359</td>\n",
       "      <td>14.372404</td>\n",
       "      <td>16.074236</td>\n",
       "      <td>14.354282</td>\n",
       "      <td>1</td>\n",
       "      <td>9.786134e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>jre1pJhcQj91Kdky</td>\n",
       "      <td>13.563031</td>\n",
       "      <td>1.421501e+07</td>\n",
       "      <td>1.255350e+07</td>\n",
       "      <td>16.345510</td>\n",
       "      <td>13.738164</td>\n",
       "      <td>12699800.00</td>\n",
       "      <td>16.357097</td>\n",
       "      <td>13.749750</td>\n",
       "      <td>1.255981e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.274179e+07</td>\n",
       "      <td>16.360398</td>\n",
       "      <td>13.753051</td>\n",
       "      <td>1.259548e+07</td>\n",
       "      <td>16.348848</td>\n",
       "      <td>13.741502</td>\n",
       "      <td>16.469809</td>\n",
       "      <td>13.862462</td>\n",
       "      <td>1</td>\n",
       "      <td>1.277164e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>rQpYpY9nRG7X5mmr</td>\n",
       "      <td>4.688108</td>\n",
       "      <td>7.627120e+05</td>\n",
       "      <td>1.215194e+06</td>\n",
       "      <td>14.010415</td>\n",
       "      <td>12.465389</td>\n",
       "      <td>2012610.50</td>\n",
       "      <td>14.514944</td>\n",
       "      <td>12.969916</td>\n",
       "      <td>1.128419e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.114412e+06</td>\n",
       "      <td>13.923838</td>\n",
       "      <td>12.378812</td>\n",
       "      <td>1.131428e+06</td>\n",
       "      <td>13.938992</td>\n",
       "      <td>12.393966</td>\n",
       "      <td>13.544637</td>\n",
       "      <td>11.999613</td>\n",
       "      <td>1</td>\n",
       "      <td>1.246855e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59995</th>\n",
       "      <td>Oh5Hwr9LrWApC2mr</td>\n",
       "      <td>6.754060</td>\n",
       "      <td>9.870214e+05</td>\n",
       "      <td>1.462514e+06</td>\n",
       "      <td>14.195668</td>\n",
       "      <td>12.285528</td>\n",
       "      <td>1096943.80</td>\n",
       "      <td>13.908039</td>\n",
       "      <td>11.997901</td>\n",
       "      <td>1.450595e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1.484734e+06</td>\n",
       "      <td>14.210747</td>\n",
       "      <td>12.300607</td>\n",
       "      <td>1.496592e+06</td>\n",
       "      <td>14.218702</td>\n",
       "      <td>12.308562</td>\n",
       "      <td>13.802448</td>\n",
       "      <td>11.892310</td>\n",
       "      <td>1</td>\n",
       "      <td>1.375179e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59996</th>\n",
       "      <td>PiOgZqfsDVlTq1zs</td>\n",
       "      <td>5.356788</td>\n",
       "      <td>1.572522e+07</td>\n",
       "      <td>1.419424e+07</td>\n",
       "      <td>16.468347</td>\n",
       "      <td>14.789983</td>\n",
       "      <td>16524961.00</td>\n",
       "      <td>16.620383</td>\n",
       "      <td>14.942018</td>\n",
       "      <td>1.488475e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.483210e+07</td>\n",
       "      <td>16.512304</td>\n",
       "      <td>14.833940</td>\n",
       "      <td>1.457474e+07</td>\n",
       "      <td>16.494800</td>\n",
       "      <td>14.816436</td>\n",
       "      <td>16.570777</td>\n",
       "      <td>14.892412</td>\n",
       "      <td>1</td>\n",
       "      <td>1.462065e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59997</th>\n",
       "      <td>FQmlgGohzzWuKUzu</td>\n",
       "      <td>8.223644</td>\n",
       "      <td>1.181540e+07</td>\n",
       "      <td>1.264280e+07</td>\n",
       "      <td>16.352598</td>\n",
       "      <td>14.245585</td>\n",
       "      <td>12099525.00</td>\n",
       "      <td>16.308677</td>\n",
       "      <td>14.201664</td>\n",
       "      <td>1.259087e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.266875e+07</td>\n",
       "      <td>16.354649</td>\n",
       "      <td>14.247636</td>\n",
       "      <td>1.261376e+07</td>\n",
       "      <td>16.350299</td>\n",
       "      <td>14.243286</td>\n",
       "      <td>16.284915</td>\n",
       "      <td>14.177902</td>\n",
       "      <td>1</td>\n",
       "      <td>1.256442e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59998</th>\n",
       "      <td>zjzfMwXhDswdEaI2</td>\n",
       "      <td>8.728287</td>\n",
       "      <td>1.808500e+07</td>\n",
       "      <td>1.742945e+07</td>\n",
       "      <td>16.673672</td>\n",
       "      <td>14.507103</td>\n",
       "      <td>18142848.00</td>\n",
       "      <td>16.713787</td>\n",
       "      <td>14.547218</td>\n",
       "      <td>1.685909e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.719557e+07</td>\n",
       "      <td>16.660162</td>\n",
       "      <td>14.493594</td>\n",
       "      <td>1.716719e+07</td>\n",
       "      <td>16.658510</td>\n",
       "      <td>14.491942</td>\n",
       "      <td>16.710593</td>\n",
       "      <td>14.544025</td>\n",
       "      <td>1</td>\n",
       "      <td>1.736432e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59999</th>\n",
       "      <td>iN4H6wBMtvJpF0SN</td>\n",
       "      <td>5.356788</td>\n",
       "      <td>8.510296e+06</td>\n",
       "      <td>8.053811e+06</td>\n",
       "      <td>15.901656</td>\n",
       "      <td>14.223292</td>\n",
       "      <td>8046627.00</td>\n",
       "      <td>15.900764</td>\n",
       "      <td>14.222400</td>\n",
       "      <td>8.183993e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>8.113660e+06</td>\n",
       "      <td>15.909060</td>\n",
       "      <td>14.230696</td>\n",
       "      <td>8.189473e+06</td>\n",
       "      <td>15.918360</td>\n",
       "      <td>14.239996</td>\n",
       "      <td>15.956787</td>\n",
       "      <td>14.278423</td>\n",
       "      <td>1</td>\n",
       "      <td>8.131080e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 88 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            building_id  building_area   total_price        pred_1  \\\n",
       "0      e3mMIMR3JJqCaXz1       3.418175  6.476038e+05  6.331552e+05   \n",
       "1      LgwzgklNvy4QCtq5       4.041309  3.321452e+06  3.064324e+06   \n",
       "2      ucIR2NLLsC3T650L       5.584279  9.570885e+06  9.827776e+06   \n",
       "3      jre1pJhcQj91Kdky      13.563031  1.421501e+07  1.255350e+07   \n",
       "4      rQpYpY9nRG7X5mmr       4.688108  7.627120e+05  1.215194e+06   \n",
       "59995  Oh5Hwr9LrWApC2mr       6.754060  9.870214e+05  1.462514e+06   \n",
       "59996  PiOgZqfsDVlTq1zs       5.356788  1.572522e+07  1.419424e+07   \n",
       "59997  FQmlgGohzzWuKUzu       8.223644  1.181540e+07  1.264280e+07   \n",
       "59998  zjzfMwXhDswdEaI2       8.728287  1.808500e+07  1.742945e+07   \n",
       "59999  iN4H6wBMtvJpF0SN       5.356788  8.510296e+06  8.053811e+06   \n",
       "\n",
       "       log_pred_1  log_parea_pred_1       pred_2  log_pred_2  \\\n",
       "0       13.358472         12.129369    717209.94   13.483125   \n",
       "1       14.935338         13.538770   2899842.20   14.880167   \n",
       "2       16.100723         14.380769   9766813.00   16.094501   \n",
       "3       16.345510         13.738164  12699800.00   16.357097   \n",
       "4       14.010415         12.465389   2012610.50   14.514944   \n",
       "59995   14.195668         12.285528   1096943.80   13.908039   \n",
       "59996   16.468347         14.789983  16524961.00   16.620383   \n",
       "59997   16.352598         14.245585  12099525.00   16.308677   \n",
       "59998   16.673672         14.507103  18142848.00   16.713787   \n",
       "59999   15.901656         14.223292   8046627.00   15.900764   \n",
       "\n",
       "       log_parea_pred_2        pred_3        ...              pred_26  \\\n",
       "0             12.254022  6.656891e+05        ...         6.452832e+05   \n",
       "1             13.483600  3.079196e+06        ...         3.164660e+06   \n",
       "2             14.374546  9.814852e+06        ...         9.832843e+06   \n",
       "3             13.749750  1.255981e+07        ...         1.274179e+07   \n",
       "4             12.969916  1.128419e+06        ...         1.114412e+06   \n",
       "59995         11.997901  1.450595e+06        ...         1.484734e+06   \n",
       "59996         14.942018  1.488475e+07        ...         1.483210e+07   \n",
       "59997         14.201664  1.259087e+07        ...         1.266875e+07   \n",
       "59998         14.547218  1.685909e+07        ...         1.719557e+07   \n",
       "59999         14.222400  8.183993e+06        ...         8.113660e+06   \n",
       "\n",
       "       log_pred_26  log_parea_pred_26       pred_27  log_pred_27  \\\n",
       "0        13.377446          12.148343  6.477905e+05    13.381324   \n",
       "1        14.967557          13.570989  3.127411e+06    14.955716   \n",
       "2        16.101239          14.381284  9.745913e+06    16.092359   \n",
       "3        16.360398          13.753051  1.259548e+07    16.348848   \n",
       "4        13.923838          12.378812  1.131428e+06    13.938992   \n",
       "59995    14.210747          12.300607  1.496592e+06    14.218702   \n",
       "59996    16.512304          14.833940  1.457474e+07    16.494800   \n",
       "59997    16.354649          14.247636  1.261376e+07    16.350299   \n",
       "59998    16.660162          14.493594  1.716719e+07    16.658510   \n",
       "59999    15.909060          14.230696  8.189473e+06    15.918360   \n",
       "\n",
       "       log_parea_pred_27  log_total_price  log_parea_total_price  constant_1  \\\n",
       "0              12.152221        13.381036              12.151933           1   \n",
       "1              13.559149        15.015913              13.619345           1   \n",
       "2              14.372404        16.074236              14.354282           1   \n",
       "3              13.741502        16.469809              13.862462           1   \n",
       "4              12.393966        13.544637              11.999613           1   \n",
       "59995          12.308562        13.802448              11.892310           1   \n",
       "59996          14.816436        16.570777              14.892412           1   \n",
       "59997          14.243286        16.284915              14.177902           1   \n",
       "59998          14.491942        16.710593              14.544025           1   \n",
       "59999          14.239996        15.956787              14.278423           1   \n",
       "\n",
       "       total_price_pred  \n",
       "0          6.194845e+05  \n",
       "1          3.062496e+06  \n",
       "2          9.786134e+06  \n",
       "3          1.277164e+07  \n",
       "4          1.246855e+06  \n",
       "59995      1.375179e+06  \n",
       "59996      1.462065e+07  \n",
       "59997      1.256442e+07  \n",
       "59998      1.736432e+07  \n",
       "59999      8.131080e+06  \n",
       "\n",
       "[10 rows x 88 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (60000, 88)\n"
     ]
    }
   ],
   "source": [
    "cv.check()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "cv['total_price_pred_corr'] = correct_prices(cv, 'total_price_pred')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>building_id</th>\n",
       "      <th>building_area</th>\n",
       "      <th>total_price</th>\n",
       "      <th>pred_1</th>\n",
       "      <th>log_pred_1</th>\n",
       "      <th>log_parea_pred_1</th>\n",
       "      <th>pred_2</th>\n",
       "      <th>log_pred_2</th>\n",
       "      <th>log_parea_pred_2</th>\n",
       "      <th>pred_3</th>\n",
       "      <th>...</th>\n",
       "      <th>log_pred_26</th>\n",
       "      <th>log_parea_pred_26</th>\n",
       "      <th>pred_27</th>\n",
       "      <th>log_pred_27</th>\n",
       "      <th>log_parea_pred_27</th>\n",
       "      <th>log_total_price</th>\n",
       "      <th>log_parea_total_price</th>\n",
       "      <th>constant_1</th>\n",
       "      <th>total_price_pred</th>\n",
       "      <th>total_price_pred_corr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e3mMIMR3JJqCaXz1</td>\n",
       "      <td>3.418175</td>\n",
       "      <td>6.476038e+05</td>\n",
       "      <td>6.331552e+05</td>\n",
       "      <td>13.358472</td>\n",
       "      <td>12.129369</td>\n",
       "      <td>717209.94</td>\n",
       "      <td>13.483125</td>\n",
       "      <td>12.254022</td>\n",
       "      <td>6.656891e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>13.377446</td>\n",
       "      <td>12.148343</td>\n",
       "      <td>6.477905e+05</td>\n",
       "      <td>13.381324</td>\n",
       "      <td>12.152221</td>\n",
       "      <td>13.381036</td>\n",
       "      <td>12.151933</td>\n",
       "      <td>1</td>\n",
       "      <td>6.194845e+05</td>\n",
       "      <td>6.191868e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LgwzgklNvy4QCtq5</td>\n",
       "      <td>4.041309</td>\n",
       "      <td>3.321452e+06</td>\n",
       "      <td>3.064324e+06</td>\n",
       "      <td>14.935338</td>\n",
       "      <td>13.538770</td>\n",
       "      <td>2899842.20</td>\n",
       "      <td>14.880167</td>\n",
       "      <td>13.483600</td>\n",
       "      <td>3.079196e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>14.967557</td>\n",
       "      <td>13.570989</td>\n",
       "      <td>3.127411e+06</td>\n",
       "      <td>14.955716</td>\n",
       "      <td>13.559149</td>\n",
       "      <td>15.015913</td>\n",
       "      <td>13.619345</td>\n",
       "      <td>1</td>\n",
       "      <td>3.062496e+06</td>\n",
       "      <td>3.062662e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ucIR2NLLsC3T650L</td>\n",
       "      <td>5.584279</td>\n",
       "      <td>9.570885e+06</td>\n",
       "      <td>9.827776e+06</td>\n",
       "      <td>16.100723</td>\n",
       "      <td>14.380769</td>\n",
       "      <td>9766813.00</td>\n",
       "      <td>16.094501</td>\n",
       "      <td>14.374546</td>\n",
       "      <td>9.814852e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>16.101239</td>\n",
       "      <td>14.381284</td>\n",
       "      <td>9.745913e+06</td>\n",
       "      <td>16.092359</td>\n",
       "      <td>14.372404</td>\n",
       "      <td>16.074236</td>\n",
       "      <td>14.354282</td>\n",
       "      <td>1</td>\n",
       "      <td>9.786134e+06</td>\n",
       "      <td>9.788048e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>jre1pJhcQj91Kdky</td>\n",
       "      <td>13.563031</td>\n",
       "      <td>1.421501e+07</td>\n",
       "      <td>1.255350e+07</td>\n",
       "      <td>16.345510</td>\n",
       "      <td>13.738164</td>\n",
       "      <td>12699800.00</td>\n",
       "      <td>16.357097</td>\n",
       "      <td>13.749750</td>\n",
       "      <td>1.255981e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>16.360398</td>\n",
       "      <td>13.753051</td>\n",
       "      <td>1.259548e+07</td>\n",
       "      <td>16.348848</td>\n",
       "      <td>13.741502</td>\n",
       "      <td>16.469809</td>\n",
       "      <td>13.862462</td>\n",
       "      <td>1</td>\n",
       "      <td>1.277164e+07</td>\n",
       "      <td>1.276381e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>rQpYpY9nRG7X5mmr</td>\n",
       "      <td>4.688108</td>\n",
       "      <td>7.627120e+05</td>\n",
       "      <td>1.215194e+06</td>\n",
       "      <td>14.010415</td>\n",
       "      <td>12.465389</td>\n",
       "      <td>2012610.50</td>\n",
       "      <td>14.514944</td>\n",
       "      <td>12.969916</td>\n",
       "      <td>1.128419e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>13.923838</td>\n",
       "      <td>12.378812</td>\n",
       "      <td>1.131428e+06</td>\n",
       "      <td>13.938992</td>\n",
       "      <td>12.393966</td>\n",
       "      <td>13.544637</td>\n",
       "      <td>11.999613</td>\n",
       "      <td>1</td>\n",
       "      <td>1.246855e+06</td>\n",
       "      <td>1.246212e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59995</th>\n",
       "      <td>Oh5Hwr9LrWApC2mr</td>\n",
       "      <td>6.754060</td>\n",
       "      <td>9.870214e+05</td>\n",
       "      <td>1.462514e+06</td>\n",
       "      <td>14.195668</td>\n",
       "      <td>12.285528</td>\n",
       "      <td>1096943.80</td>\n",
       "      <td>13.908039</td>\n",
       "      <td>11.997901</td>\n",
       "      <td>1.450595e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>14.210747</td>\n",
       "      <td>12.300607</td>\n",
       "      <td>1.496592e+06</td>\n",
       "      <td>14.218702</td>\n",
       "      <td>12.308562</td>\n",
       "      <td>13.802448</td>\n",
       "      <td>11.892310</td>\n",
       "      <td>1</td>\n",
       "      <td>1.375179e+06</td>\n",
       "      <td>1.375668e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59996</th>\n",
       "      <td>PiOgZqfsDVlTq1zs</td>\n",
       "      <td>5.356788</td>\n",
       "      <td>1.572522e+07</td>\n",
       "      <td>1.419424e+07</td>\n",
       "      <td>16.468347</td>\n",
       "      <td>14.789983</td>\n",
       "      <td>16524961.00</td>\n",
       "      <td>16.620383</td>\n",
       "      <td>14.942018</td>\n",
       "      <td>1.488475e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>16.512304</td>\n",
       "      <td>14.833940</td>\n",
       "      <td>1.457474e+07</td>\n",
       "      <td>16.494800</td>\n",
       "      <td>14.816436</td>\n",
       "      <td>16.570777</td>\n",
       "      <td>14.892412</td>\n",
       "      <td>1</td>\n",
       "      <td>1.462065e+07</td>\n",
       "      <td>1.463766e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59997</th>\n",
       "      <td>FQmlgGohzzWuKUzu</td>\n",
       "      <td>8.223644</td>\n",
       "      <td>1.181540e+07</td>\n",
       "      <td>1.264280e+07</td>\n",
       "      <td>16.352598</td>\n",
       "      <td>14.245585</td>\n",
       "      <td>12099525.00</td>\n",
       "      <td>16.308677</td>\n",
       "      <td>14.201664</td>\n",
       "      <td>1.259087e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>16.354649</td>\n",
       "      <td>14.247636</td>\n",
       "      <td>1.261376e+07</td>\n",
       "      <td>16.350299</td>\n",
       "      <td>14.243286</td>\n",
       "      <td>16.284915</td>\n",
       "      <td>14.177902</td>\n",
       "      <td>1</td>\n",
       "      <td>1.256442e+07</td>\n",
       "      <td>1.257876e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59998</th>\n",
       "      <td>zjzfMwXhDswdEaI2</td>\n",
       "      <td>8.728287</td>\n",
       "      <td>1.808500e+07</td>\n",
       "      <td>1.742945e+07</td>\n",
       "      <td>16.673672</td>\n",
       "      <td>14.507103</td>\n",
       "      <td>18142848.00</td>\n",
       "      <td>16.713787</td>\n",
       "      <td>14.547218</td>\n",
       "      <td>1.685909e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>16.660162</td>\n",
       "      <td>14.493594</td>\n",
       "      <td>1.716719e+07</td>\n",
       "      <td>16.658510</td>\n",
       "      <td>14.491942</td>\n",
       "      <td>16.710593</td>\n",
       "      <td>14.544025</td>\n",
       "      <td>1</td>\n",
       "      <td>1.736432e+07</td>\n",
       "      <td>1.733521e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59999</th>\n",
       "      <td>iN4H6wBMtvJpF0SN</td>\n",
       "      <td>5.356788</td>\n",
       "      <td>8.510296e+06</td>\n",
       "      <td>8.053811e+06</td>\n",
       "      <td>15.901656</td>\n",
       "      <td>14.223292</td>\n",
       "      <td>8046627.00</td>\n",
       "      <td>15.900764</td>\n",
       "      <td>14.222400</td>\n",
       "      <td>8.183993e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>15.909060</td>\n",
       "      <td>14.230696</td>\n",
       "      <td>8.189473e+06</td>\n",
       "      <td>15.918360</td>\n",
       "      <td>14.239996</td>\n",
       "      <td>15.956787</td>\n",
       "      <td>14.278423</td>\n",
       "      <td>1</td>\n",
       "      <td>8.131080e+06</td>\n",
       "      <td>8.129147e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 89 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            building_id  building_area   total_price        pred_1  \\\n",
       "0      e3mMIMR3JJqCaXz1       3.418175  6.476038e+05  6.331552e+05   \n",
       "1      LgwzgklNvy4QCtq5       4.041309  3.321452e+06  3.064324e+06   \n",
       "2      ucIR2NLLsC3T650L       5.584279  9.570885e+06  9.827776e+06   \n",
       "3      jre1pJhcQj91Kdky      13.563031  1.421501e+07  1.255350e+07   \n",
       "4      rQpYpY9nRG7X5mmr       4.688108  7.627120e+05  1.215194e+06   \n",
       "59995  Oh5Hwr9LrWApC2mr       6.754060  9.870214e+05  1.462514e+06   \n",
       "59996  PiOgZqfsDVlTq1zs       5.356788  1.572522e+07  1.419424e+07   \n",
       "59997  FQmlgGohzzWuKUzu       8.223644  1.181540e+07  1.264280e+07   \n",
       "59998  zjzfMwXhDswdEaI2       8.728287  1.808500e+07  1.742945e+07   \n",
       "59999  iN4H6wBMtvJpF0SN       5.356788  8.510296e+06  8.053811e+06   \n",
       "\n",
       "       log_pred_1  log_parea_pred_1       pred_2  log_pred_2  \\\n",
       "0       13.358472         12.129369    717209.94   13.483125   \n",
       "1       14.935338         13.538770   2899842.20   14.880167   \n",
       "2       16.100723         14.380769   9766813.00   16.094501   \n",
       "3       16.345510         13.738164  12699800.00   16.357097   \n",
       "4       14.010415         12.465389   2012610.50   14.514944   \n",
       "59995   14.195668         12.285528   1096943.80   13.908039   \n",
       "59996   16.468347         14.789983  16524961.00   16.620383   \n",
       "59997   16.352598         14.245585  12099525.00   16.308677   \n",
       "59998   16.673672         14.507103  18142848.00   16.713787   \n",
       "59999   15.901656         14.223292   8046627.00   15.900764   \n",
       "\n",
       "       log_parea_pred_2        pred_3          ...            log_pred_26  \\\n",
       "0             12.254022  6.656891e+05          ...              13.377446   \n",
       "1             13.483600  3.079196e+06          ...              14.967557   \n",
       "2             14.374546  9.814852e+06          ...              16.101239   \n",
       "3             13.749750  1.255981e+07          ...              16.360398   \n",
       "4             12.969916  1.128419e+06          ...              13.923838   \n",
       "59995         11.997901  1.450595e+06          ...              14.210747   \n",
       "59996         14.942018  1.488475e+07          ...              16.512304   \n",
       "59997         14.201664  1.259087e+07          ...              16.354649   \n",
       "59998         14.547218  1.685909e+07          ...              16.660162   \n",
       "59999         14.222400  8.183993e+06          ...              15.909060   \n",
       "\n",
       "       log_parea_pred_26       pred_27  log_pred_27  log_parea_pred_27  \\\n",
       "0              12.148343  6.477905e+05    13.381324          12.152221   \n",
       "1              13.570989  3.127411e+06    14.955716          13.559149   \n",
       "2              14.381284  9.745913e+06    16.092359          14.372404   \n",
       "3              13.753051  1.259548e+07    16.348848          13.741502   \n",
       "4              12.378812  1.131428e+06    13.938992          12.393966   \n",
       "59995          12.300607  1.496592e+06    14.218702          12.308562   \n",
       "59996          14.833940  1.457474e+07    16.494800          14.816436   \n",
       "59997          14.247636  1.261376e+07    16.350299          14.243286   \n",
       "59998          14.493594  1.716719e+07    16.658510          14.491942   \n",
       "59999          14.230696  8.189473e+06    15.918360          14.239996   \n",
       "\n",
       "       log_total_price  log_parea_total_price  constant_1  total_price_pred  \\\n",
       "0            13.381036              12.151933           1      6.194845e+05   \n",
       "1            15.015913              13.619345           1      3.062496e+06   \n",
       "2            16.074236              14.354282           1      9.786134e+06   \n",
       "3            16.469809              13.862462           1      1.277164e+07   \n",
       "4            13.544637              11.999613           1      1.246855e+06   \n",
       "59995        13.802448              11.892310           1      1.375179e+06   \n",
       "59996        16.570777              14.892412           1      1.462065e+07   \n",
       "59997        16.284915              14.177902           1      1.256442e+07   \n",
       "59998        16.710593              14.544025           1      1.736432e+07   \n",
       "59999        15.956787              14.278423           1      8.131080e+06   \n",
       "\n",
       "       total_price_pred_corr  \n",
       "0               6.191868e+05  \n",
       "1               3.062662e+06  \n",
       "2               9.788048e+06  \n",
       "3               1.276381e+07  \n",
       "4               1.246212e+06  \n",
       "59995           1.375668e+06  \n",
       "59996           1.463766e+07  \n",
       "59997           1.257876e+07  \n",
       "59998           1.733521e+07  \n",
       "59999           8.129147e+06  \n",
       "\n",
       "[10 rows x 89 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "shape = (60000, 89)\n"
     ]
    }
   ],
   "source": [
    "cv.check()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5990.876636037242"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal_score(cv['total_price'], cv['total_price_pred'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5990.876642967078"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cal_score(cv['total_price'], cv['total_price_pred_corr'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": true,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}