bokeh-try-movies.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Table of Contents**\n",
    "\n",
    "<div id=\"toc\"></div>\n",
    "<script type=\"text/javascript\"\n",
    "src=\"https://raw.github.com/kmahelona/ipython_notebook_goodies/master/ipython_notebook_toc.js\">\n",
    "</script>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Load modules and collect data\n",
    "- use `sqlite3` (database small enough to be held in memory)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import os\n",
    "from os.path import dirname, join\n",
    "\n",
    "import numpy as np\n",
    "import pandas.io.sql as psql\n",
    "import sqlite3 as sql\n",
    "\n",
    "\n",
    "from bokeh.sampledata.movies_data import movie_path\n",
    "__file__ = os.path.expanduser('~/git_local/bokeh_original/examples/app/movies/main.py')\n",
    "conn = sql.connect(movie_path)\n",
    "query = open(join(dirname(__file__), 'query.sql')).read()\n",
    "movies = psql.read_sql(query, conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SELECT omdb.ID,\n",
      "       imdbID,\n",
      "       Title,\n",
      "       Year,\n",
      "       omdb.Rating as mpaaRating,\n",
      "       Runtime,\n",
      "       Genre,\n",
      "       Released,\n",
      "       Director,\n",
      "       Writer,\n",
      "       omdb.Cast,\n",
      "       imdbRating,\n",
      "       imdbVotes,\n",
      "       Language,\n",
      "       Country,\n",
      "       Oscars,\n",
      "       tomatoes.Rating as numericRating,\n",
      "       Meter,\n",
      "       Reviews,\n",
      "       Fresh,\n",
      "       Rotten,\n",
      "       userMeter,\n",
      "       userRating,\n",
      "       userReviews,\n",
      "       BoxOffice,\n",
      "       Production\n",
      "FROM omdb, tomatoes\n",
      "WHERE omdb.ID = tomatoes.ID AND Reviews >= 10\n",
      "\n"
     ]
    }
   ],
   "source": [
    "print query"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>imdbID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>mpaaRating</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>Genre</th>\n",
       "      <th>Released</th>\n",
       "      <th>Director</th>\n",
       "      <th>Writer</th>\n",
       "      <th>Cast</th>\n",
       "      <th>imdbRating</th>\n",
       "      <th>imdbVotes</th>\n",
       "      <th>Language</th>\n",
       "      <th>Country</th>\n",
       "      <th>Oscars</th>\n",
       "      <th>numericRating</th>\n",
       "      <th>Meter</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Fresh</th>\n",
       "      <th>Rotten</th>\n",
       "      <th>userMeter</th>\n",
       "      <th>userRating</th>\n",
       "      <th>userReviews</th>\n",
       "      <th>BoxOffice</th>\n",
       "      <th>Production</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4972</td>\n",
       "      <td>tt0004972</td>\n",
       "      <td>The Birth of a Nation</td>\n",
       "      <td>1915</td>\n",
       "      <td>Not Rated</td>\n",
       "      <td>165.0</td>\n",
       "      <td>Drama, History, Romance</td>\n",
       "      <td>1915-03-03</td>\n",
       "      <td>D.W. Griffith</td>\n",
       "      <td>Thomas F. Dixon Jr. (adapted from his novel: \"...</td>\n",
       "      <td>Lillian Gish, Mae Marsh, Henry B. Walthall, Mi...</td>\n",
       "      <td>6.9</td>\n",
       "      <td>13793.0</td>\n",
       "      <td>None</td>\n",
       "      <td>USA</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>100</td>\n",
       "      <td>38</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>4034.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gravitas</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>6206</td>\n",
       "      <td>tt0006206</td>\n",
       "      <td>Les vampires</td>\n",
       "      <td>1915</td>\n",
       "      <td>Not Rated</td>\n",
       "      <td>399.0</td>\n",
       "      <td>Action, Adventure, Crime</td>\n",
       "      <td>1915-11-13</td>\n",
       "      <td>Louis Feuillade</td>\n",
       "      <td>Louis Feuillade</td>\n",
       "      <td>Musidora, Édouard Mathé, Marcel Lévesque, Jean...</td>\n",
       "      <td>6.6</td>\n",
       "      <td>2502.0</td>\n",
       "      <td>French</td>\n",
       "      <td>France</td>\n",
       "      <td>0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>100</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>2075.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>6864</td>\n",
       "      <td>tt0006864</td>\n",
       "      <td>Intolerance: Love's Struggle Throughout the Ages</td>\n",
       "      <td>1916</td>\n",
       "      <td>Not Rated</td>\n",
       "      <td>197.0</td>\n",
       "      <td>Drama, History</td>\n",
       "      <td>1916-09-05</td>\n",
       "      <td>D.W. Griffith</td>\n",
       "      <td>D.W. Griffith (scenario), Anita Loos (titles)</td>\n",
       "      <td>Lillian Gish, Spottiswoode Aitken, Mary Alden,...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8673.0</td>\n",
       "      <td>None</td>\n",
       "      <td>USA</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>96</td>\n",
       "      <td>28</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>78.0</td>\n",
       "      <td>3.8</td>\n",
       "      <td>4604.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cohen Media Group</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     ID     imdbID                                             Title  Year  \\\n",
       "0  4972  tt0004972                             The Birth of a Nation  1915   \n",
       "1  6206  tt0006206                                      Les vampires  1915   \n",
       "2  6864  tt0006864  Intolerance: Love's Struggle Throughout the Ages  1916   \n",
       "\n",
       "  mpaaRating  Runtime                     Genre    Released         Director  \\\n",
       "0  Not Rated    165.0   Drama, History, Romance  1915-03-03    D.W. Griffith   \n",
       "1  Not Rated    399.0  Action, Adventure, Crime  1915-11-13  Louis Feuillade   \n",
       "2  Not Rated    197.0            Drama, History  1916-09-05    D.W. Griffith   \n",
       "\n",
       "                                              Writer  \\\n",
       "0  Thomas F. Dixon Jr. (adapted from his novel: \"...   \n",
       "1                                    Louis Feuillade   \n",
       "2      D.W. Griffith (scenario), Anita Loos (titles)   \n",
       "\n",
       "                                                Cast  imdbRating  imdbVotes  \\\n",
       "0  Lillian Gish, Mae Marsh, Henry B. Walthall, Mi...         6.9    13793.0   \n",
       "1  Musidora, Édouard Mathé, Marcel Lévesque, Jean...         6.6     2502.0   \n",
       "2  Lillian Gish, Spottiswoode Aitken, Mary Alden,...         8.0     8673.0   \n",
       "\n",
       "  Language Country  Oscars  numericRating  Meter  Reviews  Fresh  Rotten  \\\n",
       "0     None     USA       0            8.0    100       38     38       0   \n",
       "1   French  France       0            8.8    100       13     13       0   \n",
       "2     None     USA       0            8.0     96       28     27       1   \n",
       "\n",
       "   userMeter  userRating  userReviews  BoxOffice         Production  \n",
       "0       58.0         3.3       4034.0        NaN           Gravitas  \n",
       "1       85.0         3.8       2075.0        NaN               None  \n",
       "2       78.0         3.8       4604.0        NaN  Cohen Media Group  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.head(n=3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>Year</th>\n",
       "      <th>Runtime</th>\n",
       "      <th>imdbRating</th>\n",
       "      <th>imdbVotes</th>\n",
       "      <th>Oscars</th>\n",
       "      <th>numericRating</th>\n",
       "      <th>Meter</th>\n",
       "      <th>Reviews</th>\n",
       "      <th>Fresh</th>\n",
       "      <th>Rotten</th>\n",
       "      <th>userMeter</th>\n",
       "      <th>userRating</th>\n",
       "      <th>userReviews</th>\n",
       "      <th>BoxOffice</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.2569e+04</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12549.0000</td>\n",
       "      <td>1.2548e+04</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12569.0000</td>\n",
       "      <td>12478.0000</td>\n",
       "      <td>12358.0000</td>\n",
       "      <td>1.2557e+04</td>\n",
       "      <td>4.1890e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>5.8837e+05</td>\n",
       "      <td>1996.3287</td>\n",
       "      <td>102.7464</td>\n",
       "      <td>6.6102</td>\n",
       "      <td>2.7486e+04</td>\n",
       "      <td>0.1071</td>\n",
       "      <td>6.0808</td>\n",
       "      <td>62.6467</td>\n",
       "      <td>52.4545</td>\n",
       "      <td>32.4200</td>\n",
       "      <td>20.0345</td>\n",
       "      <td>64.2593</td>\n",
       "      <td>3.4025</td>\n",
       "      <td>1.8156e+05</td>\n",
       "      <td>3.0246e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>6.5278e+05</td>\n",
       "      <td>17.6909</td>\n",
       "      <td>23.5299</td>\n",
       "      <td>1.0107</td>\n",
       "      <td>6.5074e+04</td>\n",
       "      <td>0.6050</td>\n",
       "      <td>1.4497</td>\n",
       "      <td>27.5983</td>\n",
       "      <td>52.6809</td>\n",
       "      <td>38.3948</td>\n",
       "      <td>27.1021</td>\n",
       "      <td>19.8652</td>\n",
       "      <td>0.4614</td>\n",
       "      <td>1.9692e+06</td>\n",
       "      <td>5.7222e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>4.9720e+03</td>\n",
       "      <td>1902.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.1000</td>\n",
       "      <td>5.0000e+00</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.1000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.5000</td>\n",
       "      <td>2.0000e+00</td>\n",
       "      <td>3.8200e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1.0386e+05</td>\n",
       "      <td>1991.0000</td>\n",
       "      <td>91.0000</td>\n",
       "      <td>6.0000</td>\n",
       "      <td>1.5518e+03</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>5.1000</td>\n",
       "      <td>41.0000</td>\n",
       "      <td>16.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>50.0000</td>\n",
       "      <td>3.1000</td>\n",
       "      <td>1.4560e+03</td>\n",
       "      <td>2.0000e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>3.0021e+05</td>\n",
       "      <td>2002.0000</td>\n",
       "      <td>100.0000</td>\n",
       "      <td>6.7000</td>\n",
       "      <td>5.6120e+03</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>6.2000</td>\n",
       "      <td>69.0000</td>\n",
       "      <td>30.0000</td>\n",
       "      <td>18.0000</td>\n",
       "      <td>9.0000</td>\n",
       "      <td>67.0000</td>\n",
       "      <td>3.4000</td>\n",
       "      <td>6.7600e+03</td>\n",
       "      <td>5.1000e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>9.9717e+05</td>\n",
       "      <td>2008.0000</td>\n",
       "      <td>112.0000</td>\n",
       "      <td>7.3000</td>\n",
       "      <td>2.2700e+04</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>7.2000</td>\n",
       "      <td>86.0000</td>\n",
       "      <td>68.0000</td>\n",
       "      <td>40.0000</td>\n",
       "      <td>23.0000</td>\n",
       "      <td>81.0000</td>\n",
       "      <td>3.7000</td>\n",
       "      <td>4.1481e+04</td>\n",
       "      <td>3.6000e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>3.4041e+06</td>\n",
       "      <td>2014.0000</td>\n",
       "      <td>566.0000</td>\n",
       "      <td>9.3000</td>\n",
       "      <td>1.1875e+06</td>\n",
       "      <td>11.0000</td>\n",
       "      <td>10.0000</td>\n",
       "      <td>100.0000</td>\n",
       "      <td>304.0000</td>\n",
       "      <td>292.0000</td>\n",
       "      <td>192.0000</td>\n",
       "      <td>99.0000</td>\n",
       "      <td>5.0000</td>\n",
       "      <td>3.5778e+07</td>\n",
       "      <td>7.6050e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               ID        Year     Runtime  imdbRating   imdbVotes      Oscars  \\\n",
       "count  1.2569e+04  12569.0000  12569.0000  12549.0000  1.2548e+04  12569.0000   \n",
       "mean   5.8837e+05   1996.3287    102.7464      6.6102  2.7486e+04      0.1071   \n",
       "std    6.5278e+05     17.6909     23.5299      1.0107  6.5074e+04      0.6050   \n",
       "min    4.9720e+03   1902.0000      0.0000      1.1000  5.0000e+00      0.0000   \n",
       "25%    1.0386e+05   1991.0000     91.0000      6.0000  1.5518e+03      0.0000   \n",
       "50%    3.0021e+05   2002.0000    100.0000      6.7000  5.6120e+03      0.0000   \n",
       "75%    9.9717e+05   2008.0000    112.0000      7.3000  2.2700e+04      0.0000   \n",
       "max    3.4041e+06   2014.0000    566.0000      9.3000  1.1875e+06     11.0000   \n",
       "\n",
       "       numericRating       Meter     Reviews       Fresh      Rotten  \\\n",
       "count     12569.0000  12569.0000  12569.0000  12569.0000  12569.0000   \n",
       "mean          6.0808     62.6467     52.4545     32.4200     20.0345   \n",
       "std           1.4497     27.5983     52.6809     38.3948     27.1021   \n",
       "min           1.1000      0.0000     10.0000      0.0000      0.0000   \n",
       "25%           5.1000     41.0000     16.0000      9.0000      4.0000   \n",
       "50%           6.2000     69.0000     30.0000     18.0000      9.0000   \n",
       "75%           7.2000     86.0000     68.0000     40.0000     23.0000   \n",
       "max          10.0000    100.0000    304.0000    292.0000    192.0000   \n",
       "\n",
       "        userMeter  userRating  userReviews   BoxOffice  \n",
       "count  12478.0000  12358.0000   1.2557e+04  4.1890e+03  \n",
       "mean      64.2593      3.4025   1.8156e+05  3.0246e+07  \n",
       "std       19.8652      0.4614   1.9692e+06  5.7222e+07  \n",
       "min        0.0000      0.5000   2.0000e+00  3.8200e+02  \n",
       "25%       50.0000      3.1000   1.4560e+03  2.0000e+05  \n",
       "50%       67.0000      3.4000   6.7600e+03  5.1000e+06  \n",
       "75%       81.0000      3.7000   4.1481e+04  3.6000e+07  \n",
       "max       99.0000      5.0000   3.5778e+07  7.6050e+08  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(12569, 26)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<sqlite3.Connection at 0x7f71373a5118>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "conn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "movies[\"color\"] = np.where(movies[\"Oscars\"] > 0, \"orange\", \"grey\")\n",
    "movies[\"alpha\"] = np.where(movies[\"Oscars\"] > 0, 0.9, 0.25)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'ID', u'imdbID', u'Title', u'Year', u'mpaaRating', u'Runtime',\n",
       "       u'Genre', u'Released', u'Director', u'Writer', u'Cast', u'imdbRating',\n",
       "       u'imdbVotes', u'Language', u'Country', u'Oscars', u'numericRating',\n",
       "       u'Meter', u'Reviews', u'Fresh', u'Rotten', u'userMeter', u'userRating',\n",
       "       u'userReviews', u'BoxOffice', u'Production', u'color', u'alpha'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "      <th>31</th>\n",
       "      <th>32</th>\n",
       "      <th>33</th>\n",
       "      <th>34</th>\n",
       "      <th>35</th>\n",
       "      <th>36</th>\n",
       "      <th>37</th>\n",
       "      <th>38</th>\n",
       "      <th>39</th>\n",
       "      <th>40</th>\n",
       "      <th>41</th>\n",
       "      <th>42</th>\n",
       "      <th>43</th>\n",
       "      <th>44</th>\n",
       "      <th>45</th>\n",
       "      <th>46</th>\n",
       "      <th>47</th>\n",
       "      <th>48</th>\n",
       "      <th>49</th>\n",
       "      <th>50</th>\n",
       "      <th>51</th>\n",
       "      <th>52</th>\n",
       "      <th>53</th>\n",
       "      <th>54</th>\n",
       "      <th>55</th>\n",
       "      <th>56</th>\n",
       "      <th>57</th>\n",
       "      <th>58</th>\n",
       "      <th>59</th>\n",
       "      <th>60</th>\n",
       "      <th>61</th>\n",
       "      <th>62</th>\n",
       "      <th>63</th>\n",
       "      <th>64</th>\n",
       "      <th>65</th>\n",
       "      <th>66</th>\n",
       "      <th>67</th>\n",
       "      <th>68</th>\n",
       "      <th>69</th>\n",
       "      <th>70</th>\n",
       "      <th>71</th>\n",
       "      <th>72</th>\n",
       "      <th>73</th>\n",
       "      <th>74</th>\n",
       "      <th>75</th>\n",
       "      <th>76</th>\n",
       "      <th>77</th>\n",
       "      <th>78</th>\n",
       "      <th>79</th>\n",
       "      <th>80</th>\n",
       "      <th>81</th>\n",
       "      <th>82</th>\n",
       "      <th>83</th>\n",
       "      <th>84</th>\n",
       "      <th>85</th>\n",
       "      <th>86</th>\n",
       "      <th>87</th>\n",
       "      <th>88</th>\n",
       "      <th>89</th>\n",
       "      <th>90</th>\n",
       "      <th>91</th>\n",
       "      <th>92</th>\n",
       "      <th>93</th>\n",
       "      <th>94</th>\n",
       "      <th>95</th>\n",
       "      <th>96</th>\n",
       "      <th>97</th>\n",
       "      <th>98</th>\n",
       "      <th>99</th>\n",
       "      <th>100</th>\n",
       "      <th>101</th>\n",
       "      <th>102</th>\n",
       "      <th>103</th>\n",
       "      <th>104</th>\n",
       "      <th>105</th>\n",
       "      <th>106</th>\n",
       "      <th>107</th>\n",
       "      <th>108</th>\n",
       "      <th>109</th>\n",
       "      <th>110</th>\n",
       "      <th>111</th>\n",
       "      <th>112</th>\n",
       "      <th>113</th>\n",
       "      <th>114</th>\n",
       "      <th>115</th>\n",
       "      <th>116</th>\n",
       "      <th>117</th>\n",
       "      <th>118</th>\n",
       "      <th>119</th>\n",
       "      <th>120</th>\n",
       "      <th>121</th>\n",
       "      <th>122</th>\n",
       "      <th>123</th>\n",
       "      <th>124</th>\n",
       "      <th>125</th>\n",
       "      <th>126</th>\n",
       "      <th>127</th>\n",
       "      <th>128</th>\n",
       "      <th>129</th>\n",
       "      <th>130</th>\n",
       "      <th>131</th>\n",
       "      <th>132</th>\n",
       "      <th>133</th>\n",
       "      <th>134</th>\n",
       "      <th>135</th>\n",
       "      <th>136</th>\n",
       "      <th>137</th>\n",
       "      <th>138</th>\n",
       "      <th>139</th>\n",
       "      <th>140</th>\n",
       "      <th>141</th>\n",
       "      <th>142</th>\n",
       "      <th>143</th>\n",
       "      <th>144</th>\n",
       "      <th>145</th>\n",
       "      <th>146</th>\n",
       "      <th>147</th>\n",
       "      <th>148</th>\n",
       "      <th>149</th>\n",
       "      <th>150</th>\n",
       "      <th>151</th>\n",
       "      <th>152</th>\n",
       "      <th>153</th>\n",
       "      <th>154</th>\n",
       "      <th>155</th>\n",
       "      <th>156</th>\n",
       "      <th>157</th>\n",
       "      <th>158</th>\n",
       "      <th>159</th>\n",
       "      <th>160</th>\n",
       "      <th>161</th>\n",
       "      <th>162</th>\n",
       "      <th>163</th>\n",
       "      <th>164</th>\n",
       "      <th>165</th>\n",
       "      <th>166</th>\n",
       "      <th>167</th>\n",
       "      <th>168</th>\n",
       "      <th>169</th>\n",
       "      <th>170</th>\n",
       "      <th>171</th>\n",
       "      <th>172</th>\n",
       "      <th>173</th>\n",
       "      <th>174</th>\n",
       "      <th>175</th>\n",
       "      <th>176</th>\n",
       "      <th>177</th>\n",
       "      <th>178</th>\n",
       "      <th>179</th>\n",
       "      <th>180</th>\n",
       "      <th>181</th>\n",
       "      <th>182</th>\n",
       "      <th>183</th>\n",
       "      <th>184</th>\n",
       "      <th>185</th>\n",
       "      <th>186</th>\n",
       "      <th>187</th>\n",
       "      <th>188</th>\n",
       "      <th>189</th>\n",
       "      <th>190</th>\n",
       "      <th>191</th>\n",
       "      <th>192</th>\n",
       "      <th>193</th>\n",
       "      <th>194</th>\n",
       "      <th>195</th>\n",
       "      <th>196</th>\n",
       "      <th>197</th>\n",
       "      <th>198</th>\n",
       "      <th>199</th>\n",
       "      <th>200</th>\n",
       "      <th>201</th>\n",
       "      <th>202</th>\n",
       "      <th>203</th>\n",
       "      <th>204</th>\n",
       "      <th>205</th>\n",
       "      <th>206</th>\n",
       "      <th>207</th>\n",
       "      <th>208</th>\n",
       "      <th>209</th>\n",
       "      <th>210</th>\n",
       "      <th>211</th>\n",
       "      <th>212</th>\n",
       "      <th>213</th>\n",
       "      <th>214</th>\n",
       "      <th>215</th>\n",
       "      <th>216</th>\n",
       "      <th>217</th>\n",
       "      <th>218</th>\n",
       "      <th>219</th>\n",
       "      <th>220</th>\n",
       "      <th>221</th>\n",
       "      <th>222</th>\n",
       "      <th>223</th>\n",
       "      <th>224</th>\n",
       "      <th>225</th>\n",
       "      <th>226</th>\n",
       "      <th>227</th>\n",
       "      <th>228</th>\n",
       "      <th>229</th>\n",
       "      <th>230</th>\n",
       "      <th>231</th>\n",
       "      <th>232</th>\n",
       "      <th>233</th>\n",
       "      <th>234</th>\n",
       "      <th>235</th>\n",
       "      <th>236</th>\n",
       "      <th>237</th>\n",
       "      <th>238</th>\n",
       "      <th>239</th>\n",
       "      <th>240</th>\n",
       "      <th>241</th>\n",
       "      <th>242</th>\n",
       "      <th>243</th>\n",
       "      <th>244</th>\n",
       "      <th>245</th>\n",
       "      <th>246</th>\n",
       "      <th>247</th>\n",
       "      <th>248</th>\n",
       "      <th>249</th>\n",
       "      <th>...</th>\n",
       "      <th>12319</th>\n",
       "      <th>12320</th>\n",
       "      <th>12321</th>\n",
       "      <th>12322</th>\n",
       "      <th>12323</th>\n",
       "      <th>12324</th>\n",
       "      <th>12325</th>\n",
       "      <th>12326</th>\n",
       "      <th>12327</th>\n",
       "      <th>12328</th>\n",
       "      <th>12329</th>\n",
       "      <th>12330</th>\n",
       "      <th>12331</th>\n",
       "      <th>12332</th>\n",
       "      <th>12333</th>\n",
       "      <th>12334</th>\n",
       "      <th>12335</th>\n",
       "      <th>12336</th>\n",
       "      <th>12337</th>\n",
       "      <th>12338</th>\n",
       "      <th>12339</th>\n",
       "      <th>12340</th>\n",
       "      <th>12341</th>\n",
       "      <th>12342</th>\n",
       "      <th>12343</th>\n",
       "      <th>12344</th>\n",
       "      <th>12345</th>\n",
       "      <th>12346</th>\n",
       "      <th>12347</th>\n",
       "      <th>12348</th>\n",
       "      <th>12349</th>\n",
       "      <th>12350</th>\n",
       "      <th>12351</th>\n",
       "      <th>12352</th>\n",
       "      <th>12353</th>\n",
       "      <th>12354</th>\n",
       "      <th>12355</th>\n",
       "      <th>12356</th>\n",
       "      <th>12357</th>\n",
       "      <th>12358</th>\n",
       "      <th>12359</th>\n",
       "      <th>12360</th>\n",
       "      <th>12361</th>\n",
       "      <th>12362</th>\n",
       "      <th>12363</th>\n",
       "      <th>12364</th>\n",
       "      <th>12365</th>\n",
       "      <th>12366</th>\n",
       "      <th>12367</th>\n",
       "      <th>12368</th>\n",
       "      <th>12369</th>\n",
       "      <th>12370</th>\n",
       "      <th>12371</th>\n",
       "      <th>12372</th>\n",
       "      <th>12373</th>\n",
       "      <th>12374</th>\n",
       "      <th>12375</th>\n",
       "      <th>12376</th>\n",
       "      <th>12377</th>\n",
       "      <th>12378</th>\n",
       "      <th>12379</th>\n",
       "      <th>12380</th>\n",
       "      <th>12381</th>\n",
       "      <th>12382</th>\n",
       "      <th>12383</th>\n",
       "      <th>12384</th>\n",
       "      <th>12385</th>\n",
       "      <th>12386</th>\n",
       "      <th>12387</th>\n",
       "      <th>12388</th>\n",
       "      <th>12389</th>\n",
       "      <th>12390</th>\n",
       "      <th>12391</th>\n",
       "      <th>12392</th>\n",
       "      <th>12393</th>\n",
       "      <th>12394</th>\n",
       "      <th>12395</th>\n",
       "      <th>12396</th>\n",
       "      <th>12397</th>\n",
       "      <th>12398</th>\n",
       "      <th>12399</th>\n",
       "      <th>12400</th>\n",
       "      <th>12401</th>\n",
       "      <th>12402</th>\n",
       "      <th>12403</th>\n",
       "      <th>12404</th>\n",
       "      <th>12405</th>\n",
       "      <th>12406</th>\n",
       "      <th>12407</th>\n",
       "      <th>12408</th>\n",
       "      <th>12409</th>\n",
       "      <th>12410</th>\n",
       "      <th>12411</th>\n",
       "      <th>12412</th>\n",
       "      <th>12413</th>\n",
       "      <th>12414</th>\n",
       "      <th>12415</th>\n",
       "      <th>12416</th>\n",
       "      <th>12417</th>\n",
       "      <th>12418</th>\n",
       "      <th>12419</th>\n",
       "      <th>12420</th>\n",
       "      <th>12421</th>\n",
       "      <th>12422</th>\n",
       "      <th>12423</th>\n",
       "      <th>12424</th>\n",
       "      <th>12425</th>\n",
       "      <th>12426</th>\n",
       "      <th>12427</th>\n",
       "      <th>12428</th>\n",
       "      <th>12429</th>\n",
       "      <th>12430</th>\n",
       "      <th>12431</th>\n",
       "      <th>12432</th>\n",
       "      <th>12433</th>\n",
       "      <th>12434</th>\n",
       "      <th>12435</th>\n",
       "      <th>12436</th>\n",
       "      <th>12437</th>\n",
       "      <th>12438</th>\n",
       "      <th>12439</th>\n",
       "      <th>12440</th>\n",
       "      <th>12441</th>\n",
       "      <th>12442</th>\n",
       "      <th>12443</th>\n",
       "      <th>12444</th>\n",
       "      <th>12445</th>\n",
       "      <th>12446</th>\n",
       "      <th>12447</th>\n",
       "      <th>12448</th>\n",
       "      <th>12449</th>\n",
       "      <th>12450</th>\n",
       "      <th>12451</th>\n",
       "      <th>12452</th>\n",
       "      <th>12453</th>\n",
       "      <th>12454</th>\n",
       "      <th>12455</th>\n",
       "      <th>12456</th>\n",
       "      <th>12457</th>\n",
       "      <th>12458</th>\n",
       "      <th>12459</th>\n",
       "      <th>12460</th>\n",
       "      <th>12461</th>\n",
       "      <th>12462</th>\n",
       "      <th>12463</th>\n",
       "      <th>12464</th>\n",
       "      <th>12465</th>\n",
       "      <th>12466</th>\n",
       "      <th>12467</th>\n",
       "      <th>12468</th>\n",
       "      <th>12469</th>\n",
       "      <th>12470</th>\n",
       "      <th>12471</th>\n",
       "      <th>12472</th>\n",
       "      <th>12473</th>\n",
       "      <th>12474</th>\n",
       "      <th>12475</th>\n",
       "      <th>12476</th>\n",
       "      <th>12477</th>\n",
       "      <th>12478</th>\n",
       "      <th>12479</th>\n",
       "      <th>12480</th>\n",
       "      <th>12481</th>\n",
       "      <th>12482</th>\n",
       "      <th>12483</th>\n",
       "      <th>12484</th>\n",
       "      <th>12485</th>\n",
       "      <th>12486</th>\n",
       "      <th>12487</th>\n",
       "      <th>12488</th>\n",
       "      <th>12489</th>\n",
       "      <th>12490</th>\n",
       "      <th>12491</th>\n",
       "      <th>12492</th>\n",
       "      <th>12493</th>\n",
       "      <th>12494</th>\n",
       "      <th>12495</th>\n",
       "      <th>12496</th>\n",
       "      <th>12497</th>\n",
       "      <th>12498</th>\n",
       "      <th>12499</th>\n",
       "      <th>12500</th>\n",
       "      <th>12501</th>\n",
       "      <th>12502</th>\n",
       "      <th>12503</th>\n",
       "      <th>12504</th>\n",
       "      <th>12505</th>\n",
       "      <th>12506</th>\n",
       "      <th>12507</th>\n",
       "      <th>12508</th>\n",
       "      <th>12509</th>\n",
       "      <th>12510</th>\n",
       "      <th>12511</th>\n",
       "      <th>12512</th>\n",
       "      <th>12513</th>\n",
       "      <th>12514</th>\n",
       "      <th>12515</th>\n",
       "      <th>12516</th>\n",
       "      <th>12517</th>\n",
       "      <th>12518</th>\n",
       "      <th>12519</th>\n",
       "      <th>12520</th>\n",
       "      <th>12521</th>\n",
       "      <th>12522</th>\n",
       "      <th>12523</th>\n",
       "      <th>12524</th>\n",
       "      <th>12525</th>\n",
       "      <th>12526</th>\n",
       "      <th>12527</th>\n",
       "      <th>12528</th>\n",
       "      <th>12529</th>\n",
       "      <th>12530</th>\n",
       "      <th>12531</th>\n",
       "      <th>12532</th>\n",
       "      <th>12533</th>\n",
       "      <th>12534</th>\n",
       "      <th>12535</th>\n",
       "      <th>12536</th>\n",
       "      <th>12537</th>\n",
       "      <th>12538</th>\n",
       "      <th>12539</th>\n",
       "      <th>12540</th>\n",
       "      <th>12541</th>\n",
       "      <th>12542</th>\n",
       "      <th>12543</th>\n",
       "      <th>12544</th>\n",
       "      <th>12545</th>\n",
       "      <th>12546</th>\n",
       "      <th>12547</th>\n",
       "      <th>12548</th>\n",
       "      <th>12549</th>\n",
       "      <th>12550</th>\n",
       "      <th>12551</th>\n",
       "      <th>12552</th>\n",
       "      <th>12553</th>\n",
       "      <th>12554</th>\n",
       "      <th>12555</th>\n",
       "      <th>12556</th>\n",
       "      <th>12557</th>\n",
       "      <th>12558</th>\n",
       "      <th>12559</th>\n",
       "      <th>12560</th>\n",
       "      <th>12561</th>\n",
       "      <th>12562</th>\n",
       "      <th>12563</th>\n",
       "      <th>12564</th>\n",
       "      <th>12565</th>\n",
       "      <th>12566</th>\n",
       "      <th>12567</th>\n",
       "      <th>12568</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>color</th>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>...</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>orange</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "      <td>grey</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>alpha</th>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>...</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 12569 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      0     1     2     3     4     5     6     7     8     9     10    11     \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12    13    14    15    16    17    18    19    20    21    22    23     \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      24    25    26    27    28    29    30    31    32    33    34    35     \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      36    37    38    39      40    41      42    43    44    45    46     \\\n",
       "color  grey  grey  grey  grey  orange  grey  orange  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25     0.9  0.25     0.9  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      47      48    49    50    51    52    53      54    55    56    57     \\\n",
       "color  grey  orange  grey  grey  grey  grey  grey  orange  grey  grey  grey   \n",
       "alpha  0.25     0.9  0.25  0.25  0.25  0.25  0.25     0.9  0.25  0.25  0.25   \n",
       "\n",
       "      58    59      60    61    62    63    64    65    66    67    68     \\\n",
       "color  grey  grey  orange  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      69    70    71      72    73    74    75    76    77    78    79     \\\n",
       "color  grey  grey  grey  orange  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      80      81    82    83      84    85      86    87    88    89    90     \\\n",
       "color  grey  orange  grey  grey  orange  grey  orange  grey  grey  grey  grey   \n",
       "alpha  0.25     0.9  0.25  0.25     0.9  0.25     0.9  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      91    92      93    94    95    96    97    98    99    100     101    \\\n",
       "color  grey  grey  orange  grey  grey  grey  grey  grey  grey  grey  orange   \n",
       "alpha  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25     0.9   \n",
       "\n",
       "      102   103   104   105   106   107   108   109   110     111     112    \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  orange  orange   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25     0.9     0.9   \n",
       "\n",
       "      113   114   115   116   117   118     119     120   121   122   123    \\\n",
       "color  grey  grey  grey  grey  grey  grey  orange  orange  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25     0.9     0.9  0.25  0.25  0.25   \n",
       "\n",
       "      124   125   126   127   128   129   130   131   132   133   134    \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "        135   136     137   138   139   140   141   142   143   144     145    \\\n",
       "color  orange  grey  orange  grey  grey  grey  grey  grey  grey  grey  orange   \n",
       "alpha     0.9  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25     0.9   \n",
       "\n",
       "      146     147   148   149     150   151   152     153   154   155    \\\n",
       "color  grey  orange  grey  grey  orange  grey  grey  orange  grey  grey   \n",
       "alpha  0.25     0.9  0.25  0.25     0.9  0.25  0.25     0.9  0.25  0.25   \n",
       "\n",
       "        156   157   158     159   160     161   162   163     164   165    \\\n",
       "color  orange  grey  grey  orange  grey  orange  grey  grey  orange  grey   \n",
       "alpha     0.9  0.25  0.25     0.9  0.25     0.9  0.25  0.25     0.9  0.25   \n",
       "\n",
       "      166     167     168   169   170   171   172   173     174   175   176    \\\n",
       "color  grey  orange  orange  grey  grey  grey  grey  grey  orange  grey  grey   \n",
       "alpha  0.25     0.9     0.9  0.25  0.25  0.25  0.25  0.25     0.9  0.25  0.25   \n",
       "\n",
       "        177   178   179     180   181   182   183   184     185   186    \\\n",
       "color  orange  grey  grey  orange  grey  grey  grey  grey  orange  grey   \n",
       "alpha     0.9  0.25  0.25     0.9  0.25  0.25  0.25  0.25     0.9  0.25   \n",
       "\n",
       "        187   188   189     190   191   192   193   194   195     196    \\\n",
       "color  orange  grey  grey  orange  grey  grey  grey  grey  grey  orange   \n",
       "alpha     0.9  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25     0.9   \n",
       "\n",
       "        197   198   199   200   201   202     203   204   205   206   207    \\\n",
       "color  orange  grey  grey  grey  grey  grey  orange  grey  grey  grey  grey   \n",
       "alpha     0.9  0.25  0.25  0.25  0.25  0.25     0.9  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      208   209   210   211     212     213   214     215   216   217   218    \\\n",
       "color  grey  grey  grey  grey  orange  orange  grey  orange  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25     0.9     0.9  0.25     0.9  0.25  0.25  0.25   \n",
       "\n",
       "      219   220   221     222   223   224   225   226   227     228     229    \\\n",
       "color  grey  grey  grey  orange  grey  grey  grey  grey  grey  orange  orange   \n",
       "alpha  0.25  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25     0.9     0.9   \n",
       "\n",
       "        230   231   232   233     234   235     236     237   238     239    \\\n",
       "color  orange  grey  grey  grey  orange  grey  orange  orange  grey  orange   \n",
       "alpha     0.9  0.25  0.25  0.25     0.9  0.25     0.9     0.9  0.25     0.9   \n",
       "\n",
       "        240   241     242   243   244   245   246   247   248   249    ...   \\\n",
       "color  orange  grey  orange  grey  grey  grey  grey  grey  grey  grey  ...    \n",
       "alpha     0.9  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25  ...    \n",
       "\n",
       "      12319 12320 12321 12322 12323 12324 12325 12326 12327 12328 12329 12330  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12331 12332 12333 12334 12335 12336 12337 12338 12339 12340 12341 12342  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12343 12344 12345 12346 12347 12348 12349 12350 12351 12352 12353 12354  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12355 12356 12357 12358 12359 12360 12361   12362 12363 12364 12365  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  orange  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25     0.9  0.25  0.25  0.25   \n",
       "\n",
       "      12366 12367 12368 12369 12370 12371 12372 12373 12374 12375 12376 12377  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12378 12379 12380 12381 12382 12383 12384 12385 12386 12387 12388 12389  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12390 12391   12392 12393 12394 12395 12396 12397 12398 12399 12400  \\\n",
       "color  grey  grey  orange  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12401 12402 12403 12404 12405 12406 12407 12408 12409 12410 12411 12412  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12413 12414 12415 12416 12417 12418 12419 12420 12421 12422 12423 12424  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12425 12426 12427 12428 12429 12430 12431 12432 12433 12434 12435 12436  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12437 12438 12439 12440   12441 12442 12443 12444 12445 12446 12447  \\\n",
       "color  grey  grey  grey  grey  orange  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25     0.9  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12448 12449 12450 12451 12452 12453 12454 12455 12456 12457 12458 12459  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12460 12461 12462 12463 12464 12465 12466 12467 12468 12469 12470 12471  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12472 12473 12474 12475 12476 12477 12478 12479 12480 12481 12482 12483  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12484 12485 12486 12487 12488 12489 12490 12491 12492 12493 12494 12495  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12496 12497 12498 12499 12500 12501 12502 12503 12504 12505 12506 12507  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12508 12509 12510 12511 12512 12513 12514 12515 12516 12517 12518 12519  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12520 12521 12522 12523 12524 12525 12526 12527 12528 12529 12530 12531  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12532 12533 12534 12535 12536 12537 12538 12539 12540 12541 12542 12543  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12544 12545 12546 12547 12548 12549 12550 12551 12552 12553 12554 12555  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12556 12557 12558 12559 12560 12561 12562 12563 12564 12565 12566 12567  \\\n",
       "color  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey  grey   \n",
       "alpha  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25  0.25   \n",
       "\n",
       "      12568  \n",
       "color  grey  \n",
       "alpha  0.25  \n",
       "\n",
       "[2 rows x 12569 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies[['color','alpha']].T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# handle null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID                  0\n",
       "imdbID              0\n",
       "Title               0\n",
       "Year                0\n",
       "mpaaRating       2216\n",
       "Runtime             0\n",
       "Genre              21\n",
       "Released          188\n",
       "Director           20\n",
       "Writer            717\n",
       "Cast              157\n",
       "imdbRating         20\n",
       "imdbVotes          21\n",
       "Language          229\n",
       "Country           177\n",
       "Oscars              0\n",
       "numericRating       0\n",
       "Meter               0\n",
       "Reviews             0\n",
       "Fresh               0\n",
       "Rotten              0\n",
       "userMeter          91\n",
       "userRating        211\n",
       "userReviews        12\n",
       "BoxOffice        8380\n",
       "Production       1104\n",
       "color               0\n",
       "alpha               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ID               0\n",
       "imdbID           0\n",
       "Title            0\n",
       "Year             0\n",
       "mpaaRating       0\n",
       "Runtime          0\n",
       "Genre            0\n",
       "Released         0\n",
       "Director         0\n",
       "Writer           0\n",
       "Cast             0\n",
       "imdbRating       0\n",
       "imdbVotes        0\n",
       "Language         0\n",
       "Country          0\n",
       "Oscars           0\n",
       "numericRating    0\n",
       "Meter            0\n",
       "Reviews          0\n",
       "Fresh            0\n",
       "Rotten           0\n",
       "userMeter        0\n",
       "userRating       0\n",
       "userReviews      0\n",
       "BoxOffice        0\n",
       "Production       0\n",
       "color            0\n",
       "alpha            0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies.fillna(0, inplace=True)  # just replace missing values with zero\n",
    "movies.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "movies[\"revenue\"] = movies.BoxOffice.apply(lambda x: '{:,d}'.format(int(x)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                  0\n",
       "1                  0\n",
       "2                  0\n",
       "3                  0\n",
       "4                  0\n",
       "5                  0\n",
       "6                  0\n",
       "7                  0\n",
       "8                  0\n",
       "9                  0\n",
       "10                 0\n",
       "11                 0\n",
       "12                 0\n",
       "13                 0\n",
       "14                 0\n",
       "15                 0\n",
       "16                 0\n",
       "17                 0\n",
       "18                 0\n",
       "19                 0\n",
       "20                 0\n",
       "21                 0\n",
       "22                 0\n",
       "23                 0\n",
       "24            51,000\n",
       "25                 0\n",
       "26                 0\n",
       "27                 0\n",
       "28                 0\n",
       "29                 0\n",
       "            ...     \n",
       "12539              0\n",
       "12540              0\n",
       "12541              0\n",
       "12542         99,700\n",
       "12543              0\n",
       "12544        300,000\n",
       "12545         12,800\n",
       "12546              0\n",
       "12547              0\n",
       "12548              0\n",
       "12549         79,300\n",
       "12550              0\n",
       "12551         15,300\n",
       "12552              0\n",
       "12553              0\n",
       "12554    102,000,000\n",
       "12555              0\n",
       "12556        500,000\n",
       "12557          5,100\n",
       "12558              0\n",
       "12559              0\n",
       "12560              0\n",
       "12561              0\n",
       "12562              0\n",
       "12563              0\n",
       "12564     55,700,000\n",
       "12565              0\n",
       "12566              0\n",
       "12567              0\n",
       "12568        600,000\n",
       "Name: revenue, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "movies['revenue']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "with open(join(dirname(__file__), \"razzies-clean.csv\")) as f:\n",
    "    razzies = f.read().splitlines()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "movies.loc[movies.imdbID.isin(razzies), \"color\"] = \"purple\"\n",
    "movies.loc[movies.imdbID.isin(razzies), \"alpha\"] = 0.9\n",
    "\n",
    "axis_map = {\n",
    "    \"Tomato Meter\": \"Meter\",\n",
    "    \"Numeric Rating\": \"numericRating\",\n",
    "    \"Number of Reviews\": \"Reviews\",\n",
    "    \"Box Office (dollars)\": \"BoxOffice\",\n",
    "    \"Length (minutes)\": \"Runtime\",\n",
    "    \"Year\": \"Year\",\n",
    "}\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# now let's work with Bokeh"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "from bokeh.plotting import figure\n",
    "from bokeh.layouts import layout, widgetbox\n",
    "from bokeh.models import ColumnDataSource, HoverTool, Div\n",
    "from bokeh.models.widgets import Slider, Select, TextInput\n",
    "from bokeh.io import curdoc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "desc = Div(text=open(join(dirname(__file__), \"description.html\")).read(), width=800)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Input Controls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "reviews = Slider(title=\"Minimum number of reviews\", value=80, start=10, end=300, step=10)\n",
    "min_year = Slider(title=\"Year released\", start=1940, end=2014, value=1970, step=1)\n",
    "max_year = Slider(title=\"End Year released\", start=1940, end=2014, value=2014, step=1)\n",
    "oscars = Slider(title=\"Minimum number of Oscar wins\", start=0, end=4, value=0, step=1)\n",
    "boxoffice = Slider(title=\"Dollars at Box Office (millions)\", start=0, end=800, value=0, step=1)\n",
    "genre = Select(title=\"Genre\", value=\"All\",\n",
    "               options=open(join(dirname(__file__), 'genres.txt')).read().split())\n",
    "director = TextInput(title=\"Director name contains\")\n",
    "cast = TextInput(title=\"Cast names contains\")\n",
    "x_axis = Select(title=\"X Axis\", options=sorted(axis_map.keys()), value=\"Tomato Meter\")\n",
    "y_axis = Select(title=\"Y Axis\", options=sorted(axis_map.keys()), value=\"Number of Reviews\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Create Column Data Source that will be used by the plot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "source = ColumnDataSource(data=dict(x=[], y=[], color=[], title=[], year=[], revenue=[], alpha=[]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "hover = HoverTool(tooltips=[\n",
    "    (\"Title\", \"@title\"),\n",
    "    (\"Year\", \"@year\"),\n",
    "    (\"$\", \"@revenue\")\n",
    "])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bokeh.models.renderers.GlyphRenderer at 0x7f715a10d350>"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p = figure(plot_height=600, plot_width=700, title=\"\", toolbar_location=None, tools=[hover])\n",
    "p.circle(x=\"x\", y=\"y\", source=source, size=7, color=\"color\", line_color=None, fill_alpha=\"alpha\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def select_movies():\n",
    "    genre_val = genre.value\n",
    "    director_val = director.value.strip()\n",
    "    cast_val = cast.value.strip()\n",
    "    selected = movies[\n",
    "        (movies.Reviews >= reviews.value) &\n",
    "        (movies.BoxOffice >= (boxoffice.value * 1e6)) &\n",
    "        (movies.Year >= min_year.value) &\n",
    "        (movies.Year <= max_year.value) &\n",
    "        (movies.Oscars >= oscars.value)\n",
    "    ]\n",
    "    if (genre_val != \"All\"):\n",
    "        selected = selected[selected.Genre.str.contains(genre_val)==True]\n",
    "    if (director_val != \"\"):\n",
    "        selected = selected[selected.Director.str.contains(director_val)==True]\n",
    "    if (cast_val != \"\"):\n",
    "        selected = selected[selected.Cast.str.contains(cast_val)==True]\n",
    "    return selected"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "\n",
    "def update():\n",
    "    df = select_movies()\n",
    "    x_name = axis_map[x_axis.value]\n",
    "    y_name = axis_map[y_axis.value]\n",
    "\n",
    "    p.xaxis.axis_label = x_axis.value\n",
    "    p.yaxis.axis_label = y_axis.value\n",
    "    p.title.text = \"%d movies selected\" % len(df)\n",
    "    source.data = dict(\n",
    "        x=df[x_name],\n",
    "        y=df[y_name],\n",
    "        color=df[\"color\"],\n",
    "        title=df[\"Title\"],\n",
    "        year=df[\"Year\"],\n",
    "        revenue=df[\"revenue\"],\n",
    "        alpha=df[\"alpha\"],\n",
    "    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "controls = [reviews, boxoffice, genre, min_year, max_year, oscars, director, cast, x_axis, y_axis]\n",
    "for control in controls:\n",
    "    control.on_change('value', lambda attr, old, new: update())\n",
    "\n",
    "sizing_mode = 'fixed'  # 'scale_width' also looks nice with this example\n",
    "\n",
    "inputs = widgetbox(*controls, sizing_mode=sizing_mode)\n",
    "l = layout([\n",
    "    [desc],\n",
    "    [inputs, p],\n",
    "], sizing_mode=sizing_mode)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "update()  # initial load of the data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "curdoc().add_root(l)\n",
    "curdoc().title = \"Movies\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}