GBM-domestic_box_office.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# imports\n",
    "import h2o \n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import csv\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from h2o.estimators.gbm import H2OGradientBoostingEstimator \n",
    "from h2o.estimators.random_forest import H2ORandomForestEstimator\n",
    "from h2o.grid.grid_search import H2OGridSearch"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Checking whether there is an H2O instance running at http://localhost:54321. connected.\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"overflow:auto\"><table style=\"width:50%\"><tr><td>H2O cluster uptime:</td>\n",
       "<td>18 secs</td></tr>\n",
       "<tr><td>H2O cluster version:</td>\n",
       "<td>3.10.4.8</td></tr>\n",
       "<tr><td>H2O cluster version age:</td>\n",
       "<td>2 months and 19 days </td></tr>\n",
       "<tr><td>H2O cluster name:</td>\n",
       "<td>H2O_from_python_youdan_awm84k</td></tr>\n",
       "<tr><td>H2O cluster total nodes:</td>\n",
       "<td>1</td></tr>\n",
       "<tr><td>H2O cluster free memory:</td>\n",
       "<td>1.311 Gb</td></tr>\n",
       "<tr><td>H2O cluster total cores:</td>\n",
       "<td>1</td></tr>\n",
       "<tr><td>H2O cluster allowed cores:</td>\n",
       "<td>1</td></tr>\n",
       "<tr><td>H2O cluster status:</td>\n",
       "<td>locked, healthy</td></tr>\n",
       "<tr><td>H2O connection url:</td>\n",
       "<td>http://localhost:54321</td></tr>\n",
       "<tr><td>H2O connection proxy:</td>\n",
       "<td>None</td></tr>\n",
       "<tr><td>H2O internal security:</td>\n",
       "<td>False</td></tr>\n",
       "<tr><td>Python version:</td>\n",
       "<td>3.5.2 final</td></tr></table></div>"
      ],
      "text/plain": [
       "--------------------------  -----------------------------\n",
       "H2O cluster uptime:         18 secs\n",
       "H2O cluster version:        3.10.4.8\n",
       "H2O cluster version age:    2 months and 19 days\n",
       "H2O cluster name:           H2O_from_python_youdan_awm84k\n",
       "H2O cluster total nodes:    1\n",
       "H2O cluster free memory:    1.311 Gb\n",
       "H2O cluster total cores:    1\n",
       "H2O cluster allowed cores:  1\n",
       "H2O cluster status:         locked, healthy\n",
       "H2O connection url:         http://localhost:54321\n",
       "H2O connection proxy:\n",
       "H2O internal security:      False\n",
       "Python version:             3.5.2 final\n",
       "--------------------------  -----------------------------"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "h2o.init()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>odid</th>\n",
       "      <th>display_name</th>\n",
       "      <th>od_name</th>\n",
       "      <th>production_year</th>\n",
       "      <th>running_time</th>\n",
       "      <th>sequel</th>\n",
       "      <th>opening_weekend_revenue</th>\n",
       "      <th>opening_weekend_theaters</th>\n",
       "      <th>maximum_theaters</th>\n",
       "      <th>...</th>\n",
       "      <th>rating.PG</th>\n",
       "      <th>rating.PG-13</th>\n",
       "      <th>rating.R</th>\n",
       "      <th>Rank.others.y</th>\n",
       "      <th>Rank.dir_100</th>\n",
       "      <th>Rank.dir_20</th>\n",
       "      <th>Rank.dir_200</th>\n",
       "      <th>Rank.dir_500</th>\n",
       "      <th>Rank.dir_900</th>\n",
       "      <th>Rank.others</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>10100</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>1997</td>\n",
       "      <td>194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28638131</td>\n",
       "      <td>2674</td>\n",
       "      <td>3265</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>20100</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>Dark Knight The</td>\n",
       "      <td>2008</td>\n",
       "      <td>152.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>158411483</td>\n",
       "      <td>4366</td>\n",
       "      <td>4366</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>30100</td>\n",
       "      <td>Star Wars Ep. IV: A New Hope</td>\n",
       "      <td>Star Wars Ep IV A New Hope</td>\n",
       "      <td>1977</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1554475</td>\n",
       "      <td>43</td>\n",
       "      <td>2375</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>40100</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>2004</td>\n",
       "      <td>92.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>108037878</td>\n",
       "      <td>4163</td>\n",
       "      <td>4223</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>50100</td>\n",
       "      <td>ET: The Extra-Terrestrial</td>\n",
       "      <td>ET The Extra Terrestrial</td>\n",
       "      <td>1982</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11911430</td>\n",
       "      <td>1101</td>\n",
       "      <td>3010</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   odid                  display_name  \\\n",
       "0           1  10100                       Titanic   \n",
       "1           2  20100               The Dark Knight   \n",
       "2           3  30100  Star Wars Ep. IV: A New Hope   \n",
       "3           4  40100                       Shrek 2   \n",
       "4           5  50100     ET: The Extra-Terrestrial   \n",
       "\n",
       "                      od_name  production_year  running_time  sequel  \\\n",
       "0                     Titanic             1997         194.0     0.0   \n",
       "1             Dark Knight The             2008         152.0     1.0   \n",
       "2  Star Wars Ep IV A New Hope             1977         119.0     0.0   \n",
       "3                     Shrek 2             2004          92.0     1.0   \n",
       "4    ET The Extra Terrestrial             1982         114.0     0.0   \n",
       "\n",
       "   opening_weekend_revenue  opening_weekend_theaters  maximum_theaters  \\\n",
       "0                 28638131                      2674              3265   \n",
       "1                158411483                      4366              4366   \n",
       "2                  1554475                        43              2375   \n",
       "3                108037878                      4163              4223   \n",
       "4                 11911430                      1101              3010   \n",
       "\n",
       "      ...       rating.PG  rating.PG-13  rating.R  Rank.others.y  \\\n",
       "0     ...               0             1         0            0.0   \n",
       "1     ...               0             1         0            0.0   \n",
       "2     ...               1             0         0            0.0   \n",
       "3     ...               1             0         0            NaN   \n",
       "4     ...               1             0         0            0.0   \n",
       "\n",
       "   Rank.dir_100  Rank.dir_20  Rank.dir_200  Rank.dir_500  Rank.dir_900  \\\n",
       "0           0.0          1.0           0.0           0.0           0.0   \n",
       "1           0.0          1.0           0.0           0.0           0.0   \n",
       "2           0.0          1.0           0.0           0.0           0.0   \n",
       "3           0.0          1.0           0.0           0.0           0.0   \n",
       "4           0.0          1.0           0.0           0.0           0.0   \n",
       "\n",
       "   Rank.others  \n",
       "0          0.0  \n",
       "1          0.0  \n",
       "2          0.0  \n",
       "3          0.0  \n",
       "4          0.0  \n",
       "\n",
       "[5 rows x 60 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"/home/youdan/Documents/Practicum/Encoding_Version4.csv\", sep=',', encoding='latin-1')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "cols = list(df)\n",
    "cols.insert(-1, cols.pop(cols.index('opening_weekend_revenue')))\n",
    "cols\n",
    "cols.insert(-1, cols.pop(cols.index('Rank.others')))\n",
    "#cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>odid</th>\n",
       "      <th>display_name</th>\n",
       "      <th>od_name</th>\n",
       "      <th>production_year</th>\n",
       "      <th>running_time</th>\n",
       "      <th>sequel</th>\n",
       "      <th>opening_weekend_theaters</th>\n",
       "      <th>maximum_theaters</th>\n",
       "      <th>theatrical_engagements</th>\n",
       "      <th>...</th>\n",
       "      <th>rating.PG-13</th>\n",
       "      <th>rating.R</th>\n",
       "      <th>Rank.others.y</th>\n",
       "      <th>Rank.dir_100</th>\n",
       "      <th>Rank.dir_20</th>\n",
       "      <th>Rank.dir_200</th>\n",
       "      <th>Rank.dir_500</th>\n",
       "      <th>Rank.dir_900</th>\n",
       "      <th>Rank.others</th>\n",
       "      <th>opening_weekend_revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>10100</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>1997</td>\n",
       "      <td>194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2674</td>\n",
       "      <td>3265</td>\n",
       "      <td>87202</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28638131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>20100</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>Dark Knight The</td>\n",
       "      <td>2008</td>\n",
       "      <td>152.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4366</td>\n",
       "      <td>4366</td>\n",
       "      <td>39170</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>158411483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>30100</td>\n",
       "      <td>Star Wars Ep. IV: A New Hope</td>\n",
       "      <td>Star Wars Ep IV A New Hope</td>\n",
       "      <td>1977</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43</td>\n",
       "      <td>2375</td>\n",
       "      <td>43684</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1554475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>40100</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>2004</td>\n",
       "      <td>92.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4163</td>\n",
       "      <td>4223</td>\n",
       "      <td>33603</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>108037878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>50100</td>\n",
       "      <td>ET: The Extra-Terrestrial</td>\n",
       "      <td>ET The Extra Terrestrial</td>\n",
       "      <td>1982</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1101</td>\n",
       "      <td>3010</td>\n",
       "      <td>62065</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11911430</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   odid                  display_name  \\\n",
       "0           1  10100                       Titanic   \n",
       "1           2  20100               The Dark Knight   \n",
       "2           3  30100  Star Wars Ep. IV: A New Hope   \n",
       "3           4  40100                       Shrek 2   \n",
       "4           5  50100     ET: The Extra-Terrestrial   \n",
       "\n",
       "                      od_name  production_year  running_time  sequel  \\\n",
       "0                     Titanic             1997         194.0     0.0   \n",
       "1             Dark Knight The             2008         152.0     1.0   \n",
       "2  Star Wars Ep IV A New Hope             1977         119.0     0.0   \n",
       "3                     Shrek 2             2004          92.0     1.0   \n",
       "4    ET The Extra Terrestrial             1982         114.0     0.0   \n",
       "\n",
       "   opening_weekend_theaters  maximum_theaters  theatrical_engagements  \\\n",
       "0                      2674              3265                   87202   \n",
       "1                      4366              4366                   39170   \n",
       "2                        43              2375                   43684   \n",
       "3                      4163              4223                   33603   \n",
       "4                      1101              3010                   62065   \n",
       "\n",
       "            ...             rating.PG-13  rating.R  Rank.others.y  \\\n",
       "0           ...                        1         0            0.0   \n",
       "1           ...                        1         0            0.0   \n",
       "2           ...                        0         0            0.0   \n",
       "3           ...                        0         0            NaN   \n",
       "4           ...                        0         0            0.0   \n",
       "\n",
       "   Rank.dir_100  Rank.dir_20  Rank.dir_200  Rank.dir_500  Rank.dir_900  \\\n",
       "0           0.0          1.0           0.0           0.0           0.0   \n",
       "1           0.0          1.0           0.0           0.0           0.0   \n",
       "2           0.0          1.0           0.0           0.0           0.0   \n",
       "3           0.0          1.0           0.0           0.0           0.0   \n",
       "4           0.0          1.0           0.0           0.0           0.0   \n",
       "\n",
       "   Rank.others  opening_weekend_revenue  \n",
       "0          0.0                 28638131  \n",
       "1          0.0                158411483  \n",
       "2          0.0                  1554475  \n",
       "3          0.0                108037878  \n",
       "4          0.0                 11911430  \n",
       "\n",
       "[5 rows x 60 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.ix[:,cols]\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>odid</th>\n",
       "      <th>display_name</th>\n",
       "      <th>od_name</th>\n",
       "      <th>production_year</th>\n",
       "      <th>running_time</th>\n",
       "      <th>sequel</th>\n",
       "      <th>opening_weekend_theaters</th>\n",
       "      <th>maximum_theaters</th>\n",
       "      <th>theatrical_engagements</th>\n",
       "      <th>production_budget</th>\n",
       "      <th>...</th>\n",
       "      <th>rating.PG-13</th>\n",
       "      <th>rating.R</th>\n",
       "      <th>Rank.others.y</th>\n",
       "      <th>Rank.dir_100</th>\n",
       "      <th>Rank.dir_20</th>\n",
       "      <th>Rank.dir_200</th>\n",
       "      <th>Rank.dir_500</th>\n",
       "      <th>Rank.dir_900</th>\n",
       "      <th>Rank.others</th>\n",
       "      <th>opening_weekend_revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10100</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>Titanic</td>\n",
       "      <td>1997</td>\n",
       "      <td>194.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2674</td>\n",
       "      <td>3265</td>\n",
       "      <td>87202</td>\n",
       "      <td>200000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>28638131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20100</td>\n",
       "      <td>The Dark Knight</td>\n",
       "      <td>Dark Knight The</td>\n",
       "      <td>2008</td>\n",
       "      <td>152.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4366</td>\n",
       "      <td>4366</td>\n",
       "      <td>39170</td>\n",
       "      <td>185000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>158411483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>30100</td>\n",
       "      <td>Star Wars Ep. IV: A New Hope</td>\n",
       "      <td>Star Wars Ep IV A New Hope</td>\n",
       "      <td>1977</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>43</td>\n",
       "      <td>2375</td>\n",
       "      <td>43684</td>\n",
       "      <td>11000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1554475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>40100</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>Shrek 2</td>\n",
       "      <td>2004</td>\n",
       "      <td>92.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4163</td>\n",
       "      <td>4223</td>\n",
       "      <td>33603</td>\n",
       "      <td>70000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>108037878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>50100</td>\n",
       "      <td>ET: The Extra-Terrestrial</td>\n",
       "      <td>ET The Extra Terrestrial</td>\n",
       "      <td>1982</td>\n",
       "      <td>114.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1101</td>\n",
       "      <td>3010</td>\n",
       "      <td>62065</td>\n",
       "      <td>10500000</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11911430</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 59 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    odid                  display_name                     od_name  \\\n",
       "0  10100                       Titanic                     Titanic   \n",
       "1  20100               The Dark Knight             Dark Knight The   \n",
       "2  30100  Star Wars Ep. IV: A New Hope  Star Wars Ep IV A New Hope   \n",
       "3  40100                       Shrek 2                     Shrek 2   \n",
       "4  50100     ET: The Extra-Terrestrial    ET The Extra Terrestrial   \n",
       "\n",
       "   production_year  running_time  sequel  opening_weekend_theaters  \\\n",
       "0             1997         194.0     0.0                      2674   \n",
       "1             2008         152.0     1.0                      4366   \n",
       "2             1977         119.0     0.0                        43   \n",
       "3             2004          92.0     1.0                      4163   \n",
       "4             1982         114.0     0.0                      1101   \n",
       "\n",
       "   maximum_theaters  theatrical_engagements  production_budget  \\\n",
       "0              3265                   87202          200000000   \n",
       "1              4366                   39170          185000000   \n",
       "2              2375                   43684           11000000   \n",
       "3              4223                   33603           70000000   \n",
       "4              3010                   62065           10500000   \n",
       "\n",
       "            ...             rating.PG-13  rating.R  Rank.others.y  \\\n",
       "0           ...                        1         0            0.0   \n",
       "1           ...                        1         0            0.0   \n",
       "2           ...                        0         0            0.0   \n",
       "3           ...                        0         0            NaN   \n",
       "4           ...                        0         0            0.0   \n",
       "\n",
       "   Rank.dir_100  Rank.dir_20  Rank.dir_200  Rank.dir_500  Rank.dir_900  \\\n",
       "0           0.0          1.0           0.0           0.0           0.0   \n",
       "1           0.0          1.0           0.0           0.0           0.0   \n",
       "2           0.0          1.0           0.0           0.0           0.0   \n",
       "3           0.0          1.0           0.0           0.0           0.0   \n",
       "4           0.0          1.0           0.0           0.0           0.0   \n",
       "\n",
       "   Rank.others  opening_weekend_revenue  \n",
       "0          0.0                 28638131  \n",
       "1          0.0                158411483  \n",
       "2          0.0                  1554475  \n",
       "3          0.0                108037878  \n",
       "4          0.0                 11911430  \n",
       "\n",
       "[5 rows x 59 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop('Unnamed: 0', axis=1, inplace=True)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('opening_weekend_revenue.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Parse progress: |█████████████████████████████████████████████████████████| 100%\n",
      "Rows:10594\n",
      "Cols:60\n",
      "\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead>\n",
       "<tr><th>       </th><th>C1              </th><th>odid              </th><th>display_name                              </th><th>od_name                                 </th><th>production_year   </th><th>running_time     </th><th>sequel             </th><th>opening_weekend_theaters  </th><th>maximum_theaters  </th><th>theatrical_engagements  </th><th>production_budget  </th><th>domestic_box_office  </th><th>international_box_office  </th><th>inflation_adjusted_domestic_box_office  </th><th>name_length       </th><th>source_category.fiction_tale_novel  </th><th>source_category.music_dance  </th><th>source_category.original_screenplay  </th><th>source_category.others  </th><th>source_category.play_TV_movie_film  </th><th>source_category.real_factual  </th><th>source_category.NA  </th><th>production_companies_size.Big_15  </th><th>production_companies_size.Extra_small  </th><th>production_companies_size.Large  </th><th>production_companies_size.Medium  </th><th>production_companies_size.NULL  </th><th>production_companies_size.Others  </th><th>production_companies_size.Small  </th><th>Rank.others.x      </th><th>Rank.act_1000      </th><th>Rank.act_250       </th><th>Rank.act_500.x     </th><th>Rank.act_750      </th><th>genre.Action       </th><th>genre.Adventure    </th><th>genre.Comedy      </th><th>genre.Concert/Performance  </th><th>genre.Documentary  </th><th>genre.Drama        </th><th>genre.Horror       </th><th>genre.Musical       </th><th>genre.Others       </th><th>genre.Thriller/Suspense  </th><th>genre.Western        </th><th>rating.G            </th><th>rating.NC-17        </th><th>rating.Not Rated   </th><th>rating.Open          </th><th>rating.PG          </th><th>rating.PG-13       </th><th>rating.R           </th><th>Rank.others.y      </th><th>Rank.dir_100       </th><th>Rank.dir_20         </th><th>Rank.dir_200       </th><th>Rank.dir_500       </th><th>Rank.dir_900       </th><th>Rank.others       </th><th>opening_weekend_revenue  </th></tr>\n",
       "</thead>\n",
       "<tbody>\n",
       "<tr><td>type   </td><td>int             </td><td>int               </td><td>string                                    </td><td>string                                  </td><td>int               </td><td>int              </td><td>int                </td><td>int                       </td><td>int               </td><td>int                     </td><td>int                </td><td>int                  </td><td>int                       </td><td>int                                     </td><td>int               </td><td>int                                 </td><td>int                          </td><td>int                                  </td><td>int                     </td><td>int                                 </td><td>int                           </td><td>int                 </td><td>int                               </td><td>int                                    </td><td>int                              </td><td>int                               </td><td>int                             </td><td>int                               </td><td>int                              </td><td>int                </td><td>int                </td><td>int                </td><td>int                </td><td>int               </td><td>int                </td><td>int                </td><td>int               </td><td>int                        </td><td>int                </td><td>int                </td><td>int                </td><td>int                 </td><td>int                </td><td>int                      </td><td>int                  </td><td>int                 </td><td>int                 </td><td>int                </td><td>int                  </td><td>int                </td><td>int                </td><td>int                </td><td>int                </td><td>int                </td><td>int                 </td><td>int                </td><td>int                </td><td>int                </td><td>int               </td><td>int                      </td></tr>\n",
       "<tr><td>mins   </td><td>0.0             </td><td>10100.0           </td><td>NaN                                       </td><td>NaN                                     </td><td>1902.0            </td><td>0.0              </td><td>0.0                </td><td>0.0                       </td><td>0.0               </td><td>0.0                     </td><td>0.0                </td><td>20.0                 </td><td>0.0                       </td><td>25.0                                    </td><td>1.0               </td><td>0.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>0.0                               </td><td>0.0                                    </td><td>0.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                      </td></tr>\n",
       "<tr><td>mean   </td><td>5296.5          </td><td>115875216.10345477</td><td>NaN                                       </td><td>NaN                                     </td><td>2006.8768170662638</td><td>97.1203738317756 </td><td>0.04843601895734597</td><td>690.8191429110826         </td><td>770.4321313951297 </td><td>3971.1731168586007      </td><td>13874950.005663572 </td><td>18817316.41891638    </td><td>23700190.34523137         </td><td>25434537.117141757                      </td><td>15.635831602794036</td><td>0.1363979611100623                  </td><td>0.003209363790824995         </td><td>0.46913347177647724                  </td><td>0.033226354540305834    </td><td>0.03162167264489334                 </td><td>0.18302812912969604           </td><td>0.14338304700774024 </td><td>0.15747103868054194               </td><td>0.22364029059493418                    </td><td>0.34223443942666404              </td><td>0.36756332220695076               </td><td>0.029255841350873748            </td><td>0.354408010995484                 </td><td>0.30335754957785194              </td><td>0.9393130450258053 </td><td>0.29115500978821857</td><td>0.29186688022779855</td><td>0.25093432995194875</td><td>0.2407901761879338</td><td>0.06248820086841608</td><td>0.04578063054559185</td><td>0.218331130828771 </td><td>0.0047196526335661695      </td><td>0.13045119879176892</td><td>0.30536152539173117</td><td>0.03804040022654333</td><td>0.009533698319803663</td><td>0.1129884840475741 </td><td>0.0686237492920521       </td><td>0.0036813290541816124</td><td>0.016518784217481593</td><td>0.001699074948083821</td><td>0.34642250330375685</td><td>0.0002831791580139702</td><td>0.08778553898433075</td><td>0.20237870492731735</td><td>0.34491221446101566</td><td>0.6189910979228487 </td><td>0.05594207014056511</td><td>0.024563396279994317</td><td>0.04671304841686781</td><td>0.09456197643049835</td><td>0.05849779923328127</td><td>0.7197217094987931</td><td>5091609.640362451        </td></tr>\n",
       "<tr><td>maxs   </td><td>10593.0         </td><td>284460100.0       </td><td>NaN                                       </td><td>NaN                                     </td><td>2017.0            </td><td>600.0            </td><td>1.0                </td><td>4468.0                    </td><td>4468.0            </td><td>87202.0                 </td><td>425000000.0        </td><td>936662225.0          </td><td>2023411357.0              </td><td>3926220158.0                            </td><td>86.0              </td><td>1.0                                 </td><td>1.0                          </td><td>1.0                                  </td><td>1.0                     </td><td>1.0                                 </td><td>1.0                           </td><td>1.0                 </td><td>1.0                               </td><td>1.0                                    </td><td>1.0                              </td><td>1.0                               </td><td>1.0                             </td><td>1.0                               </td><td>1.0                              </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0               </td><td>1.0                </td><td>1.0                </td><td>1.0               </td><td>1.0                        </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                 </td><td>1.0                </td><td>1.0                      </td><td>1.0                  </td><td>1.0                 </td><td>1.0                 </td><td>1.0                </td><td>1.0                  </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                 </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0               </td><td>247966675.0              </td></tr>\n",
       "<tr><td>sigma  </td><td>3058.36871005879</td><td>73795347.49056596 </td><td>NaN                                       </td><td>NaN                                     </td><td>7.246012430689698 </td><td>35.68271325565838</td><td>0.21469592487208042</td><td>1194.5515895877886        </td><td>1211.0350312240892</td><td>7296.221585490208       </td><td>32428855.81257     </td><td>49544119.22891575    </td><td>79907153.02579232         </td><td>81581240.00872976                       </td><td>8.748804928832836 </td><td>0.3432268597563215                  </td><td>0.056562936387576646         </td><td>0.4990699029049416                   </td><td>0.17923558887256325     </td><td>0.17499895204443025                 </td><td>0.38670783401998826           </td><td>0.3504795909867218  </td><td>0.36428006536298047               </td><td>0.41672461972231983                    </td><td>0.4745042006820493               </td><td>0.48218894479410784               </td><td>0.16853935582423948             </td><td>0.47838050394022985               </td><td>0.4597534658832248               </td><td>0.23877645434631053</td><td>0.4543352355118052 </td><td>0.4546618451710317 </td><td>0.4335893793321747 </td><td>0.4276012246670089</td><td>0.24205155651442375</td><td>0.2090188707748133 </td><td>0.4131328588104461</td><td>0.0685406518370333         </td><td>0.3368150707554786 </td><td>0.4605821190148933 </td><td>0.19130285585735743</td><td>0.09717869280693708 </td><td>0.31659366336356903</td><td>0.2528251648517537       </td><td>0.06056503212180223  </td><td>0.1274654762343041  </td><td>0.041186748061616936</td><td>0.4758522107022408 </td><td>0.016826339253588646 </td><td>0.28299610910201783</td><td>0.401791990004691  </td><td>0.4753620816710066 </td><td>0.48568280066823444</td><td>0.2298261399008838 </td><td>0.1548012864635308  </td><td>0.2110385347407767 </td><td>0.29262974476810405</td><td>0.23469901526051537</td><td>0.4491670245941515</td><td>14355630.602723205       </td></tr>\n",
       "<tr><td>zeros  </td><td>1               </td><td>0                 </td><td>0                                         </td><td>0                                       </td><td>0                 </td><td>429              </td><td>10039              </td><td>953                       </td><td>78                </td><td>249                     </td><td>6617               </td><td>0                    </td><td>5324                      </td><td>0                                       </td><td>0                 </td><td>9149                                </td><td>10560                        </td><td>5624                                 </td><td>10242                   </td><td>10259                               </td><td>8655                          </td><td>9075                </td><td>4291                              </td><td>3954                                   </td><td>3350                             </td><td>3221                              </td><td>4944                            </td><td>3288                              </td><td>3548                             </td><td>341                </td><td>3983               </td><td>3979               </td><td>4209               </td><td>4266              </td><td>9932               </td><td>10109              </td><td>8281              </td><td>10544                      </td><td>9212               </td><td>7359               </td><td>10191              </td><td>10493               </td><td>9397               </td><td>9867                     </td><td>10555                </td><td>10419               </td><td>10576               </td><td>6924               </td><td>10591                </td><td>9664               </td><td>8450               </td><td>6940               </td><td>1926               </td><td>6649               </td><td>6870                </td><td>6714               </td><td>6377               </td><td>6631               </td><td>1974              </td><td>948                      </td></tr>\n",
       "<tr><td>missing</td><td>0               </td><td>0                 </td><td>0                                         </td><td>0                                       </td><td>0                 </td><td>5244             </td><td>44                 </td><td>0                         </td><td>0                 </td><td>0                       </td><td>0                  </td><td>0                    </td><td>4                         </td><td>0                                       </td><td>0                 </td><td>0                                   </td><td>0                            </td><td>0                                    </td><td>0                       </td><td>0                                   </td><td>0                             </td><td>0                   </td><td>5501                              </td><td>5501                                   </td><td>5501                             </td><td>5501                              </td><td>5501                            </td><td>5501                              </td><td>5501                             </td><td>4975               </td><td>4975               </td><td>4975               </td><td>4975               </td><td>4975              </td><td>0                  </td><td>0                  </td><td>0                 </td><td>0                          </td><td>0                  </td><td>0                  </td><td>0                  </td><td>0                   </td><td>0                  </td><td>0                        </td><td>0                    </td><td>0                   </td><td>0                   </td><td>0                  </td><td>0                    </td><td>0                  </td><td>0                  </td><td>0                  </td><td>5539               </td><td>3551               </td><td>3551                </td><td>3551               </td><td>3551               </td><td>3551               </td><td>3551              </td><td>0                        </td></tr>\n",
       "<tr><td>0      </td><td>0.0             </td><td>10100.0           </td><td>Titanic                                   </td><td>Titanic                                 </td><td>1997.0            </td><td>194.0            </td><td>0.0                </td><td>2674.0                    </td><td>3265.0            </td><td>87202.0                 </td><td>200000000.0        </td><td>658672302.0          </td><td>1548943366.0              </td><td>1147349023.0                            </td><td>7.0               </td><td>0.0                                 </td><td>0.0                          </td><td>1.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>1.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>28638131.0               </td></tr>\n",
       "<tr><td>1      </td><td>1.0             </td><td>20100.0           </td><td>The Dark Knight                           </td><td>Dark Knight The                         </td><td>2008.0            </td><td>152.0            </td><td>1.0                </td><td>4366.0                    </td><td>4366.0            </td><td>39170.0                 </td><td>185000000.0        </td><td>533345358.0          </td><td>469546000.0               </td><td>626080555.0                             </td><td>15.0              </td><td>1.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>0.0                </td><td>0.0               </td><td>1.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>158411483.0              </td></tr>\n",
       "<tr><td>2      </td><td>2.0             </td><td>30100.0           </td><td>Star Wars Ep. IV: A New Hope              </td><td>Star Wars Ep IV A New Hope              </td><td>1977.0            </td><td>119.0            </td><td>0.0                </td><td>43.0                      </td><td>2375.0            </td><td>43684.0                 </td><td>11000000.0         </td><td>460998007.0          </td><td>325600000.0               </td><td>1385311974.0                            </td><td>28.0              </td><td>0.0                                 </td><td>0.0                          </td><td>1.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>0.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>0.0                </td><td>1.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>1554475.0                </td></tr>\n",
       "<tr><td>3      </td><td>3.0             </td><td>40100.0           </td><td>Shrek 2                                   </td><td>Shrek 2                                 </td><td>2004.0            </td><td>92.0             </td><td>1.0                </td><td>4163.0                    </td><td>4223.0            </td><td>33603.0                 </td><td>70000000.0         </td><td>441226247.0          </td><td>495781885.0               </td><td>598959298.0                             </td><td>7.0               </td><td>1.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>0.0                </td><td>1.0                </td><td>1.0                </td><td>0.0                </td><td>1.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>nan                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>108037878.0              </td></tr>\n",
       "<tr><td>4      </td><td>4.0             </td><td>50100.0           </td><td>ET: The Extra-Terrestrial                 </td><td>ET The Extra Terrestrial                </td><td>1982.0            </td><td>114.0            </td><td>0.0                </td><td>1101.0                    </td><td>3010.0            </td><td>62065.0                 </td><td>10500000.0         </td><td>435110554.0          </td><td>357854772.0               </td><td>1133175867.0                            </td><td>25.0              </td><td>0.0                                 </td><td>0.0                          </td><td>1.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>0.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>11911430.0               </td></tr>\n",
       "<tr><td>5      </td><td>5.0             </td><td>60100.0           </td><td>Star Wars Ep. I: The Phantom Menace       </td><td>Star Wars Ep I The Phantom Menace       </td><td>1999.0            </td><td>133.0            </td><td>1.0                </td><td>2970.0                    </td><td>3126.0            </td><td>47092.0                 </td><td>115000000.0        </td><td>474544677.0          </td><td>552500000.0               </td><td>761329663.0                             </td><td>35.0              </td><td>0.0                                 </td><td>0.0                          </td><td>1.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>1.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>64810970.0               </td></tr>\n",
       "<tr><td>6      </td><td>6.0             </td><td>70100.0           </td><td>Pirates of the Caribbean: Dead ManÍs Chest</td><td>Pirates of the Caribbean Dead Mans Chest</td><td>2006.0            </td><td>151.0            </td><td>1.0                </td><td>4133.0                    </td><td>4133.0            </td><td>34395.0                 </td><td>225000000.0        </td><td>423315812.0          </td><td>642900000.0               </td><td>544817142.0                             </td><td>42.0              </td><td>0.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>1.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>135634554.0              </td></tr>\n",
       "<tr><td>7      </td><td>7.0             </td><td>80100.0           </td><td>Spider-Man                                </td><td>Spider Man                              </td><td>2002.0            </td><td>121.0            </td><td>0.0                </td><td>3615.0                    </td><td>3876.0            </td><td>31297.0                 </td><td>139000000.0        </td><td>403706375.0          </td><td>418000000.0               </td><td>585756409.0                             </td><td>10.0              </td><td>1.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>0.0                </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>114844116.0              </td></tr>\n",
       "<tr><td>8      </td><td>8.0             </td><td>90100.0           </td><td>Transformers: Revenge of the Fallen       </td><td>Transformers Revenge of the Fallen      </td><td>2009.0            </td><td>149.0            </td><td>1.0                </td><td>4234.0                    </td><td>4293.0            </td><td>28686.0                 </td><td>210000000.0        </td><td>402111870.0          </td><td>434407829.0               </td><td>451973742.0                             </td><td>35.0              </td><td>0.0                                 </td><td>0.0                          </td><td>0.0                                  </td><td>0.0                     </td><td>1.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>1.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>1.0                </td><td>0.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>108966307.0              </td></tr>\n",
       "<tr><td>9      </td><td>9.0             </td><td>100100.0          </td><td>Star Wars Ep. III: Revenge of the Sith    </td><td>Star Wars Ep III Revenge of the Sith    </td><td>2005.0            </td><td>139.0            </td><td>1.0                </td><td>3661.0                    </td><td>3663.0            </td><td>26895.0                 </td><td>115000000.0        </td><td>380270577.0          </td><td>468728300.0               </td><td>500106226.0                             </td><td>38.0              </td><td>0.0                                 </td><td>0.0                          </td><td>1.0                                  </td><td>0.0                     </td><td>0.0                                 </td><td>0.0                           </td><td>0.0                 </td><td>0.0                               </td><td>0.0                                    </td><td>1.0                              </td><td>0.0                               </td><td>0.0                             </td><td>0.0                               </td><td>0.0                              </td><td>1.0                </td><td>1.0                </td><td>1.0                </td><td>0.0                </td><td>1.0               </td><td>0.0                </td><td>1.0                </td><td>0.0               </td><td>0.0                        </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                 </td><td>0.0                </td><td>0.0                      </td><td>0.0                  </td><td>0.0                 </td><td>0.0                 </td><td>0.0                </td><td>0.0                  </td><td>0.0                </td><td>1.0                </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>1.0                 </td><td>0.0                </td><td>0.0                </td><td>0.0                </td><td>0.0               </td><td>108435841.0              </td></tr>\n",
       "</tbody>\n",
       "</table>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "path = '/home/youdan/Documents/Practicum/opening_weekend_revenue.csv'\n",
    "frame = h2o.import_file(path=path) # multi-threaded import\n",
    "frame.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "opening_weekend_revenue\n",
      "['display_name', 'od_name', 'production_year', 'running_time', 'sequel', 'opening_weekend_theaters', 'maximum_theaters', 'theatrical_engagements', 'production_budget', 'name_length', 'source_category.fiction_tale_novel', 'source_category.music_dance', 'source_category.original_screenplay', 'source_category.others', 'source_category.play_TV_movie_film', 'source_category.real_factual', 'source_category.NA', 'production_companies_size.Big_15', 'production_companies_size.Extra_small', 'production_companies_size.Large', 'production_companies_size.Medium', 'production_companies_size.NULL', 'production_companies_size.Others', 'production_companies_size.Small', 'Rank.others.x', 'Rank.act_1000', 'Rank.act_250', 'Rank.act_500.x', 'Rank.act_750', 'genre.Action', 'genre.Adventure', 'genre.Comedy', 'genre.Concert/Performance', 'genre.Documentary', 'genre.Drama', 'genre.Horror', 'genre.Musical', 'genre.Others', 'genre.Thriller/Suspense', 'genre.Western', 'rating.G', 'rating.NC-17', 'rating.Not Rated', 'rating.Open', 'rating.PG', 'rating.PG-13', 'rating.R', 'Rank.others.y', 'Rank.dir_100', 'Rank.dir_20', 'Rank.dir_200', 'Rank.dir_500', 'Rank.dir_900', 'Rank.others']\n"
     ]
    }
   ],
   "source": [
    "# split into 40% training, 30% validation, and 30% test\n",
    "train, valid, test = frame.split_frame([0.4, 0.3])\n",
    "y = 'opening_weekend_revenue'\n",
    "X = [name for name in frame.columns if name not in ['Unnamed: 0 ', 'C1','odid', 'odname', 'domestic_box_office', 'international_box_office','inflation_adjusted_domestic_box_office',y]]\n",
    "print(y)\n",
    "print(X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "gbm Grid Build progress: |████████████████████████████████████████████████| 100%\n"
     ]
    }
   ],
   "source": [
    "# GBM with random hyperparameter search\n",
    "# train many different GBM models with random hyperparameters\n",
    "# and select best model based on validation error\n",
    "\n",
    "# define random grid search parameters\n",
    "hyper_parameters = {'ntrees':list(range(0, 500, 50)),\n",
    "                    'max_depth':list(range(0, 20, 2)),\n",
    "                    'sample_rate':[s/float(10) for s in range(1, 11)],\n",
    "                    'col_sample_rate':[s/float(10) for s in range(1, 11)]}\n",
    "\n",
    "# define search strategy\n",
    "search_criteria = {'strategy':'RandomDiscrete',\n",
    "                   'max_models':20,\n",
    "                   'max_runtime_secs':600}\n",
    "\n",
    "# initialize grid search\n",
    "gsearch = H2OGridSearch(H2OGradientBoostingEstimator,\n",
    "                        hyper_params=hyper_parameters,\n",
    "                        search_criteria=search_criteria)\n",
    "\n",
    "# execute training w/ grid search\n",
    "gsearch.train(x=X,\n",
    "              y=y,\n",
    "              training_frame=train,\n",
    "              validation_frame=valid)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     col_sample_rate max_depth ntrees sample_rate  \\\n",
      "0                0.3        10    250         0.6   \n",
      "1                0.3        16     50         0.6   \n",
      "2                0.4        10    100         0.6   \n",
      "3                0.3        18    300         0.8   \n",
      "4                0.6        18    100         0.1   \n",
      "5                0.7         4    200         0.3   \n",
      "6                0.2        14    150         0.5   \n",
      "7                0.5        14    250         0.2   \n",
      "8                0.2        18    350         0.5   \n",
      "9                0.4        10    100         0.3   \n",
      "10               0.7        10    300         0.3   \n",
      "11               1.0        12     50         1.0   \n",
      "12               0.9        18    150         1.0   \n",
      "13               0.3        12    200         0.1   \n",
      "14               1.0        10    300         0.8   \n",
      "15               0.4        14    450         0.1   \n",
      "16               0.1        10    400         0.1   \n",
      "17               0.5        16      0         0.8   \n",
      "\n",
      "                                                       model_ids  \\\n",
      "0    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_4   \n",
      "1    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_2   \n",
      "2    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_3   \n",
      "3    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_5   \n",
      "4    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_7   \n",
      "5   Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_17   \n",
      "6   Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_11   \n",
      "7   Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_18   \n",
      "8    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_9   \n",
      "9    Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_8   \n",
      "10  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_15   \n",
      "11   Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_6   \n",
      "12  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_10   \n",
      "13  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_14   \n",
      "14  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_12   \n",
      "15   Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_1   \n",
      "16  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_13   \n",
      "17  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_19   \n",
      "\n",
      "        residual_deviance  \n",
      "0    2.434732112830511E13  \n",
      "1   2.5423574436974504E13  \n",
      "2    2.561500897437175E13  \n",
      "3   2.5674888980647234E13  \n",
      "4   2.6873102573233668E13  \n",
      "5   2.6890558373165234E13  \n",
      "6   2.6965932293614594E13  \n",
      "7     2.71985135885267E13  \n",
      "8   2.7608491543354977E13  \n",
      "9    2.834449471844503E13  \n",
      "10   2.856911224458662E13  \n",
      "11  2.8672615813178754E13  \n",
      "12  2.9100883688524254E13  \n",
      "13   2.937040100059576E13  \n",
      "14   2.964778055880041E13  \n",
      "15   3.162741603156698E13  \n",
      "16   3.326426315938199E13  \n",
      "17   1.838160719165445E14  \n",
      "Model Details\n",
      "=============\n",
      "H2OGradientBoostingEstimator :  Gradient Boosting Machine\n",
      "Model Key:  Grid_GBM_py_3_sid_b31b_model_python_1502305177818_1_model_4\n",
      "\n",
      "\n",
      "ModelMetricsRegression: gbm\n",
      "** Reported on train data. **\n",
      "\n",
      "MSE: 2743941704670.736\n",
      "RMSE: 1656484.7432653087\n",
      "MAE: 516134.58112983714\n",
      "RMSLE: NaN\n",
      "Mean Residual Deviance: 2743941704670.736\n",
      "\n",
      "ModelMetricsRegression: gbm\n",
      "** Reported on validation data. **\n",
      "\n",
      "MSE: 24347321128305.11\n",
      "RMSE: 4934300.470006373\n",
      "MAE: 1592329.6918092952\n",
      "RMSLE: NaN\n",
      "Mean Residual Deviance: 24347321128305.11\n",
      "Scoring History: \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"overflow:auto\"><table style=\"width:50%\"><tr><td><b></b></td>\n",
       "<td><b>timestamp</b></td>\n",
       "<td><b>duration</b></td>\n",
       "<td><b>number_of_trees</b></td>\n",
       "<td><b>training_rmse</b></td>\n",
       "<td><b>training_mae</b></td>\n",
       "<td><b>training_deviance</b></td>\n",
       "<td><b>validation_rmse</b></td>\n",
       "<td><b>validation_mae</b></td>\n",
       "<td><b>validation_deviance</b></td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:06</td>\n",
       "<td>32.531 sec</td>\n",
       "<td>0.0</td>\n",
       "<td>14884251.0762023</td>\n",
       "<td>7522932.3997815</td>\n",
       "<td>221540930099428.7187500</td>\n",
       "<td>13557878.5920418</td>\n",
       "<td>7479167.0387013</td>\n",
       "<td>183816071916544.5000000</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:06</td>\n",
       "<td>32.569 sec</td>\n",
       "<td>1.0</td>\n",
       "<td>13760777.7364060</td>\n",
       "<td>6795688.5285582</td>\n",
       "<td>189359003910766.9687500</td>\n",
       "<td>12496472.5031604</td>\n",
       "<td>6755974.4353661</td>\n",
       "<td>156161825022243.4062500</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:06</td>\n",
       "<td>32.596 sec</td>\n",
       "<td>2.0</td>\n",
       "<td>12671364.0946424</td>\n",
       "<td>6134899.9954144</td>\n",
       "<td>160563468018993.6875000</td>\n",
       "<td>11477913.3019423</td>\n",
       "<td>6102167.9167823</td>\n",
       "<td>131742493766903.0625000</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:06</td>\n",
       "<td>32.622 sec</td>\n",
       "<td>3.0</td>\n",
       "<td>11842101.6450433</td>\n",
       "<td>5581201.4964012</td>\n",
       "<td>140235371371536.2500000</td>\n",
       "<td>10643531.6523786</td>\n",
       "<td>5544801.9361157</td>\n",
       "<td>113284766035186.0156250</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:06</td>\n",
       "<td>32.650 sec</td>\n",
       "<td>4.0</td>\n",
       "<td>10937293.0540207</td>\n",
       "<td>5054946.8544230</td>\n",
       "<td>119624379349529.4062500</td>\n",
       "<td>9860516.0981840</td>\n",
       "<td>5042419.0980366</td>\n",
       "<td>97229777722546.0156250</td></tr>\n",
       "<tr><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></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:09</td>\n",
       "<td>36.243 sec</td>\n",
       "<td>66.0</td>\n",
       "<td>3495424.2878201</td>\n",
       "<td>921048.4523676</td>\n",
       "<td>12217990951882.4082031</td>\n",
       "<td>4966480.2276763</td>\n",
       "<td>1545754.0187810</td>\n",
       "<td>24665925851899.8203125</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:09</td>\n",
       "<td>36.338 sec</td>\n",
       "<td>67.0</td>\n",
       "<td>3480603.0483884</td>\n",
       "<td>919929.7377348</td>\n",
       "<td>12114597580450.5273438</td>\n",
       "<td>4976028.0608303</td>\n",
       "<td>1548031.8835935</td>\n",
       "<td>24760855262170.8984375</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:10</td>\n",
       "<td>36.422 sec</td>\n",
       "<td>68.0</td>\n",
       "<td>3462891.1934177</td>\n",
       "<td>919062.5412798</td>\n",
       "<td>11991615417449.8281250</td>\n",
       "<td>4970784.7881827</td>\n",
       "<td>1549871.4424014</td>\n",
       "<td>24708701410428.7304688</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:10</td>\n",
       "<td>36.511 sec</td>\n",
       "<td>69.0</td>\n",
       "<td>3443823.8569367</td>\n",
       "<td>914041.5831007</td>\n",
       "<td>11859922757606.1191406</td>\n",
       "<td>4975699.9523771</td>\n",
       "<td>1551297.4242154</td>\n",
       "<td>24757590016085.0703125</td></tr>\n",
       "<tr><td></td>\n",
       "<td>2017-08-09 12:01:13</td>\n",
       "<td>40.005 sec</td>\n",
       "<td>250.0</td>\n",
       "<td>1656484.7432653</td>\n",
       "<td>516134.5811298</td>\n",
       "<td>2743941704670.7358398</td>\n",
       "<td>4934300.4700064</td>\n",
       "<td>1592329.6918093</td>\n",
       "<td>24347321128305.1093750</td></tr></table></div>"
      ],
      "text/plain": [
       "     timestamp            duration    number_of_trees    training_rmse       training_mae        training_deviance    validation_rmse     validation_mae      validation_deviance\n",
       "---  -------------------  ----------  -----------------  ------------------  ------------------  -------------------  ------------------  ------------------  ---------------------\n",
       "     2017-08-09 12:01:06  32.531 sec  0.0                14884251.076202279  7522932.399781452   221540930099428.72   13557878.592041768  7479167.038701325   183816071916544.5\n",
       "     2017-08-09 12:01:06  32.569 sec  1.0                13760777.736405997  6795688.528558161   189359003910766.97   12496472.503160378  6755974.435366128   156161825022243.4\n",
       "     2017-08-09 12:01:06  32.596 sec  2.0                12671364.094642442  6134899.995414441   160563468018993.7    11477913.30194226   6102167.916782259   131742493766903.06\n",
       "     2017-08-09 12:01:06  32.622 sec  3.0                11842101.645043258  5581201.4964012075  140235371371536.25   10643531.652378641  5544801.936115692   113284766035186.02\n",
       "     2017-08-09 12:01:06  32.650 sec  4.0                10937293.054020697  5054946.854423032   119624379349529.4    9860516.09818401    5042419.098036626   97229777722546.02\n",
       "---  ---                  ---         ---                ---                 ---                 ---                  ---                 ---                 ---\n",
       "     2017-08-09 12:01:09  36.243 sec  66.0               3495424.287820065   921048.4523675625   12217990951882.408   4966480.227676319   1545754.0187810306  24665925851899.82\n",
       "     2017-08-09 12:01:09  36.338 sec  67.0               3480603.048388386   919929.7377348103   12114597580450.527   4976028.060830334   1548031.88359349    24760855262170.9\n",
       "     2017-08-09 12:01:10  36.422 sec  68.0               3462891.193417695   919062.5412797611   11991615417449.828   4970784.788182721   1549871.4424013784  24708701410428.73\n",
       "     2017-08-09 12:01:10  36.511 sec  69.0               3443823.856936664   914041.5831006903   11859922757606.12    4975699.9523770595  1551297.424215396   24757590016085.07\n",
       "     2017-08-09 12:01:13  40.005 sec  250.0              1656484.7432653087  516134.58112983714  2743941704670.736    4934300.470006373   1592329.6918092952  24347321128305.11"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "See the whole table with table.as_data_frame()\n",
      "Variable Importances: \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div style=\"overflow:auto\"><table style=\"width:50%\"><tr><td><b>variable</b></td>\n",
       "<td><b>relative_importance</b></td>\n",
       "<td><b>scaled_importance</b></td>\n",
       "<td><b>percentage</b></td></tr>\n",
       "<tr><td>maximum_theaters</td>\n",
       "<td>1407394262445719552.0000000</td>\n",
       "<td>1.0</td>\n",
       "<td>0.3348475</td></tr>\n",
       "<tr><td>opening_weekend_theaters</td>\n",
       "<td>1241425181256187904.0000000</td>\n",
       "<td>0.8820735</td>\n",
       "<td>0.2953601</td></tr>\n",
       "<tr><td>theatrical_engagements</td>\n",
       "<td>542401627286405120.0000000</td>\n",
       "<td>0.3853942</td>\n",
       "<td>0.1290483</td></tr>\n",
       "<tr><td>production_budget</td>\n",
       "<td>480129274418823168.0000000</td>\n",
       "<td>0.3411477</td>\n",
       "<td>0.1142324</td></tr>\n",
       "<tr><td>Rank.others.y</td>\n",
       "<td>76410174025236480.0000000</td>\n",
       "<td>0.0542919</td>\n",
       "<td>0.0181795</td></tr>\n",
       "<tr><td>---</td>\n",
       "<td>---</td>\n",
       "<td>---</td>\n",
       "<td>---</td></tr>\n",
       "<tr><td>source_category.NA</td>\n",
       "<td>35869290496.0000000</td>\n",
       "<td>0.0000000</td>\n",
       "<td>0.0000000</td></tr>\n",
       "<tr><td>genre.Others</td>\n",
       "<td>10548208640.0000000</td>\n",
       "<td>0.0000000</td>\n",
       "<td>0.0000000</td></tr>\n",
       "<tr><td>source_category.music_dance</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td></tr>\n",
       "<tr><td>rating.NC-17</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td></tr>\n",
       "<tr><td>rating.Open</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td>\n",
       "<td>0.0</td></tr></table></div>"
      ],
      "text/plain": [
       "variable                     relative_importance     scaled_importance      percentage\n",
       "---------------------------  ----------------------  ---------------------  ----------------------\n",
       "maximum_theaters             1.4073942624457196e+18  1.0                    0.3348474785459035\n",
       "opening_weekend_theaters     1.241425181256188e+18   0.8820734987926436     0.2953600869628798\n",
       "theatrical_engagements       5.424016272864051e+17   0.38539422943492674    0.12904828597242665\n",
       "production_budget            4.801292744188232e+17   0.34114767072054963    0.11423243735258422\n",
       "Rank.others.y                7.641017402523648e+16   0.054291946517142683   0.018179521396614277\n",
       "---                          ---                     ---                    ---\n",
       "source_category.NA           35869290496.0           2.548631286422017e-08  8.53402760001615e-09\n",
       "genre.Others                 10548208640.0           7.494849823865063e-09  2.5096315656014252e-09\n",
       "source_category.music_dance  0.0                     0.0                    0.0\n",
       "rating.NC-17                 0.0                     0.0                    0.0\n",
       "rating.Open                  0.0                     0.0                    0.0"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "See the whole table with table.as_data_frame()\n"
     ]
    },
    {
     "data": {
      "text/plain": []
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# show grid search results\n",
    "gsearch.show()\n",
    "\n",
    "# select best model\n",
    "gbm_model = gsearch.get_grid()[0]\n",
    "\n",
    "# print model information\n",
    "gbm_model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA94AAAJeCAYAAABCqt1HAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3Xe4JVWd7vHvC400oIABE0qjiIwMICAqSUVRZxwUQcwJ\nzKNewTDOoLbiqFdQx4B4HUURQdQRxYCikkQk5ygYgTahjIEgCgr9u3/UOt27N3ufc7o51fH7eZ7z\nnL2raoWqfVp591q1KlWFJEmSJEnqx2rLugOSJEmSJK3MDN6SJEmSJPXI4C1JkiRJUo8M3pIkSZIk\n9cjgLUmSJElSjwzekiRJkiT1yOAtSdJiSnJ6kr/PQD2/SvKTxTh+kyTzkxx6Z9uWJElLj8FbkrTc\nS3JUC5z/Oo1jT2jHPr3HLhUwf4bqWa60LxXmJ9lxWfelb4v7xceqIMmu7fM/YZJjJr4A+snQ9g2T\n7JfkO0muTnJLkt8nOX6qf49JZiV5efv3+7skt7bfxyd5SZLV7+Q5HZnkJ0lubHVfm+TEJP+e5P4j\nykz8Oxj8+XuS3yb5ZpInjyiz+sCxtyV54CR9Om3g2Ocv6blJWnHMWtYdkCRpGj4FPB94OfCJcQcl\nmQPsCvwa+GaP/XkesFaP9S9LxXL4hUBPVpXzXFpeD7wJ+DlwMvA7YGNgT+BJSd5fVfsPF2oB9ZvA\nVsC17fVvgfsC/wI8CXhNkt2r6trpdibJesCRwNOAW4EftLr/AmwAPBo4EHhnkkdV1eUDxSf+HRwO\n/KJtWwt4GPAUYLckL62qz45o+u90/439MuCdI/q1GbDTwHGSVgH+Y5ckLfeq6tQ2urZNkq2r6uIx\nh74cCHB4Vc3EiPS4/vyqr7qlFdhZwGOq6ozBjUk2b/venOTzVXXZwL51gOOBzYBPA6+rqlsH9q9F\n92Xbi4DjkuwwuH+cNkL+NWAX4CRg71GhvfXtXcC6Y6r6TFWdOVTmWcCXgLcCnx1R5tfAn4CXJvnP\nqhr+gueVdKH+W8AeU52LpJWDU80lSSuKT9GF6leM2plkNWAfuinghw1sv3+SA5Kc0aaX3tqmGB/V\nRp6G61lwH3WShyb5cpLrktw+Mf161D3eSe6S5HVJvp3kmjbN9g9t6uwdpqUOlV0vyceT/DrJX5Nc\nnuQ1i3Nxkqyd5K1JLk7y5yQ3tXN+9uLUM0n9v2pTde+W5OAkv0zylyQXJnlaO2b1JG9vx/01yU8z\n4vaAgenMb02yY5KTk9zQfr6dZJsxfVgvyfsG6v9DumnNj5+ijUe3ev/QPscXJJkP3B94yNB04kMH\n6nhG+zv5ycA1PS/Ja5NkRJsTt0RsmOQ1SS5r/bw2yX8nuduY83pAkkMGzuv3Sc5J8tYxx348yc+z\ncCr315NsO9nntzRU1VeHQ3fbfgXwlfZ2l6Hdbwb+ATi1ql45HKqr6q/AS4BzgIcD+06zO3u3tq4A\nnjZupLyqrqiqZwJnT7NegBPb7w0mOeZTwAPoRscXSLIG3ZcIPwC8zUFahRi8JUkriiOAvwHPSzJ7\nxP5/ATYETqyqeQPbHw/8G/AHuv/4/zDdf8Q/CzinjXiNshlwLl04+xxwKHBT2zdqOvYGre51gBOA\nDwLfALYFvpPkxWPaWRP4HvAE4POtnXsAH0vy4TFlFpFkfeBM4N101+gwupG4ewP/k+Qd06lnCtX6\nehLd1N+v0V2XhwDHJHkc8FW6WQffoxu9vBvw/5LsOabOnYBTgJuBQ4DvtrpPT7L90DnenS4cTXyW\nH27t7QiclOSlY9p4DF3ImdX6dCRd4Hkn8Gfgj8AB7f07gWMHyr6PLuydBXy0lb1b6+unx1yjAj5E\n91lcCHyMbvr0q1gYPgfP69HApcBrgF8CHwG+QPe39vahY7cDLqEbMb0SOLj193HAmUmeOHT8xD3H\nfxtzbZamiS+qbhva/nK6a/aecQXb7JX30n3x9spptveKVu/7pzNCvpgzZJ7Ufp83yTGfp5vS/vKh\n7c8A7kkXzCWtSqrKH3/88ccff1aIH+B/gNuBF4/Y9422b8+h7RsAa484/uF0wesbQ9s3oRs1vx04\nYEw/TgP+NrRtTeB+I45dl27U7XfAGkP7ftna+R4wa2D7PYCr2r7tR/Tt0KF6jmrH7jeiTyfQhZ1/\nnOY1Pq3VteOYvh4zeB50o4rz6cLwmcBdB/Y9hO6LgHOG6tp14Bq/Ymjfnm3fFUPbD2vHHzK0/aHA\njXQhZ8Mxbewz5lx/CfxkkmvxoDHbJ673NkPbP9fa/Png3wKwOnBGK7P1wPa70N0/fDuw14h27j/w\nelb7m7gZ2GH4OOA3ra5ZQ+3OB25djH9jE9ftZ3RfSIz6ObgdM/baDdW5HnAdXfjeZGD7xq2eWxj6\ntzGijnXa3/HtwL2nOHaN1tbtwAOne+5j/h0cNnDeBwFfp7tf/BJg06EyE9f7qvb+8HbsfQaOOQn4\nffvsD2xtPH9J+uiPP/6sWD+OeEuSViSH0o16LTKKlOS+dFM6r2PREUuq6n+r6i/DFVXVJcCpwK6j\npg3TBZn/O92OVdWtNWI6a1XdSPcf4PcCHjGm+P5VddtAmT+2tkM3zXasJBsAzwXOrqqDh/sE7E83\nw+150z2XKexXVQum2VfV9+kC7PrAm6vqzwP7fkY3Sr3VmLp+VFWLjPxV1dfoQupmSXaAbhp/6/+N\nwNuGjv8J3ajymnRTeIedV6MXwJpSVV09ZtdH6T6bfxpVDHjn4N9CVd1O9zcA8KiBY/egm458TFUd\nM6L93wy8fTpdUP1IVZ014rj/opvxsctQu/8AbDHmPCbzIOAdY37+z2LWdTjdKO8hVfXzge33a7+v\nG/ybGqWqbqa7bxq6Lxomcy+6EAzd/daLSPL4dLefDP48bUQ9obt9ZeK830y3UNsNdLMSrpmiH5+i\n+xLgJa3dB9PNwPlcVS0PsxAkLUUuriZJWmFU1feS/BzYKclmVfXjtuuldP+fdngLG4tIsjvdVN9t\n6QLA4P//Fd0I8x+Gil08GIanI8kWwL/TTaG+P10YHGxnwxHFbq2qc0ds/377PfJ+5wGPogvWSXLA\niP0T0/IfNkU90/H7Gr2w3G/oAuRFI/b9mu7z2qCq/ndo32lj2vk+3RTybeimeW9Odx5nty8yhn2P\n7guGUddqsunAk0pyT7rP8yl0QXSdgd3jPk+AC0Zs+yVdkLv7wLbtWz3fnUZ3Jo598JjPebNW/8Po\nRlW7TnZfTCyJk6tq5NoESTYBfjqdSpJ8lO4Lhu/RXcvlwRPoFkabELpbB4afhFDAzhNfdCSZRffl\nxxvoRqufTDdDYKSqOjPJlXSrmx/EwvUpnGYurYIM3pKkFc2n6f6j9+V0I1DQ/YftfEbcd5vkTcAH\n6IL1ScA84K90/1G9F91o4JrD5egeZzRtSXaiW3QpdI9S+jrdfbrz6QL/08a0MxxGh9tfb4qm79l+\nP7r9jFIsGhqX1A1jtt8G3D5qZgEL7+ldY8S+342p77d013Hi3Cd+j3uU1MT29cfUtdjaPeUXAA+k\nWxPgCLr7wW+j+6JmX0Z/ngDXj9g2cR0Gn0c90d87jMqOcE+6azLZYnkF3HUadS0VST5ENzp+Mt0C\nZ8NfZE18NhskWWOyUe8ka7PwS4vfjDuu+T3dFO7V6L4AW+TLoqp6O+3++ST/BHxnstMYKHcb3RT8\n17bF7HZJsteo2QoDPgV8sLWzN91tF1dM0X9JKyGDtyRpRXM43eN/XpzkLXQLSz0IOKmqrho8sI1Q\nvYMu2GxTVb8f2v/YSdpZ3Gc8v50uiO08PBU4yVy64D3KuJWR79t+jwu7DO3/QI14RvJy7j5jtt+X\n7vpPnNsNA9tHud/QcYOW9Fndr6IL3XOr6sDBHUl2Zvqra09mIqCPGzkfdAPdufxLVR0/A233Kskh\nwGvp1hh4eo1Y4Kyqrk5yLd3n+li6gD7OrnRB+udVdd1kbVfV35OcR/dF1K50X5rMtHPoZps8im7d\ng3GOpPui8FN0f+9v6aEvklYA3uMtSVqhtP/oPpbuPs49Wbgq8qEjDr8P3SrUp48I3Xdj6mnci2MT\nuntVzxqxb5dJyq3ZVrYeNvGIrAunaPccuvN/zJQ9XP6M6/PEuU9MXb+SbpGqbZKMGtF9Qvs91bUa\ndjuLjkAP2qT9/uqIfbssZjvjnE03ovqUqQ4cOHayL4uWC0k+SRe6vw3sPip0D/g03Xnd4dFpA/VN\n7C/gk9PsxkS9b25rBMy0idH3Sf9buq3X8FW6L1duBI7uoS+SVgAGb0nSimjimd5vort/9Pd0U7uH\nXUsX2B7ZpqoCC56l+zEWvd/2zrqGbsrsIvdSJ3kVC4PhOAe1Pk2UuRfdImJF91iwsarqt3SrvW+f\nZP90zzNfRLpnk280nZNYyv6hXZ8FkuxFd3/3jya+xGjB7Qt0U7PfNXT8pnTTmW+lW218cfwBuPfg\ntR9wDd3f2C5D7W1Hd6/yko6kD/o63b3fz0jyzOGdSQZHwr/W+rRvxjwXPskOwyEzyWZJHjoDfZ1S\nOp+hu5f5WLonDEy1iNgHgB/TTdv+ZJJFpu8nWYtulsujgYvpHuU2HUfQrRXwMOBbScYtyLbY/xvQ\nFkl7env7/WkU2Z/uS8KnVPdcckmrIKeaS5JWOFV1QpJr6KZ5FvDZUQuhVdX8NuX1TcBlSY6lmw7+\nBLrHfJ3KzI0gfphuWutZSY6mG916FN2iWF8B7hCsml/Rjcpf3vo3m+7e8/sAB1fV2dNo+9V0I7T/\nF9gnyel0947fj25hskfQPbf8F0t2ar35DnBwkt2Ay+geDbYn3aPBXjZ07JuBnYH92gyBU+meU/4s\nYG3gX8cs/DaZk4GtgeOTnEb36LOLqurbdF94vInueepPoru396HAU+k+z+cuZlt3UFV/S/Isuutw\ndJJT6J4dvxbd57ZzO7eJY5/Rjv1ukjPoguhfgY2AR9It/LUB3b3oJFmdbrbAbXSPr+rbu+hWAb8Z\nuBx464gHBlxYVQsWMauqP7f7n4+lm73y1CTfobv/+77AbnSf8/lMPXq+QFXdnmQPuke8PRW4Ksmp\nwA/p/r42oFvfYQe6x5mdM6aql7XPH7p1Cjam+7JvLeCrVXXcNPryS7ovWEYZ9UQFSSshg7ckaUX1\naeDddMH7DouqDdifbhGvlwKvpLuv9gRgLt1Kw6NGLmvM9uFjFr6p+nZbPf1twHPows45dCOmD6ML\n06PcQvdFwIF0j8y6J91zoN9dVf89nb5V1Y1JHkN3X/LzWltr0p33T4H96FaVnq5x5z7ZNVmSfWfS\nfVnwbhY+oup44G1VdfEiFVT9Mcmj6KYc70m3svRf6B499oGqOmVMu5P16z/pvvR4Kl3IXZ3uuc3f\nrqpft3u5D6KbEv9PdCH2FcDpdJ/xuL+dcUZ9ducm2Zru3t9/phvtv4mFz9EePPbiJFsBb2x9fgnd\n4n3X0gXTt7HwkVvT7dO0+jnNYzZu29Zm/L3MhzG0enhV/aLNJNiH7ro+jW52w/V0Xy58ETiyquZP\n+wxY8Ci/pyfZFXgxXcjekS5A/5EuhP8HcNSoRwE2+wxWSXev/fnAEVV1+MgSi3e9Z2LmhKQVQKr8\n9y5JkpaeFoROpFu47L3Luj+SJPXNe7wlSZIkSeqRwVuSJEmSpB4ZvCVJ0rIwnfuIJUlaKXiPtyRJ\nkiRJPXJVcwmYO3duvec971nW3ZAkSZK0/FriRwA61VySJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8\nJUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnq\nkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJ\nkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwl\nSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqR\nwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmS\npB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJ\nkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHB\nW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKk\nHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmS\nJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFb\nkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQe\nGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIk\nSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuS\nJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4Z\nvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ\n6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5Ik\nSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8\nJUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnq\nkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJ\nkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwl\nSZIkSerRrGXdAWl5sfH+xy3rLkiSJElaTl1z0G5LXNYRb0mSJEmSemTwliRJkiSpRwZvSZIkSZJ6\nZPCWJEmSJKlHBm9JkiRJknpk8JYkSZIkqUcGb0mSJEmSemTwXokkeVqSf18O+vGWgddzklw2Q/U+\nLskOM1GXJEmSJC0tBu+VSFV9s6rev6z7Abx16H3NUL27ADsuToEkq89Q25IkSZK0RAzey0gbCb4y\nyeFJfpzkqCS7Jjm9vd8uySOTnJnkgrZ901b29UkOa6+3THJpktlJ9k5ySNt+eJKPJzkryc/aaPFh\nSa5I8pmBftw08HqvJIcvTvkR53UgsFaSC5N8rm2eleTQJJcn+W6SNduxD07ynSTnJTk1yUPb9qcm\nObud9wlJNkgyB/hX4PWt7p2S3CvJV5Kc0352aOUPSHJkktOBI5Ns3vZfmOTiJJvM2AcpSZIkSVOY\ntaw7sIrbBNirqq5Icj7wvKraOcnuwNuAFwE7V9X8JLsCBwLPBA4GTkmyRzvulVV1SxJYdHR5/ara\nodV3LLDDRFtJtqqqS7njaPTill+0cNVbkry2qraF7gsGYFPgOVX1yiRfAvYCvgAcCryqqn6e5FHA\nfwO7AqdV1fat/MuAf6+qNyf5BHBTVX2o7fs88KGqOjPJA4Hjgc1bVx4G7FRVf0vyUeAjVfXFJLMA\nR8ElSZIkLTUG72Xr6qq6or3+IXBye30ZMAdYn27EdlO6QDwLoKoqyUuAS4FPVNXZY+r/5kB9vx1q\na+NWPpP0bzrlp+Oqqpq4z/sCYOMk69BNG/9y2jcGwBrt9wOTHA3cr227eky9TwQeNlD+rknWbq+P\nraq/tddnAW9L8gDga1X1s+GK5s2bx/VXX7Xg/eyNtmT2RltN8/QkSZIkaTyD97J168Dr+QPv59MF\nzncD36uqZ7SR41MGjn8ocBNw/2nUP1j3xPuJz35whHv2EpQfZTjMD5a9vbWzGvCniZHxIYcA/1VV\nxyV5HHDAJO08uqr+vsjGLoffPPG+jXSfDTwV+HaSV1bV9wfLzJkzh/U3dN02SZIkSTPPe7yXrclG\nmwHWBX7dXr9kQaFkPbrp5o8F7plkrzvR1m+TbJZkNWDPO9HXQX8bWtTsDmWr6ibg6iTPXHBQMjHE\nvC7wm/Z674FiN7V9E04A9hso//CRHU8eVFVXV9UhwDcAh7IlSZIkLTUG72WrxryeeP9+4KAkF7Do\nZ/Uh4JA2ZfrlwIFJ7jVJ3ZO19RbgOOB0FobdxSk/yqHAZQOLq407/oXAy9qCZ5cDu7ft/wl8Jcl5\nwP8OHP9NYM+JxdWAfYHtklzSyr9qTDvPbgu7XQT8I3DkFP2XJEmSpBmTqpl60pO04po7d24ddZtT\nzSVJkiSNds1Buy3OLOBFOOItSZIkSVKPXFxNS6wtWHaXibd0U8pfVFU/XHa9kiRJkqTli8FbS2zi\nWduSJEmSpPGcai5JkiRJUo8M3pIkSZIk9cjgLUmSJElSj7zHW2quOWi3Zd0FSZIkSSshR7wlSZIk\nSeqRwVuSJEmSpB4ZvCVJkiRJ6pHBW5IkSZKkHhm8JUmSJEnqkauaS83G+x+3rLsgSZIkTZtP5Vlx\nOOItSZIkSVKPDN6SJEmSJPXI4C1JkiRJUo8M3pIkSZIk9cjgLUmSJElSjwzekiRJkiT1yOC9BJI8\nIslHlnU/JpNk7ySH9FDvAUneOEW79x14f3WSe8xAu3OSPO/O1iNJkiRJS5vBewlU1QVV9fpl3Y9p\nqGXQ5j7Ahj304UHA8xenQJLVZ6htSZIkSVpiK23wTvLGJJcluTTJfm3E9MokRyW5IsnRSWa3Y7dN\n8v0k5yX5TpL7tO2nJDkoyTlJfpRkp7b9cUm+2V4fkOSwduzPkrxuoA9vb+V+kOQL40aKk2yQ5Pz2\n+uFJ5id5QHv/sySzk9wryVdaX85JsmPbv3Zr/+wkFyR52oj6d0tyRpJ7jKhnh2mcx9uS/DjJD4DN\nJrnmewHbAUclubBd3wD7tr5dkuShk/W7fU4/SHJ++9m+VX8gsHOrd78kqyV5fzuHi5O8YuCz+UGS\nbwA/bO18K8lF7W/hWZP/5UiSJEnSzJq1rDvQhyTbAnsDjwRWB84GTqULjS+pqrOTHAa8JslHgUOA\n3avqD0meDbwXeFmrbvWqenSSpwDvBJ7Utg+O5G4G7AKsB/w4yceBbYE9gS2BNYELgfNH9beq/jfJ\nmknuCuwMnAc8JskZwO+q6pbW3w9V1ZlJHggcD2wOvA04uapelmQ94NwkJy28FNkDeAPwlKq6Mcnn\nx9Qz7jy2Bp4NbAXcZYrzOCbJa4E3VdVFrQMA11XVI5K8Gvg34JWT9Pt3wBOr6m9JHgJ8sX2O+7d6\nd2/1vgK4vn02dwHOSHJC68o2wD9W1S+SPAP4dVU9tZW726i+S5IkSVJfVsrgTRdev1ZVtwAk+Srw\nGOAXVXV2O+Yo4HV0wXML4MR0KXE14DcDdX21/b4AmDOmveOq6jbgD0l+B9wH2BH4RlX9Hfj7xAj5\nJM5s/X4sXfB/SuvLaW3/E4GHtT4C3DXJ2sCTgacleXPbfhdgo/b6CcAjgCdX1Z+nqGfceUxcy1uB\nW5McO8V5pP0M+lr7fQHdlxFM0u9rgY8l2Rq4Hdh0TDtPBrYcGMFetx37d+DcqvpF234Z8F9JDmzn\nd/qoyubNm8f1V1+14P3sjbZk9kZbTXGqkiRJkjS1lTV4D5sIgsP3G1fbd3lV7TSm7K3t9+2Mv163\nDrye7LjJnEb35cBGVfWNJPsD84Hj2v4Aj25BfoGWn/eqqp8Obd8e+DndvdGb0YXeqeqZifMYZdQ1\nzJh+HwD8tqq2SneP9l/H1BngdVV14lD5xwE3T7yvqp+2GRD/ArwnyUlV9Z7hyubMmcP6G+6wBKcm\nSZIkSZNbWe/xPg3Yo90bvQ6wB/ADYE6SR7djnt+O+zGwwcS9xElmJdl8VKXccSR3smPOoBvRnZhC\n/tRp9PmFwEQQ/SNdWJwYoT0B2G9BI8nD28vjgX0Htm89UOc1wF7AkUkeNkU9487jB3TXcs02TfsO\n95APuZFu9Hkq4/q9Ht2oN8CL6W4VALgJGJwmfjzdrQKzWvlNB0buF55Ecj/gr1X1BeADdLcASJIk\nSdJSs1IG73Z/8Wfp7pU+C/gUcD1dyH5tkiuA9YFPtJHfZwLvS3IxcBEwMfQ5aoR8yuZbH84HjgUu\noRu1vhS4YZI+z2svT22/T6e7h3mizH7Adm2BssuBV7Xt7wHWaAuHXQ68a6jenwAvAL6c5EGT1DPu\nPC4Cjm79Pw44d4rzPwL4xMDiauOu2bsH+n3ZQL8/DuyT5CLgoSwcvb4UmN8WSduvqj4FXAFc2Mp/\ngoUhfdCWdPePXwS8g+56SZIkSdJSk6pl8cSppS/JHOBbVbXlUmxznaq6OcladCPHr6iqi5dW+5q+\nuXPn1lG3OdVckiRJK45rDtptWXdhVTOdGdAjrSr3eE9Y2t8yHNqmra8JfNbQLUmSJEmrnlUmeLep\n3Et1meqqesHwtiQfA3Zi4cJuBRxcVUcszb7dWSvLeUiSJElS31aZ4L28qKr/s6z7MBNWlvOQJEmS\npL6tlIurSZIkSZK0vDB4S5IkSZLUI4O3JEmSJEk9MnhLkiRJktQjF1eTGp+DKEmSJKkPjnhLkiRJ\nktQjg7ckSZIkST0yeEuSJEmS1CODtyRJkiRJPXJxNanZeP/jlnUXJGlaXAxSkqQViyPekiRJkiT1\nyOAtSZIkSVKPDN6SJEmSJPXI4C1JkiRJUo8M3pIkSZIk9cjgLUmSJElSjwzeIyRZL8mr2+vHJfnm\nDNX79CREKGHRAAAgAElEQVT/MMn+VyV54RLWfdOS92zlMtV1liRJkqSlyeA92t2B17TXAWqG6t0D\n+MdRO5KsXlWfrKqjlrDumerjymDsdZYkSZKkpc3gPdqBwIOTXAi8D7hbki8nuTLJ5yYOSrJtku8n\nOS/Jd5Lcp21/eZJzk1zUys1OsgOwO/D+JBcmeXCSU5J8OMm5wL5JDkjyxlbHJklOTHJxkvOTPCjJ\nOklOau8vSbL7dE8oyb+1Pl2c5IC2bU6SK5IcmuTyJN9Nsmbb98jWxoVJ3p/ksoEyP2h9OD/J9m17\nkny81Xd8kuOSPGOK63RKkg+17T9Msl2SY5L8OMm7B/r+giTntL78d5K07TcleU87pzOTbDDiOj8o\nyb6t/ouTfGHJ/iQkSZIkackYvEfbH/h5VW0L/DuwNbAvsDmwSZIdk8wCDgH2qqpHAocD723lj6mq\nR1XVNsCPgJdV1VnAscCbq2rbqrqqHbtGO/bDQ334PHBIVW0N7AhcC/wV2KOqtgOeAHxwOieT5EnA\nplX1KGAbYLskO7fdD2ntbAHcAOzVtn8GeEW7BrezcET9OuCJrQ/PbdeAVm6jqtoceDGwQ2t7susE\ncGvb/kngG8CrgS2BfZLcvU0Zfw6wY+vLfOAFrew6wJntGp3W+jt8na8G/gPYuh33r9O5ZpIkSZI0\nU2Yt6w6sIM6tqmsBklwMbEwXUrcATmwjsKsBv2nHb9VGbNenC4fHT1L3l4Y3JLkrcP+qOhagqv7W\nts8CDkzyWLoAev8k966q66bo/5OBJ7UR/LQ+bQr8Eri6qi5rx10AbJxkPeCuVXVu2/4FYLf2eg3g\nk0m2pgvkm7btOwFfbv39XZJT2vbNJrlO0IVkgMuAyyfOJcnPgQcCjwG2Bc5r5WcDv21l/lZV3x7o\n+xPHnP8lwBeSfB34+qRXSpIkSZJmmMF7em4deH073XULXVDcacTxhwO7V9XlSfYGHjdJ3TeP2Z4R\n214A3AvYpqrmJ7maLohOJcCBVfWpRTYmc7jjuc0eKDPKG4DfVtVWSVanG4Wfqu1x14mB9ucP9aVY\neJ2PqKq3jSj7t6G+j/t73g14LN0U9Lcl2aKq5g8eMG/ePK6/+qoF72dvtCWzN9pqTHWSJEmSNH1O\nNR/tJuBu7fW4APpjYIOBe5xnJdm87bsr8Nska7BwWvREvetO1XhV/Rn4ZZKnt7rvkmQtYD3guha6\nHw/MGSg2rp/Qjbi/NMk6rb77J9lgXLmqugG4Mckj26bnDuxej27aO3RTyldvr88A9mr3et8H2KVt\nn+w6TcfJwDMn+tumnz9wXN+bBde5jZJvVFWn0t1CsC7d57OIOXPmsP7OL1jwY+iWJEmSNFMM3iNU\n1R+BM5JcSre42iK72zF/B54JvK9NP7+Idl8z8A7gXLr7jq8cKPs/wJuTXJDkwUy+EvmL6RZcu4Qu\n1N6H7r7vR7ZtLxyqe2xdVXUi3XTxs9o5fZmF4XNcuZcDn27T09emm1oP8HG6+68vAh7KwhH7Y4Bf\nAT8EjqSb+n3DFNdpsvOfuM5XAnOBE9p5nwDcb4ryC64z3T3sR7XzvgA4uKpunKRdSZIkSZpRqfIp\nVLqjJOtU1c3t9X8A962qN0ynTJJ7AOcAO03j/vPlwty5c+uo23aY+kBJWg5cc9BuUx8kSZJm2mSz\njCflPd4aZ7ckb6H7G7kG2GcaZb6VZH26BdjetaKEbkmSJEnqk8F7JZJkC+BzLJyCHeCWqlrsodyq\nOho4ejHLPH5x25EkSZKklZ3BeyVSVZfTPadbkiRJkrSccHE1SZIkSZJ6ZPCWJEmSJKlHBm9JkiRJ\nknpk8JYkSZIkqUcuriY1PhdXkiRJUh8c8ZYkSZIkqUcGb0mSJEmSemTwliRJkiSpRwZvSZIkSZJ6\nZPCWJEmSJKlHrmouNRvvf9yy7oKk5ZxPP5AkSUvCEW9JkiRJknpk8JYkSZIkqUcGb0mSJEmSemTw\nliRJkiSpRwZvSZIkSZJ6ZPCWJEmSJKlHBu+VTJI5SS5bwrKPS7LDwPtXJXnhDPZt7ySH3InyS3xu\nrfx+SWYvaXlJkiRJWhIG7xVEksX5rGoJm9kF2HFBJVWfrKqjlrCucZa0bzNR/vXA2neyfUmSJEla\nLAbv5UAbyb0yyVFJrkhydJK1klyd5KAk5wPPTPLwJGcluTjJMUnWa+Uf0bZdBLx2oN5FRpiTfDPJ\nY9vrf05yQZKLkpyYZA7wr8Drk1yYZKckByR5Yzt+6zFtn9L6eE6SHyXZaYrT3aiV+XGSdwyc/4KR\n7CRvGtg37tzWSvKlJJcn+WqSs5Ns2/Y9KcmZSc5vx6yT5HXA/YFTkpy8pJ+VJEmSJC0ug/fyYzPg\nY1W1OXAj8Bq60d3fV9V2VXU0cCTw5qraGrgcOKCV/Qzw2qraZkS9dxghTnIv4FBgz1bmWVU1D/gE\n8OGq2raqzhgqdsSYtgFWr6pHA28A3jnFeT4S2BN4OPCsibA8qp9TnNtrgD9W1RbA24GJ0H1PYC6w\na1VtB1wAvKGqDgF+A+xSVbtO0UdJkiRJmjGzlnUHtMAvqurs9vrzwL7t9ZcAkqwLrFdVp7ftRwBH\nt5Hn9QaC8ueAf56ire2BU6vqFwBVdf1kB49re+CQr7bfFwBzpmj7xIn2knwV2Bn4xph2Jzu3nYGP\ntP7/MMmlA+e2OXBGkgBrAGcOVjuqrXnz5nH91VcteD97oy2ZvdFWU5yKJEmSJE3N4L38mhgBvnka\nx44Mk8BtLDqrYXBhsXFlFrcNgFvb79uZ+m9qeGS76Pq5+sC2JelnBn6fUFUvmGY5AObMmcP6G+4w\n9YGSJEmStJicar782CjJo9vr5wOnDe6sqhuBPw3cQ/0iulHrG9r2iUXRBlchvwbYOp0HAo9q288G\nHtPu6ybJ3dv2m4B1hzvW2v7jcNtjzmOqoPykJOsnWQvYAzgd+B2wQZK7J1kTeGprd7JzOwN4Tuv/\n5sAWA+e2U5JN2r61k2za9t046vwkSZIkqU+OeC8/fgy8NsnhdPdQfwJ43dAxewOfbKH1KuAlbftL\ngc8kmQ+cMHFwVZ2R5Brgh8CVdFPBqarfJ3kl8LU2Hfs64J+AbwJfSbJ7a3twdHof4BMj2h41gj2Z\nc+mmpm8IfK6qLgJI8i7gPOBXra8TRp4b8HHgs0kuB37UzvGGdm77AF9sIb7o7vn+KfAp4LtJfu19\n3pIkSZKWllTd2ac76c5qI8/fqqotl3VfVhTt8WprVNWtSR4MnAhsVlW3LUl9c+fOraNuc6q5pMld\nc9Buy7oLkiRp2Vnc23UXcMR7+eE3IItnbbpHg63R3r96SUO3JEmSJPXJ4L0caI/yWmmW0E7yZOB9\nLPwyIcBVVbXXTLVRVX+mezSZJEmSJC3XDN6acVV1Aovejy1JkiRJqyxXNZckSZIkqUcGb0mSJEmS\nemTwliRJkiSpR97jLTU+JkiSJElSHxzxliRJkiSpRwZvSZIkSZJ6ZPCWJEmSJKlHBm9JkiRJknpk\n8JYkSZIkqUeuai41G+9/3LLuwpRceV2SJEla8TjiLUmSJElSjwzekiRJkiT1yOAtSZIkSVKPDN6S\nJEmSJPXI4C1JkiRJUo8M3pIkSZIk9cjgvYpIcnuSC5NcluQbSda9E3WdkmTbJSy7d5L7Dry/Osk9\nlrQvkiRJkrS8M3ivOm6uqm2rakvgT8Brl1E/9gE2HHhfS1pRktXvdG8kSZIkqWcG71XTWbTwm2Sd\nJCclOT/JJUl2b9vnJLkiyaFJLk/y3SRrDlaSzuFJ3jXcQJKHJzkrycVJjkmyfpK9gO2Ao9ro+2wg\nwL5JLmjtP7SVXzvJYUnObvue1rbv3UbsTwZOSnLfJKe2+i5NstNQPx6c5IKB9w8ZfC9JkiRJfTN4\nrzoCC0aJdwWObdv/CuxRVdsBTwA+OFDmIcAhVbUFcAOw18C+NYDPAz+pqneMaO9I4M1VtTVwOfCO\nqjoGOB94fht9v6Ude11VPQL4BPBvbdvbgJOravvWr/9Kslbbtw3wjKp6PPB84LtVtS3wcODiwU5U\n1VXA9Um2apteAnxmimslSZIkSTPG4L3qWCvJhcC1wL2BE9v21YADk1wCnATcP8m9276rq+qy9voC\nYOOB+j4JXFZVBw431O4fX6+qTm+bjgAeO3jIUJGvjWjjycD+SS4Cvg/cBdio7Tuxqm5or88DXpLk\nHcBWVXXziHM/rB2zGvAc4AsjjpEkSZKkXhi8Vx1/aaPCG9EF34l7vF8A3AvYpqq2Aa4DZrd9tw6U\nvx2YNfD+DODxw9PPl9BEO4NtBNirqrZpPw+qqh+3fQvCdVWdRhfqfw18NskLR9R/DPAvwFOB86vq\nT8MHzJs3j+tP//yCn1t+cekMnJYkSZIkLRqktHILQFXdkmQ/4OtJPg6sRzfVe36SxwNzhsuMcRhd\n4D06yTOq6vaJHVV1Y5I/Jdmpqs4AXgSc2nbfBExnRfXjgX2B1wEk2bqqLh4+KMlGwK+q6rB2z/i2\nwFGDx1TVrUmOB/4beOmoxubMmcP6G+4wjW5JkiRJ0uJxxHvVsWD18BZgLwGeR3ef9iPbVPMXAleO\nKjOqrqr6CHARcGRbaO1TA48Z24fuvuyL6e69nliA7bPAJwYWVxvXxruBNdqCaZcPlB+2C3BJm0b/\nbOBggKG+0M7zduCEMfVIkiRJUi9StcRPc5JWGEneBKxbVQeM2j937tw66rblf8T7moN2W9ZdkCRJ\nklZVk80InpRTzbXSS/JV4MF0q6NLkiRJ0lJl8NZKr6qesaz7IEmSJGnV5T3ekiRJkiT1yOAtSZIk\nSVKPDN6SJEmSJPXI4C1JkiRJUo8M3pIkSZIk9chVzaXGZ2RLkiRJ6oMj3pIkSZIk9cjgLUmSJElS\njwzekiRJkiT1yOAtSZIkSVKPDN6SJEmSJPXIVc2lZuP9j1vWXZiSK69LkiRJKx5HvCVJkiRJ6pHB\nW5IkSZKkHhm8JUmSJEnqkcFbkiRJkqQeGbwlSZIkSeqRwVuSJEmSpB4ZvDWjkhya5B9msL45SZ43\n8P4RST4yU/VLkiRJUt98jrdIkqqqmairql45E/UMeBDwfOCLrf4LgAtmuA1JkiRJ6o0j3qugNor8\noyRHJLkcuH1g315JDm+vD09ycJIzkvwsyTPa9sclOSXJl5NcmeRzA+VPSbJte31TkvckuTjJmUk2\naNsfnOSsJJckeXeSmybp7oHAzkkuTLJfa/ubrZ4Dknw2yQ+SXJ1kzyTvS3Jpkm8nWb0dt22S7yc5\nL8l3ktxnhi+pJEmSJI1l8F51PQT4WFVtAfx5aN/g6Pd9q2on4GnA+wa2bw3sC2wObJJkxxFtrAOc\nWVVbA6cBr2jbDwY+XFUPB3411N6w/YHTqmrbqjp4RP8eDOwCPB04Cji5qrYCbgF2SzILOATYq6oe\nCRwOvHeS9iRJkiRpRjnVfNU1r6rOm8ZxXweoqiuT3Htg+7lVdS1AkouBjYEzh8reWlXfbq8vAJ7Y\nXu9AF5QBvgB8YPG7v8B3qmp+ksuA1arqhLb9stanzYAtgBOThO7Lpt8MVzJv3jyuv/qqBe9nb7Ql\nszfa6k50S5IkSZI6Bu9V181jts8een/rwOuM2X47o/+W/j7mmMER68E6l8StAFVVSQbbm9/aC3B5\nG7Ufa86cOay/4Q53siuSJEmSdEdONV91DQbe3ybZLMlqwJ7TLLO4bQw6G3hme/3cKeq4CbjbnWjv\nx8AGSbYHSDIryebTrE+SJEmS7jSD96prcNT5LcBxwOksOg17+N7rcfdi1zReD3oD8MY2RX0T4IZJ\n+nkpMD/JRUn2m+S4ke1V1d/pQv77WnsX0U11lyRJkqSlIjP0FClp2pKsVVV/ba+fAzy3qiYbae/d\n3Llz66jblv88fs1Buy3rLkiSJEmrqiW+TdZ7vLUsPCLJx+j+cP8EvHQZ90eSJEmSemPw1lJXVafT\nPY5sgSRbAJ9j4XTxALdU1fI/DC1JkiRJkzB4a7lQVZcD2yzrfkiSJEnSTHNxNUmSJEmSemTwliRJ\nkiSpRwZvSZIkSZJ65D3eUuOjuiRJkiT1wRFvSZIkSZJ6ZPCWJEmSJKlHBm9JkiRJknpk8JYkSZIk\nqUcGb0mSJEmSeuSq5lKz8f7HLesuTMpV1yVJkqQVkyPekiRJkiT1yOAtSZIkSVKPDN6SJEmSJPXI\n4C1JkiRJUo8M3pIkSZIk9cjgLUmSJElSjwzeK4kktye5MMllSb6RZN07UdcpSbadwb6tl+TV0zhu\n4hwuSvL1ge0bJzk7yU+SfDHJrIF9H03y0yQXJ9l6pvosSZIkSTPF4L3yuLmqtq2qLYE/Aa9d1h0a\ncHfgNdM4buIctqmqPQa2vw/4YFU9FLgeeBlAkqcAm1TVpsCrgE/McL8lSZIk6U4zeK+czgI2BEiy\nTpKTkpyf5JIku7ftc5JckeTQJJcn+W6SNQcrSefwJO8abiDJy5Oc20anv5xkdtt+7yRfbSPQFyXZ\nHjgQ2KSNZr9vkn5nzPYnAMe010cAE6H86cCRAFV1DrBekvsM9XPdJD9Ksml7/4UkL5ukD5IkSZI0\nowzeK48AJFkd2BU4tm3/K7BHVW1HF2A/OFDmIcAhVbUFcAOw18C+NYDPAz+pqneMaO+YqnpUVW0D\n/Ig2Cg18FPh+VW0NbAv8ENgf+Fkbzf6PSc5hzfYFwZlJnt7O557An6pqfjvmV7QvFdrvXw6U//XA\nPgCq6ka60f8jkjwHWL+qDpukD5IkSZI0o2ZNfYhWEGsluRB4AHAFcGLbvhpwYJLHAvOB+ye5d9t3\ndVVd1l5fAGw8UN8ngS9V1YFj2tsyyXuA9YF1gOPb9icALwKoqgJuSnKPaZ7DnKq6NsmDgO8luRS4\nkfEj4dNSVScneTbw/4At70xdkiRJkrS4HPFeefylqrYFNqILqhP3eL8AuBewTRudvg6Y3fbdOlD+\ndhb9IuYM4PHD088HfBZ4TVVtBbxroM5a0hOoqmvb76uB77c+/4FuCvnE3+oD6Ea2ab8fOFDF4L4F\nkgR4GHAzMPJLgHnz5nH96Z9f8HPLLy5d0tOQJEmSpEUYvFceAaiqW4D9gH9rYXU94Lqqmp/k8cCc\n4TJjHAZ8Gzi6TV8fdlfgt0nWoAv3E06mLaSWZLW2uvpNwN0m7XyyfpK7tNf3AnaiG7kHOAV4Vnu9\nN/CN9vpY4MWtzPbA9VX1uxHVv7HV9Xzgs6POZ86cOay/8wsW/MzeaKvJuitJkiRJ02bwXnksGGmu\nqouBS4Dn0d2n/cgklwAvBK4cVWZUXVX1EeAi4Mi20NqnBh4z9nbgXOC0oTpfTzdSfilwPvCwqvoj\ncGaSSydZXO1hwPlJLqIL7++tqh+1ffsDb0zyE7oR68Na/74NXJ3kZ3RT4xesnJ7kuCT3TfJQ4KXA\nG6vqDOBUYO6YPkiSJEnSjEt3G660aps7d24dddsOy7obk7rmoN2WdRck6f+3d+/Bll11ncC/X0gg\nBkIQZBhA0hEENSQhCSE8SyAaQRBRkdERI/gaSnzVIAo1xkKBMTjCiEaRCSY8IiCOoAQjE4KTDJKA\n4ZEnBAfy6BEQKORtgeSx5o+zm5y03ffevsm+l9z7+VR19Tn7rLX3b5+zqm9/z1p7XwDYztZ97ykz\n3gAAADAjdzVnQ7U9PMkZuXGZe5N8ZYzx9T3dDAAAsE6CNxtqjHF5kqM3uw4AAICNYqk5AAAAzEjw\nBgAAgBkJ3gAAADAjwRsAAABm5OZqMPF7sgEAgDmY8QYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwE\nbwAAAJiRu5rD5NDnnrUpx3U3dQAA2NrMeAMAAMCMBG8AAACYkeANAAAAMxK8AQAAYEaCNwAAAMxI\n8AYAAIAZCd5smrbntj3mFt7nwW1/bun5o9q+5ZY8BgAAwL4QvNlqvjHJM3fbNjajEAAAgETw3rba\n7mj7wbantr287f9qe/u2P9P2wrYXtf2fbQ+Y2r+y7cvavqvtR6aZ5NOmfZy+tN8T2l7Q9r1t39D2\nwDXWs8d+ba9u+5tt39f2krb3n7Z/U9u3tb2s7SvaXtP2LklOTnKftu9v+zvT7g+azuWKtmfcom8k\nAADAKgTv7e1bk5wyxjg8yeeTPDnJG8cYx40xjk7yoSQ/vdT+zmOMhyV5VpIzk7xkjHFYkiPbHtn2\nrklOSvJdY4xjk7wvya+sVsRe+j1rqcmnxhgPSvLyJM+etj0vyd+OMY5I8hdJ7j1tf26SK8cYx4wx\nnjNtOyrJLyU5LMl92z58rW8QAADAzbXfZhfAprp6jHHZ9Ph9SQ5NckTbFya5c5I7JDl7qf2ua6Uv\nS/KJMcYHp+cfmPreO4twe37bJtk/ybvWUMdD99DvgqXX/3Kpxh+cHj8yyQ8kyRjj7LafXWH/F44x\n/ilJ2l481bq8/+zcuTOfu/qqrz0/4JAjcsAhR66hdAAAgJUJ3tvbvy49vj7JNyR5VZLvH2Nc3vZp\nSR61h/Y37Nb3hizG0g1J3jbGeOo+1tFV+u061vXZ+5jtCvvf/Tz/zT527NiRO9/rYavVCQAAsM8s\nNd/e9hRW75jkE233T7JSgN5T33cneUTb+yZJ2wPb3m8Ndayn3/lJfmRq/z1ZzNAnyReTHLSGYwIA\nAGwIwXt72/1u3yPJbyS5MMnfJblilbY3eTzG+HSSpyd5fdtLsljO/W2rHX+Vfnu7I/lvJTmh7aVZ\nXJv+iSRfHGN8Josl65cu3Vxtb3UDAADMrmPIIdz6tL1dkuvHGNe3fWiSl40x1v07wU866aTxp9dt\nzlLza170hE05LgAAsE9Wurx1Ra7x5tbqkCR/3vY2WVzD/bObXA8AAMAeCd7Mru2bsriTeLL4lmgk\nec4Y45z17nOM8ZEk657hBgAA2CiCN7MbY/zQZtcAAACwWdxcDQAAAGYkeAMAAMCMBG8AAACYkWu8\nYeLXegEAAHMw4w0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAAADAjdzWHyaHPPetm78Od0QEA\ngN2Z8QYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAzErzZVtqe2/aYza4DAADY\nPgRvAAAAmJHgzaZoe2Dbv257UdtL2z6l7TFtz2v7nrZvbXv3qe2D2l48tf1vbS+btj+t7SlL+3xL\n2++cHp/Q9oK27237hrYHbs6ZAgAA253gzWZ5XJKPjTGOHmMcmeTsJKckefIY48FJXpnkt6e2pyf5\n+THG0dPzsbSf5cdJkrZ3TXJSku8aYxyb5H1JnjXPaQAAAKxsv80ugG3rsiQvbntykrOSfDbJ4UnO\nadssvhT6eNuDkxw8xjh/6ndGFqF9JQ9NcliS86d97Z/kgpU67Ny5M5+7+qqvPT/gkCNywCFH7vtZ\nAQAA7EbwZlOMMT483eTs8UlekOTcJJePMR6x3G4K3ntzXW66auOAXd2SvG2M8dS11rNjx47c+V4P\nW2tzAACANbPUnE3R9h5JvjzGeF2SFyd5SJK7tX3o9Pp+bQ8bY3w+yefaPnzquhymr0lyVBfuneS4\nafu7kzyi7X2nfR3Y9n7znxUAAMC/ZcabzXJEkt9te0OSryb5uSxmsE+ZZrlvm+SlST6Y5KeSnD61\nfduuHYwxzm97TZIPJLkii2u5M8b4dNunJ3l929tncR34SUk+nD1cEw4AADAnwZtNMcZ4W5ZC9JJH\n7aHt+5MclSRtdyR5wtJrP76X/Z+XG2fAl7cfv76KAQAA1sdSc26NzFoDAAC3Gma8uVUZY+xM4nbj\nAADArYYZbwAAAJiR4A0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBm5qzlMrnnRE1ZvBAAAsI/MeAMA\nAMCMBG8AAACYkeANAAAAMxK8AQAAYEaCNwAAAMzIXc1hcuhzz9qn9u6CDgAArIUZbwAAAJiR4A0A\nAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAAADCjbRG82x7c9uc2u4591fa4ti9Zpc1t2v6fm3GM\nM9p+/3r7b6a2t2372c2uAwAAYCUbHrzb3najj5nkG5M8c+6D3JLn1va2Y4wLxxi/slK7McYNY4xH\n3VLHvaW07QYdamzQcQAAANZl1eDd9sC2f932oraXtn1K2+Pbvr/tJW3/pO3+U9ur295levygtudO\nj5/X9jVt35nkNdMs7YvbXtb24rY/P7U7pu15bd/T9q1t775CXfdte87U/71tv6XtHdq+fXp+Sdsn\nTs1PTnKfqebfmfo/u+2FU//nLe33N9p+qO072r6u7bOm7Ue1fdfU/o1tD562n9v299pemOTX2161\nK4C3PWj5+dIx7tr2zVON72x72LT9BW1fPb1Pr2z7XW3/cnrtbtO5Xdb25W0/2vZOy7O+U/u3T/V9\nqO2rlo75m23/fvoMX7ba577U73fbXj6d98nTtru3/aup/ovaPnj6PD7Q9k/bXp7k37d9XNsLps/j\n9W2/Yep/7NLnfFbbu03b/67tyVOdV7R96LT9p9u+aerzD21/fQ91HtT2b6djXdz28dP2/7prfE3P\nX9Rb4eoHAADg1mstM96PS/KxMcbRY4wjk5yd5FVJnjLGeGCS/ZPsCjK7zz4uP/+OJMePMZ6a5D8l\nOSTJkWOMo5K8tu1+SU5J8uQxxoOTvDLJb69Q12uTnDL1f3iSf0ry5SQ/MMY4NsnxSf771Pa5Sa4c\nYxwzxnhO2xOS3G+McVySo5Mc2/aRbY9N8oNJjkjy+CTHLh3v1Ul+dTre5Umet/Ta/mOM48YYz09y\nbpInTNt/NMkbxxjX71b7C5K8e3r/fmva9y7fluQxY4yf2O09fH6St44xjkjyliT3WOqz/D4fncXs\n/mFJDmt73LT9pWOMh0yf4Z3bPjaraPvvknzvGOPw6bxPnl76oyRnT/U/KMkVS7W/ZIxxeJLrsnjf\nj58+j8uS/HLb2yX5/SQ/NH3Or03ywuXjjjEekuTXctP3+MFJvn86vx9re+Ru5X45yZOmY52Q5KXT\n9luq3DkAAA2RSURBVNOTPG06n9skeUqS16127gAAALeU/dbQ5rIkL55mO89K8oUkV40xrpxef3UW\nQe8Pkqy0vPjMMcZXp8ffneSPxxgjScYYn2v7gCSHJzmnbbP4UuDje9pR2zsmuecY48yp/1en7fsl\nObntdya5Ick9p/C4u+9JckLb90813yHJ/ZLcKcmbxxjXJrm27Vum/d4pycFjjHcunfOfL+3vDUuP\nT0vyq0nOTPKTSX5mD8d/ZBbBPmOMc9q+ctds8NLx99TnhVOfs9p+cU/vTRaB/pNT3RcnOTTJhdP5\nPjvJAUnumuS9WXyJspLPJLm+7alJ/ibJX0/bH53kR6ZabkjypS5WJ1w5xrhoavPwLML/BdPnuX+S\nd2bxBcwDkrx96XP+x6Vjvmn6+31JdixtP3uM8YXpvP5qej8+kBvHXJP8TttHZvHZf3Pbu4wxrmz7\nhWl8HZrk78cYn9/9RHfu3JnPXX3V154fcMgROeCQ3bM9AADAvls1eI8xPtz2mCyC4guymNHdm+ty\n4yz6Abu99i+rHKpJLh9jPGK1mlbw1CTflOToMcYNba/eQx27jnXyGOMVN9nY/vIq9e3N185tjHFB\n20PbPirJbcYYH9xD+5WuS17tfVqtnn9denx9kv2mUH9KkqPGGJ9o+4Ls+X25aZFjXDetAjghyX/I\nYmXDY7Oof0/nsFx7s5ihf9pNim6PSnLJCtel76r/+tx0fO5tNcWuv38iiy9OjhpjjLb/mBvP8bQs\nvgQ5NMnL93TQHTt25M73etheSgIAAFi/tVzjfY8kXx5jvC7Ji5M8LMmhbe8zNTkxyXnT46uzWHqc\nJE9eYbfnJHnG0rXQ35jkH5Lcbem63v12Xfu8uzHGl5J8tO2Tpra3m8LlwUk+NYXux+TGGdMvJjlo\naRdnJ/mptneY+t9zus74/CRPbHv7aVb9+6bjfSHJZ9ru+lLgxCQr3Un8jCyWM5++l9f/LsmPT8f+\n7iyW8n95hf0li9niH5n6PD7JHZdeW+1GZt+QRZD957YHZeXP5sadLt6Dg8cYf5PkWUmOml46N9Pl\nBV1cr7/rvV2u44Ikj2r7LVO7A9t+a5IPJrlX2wdP2/ff2+e8m+/p4pr2A5M8KYv3Y/mYuz77MV1K\ncM+lvm9K8sQkDxxjvH0t5w4AAHBLWctS8yOS/G7bG5J8NYvAdXCSv5iC83uS/I+p7fOTnNb287kx\njO/JnyS5f5JL2341ySvGGC9r+8NJTunixmW3zeI63T3NGCeL8Htq2+dPdT0li+uF39L2kiyWUl+R\nJGOMz7Q9v+2lWczCPqftdyR512K1c76Y5MfHGO9te2aSS5J8MsmlSXYtS356kpdPAf+qLGZQkz3P\n/L42i9UBf7ZrQ9tnJvnKGOP0LK5dPn2q84vTvlfzm1lcC//0LL4g+FRunGHe2wz6rqX8n2n7mun9\n+HiSd+/eZi8OTvKmtrfPIuD+52n7LyZ5RdtnJLk2yTOSfHZ5X2OMT7X96SRvmK7rHkn+yxjjI0uf\n852y+PLnJVl8zivV8p4slu/fI8mrxhiXTeNvV58zcuNnf2GSDy/V8q9t35HFfQAAAAA2VKfLrJm0\nvcMY41+mgP2OJD87xrh4H/fxw0meuPsy65tZ1+2TXDfGuH6aef+96eZwW94U4B8wxnjWOvvfJslF\nWdx87Zo9tTnppJPGn163b0vNr3nRE1ZvBAAAbBXr/pXJa5nx3m5OnZY+3z6LmdV9Dd1/kMWd4B9/\nC9d1aJLXT7O8X8lilplVtD08i5nyN+wtdAMAAMzp6z54t/3DJI/IYklxp79/f4zx6hU7rtP0685u\nTv9fuqVq2W2//5DkmDn2nSRt35zk3rueZvE+P3uM8b/nOuZajTFOuxl9L09yn1UbAgAAzOTrPniP\nMX5hs2vYDsYYT9rsGgAAALaiVe9qDgAAAKyf4A0AAAAzErwBAABgRl/313jDRvHrwQAAgDmY8QYA\nAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ\n3gAAADAjwRsAAABmJHgDAADAjARvAAAAmJHgDQAAADMSvAEAAGBGgjcAAADMSPAGAACAGQneAAAA\nMCPBGwAAAGYkeAMAAMCMBG8AAACYkeANAAAAMxK8AQAAYEaCNwAAAMxI8AYAAIAZCd4AAAAwI8Eb\nAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAAADAjwRsAAABm\nJHgDAADAjARvAAAAmJHgDQAAADMSvAEAAGBGgjcAAADMSPAGAACAGQneAAAAMCPBGwAAAGYkeAMA\nAMCMBG8AAACYkeANAAAAMxK8AQAAYEaCNwAAAMxI8AYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwE\nbwAAAJiR4A0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAAADAjwRsAAABmJHgDAADAjARvAAAA\nmJHgDQAAADMSvAEAAGBGgjcAAADMSPAGAACAGQneAAAAMCPBGwAAAGYkeAMAAMCMBG8AAACYkeAN\nAAAAMxK8AQAAYEaCNwAAAMxI8AYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAz\nErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAAADAjwRsAAABmJHgDAADAjARvAAAAmJHgDQAAADMSvAEA\nAGBGgjcAAADMSPAGAACAGQneAAAAMCPBGwAAAGYkeAMAAMCMBG8AAACYkeANAAAAMxK8AQAAYEaC\nNwAAAMxI8AYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAzErwBAABgRoI3AAAA\nzEjwBgAAgBkJ3gAAADAjwRsAAABmJHgDAADAjARvAAAAmJHgDQAAADMSvAEAAGBGgjcAAADMSPAG\nAACAGQneAAAAMCPBGwAAAGYkeAMAAMCMBG8AAACYkeANAAAAMxK8AQAAYEaCNwAAAMxI8AYAAIAZ\nCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0AAAAzErwBAABgRoI3AAAAzEjwBgAAgBkJ3gAA\nADAjwRsAAABmJHgDAADAjARvAAAAmJHgDQAAADMSvAEAAGBGgjck2blz52aXwDZy3nnnbXYJbDPG\nHBvJeGMjGW9spLaPXm9fwRsieLOx/CeBjWbMsZGMNzaS8cYGe/R6OwreAAAAMCPBGwAAAGbUMcZm\n1wCb7sQTTxw7duzY7DLYJnbu3BnjjY1kzLGRjDc2kvHGRtq5c2fOOOOMrqev4A0AAAAzstQcAAAA\nZiR4AwAAwIwEb7aVto9r+6G2/7ftc/bS5g/afrjtxW2P2uga2TpWG29tf6ztJdOfd7Y9YjPqZGtY\ny79vU7sHt7227Q9tZH1sLWv8efrothe1vbztuRtdI1vLGn6m3qntmdP/3y5r+/RNKJMtoO1pbT/Z\n9tIV2uxzXhC82Tba3ibJHyZ5bJIHJPmPbb99tzbfm+S+Y4z7JXlGkpdveKFsCWsZb0muSvKdY4wH\nJnlhkldsbJVsFWscb7vavSjJ2RtbIVvJGn+eHpzkj5J83xjj8CRP2fBC2TLW+G/czyf5wBjjqCSP\nSfKStvttbKVsEa/MYqzt0XrzguDNdnJckg+PMXaOMa5N8mdJnrRbmycleU2SjDH+PsnBbe++sWWy\nRaw63sYY7x5jfH56+u4k99rgGtk61vLvW5L8YpK/SPKpjSyOLWct4+3HkrxxjPGxJBljfHqDa2Rr\nWcuYG0kOmh4flOSfxxjXbWCNbBFjjHcm+ewKTdaVFwRvtpN7JfnHpecfzb8NOru3+dge2sBarGW8\nLfuZJG+dtSK2slXHW9t7JvmBMcYfJ1nXr0KByVr+fbt/kru0Pbfte9qeuGHVsRWtZcz9YZLD2n48\nySVJfnmDamP7WVdesPwCYJO1fUySn0zyyM2uhS3tpUmWr4sUvpnTfkmOSXJ8kjskeVfbd40xPrK5\nZbGFPTbJRWOM49veN8k5bY8cY3xpswuDRPBme/lYkkOWnn/ztG33NvdepQ2sxVrGW9oemeTUJI8b\nY6y0rAlWspbxdmySP2vbJN+U5HvbXjvGOHODamTrWMt4+2iST48xvpLkK23fkeSBSQRv1mMtY+4n\nk5ycJGOMK9teneTbk7x3QypkO1lXXrDUnO3kPUm+te2OtrdL8qNJdv8P55lJfiJJ2j40yefGGJ/c\n2DLZIlYdb20PSfLGJCeOMa7chBrZOlYdb2OM+0x/viWL67yfKXSzTmv5efrmJI9se9u2ByZ5SJIr\nNrhOto61jLmdSb47Sabrbe+fxU1MYT2ava8MW1deMOPNtjHGuL7tLyR5WxZfOp02xrii7TMWL49T\nxxh/0/bxbT+S5F+y+PYU9tlaxluS30hylyQvm2Yhrx1jHLd5VXNrtcbxdpMuG14kW8Yaf55+qO3Z\nSS5Ncn2SU8cYH9zEsrkVW+O/cS9M8qqlXwH1a2OMz2xSydyKtX1dkkcnuWvb/5fkeUlul5uZFzqG\nn70AAAAwF0vNAQAAYEaCNwAAAMxI8AYAAIAZCd4AAAAwI8EbAAAAZiR4AwAAwIwEbwAAAJiR4A0A\nAAAz+v9FvAbzteN77AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f977286e2e8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "gbm_model.varimp_plot(num_of_features=10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "gbm prediction progress: |████████████████████████████████████████████████| 100%\n"
     ]
    }
   ],
   "source": [
    "predictions = gbm_model.predict(test[:-1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8663160713653524\n",
      "27693802656756.91\n"
     ]
    }
   ],
   "source": [
    "print(gbm_model.model_performance(test_data=test).r2())\n",
    "print(gbm_model.model_performance(test_data=test).mse())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "test=test.cbind(predictions)\n",
    "test_df=test.as_data_frame()\n",
    "result = test_df.sort_values(['predict'],ascending=False)\n",
    "result1 = result.reset_index(drop= True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>C1</th>\n",
       "      <th>odid</th>\n",
       "      <th>display_name</th>\n",
       "      <th>od_name</th>\n",
       "      <th>production_year</th>\n",
       "      <th>running_time</th>\n",
       "      <th>sequel</th>\n",
       "      <th>opening_weekend_theaters</th>\n",
       "      <th>maximum_theaters</th>\n",
       "      <th>theatrical_engagements</th>\n",
       "      <th>...</th>\n",
       "      <th>rating.R</th>\n",
       "      <th>Rank.others.y</th>\n",
       "      <th>Rank.dir_100</th>\n",
       "      <th>Rank.dir_20</th>\n",
       "      <th>Rank.dir_200</th>\n",
       "      <th>Rank.dir_500</th>\n",
       "      <th>Rank.dir_900</th>\n",
       "      <th>Rank.others</th>\n",
       "      <th>opening_weekend_revenue</th>\n",
       "      <th>predict</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>6033</td>\n",
       "      <td>118060100</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>Jurassic World</td>\n",
       "      <td>2015</td>\n",
       "      <td>124.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4274</td>\n",
       "      <td>4291</td>\n",
       "      <td>36378</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>208806270</td>\n",
       "      <td>1.657416e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8610</td>\n",
       "      <td>196380100</td>\n",
       "      <td>Batman v Superman: Dawn of Justice</td>\n",
       "      <td>Batman v Superman Dawn of Justice</td>\n",
       "      <td>2015</td>\n",
       "      <td>151.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4242</td>\n",
       "      <td>4256</td>\n",
       "      <td>25005</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>166007347</td>\n",
       "      <td>1.644709e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7779</td>\n",
       "      <td>173060100</td>\n",
       "      <td>Transformers: Age of Extinction</td>\n",
       "      <td>Transformers Age of Extinction</td>\n",
       "      <td>2014</td>\n",
       "      <td>165.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4233</td>\n",
       "      <td>4233</td>\n",
       "      <td>22124</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100038390</td>\n",
       "      <td>1.402745e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9099</td>\n",
       "      <td>209020100</td>\n",
       "      <td>Fantastic Beasts and Where to Find Them</td>\n",
       "      <td>Fantastic Beasts and Where to Find Them</td>\n",
       "      <td>2016</td>\n",
       "      <td>133.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4144</td>\n",
       "      <td>4144</td>\n",
       "      <td>26391</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>74403387</td>\n",
       "      <td>1.365472e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7959</td>\n",
       "      <td>178300100</td>\n",
       "      <td>The Hunger Games: Mockingjay - Part 2</td>\n",
       "      <td>Hunger Games Mockingjay Part 2 The</td>\n",
       "      <td>2015</td>\n",
       "      <td>136.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4175</td>\n",
       "      <td>4175</td>\n",
       "      <td>25500</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>102665981</td>\n",
       "      <td>1.318924e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 61 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     C1       odid                             display_name  \\\n",
       "0  6033  118060100                           Jurassic World   \n",
       "1  8610  196380100       Batman v Superman: Dawn of Justice   \n",
       "2  7779  173060100          Transformers: Age of Extinction   \n",
       "3  9099  209020100  Fantastic Beasts and Where to Find Them   \n",
       "4  7959  178300100    The Hunger Games: Mockingjay - Part 2   \n",
       "\n",
       "                                   od_name  production_year  running_time  \\\n",
       "0                           Jurassic World             2015         124.0   \n",
       "1        Batman v Superman Dawn of Justice             2015         151.0   \n",
       "2           Transformers Age of Extinction             2014         165.0   \n",
       "3  Fantastic Beasts and Where to Find Them             2016         133.0   \n",
       "4       Hunger Games Mockingjay Part 2 The             2015         136.0   \n",
       "\n",
       "   sequel  opening_weekend_theaters  maximum_theaters  theatrical_engagements  \\\n",
       "0     1.0                      4274              4291                   36378   \n",
       "1     1.0                      4242              4256                   25005   \n",
       "2     1.0                      4233              4233                   22124   \n",
       "3     0.0                      4144              4144                   26391   \n",
       "4     1.0                      4175              4175                   25500   \n",
       "\n",
       "       ...       rating.R  Rank.others.y  Rank.dir_100  Rank.dir_20  \\\n",
       "0      ...              0            0.0           0.0          0.0   \n",
       "1      ...              0            0.0           NaN          NaN   \n",
       "2      ...              0            0.0           NaN          NaN   \n",
       "3      ...              0            0.0           NaN          NaN   \n",
       "4      ...              0            0.0           NaN          NaN   \n",
       "\n",
       "   Rank.dir_200  Rank.dir_500  Rank.dir_900  Rank.others  \\\n",
       "0           0.0           0.0           0.0          1.0   \n",
       "1           NaN           NaN           NaN          NaN   \n",
       "2           NaN           NaN           NaN          NaN   \n",
       "3           NaN           NaN           NaN          NaN   \n",
       "4           NaN           NaN           NaN          NaN   \n",
       "\n",
       "   opening_weekend_revenue       predict  \n",
       "0                208806270  1.657416e+08  \n",
       "1                166007347  1.644709e+08  \n",
       "2                100038390  1.402745e+08  \n",
       "3                 74403387  1.365472e+08  \n",
       "4                102665981  1.318924e+08  \n",
       "\n",
       "[5 rows x 61 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>opening_weekend_revenue</th>\n",
       "      <th>predict</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>208806270</td>\n",
       "      <td>1.657416e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>166007347</td>\n",
       "      <td>1.644709e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>100038390</td>\n",
       "      <td>1.402745e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>74403387</td>\n",
       "      <td>1.365472e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>102665981</td>\n",
       "      <td>1.318924e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   opening_weekend_revenue       predict\n",
       "0                208806270  1.657416e+08\n",
       "1                166007347  1.644709e+08\n",
       "2                100038390  1.402745e+08\n",
       "3                 74403387  1.365472e+08\n",
       "4                102665981  1.318924e+08"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf = result1[result1.columns[59:61]]\n",
    "newdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f976f72dc18>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXkAAAEGCAYAAACAd+UpAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzt3Xt4VNW9N/Dvb3K/kyu5kAQkIIgXFFRQhKineKlH9LV6\nEBXlWEtR6qWvnGOrFuztVZ9Tq9WeKhZUqtRL61FRjkVrA0UFRUERCXcSkpCQQALkRiYzv/ePvWcy\nM5lJJmRIZjbfz/PkmT17r733WrMnv71m7bXXFlUFERFZk22wM0BERCcOgzwRkYUxyBMRWRiDPBGR\nhTHIExFZGIM8EZGFhWWQF5ElIlInIl8HkbZQRD4SkS9FZJOIXDEQeSQiigRhGeQBvADgsiDTPgTg\nNVU9B8CNAP77hOWKiCjChGWQV9W1ABo954nIKSLyvyLyuYisFpHR5iIngFRzegiA6gHMKhFRWIse\n7Az0wWIAc1V1l4icB+APAC4F8AiAVSJyN4BEAP8yiHkkIgorERHkRSQJwAUA3hARMWfHmK83AnhB\nVX8rIpMAvAxg3CBkk4go7EREkIfRrNRotrv7uh1m+72qrhOReBHJUtWGAc0hEVEY6nebvIgMM3u3\nbBGRzWaziW+aaSLSZPaA+VJEHgpm0+YfVPUogD0i8j2PbZ5pTlbAbKIRkbEA4hjgiYgM0t9RKEUk\nF0Cuqm4SkWQAXwCYoarlHmmmAfi/qnp1kNtcDqAUQCaAOgALAXwE4FkAeTB+gbyqqr80A/vzAJJh\nXIRdoKp/71ehiIgsot/NNapaC6DWnG4Wka0ACgCU+yQV33V72OasAIu69YFX1a0ApgS7bSKik0lI\nu1CKyHAA4wGs97N4snmz0nsicloo90tERP6F7MKr2VTzFwD3qGqzz+IvABSpaqt5R+pbAEb7boOI\niEKr323yACAi0QDeBfC/qvpUEOn3AJigqof8LOOjqoiI+khV/TaJh6q5ZimAbwMFeBEZ6jF9HoyT\nS7cA76KqlvpbuHDhoOeBZTp5y2XFMlm1XMdbpp70u7lGRC4EcBOAzSKyEYAC+CmAYiNe62IA3xOR\neQDsANoA/Ft/90tERL0LRe+ajwFE9ZLm9wB+3999ERFR34TlAGVWU1paOthZCDkrlgmwZrmsWCbA\nmuU6EWUKyYXXUBIRDbc8ERGFMxGBBrjwGilj15CFDB8+HBUVFYOdDaKIU1xcjL179/ZpHdbkacCZ\ntY7BzgZRxAn0v9NTTZ5t8kREFsYgT0RkYQzyREQWxiBPFAZSUlL6fEEt3Fx88cVYunTpCd/PI488\ngltuueWE78cq2LuGKAwcPXp0sLMQUbqeAkq9YU2eiCzP4XAMdhYGDYM8kY/y8nJcfPHFSE9Pxxln\nnIEVK1YAAObMmYN58+Zh+vTpSE1NxcUXX4zKykqv9aZPn47MzEyMHTsWb7zxhnvZnDlzMH/+fFx1\n1VVITU3F5MmTsWfPHvdym82G3bt3B5V21apVGDNmDNLT03HXXXehtLS012aS4cOHY+PGjQCAV155\nBTabDVu3bgUALF26FNdeey0AY3DARx99FCUlJcjOzsbMmTPR1NTk3s66detw4YUXIj09HWeffTZW\nr17td3/79+/HWWedhd/85jcAgCNHjuD73/8+8vPzUVhYiIcfftjdFfCll17CRRddhAULFiAjIwMj\nR47E+++/797W3r17UVpairS0NFx22WVoaOj96Z4VFRWw2WxYunQpiouLcemll/aY/9dffx3nnnuu\n1zZ++9vf4pprrgEAdHR04P7770dxcTHy8vJw55134tixYwCA1atXo7CwEE888QSGDh2KgoICvPji\ni+7t+DZjucrr0tP3JiQGe9Q1P6OpKVlbOB9ju92uJSUl+uijj6rdbtePPvpIU1NTdfv27Xrbbbdp\namqqrl27Vjs6OvSee+7RKVOmqKpqS0uLFhYW6ksvvaROp1M3bdqkWVlZunXrVlVVve222zQrK0s3\nbNigDodDb7rpJr3xxhvd+7XZbLpr165e0zY0NGhqaqq+9dZb6nA49KmnntLY2FhdsmRJj+W69dZb\n9YknnlBV1R/84AdaUlKizz77rKqqzp49W5988klVVX3yySd18uTJWlNTox0dHfrDH/7Qve+qqirN\nzMzU999/X1VVP/zwQ83MzNSGhgZVVS0tLdUlS5bonj17dPTo0frHP/7Rvf9rrrlG582bp21tbVpf\nX6/nn3++Ll68WFVVX3zxRXcZnE6n/uEPf9D8/Hz3upMnT9b7779fOzo6dM2aNZqSkqK33HJLj+Xd\nu3eviojeeuut2traqu3t7VpdXR0w/62trZqamqo7d+50b+Pcc8/V119/XVVV7733Xp0xY4Y2NTVp\nc3OzXn311frTn/5UVVXLyso0OjpaFy1apJ2dnbpy5UpNTEzUpqYmr8/F5cUXX9SLLrpIVf1/b7Kz\ns93fG1+B/nfM+f5jaqAFg/UXzgGAQqPXY1z2eWj+jsM///lPzcvL85o3a9YsXbRokd52221egbm5\nuVmjo6O1qqpKX3vtNZ06darXenPnztWf//znqmoE7jvuuMO9bOXKlTp27Fj3exHxCvKB0i5btkwv\nuOACr/0UFhb2GuSXLFmiM2bMUFXVsWPH6pIlS9xlKS4u1k2bNrmXffTRR+71ampqNCYmRh0Ohz72\n2GM6e/Zsr+1edtllumzZMlU1gtmPf/xjHT58uL722mvuNHV1dRoXF6ft7e3ueX/+85/14osvVlUj\n6I0aNcq9rLW1VUVE6+rqtLKyUmNiYrS1tdW9fNasWUEFeZvNpnv37nXP6y3/N998s/7iF79QVdXt\n27dramqqO89JSUm6e/du93qffPKJjhgxQlWNIJ+YmKgOh8O9PCcnR9evX+/+XAIF+d6+N76OJ8jz\nwiuFn2kTB23XNTU1KCws9JpXVFSEmpoaAPBalpSUhPT0dNTU1KCiogLr1q1DRkYGAKPy5HA4MHv2\nbHf63Nxc93RiYiKam30foIZe0/rL37Bhw3ot17Rp07BgwQLU1tbC6XTihhtuwKJFi1BRUYEjR47g\nrLPOAmA0c1x77bWw2WzucsTExKCurg4VFRV4/fXX3c1XqorOzk53UwgALF++HCUlJbjuuuvc8yoq\nKmC325GXl+deT1VRVFTkt7wJCQkAgObmZtTX1yM9Pd09DzBu7a+qquq1zL6fTaD8X3LJJQCAWbNm\n4f7778dDDz2E5cuX45prrkFcXBzq6+vR2tqKCRMmuLfldDq97jzNzMx0f2ZA78fXM0/+vjeh7D3E\nIE/kIT8/H/v27fOaV1lZiVNPPRV79uzxWtbc3IzGxkZ3O3NpaSn+9re/ndD85eXl4Z133vGaF0zA\nGzlyJBISEvD0009j6tSpSE5ORm5uLhYvXowpU6a40xUVFWHp0qWYPHlyt20UFhZi9uzZeO655wLu\nZ9GiRXj//fdx44034rXXXoOIoLCwEPHx8Th48GCfe8Xk5eWhsbERbW1t7kBfWVnpFVB74rm/3vL/\nne98B/X19fjqq6/w6quv4sknnwQAZGVlITExEVu2bHGfqPoiKSkJra2t7ve1tbVeeTrR3xteeCXy\ncP755yMxMRGPP/44Ojs7UVZWhnfffRczZ84EAKxcuRKffPIJOjo68PDDD2PSpEkoKCjAVVddhe3b\nt+Pll19GZ2cn7HY7NmzYgG3btoU0f9/97nfxzTff4J133oHD4cAzzzyDurq6oNadNm0annnmGUyb\nNg2AMayt53sAmDt3Ln7605+6LyjX19e7Tyo333wzVqxYgVWrVsHpdKK9vR2rV692/8oBgJiYGLzx\nxhtoaWnBLbfcAlVFbm4upk+fjvvuuw9Hjx6FqmL37t1Ys2ZNr3kuKirCxIkTsXDhQtjtdqxdu9Zd\nE++NZ007mPxHR0fj+uuvx4IFC9DY2IjvfOc7AIwTxR133IF7770X9fX1AIDq6mqsWrUqqHyMHz8e\nb775Jtra2rBz504sWbLEvSzQ96a8vDyobQeDQZ7IQ0xMDFasWIGVK1ciKysL8+fPx5/+9CeMHm08\nd37WrFlYtGgRMjMzsXHjRrz88ssAgOTkZKxatQqvvvoq8vPzkZ+fjwceeMDdA6M3wdZwMzMz8cYb\nb2DBggXIyspCeXk5Jk6ciLi4uF7XnTZtGpqbmzF16lS/7wHgnnvuwYwZMzB9+nSkpaXhggsuwGef\nfQbAaPp4++238etf/xrZ2dkoLi7Gf/3Xf8HpdHqVITo6Gm+++SYOHDiA22+/HYDRo6SjowOnnXYa\nMjIycP3113vVaHv6PF555RWsW7cOmZmZ+MUvfoFbb701qM/K9zPtLf8AcOONN+Lvf/87brjhBq9f\nC4899hhKSkowadIkDBkyBNOnT8f27duD2vd9992HmJgY5ObmYs6cObj55pvdywJ9bzo6OoIqYzA4\nCiUNuEgdhXLOnDkoLCzEz3/+88HOipuqYtiwYVi+fLlXjZysiaNQEp0EVq1ahcOHD+PYsWP41a9+\nBQCYNGnSIOeKwhWDPFGQwuVW+k8//RQjR45ETk4O3nvvPbz99tuIi4vDvHnzkJKSgtTUVKSmprqn\n77zzzsHO8gmxfPlyr/K6ynzGGWcMdtbCCptraMBFanMN0WBjcw0REXlhkCcisjAGeSIiC2OQJyKy\nMAZ5IiILY5AnGiBz5szBz372MwDA2rVrMXbs2EHOEZ0MGOSJBsGUKVPcD+3oie8DJoj6qt9BXkSG\nichHIrJFRDaLyN0B0v1ORHaIyCYRGd/f/RINpoF6nJyqhs1NWBSZQlGT7wTwY1UdB2AygLtEZIxn\nAhG5AsBIVR0FYC6AZ0OwX6KQGzFiBB599FGMGzcOmZmZuP3229HR0eF+xNvjjz+OvLw8/Pu//zsA\n4N1338XZZ5+N9PR0TJkyBZs3b3Zva+PGjZgwYQLS0tIwc+ZMtLe3u5e5tudSVVWF6667Djk5OcjO\nzsbdd9+N8vJyzJs3D59++ilSUlLcY44T9UW/g7yq1qrqJnO6GcBWAAU+yWYAWGamWQ8gTUSG9nff\nRCfC8uXL8cEHH2DXrl3Ytm0bfvnLXwIwxgFvampCZWUlFi9ejI0bN+L222/H888/j0OHDmHu3Lm4\n+uqrYbfbYbfbce211+LWW2/FoUOHcP311+Ovf/2r135cNXSn04mrrroKI0aMQGVlJaqrqzFz5kyM\nGTMGzz77LCZPnoyjR4/i0KFDA/5ZUOQL6UNDRGQ4gPEA1vssKgDg+SSGanNecANh00nlEXkkJNtZ\nqAuPa70f/ehHyM/PBwA8+OCDuPvuu3HppZciKioKjzzyCGJiYgAAzz//PH74wx9i4kTjSVa33HIL\nfvWrX2HdunUAgM7OTtx9t9F6ed1113V7ULTL+vXrsX//fjz++OPu4W0vuOCC48o7ka+QBXkRSQbw\nFwD3mDV6ouNyvME5VDwfGVdcXOx+qER2drY7wAPGo9uWLVuGp59+GoDRfm63293pCwq8f9AWFxf7\n3V9VVRWKi4uDftoRUV+EJMiLSDSMAP8nVX3bT5JqAJ4PphxmzvNr0aJF7unS0lKUlpaGIptEQfF8\nxF9FRYW7Vu97AbSwsBAPPvggfvKTn3Tbxpo1a1Bd7f0Vr6ysRElJSbe0hYWFqKyshNPp7BboedGV\n/CkrK0NZWVlwiQM94bsvfzDa25/oYfmVAN4zpycBWNdDWr9PIyfrCOdjPHz4cD3zzDO1qqpKDx48\nqFOmTNGHHnpIy8rKdNiwYV5pN2zYoEVFRbp+/XpVVW1ubtb33ntPm5ubtaOjQ4uLi/V3v/ud2u12\n/etf/6oxMTH68MMPq6pqWVmZFhYWqqqqw+HQ8ePH64IFC7SlpUXb29v1448/VlXV999/X0eMGKEd\nHR0D+ClQuAr0v2PO9xtTQ9GF8kIANwG4REQ2isiXInK5iMwVkR+YUXslgD0ishPAcwCsOcA1WcKs\nWbMwffp0lJSUYNSoUXjwwQcBdK9VT5gwAc8//zzmz5+PjIwMjB49Gi+99BIA4zGCb775Jl544QX3\nI/uuu+46v/uz2WxYsWIFduzYgaKiIhQWFuL1118HAFxyySUYN24ccnNzkZOTcwJLTVbF8eRpwIXz\nePIjRozAkiVLcMkllwx2Voi64XjyRETkhUGeyAMvdJLVsLmGBlw4N9cQhTM21xARkRcGeSIiC2OQ\nJyKysJCOXUMUjOLiYl7gJDoOgYbG6AkvvBIRRTheeCUiOkkxyBMRWRiDPBGRhTHIExFZGIM8EZGF\nMcgTEVkYgzwRkYUxyBMRWRiDPBGRhTHIExFZGIM8EZGFMcgTEVkYgzwRkYUxyBMRWRiDPBGRhTHI\nExFZGIM8EZGFMcgTEVkYgzwRkYUxyBMRWRiDPBGRhYUkyIvIEhGpE5GvAyyfJiJNIvKl+fdQKPZL\nREQ9iw7Rdl4A8DSAZT2kWaOqV4dof0REFISQ1ORVdS2Axl6SSSj2RUREwRvINvnJIrJJRN4TkdMG\ncL9ERCetUDXX9OYLAEWq2ioiVwB4C8DoQIkXLVrkni4tLUVpaemJzh8RUcQoKytDWVlZUGlFVUOy\nUxEpBrBCVc8MIu0eABNU9ZCfZRqqPBERnQxEBKrqt0k8lM01ggDt7iIy1GP6PBgnl24BnoiIQisk\nzTUishxAKYBMEakEsBBALABV1cUAvici8wDYAbQB+LdQ7JeIiHoWsuaaUBERVYcDsPE+LSKiYAxU\nc03ofL1jsHNARGQJ4RnkW1oHOwdERJYQnkGeiIhCIkyDPG+OJSIKhTAN8kREFAoM8kREFsYgT0Rk\nYQzyREQWxiBPRGRhDPJERBbGIE9EZGHhGeTZTZ6IKCTCM8gTEVFIMMgTEVkYgzwRkYWFd5BXBQ43\nD3YuiIgiVngH+SMtwKbywc4FEVHECssg7+x0GhNh9tQqIqJIE5ZBvqWpw5hgV0oion4JyyDfWNNi\n1OLbOwY7K0REES16sDPgj73FDlTVAburBjsrREQRLSxr8s5OJwM8EVEIhGWQd9idg50FIiJLCM8g\n72CvGiKiUAjLIO/uQklERP0SlkHe0cmaPBFRKIRlkGdNnogoNMIyyLNNnogoNEIS5EVkiYjUicjX\nPaT5nYjsEJFNIjK+p+2xJk9EFBqhqsm/AOCyQAtF5AoAI1V1FIC5AJ7taWNskyciCo2QBHlVXQug\nsYckMwAsM9OuB5AmIkMDJXawJk9EFBID1SZfAGCfx/tqc55fjg4GeSKiUAjLsWuWfvEXlCELAFA6\nfgJKp00c5BwREYWPsrIylJWVBZVWNERjtotIMYAVqnqmn2XPAviHqr5mvi8HME1V6/yk1fdveAmX\n3Xla10wGeSKigEQEqup3cPZQNtcIAo8A/w6A2WZmJgFo8hfgXdhcQ0QUGiFprhGR5QBKAWSKSCWA\nhQBiAaiqLlbVlSJypYjsBNACYE5P2+vkAGVERCERkiCvqrOCSDM/2O11G4VSFeiwA3Gxfc8cEdFJ\nLDzvePUN8gebgHUB77MiIqIAwjLItx21e8+wdw5ORoiIIlxYBvnWw3y2KxFRKIRlkO885hjsLBAR\nWUJYBnn7Md8Lr4OTDyKiSBeWQb6zw6cmf8xsvnE4jF42REQUlLAM8vZ2nyB/qMl43V4BfPrVwGeI\niChChWeQD9Rcc4wXZImI+iIsgzzA4YaJiEIhLIN8TJyNPWyIiEIgLIO806lobmTTDBFRf4VlkM8q\nSkZjdUvXjBANh0xEdLIJyyCfW5KKI/Xt3Rc42U5PRNQXYRnkU3MS0FDZ3H2Bg0GeiKgvwjLI55Wk\non6vR5B3tdY42WxDRNQXYRnkh+Ql4vCBtq4ZbWbTjbImT0TUF2EZ5NOGJvhvk/etyNfUA0dbuqcj\nIiIAYRrk45Oj4XQojrX4jFPjO27NjgpgT/XAZYyIKMKEZZAXEaTlxOPwAT+1eSIiClpYBnnAaLI5\nXNfWe0IiIgoobIN8RkESDu5jezsRUX+EbZBPL0jE3k0HBzsbREQRLWyD/OhJOajZdrj3hHLi80JE\nFKnCNshnFCSho60TLU3HeknJKE9EFEjYBnmxCdLzEnHkeHvYNB0F9tWGNlNERBEmbIM8ACSlx6Kl\nsbeafAB7a4DdVaHNEBFRhAnrID8kNxF1u492X9DZCXT28lARtuIQEYV3kB9/+TB8saIS6jue/Meb\ngI83GtOuYP7tLuCIn5EriYhOYiEJ8iJyuYiUi8h2EflPP8uniUiTiHxp/j0UzHYLThsCR6cTlV8f\nCpzIVaOvbwQ2lh9fAYiILCq6vxsQERuAZwBcCqAGwOci8raq+kbcNap6dR+3jXOuKkL52joUn5Xp\nP9HhALV3YXsNEVEoavLnAdihqhWqagfwKoAZftIdV9QdPj4TO9Yd6N5k0xsHHwRORBSKIF8AYJ/H\n+ypznq/JIrJJRN4TkdOC3XjRGelob+5E/Z4+trfzUYFERP1vrgnSFwCKVLVVRK4A8BaA0YESL3ph\nsXu6dPwEjJ06FOVra5FzSkofdsnmGiKyprKyMpSVlQWVVvrcDOK7AZFJABap6uXm+wcAqKo+1sM6\newBMUNVuV1RFRLXsc6952z+tw98Xb8PcP14EW5Sf4H3h2V29baZNNF6/+BZobu16T0RkUSICVfVb\nsw1Fc83nAEpEpFhEYgHMBPCOTwaGekyfB+Pk0kOXGW+jJuUgLika697Y7T9BRU33eazIExH1P8ir\nqgPAfACrAGwB8KqqbhWRuSLyAzPZ90TkGxHZCOBJAP/Wl32ICC6bfxq+fG+f/wR+298Z5YmIQtIm\nr6rvAzjVZ95zHtO/B/D7/uwjb1Qamg8dQ0vjMSSlx/Ulc+xOSUQnrbC+49WTLUpQdEYGdqw7ENwK\njOtERJET5AFg7NRc7Fhf331Bjcc814Vkz+vJ9Y3AsY4TmjcionAUUUE+b3Qa6nYd6TnRmi+MQG+3\nG+9VjXFt/F2cJSKyuIgK8tnFyejscGLNsh09JzxwCGg3a+7//NJ47V9PUSKiiBSeQX5cSdd0dNe1\n4agYG+b8bjI+fWNPz4OW+W2aYZQnopNPeAb5Icld00nxXovShibgoptG4pPXAvSZB4ynQvkKNsY7\nnV3t+kREES48g7wnP90fJ1xdjLpdR7Dt4zr/6zT20m7fk/WbgfI9waV1OIwHmBARhanwDPK9VKTj\nEqNx5b2n493fbEZHW5BBtu5gcD1sOuzGcAjB2LQN+Oyb4NISEQ2C8AzyQRg1KQdFZ6Rj+QOfw94e\n5LDCR1uMp0e19/Lc2GBba9qPAfY+1uSdzuBPIkRE/RSmQd4jyvZwt+p1PzsH0bE2fLi4HE5HkJF5\nYzmwZZcxfeAgsKe6+7AIbe2Bm3xWb+hfc1BtgzF4GhHRAAjPIB9kvLZFCa768Rmo3tqEP//kc7Qd\n6aU5xvWowOZWI1hv3QNU7geq/dxFu7mHbpotrpr4cdxWy3HuiWgAhWeQj44C4mK63o8ZETDpkLxE\nzHl6MtKGJuDl//gMnR09NN1s2+t/vlONE0CwT5NSAEdaju+iKzvuENEACs8gb7MBk84ypgXA0ADP\ndzVFRdvw3ftOR0pmPN76f1/1/VGBe6uN8ej78iDwjVv7tg8iokEQnkHeS3BNImITfG/h2WiobMGH\nz/Whjd5Ta3vXtKrRrFPbAHyyyTudv5NIS1vf90dEdIKFf5DvQ7N3dGwUbn78XFRvbcLyBz5H4/5+\n9mL54lvgcHPvPWicTmDDlsDLV28w/kLB4QC27AzNtojI8sI7yA8bCuTn9GmV5Mx4zP7N+cg7NRXP\nz12LlU99g6MN7b2vCPivofs7yeyp9n7vukg7EHfKtncADU0nfj9EZAnhHeRHFgIZaX1ezRZtw6Xf\nH4P5y0oBBX5/62q8+uAGfLt6P4619vFi6f4G4/VAD2PluIZRUDVq/cFcwP3i255Hxqw76L/27++k\nc7iZd94SkV/hHeT7KXFILK6893Tc/+a/YMQ5mdj43j48fdM/sGbZDjQf6uWGKF9bd3u32fujCqz/\nGvg6QPfLNo99NrcCBw8H3tbRQE1NfqL8pvLuvy6IiBBJQf60kd3nXXROUKtGx0Xh/OtG4KbHz8Ps\nJyahsbYVz9xShjd/uRG1O48E1xvHJr23hSsAh7Prjlrf7X622Sd9D33m+9oF38m+mUTUXUie8Tog\nstO7z7P1cI5KSTKGMfCRMyIFM/7jLFw27zSs/5+9eO2hDRCboPD0dBSdmYHTL8lHXKKfj8Wpvdfk\n68ymHVUj0K/fDORmBU7vCsx2O9DSDgxJ6VoW6E7fQMGfI2cSkR+RE+T76uwxxlOiAohPicG02aMw\n9ZYS1O06ipryJpSvrcXfF5ej5LxsjJqcg6EjUpE9PBliC7JavXNf17TDrKXXNnin2V3VNe0K8ntr\njEcYTpvYtSzgcA7mfN8HlDPIE5EfkRfkE+KMkSIdzu7zPdu8PQNglK17encyQW5JKnJLUnHOVUU4\nfKANO9fXY8tH+/GPPdshApRMykH+qWkoOiMDQ3ITID2MpwPAuPjaU5dKl/ZjwPYKoymoW8Z6X90L\ngzwR+RFZQT4nw2iGqdzfFbRdtd9vdhpBPjbGOAm4JCcCZ4wCPv0qqF2k5SRgwr8WYcK/FkFVUfVt\nEyo3H8L2j+vw4bPlsB9zoGDsEJwyIQv5p6Yhb1Qa4lNiet9wIPvrgcwhXe8PHQbSU4GK/cb7bXuA\nY3bgzNFmAjOYOxzGiSwqypzNIE9E3UVWkB97ivFauT9wmugo7yAfHWUE/pIiYGdln3YnIigcl47C\nccb1AFVF2xE7dn/RgKpvm1D2wnbU7jyC5Mx45J+ahvwxacg/dQjySlIR669dP5CDZr/3I81Gn/tJ\nZ3Ytqz3ondYVyz/fYpTzgvHmfAZ5IuousoJ8T3pr3nAtH3uK0R3yonOMh37kZAC79vW4qnsTIkhM\ni8Xpl+Tj9EvyAQBOh6Khshk15U2o2XYYWz7ajwN7jiJtaAKGnpKCIXmJSEyLxZChCcgYloTMwiTE\nxEX534Fr7Bx/8bq1DUiI71roOpG5nmLVU5DvsBvL42KDKicRWYd1gnwgrtgXazap5GQAqUlGz5xz\nxhrzDjeUa9HWAAAOEklEQVQbPVxys7pGqszJ6FqnyuMxgyJeAdUWJcgZkYKcESkYf0UhAMDR6UT9\nnqM4sLcZTbWtOFLfjsqvD+FQdQuaatuQnp+I9LxEpObEo+iMDOSNSkXGsKSutv42P714Pt9ijMaZ\nnOg933UTlL2HG7C+3GoE+qkTev6siMhyrBfku10UNQNy5hDgQrNpIz7OO8k4jz742enA2o3GxdCR\nRtBGSpJR+weMIZDPPLV7n3cPUdE25I5KQ+6o7nfrdrR24mBVC5pqW3GwqhWbP6zGh8+Vo6OtE8kZ\ncRiSm4gRE3YjqygZ6bnGiSA2wTxMTUe6P3/2iNlN1N/Trux2oOqA8crmHKKTkoWCvJ/2mvFjusal\nFwGigyiu60KmZx/8LPPC6IgCo7bvCphjRgT/0G9TbGI08kanIW+06wRgnGCaD7ajpakD9Xubsfer\ng9i5vh5NtW04cqANsYnRGHpKCkaem41xF+chbaifHj72TmPohex0o9a+t8b4SPY3dJ34nE7jqVYZ\naT0+cYuIrCMkQV5ELgfwJIw7aJeo6mN+0vwOwBUAWgDcpqqbfNOEXFry8a/rWdu32bz7sLvTxBqB\n33dIgawh3QcRy0oHGhr97ysmGsmZ8UjOjMfQkak4/dJ89yJ1Kpobj6Gm/DC2rqnFkrs+QUebA9nF\nyUazT34iMoclIas4GVmt2xGXntj9geWuk9KWXUbvnYnjgKSEID8IIopk0ucHbPhuQMQGYDuASwHU\nAPgcwExVLfdIcwWA+ar6XRE5H8BTqjopwPa01zx9ssmouXoG3m93AfWNRvBqafMflINltxu1/p5q\nu23HjCDvSlPbYHTr3FlpXNT9cmvXGPPjTwXSUoCvthmDmRXkGE1Brpu1pk4wmoPqA5wEfLQe7kBD\nZTMa97eisboVh6pbcGBPMw5Vt2BIbgJyS1KRUZCE7OHJyD91CFJz4hEVbTOaoJxqXIvY3wCcUgA0\ntwHJCUBHp/EYxFFFx/+5hUJnp/E58iIxUc8aGo3u1lFREBGoqt+AFYqa/HkAdqhqBQCIyKsAZgDw\nfMzSDADLAEBV14tImogMVdW6blvrr1C0QsQE0e89wadd3zV8QYE5NLLrRHX2GCDV/EXh6ttfYgbS\nqROMk5WI0etHdwOnnQLsqzXm1x30Hss+NRk40ozEi05HUVoyiuobvZqLOjscaKhoxv6dR9C0vxWb\n/rcKHzxbjuZDxzAkNwEZBYlIyYpHStZ2pGbFI6WkAqkxnUjJjEdCWozRBFRzADh1uHGx+Zyxxq8Y\nV1lEjBNXUoLR9NNh7359w5+aemOd3n5ZOZ3At7uNJqX+nKSJrK79mPHLfGShMSR7D0IR5AsAePZB\nrIIR+HtKU23OC32QD0mUD6FUj8A2ZrgxHryLSFcPHpGuC8BFecbryMKu4YanTfQOtoDxWMS0ZOPi\n65AURH/6ld8Lvg67Ewf3taCxthVH69txpKEd+7Y04ujq/ThS346jDe2wH3MiJSsOiamxiEtah7ik\naMQnrUN0nA1R0TZExUYhKkoQFWtDVHI8ohx2Y/6IPETVNSAqJR5RBdmIirUh2gZEqQNRuRmIam1B\n1P4DiEpLhC3aBklPBZITIA4HJCcDIoDAGKJZvjbuMBYRSH0zYBMIFFJRA0lOgmQPAeJiIFE2iKrR\nLBUXA2luAxLjvZ4L7L5m4XpxDQMdF2ucTFzXXBxO4xeO7xARwVyzcDphZrj3tC4HDgLx8cavJ4Vx\nN3ZfuPKuavz5G78p2PwH2vbxcN2cd7zrB2vDFqAwt9dHgvrVW/la24GYKO9KnutzFjF64cVGG12Z\n7Z3GPTi+2/P3nXA6jVFlXZUcz5YKh9N4vrTd7BKdnNi1rt0OiM1oYo2JNmrtQNe4WICRj009P7Y0\nMi+8jj3F+GA8DUk1biYaWei/C+JAGza0+yMBExOMv+Pl7x83Pq6rNj1totEc9NU24715929UjA05\np6Qg55SU7uub7O0OHG1oR9tRO9pb7DjW3In2Fjs6O5xwdDrhsKv56kRHfXPX+53b4DSXd9r3eKXz\nXc/pUKiqe/BNdar5P+SaZ7yqKlTLoObYPt3ToWuZ+/+l6x/HPa+3lkjXCcD1sZoT4jeNz0nDa7n4\nbMc3TdcWfQ+hv3GRvNJ4vVEIxNiwq2zimVTc6fztzGuxbz5EvBf43W73fXZ763e7Psv9Zy9wfj23\n67uun/8Jv+c3c789jkOlauTXc9seAbn7drvSuj8/V3KP/QiM7UqUGK9idL0Wm8BmM1+j0PU+ymYs\nFyAmPgoJqTFISI5BQmqsMZ1i/qXGIqF1H2ISAtx3YwpFkK8G4NmQO8yc55umsJc0bosWLXJPl5aW\norS01DuB64zmKT/b+AO8R3McLHnZodlOX5sthqR41/qBrpqI60vr+eU1a4Mxqshw1Qw9fzE4zajq\nVOOL61rf6aot+tmeuNr/nd7L3DVQGOu5mq+io7q26zp5u4Oq+Y/keq8wthtl66qZORzGPlXh9Y/m\nySbGkNIOV56Mbaqga6A4p3ESco915C6Sa8IonwJdwd19svH8vH3WgZ/tuN6r+k/jua5ZdnUFYd9t\nq3bvIetTm/da7jou/pb5bEh9h7D2Xe6ZR1d53Nn3iYqey5we+fNzDc47T57jTpnH0TPqB/r8zMXm\naubXw8/n6++t7zKfz8z/Ps3vqtPnc3BXUBTqUDgdTqgTcHY6jPeq0E7z1e40ljsUzk4n7K12tDW2\no+1QGw41tqN9VwvaGtvwVeXX2NLwLTrbOhEV6OZKV65CcOE1CsA2GBde9wP4DMCNqrrVI82VAO4y\nL7xOAvBkvy68EhERAODLJV9iwvcnnLgLr6rqEJH5AFahqwvlVhGZayzWxaq6UkSuFJGdMLpQzunv\nfomICBh2/rAel/e7Jh9qrMkTEQWvtaEVSdlJAWvyDPJERBGup37ykfOMVyIi6jMGeSIiC2OQJyKy\nMAZ5IiILY5AnIrIwBnkiIgtjkCcisjAGeSIiC2OQJyKyMAZ5IiILY5AnIrIwBnkiIgtjkCcisjAG\neSIiC2OQJyKyMAZ5IiILY5AnIrIwBnkiIgtjkCcisjAGeSIiC2OQJyKyMAZ5IiILY5AnIrIwBnki\nIgtjkCcisjAGeSIiC2OQJyKysOj+rCwi6QBeA1AMYC+AG1T1sJ90ewEcBuAEYFfV8/qzXyIiCk5/\na/IPAPhQVU8F8BGAnwRI5wRQqqpnn4wBvqysbLCzEHJWLBNgzXJZsUyANct1IsrU3yA/A8BL5vRL\nAK4JkE5CsK+IxS9j5LBiuaxYJsCa5QrHIJ+jqnUAoKq1AHICpFMAH4jI5yJyRz/3SUREQeq1TV5E\nPgAw1HMWjKD9kJ/kGmAzF6rqfhHJhhHst6rq2j7nloiI+kRUA8XlIFYW2Qqjrb1ORHIB/ENVx/ay\nzkIAR1X1iQDLjz9DREQnKVUVf/P71bsGwDsAbgPwGIBbAbztm0BEEgHYVLVZRJIATAfwSF8zSkRE\nfdffmnwGgNcBFAKogNGFsklE8gA8r6pXicgIAP8DoyknGsArqvpo/7NORES96VeQJyKi8BY23RpF\n5HIRKReR7SLyn4Odn74Qkb0i8pWIbBSRz8x56SKySkS2icjfRCTNI/1PRGSHiGwVkemDl3NvIrJE\nROpE5GuPeX0uh4icIyJfm8fyyYEuh6cAZVooIlUi8qX5d7nHskgo0zAR+UhEtojIZhG525wf6cfK\nt1w/MudH7PESkTgRWW/Ghs3mNcmBPVaqOuh/ME42O2HcORsDYBOAMYOdrz7kfzeAdJ95jwH4D3P6\nPwE8ak6fBmAjjKar4Wa5ZbDLYOZtCoDxAL7uTzkArAdwrjm9EsBlYVamhQB+7Cft2AgpUy6A8eZ0\nMoBtAMZY4FgFKlekH69E8zUKwDoA5w3ksQqXmvx5AHaoaoWq2gG8CuNGq0jh72avQDeKXQ3gVVXt\nVNW9AHbAKP+gU6Nba6PP7D6Vw+xllaKqn5vpliHwTXInXIAyAcYx8zUDkVGmWlXdZE43A9gKYBgi\n/1j5K1eBuTiSj1erORkHI3grBvBYhUuQLwCwz+N9FboObiTwvNnr++a8oer/RjHfslYjvMsa6Ia3\nQOUogHH8XML1WM4XkU0i8kePn8oRVyYRGQ7jl8o69P07FwnlWm/OitjjJSI2EdkIoBbAB2agHrBj\nFS5BPtJdqKrnALgSwF0ichG63xhmlSvcVijHfwM4RVXHw/jH+80g5+e4iEgygL8AuMes+VriO+en\nXBF9vFTVqapnw/i1dZ6IjMMAHqtwCfLVAIo83g8z50UEVd1vvtYDeAtG80udiAwFAPOn1gEzeTWM\nLqcu4V7WvpYj7MunqvVqNmwCeB5dzWURUyYRiYYRCP+kqq77UyL+WPkrlxWOFwCo6hEAZQAuxwAe\nq3AJ8p8DKBGRYhGJBTATxo1WYU9EEs2aB6TrZq/N6LpRDPC+UewdADNFJFaMewhKAHw2oJnumcC7\n/bNP5TB/eh4WkfNERADMhp+b5AaYV5nMfyqX/wPgG3M6ksq0FMC3qvqUxzwrHKtu5Yrk4yUiWa7m\nJRFJAPAdGNcaBu5YDdYVZz9XoC+HcTV9B4AHBjs/fcj3CBi9gTbCCO4PmPMzAHxolmkVgCEe6/wE\nxlXzrQCmD3YZPPK1HEANgGMAKgHMAZDe13IAmGB+FjsAPBWGZVoG4GvzuL0Fo300ksp0IQCHx/fu\nS/P/p8/fuQgpV8QeLwBnmOXYZJbhQXP+gB0r3gxFRGRh4dJcQ0REJwCDPBGRhTHIExFZGIM8EZGF\nMcgTEVkYgzwRkYUxyBMRWRiDPBGRhf1/qkqyP2kPwxEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f976f737550>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "newdf.plot(color=['pink','purple'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}