visitors_by_month-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from bokeh.plotting import figure, output_file, show, output_notebook"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from bokeh.core.properties import field\n",
    "from bokeh.io import curdoc\n",
    "from bokeh.layouts import layout\n",
    "from bokeh.models import (ColumnDataSource, HoverTool, SingleIntervalTicker,\n",
    "                          Slider, Button, Label, CategoricalColorMapper)\n",
    "from bokeh.palettes import Spectral6\n",
    "from bokeh.plotting import figure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt \n",
    "import numpy as np\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/by_month.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "# remove total column \n",
    "df.drop('Total', axis= 1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Jan</th>\n",
       "      <th>Feb</th>\n",
       "      <th>Mar</th>\n",
       "      <th>Apr</th>\n",
       "      <th>May</th>\n",
       "      <th>Jun</th>\n",
       "      <th>July</th>\n",
       "      <th>Aug</th>\n",
       "      <th>Sep</th>\n",
       "      <th>Oct</th>\n",
       "      <th>Nov</th>\n",
       "      <th>Dec</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1992</td>\n",
       "      <td>12560</td>\n",
       "      <td>20331</td>\n",
       "      <td>24792</td>\n",
       "      <td>20295</td>\n",
       "      <td>11380</td>\n",
       "      <td>7264</td>\n",
       "      <td>12708</td>\n",
       "      <td>20198</td>\n",
       "      <td>18442</td>\n",
       "      <td>33834</td>\n",
       "      <td>25862</td>\n",
       "      <td>20113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1993</td>\n",
       "      <td>14147</td>\n",
       "      <td>18164</td>\n",
       "      <td>25200</td>\n",
       "      <td>14594</td>\n",
       "      <td>9355</td>\n",
       "      <td>8536</td>\n",
       "      <td>9076</td>\n",
       "      <td>16671</td>\n",
       "      <td>18293</td>\n",
       "      <td>34415</td>\n",
       "      <td>23715</td>\n",
       "      <td>18039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1994</td>\n",
       "      <td>14795</td>\n",
       "      <td>19794</td>\n",
       "      <td>24856</td>\n",
       "      <td>19778</td>\n",
       "      <td>12244</td>\n",
       "      <td>8561</td>\n",
       "      <td>13352</td>\n",
       "      <td>20524</td>\n",
       "      <td>21289</td>\n",
       "      <td>30063</td>\n",
       "      <td>20556</td>\n",
       "      <td>18179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1995</td>\n",
       "      <td>15758</td>\n",
       "      <td>19482</td>\n",
       "      <td>25381</td>\n",
       "      <td>23419</td>\n",
       "      <td>12491</td>\n",
       "      <td>9270</td>\n",
       "      <td>14141</td>\n",
       "      <td>20211</td>\n",
       "      <td>22344</td>\n",
       "      <td>38398</td>\n",
       "      <td>28177</td>\n",
       "      <td>17063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1996</td>\n",
       "      <td>17678</td>\n",
       "      <td>23629</td>\n",
       "      <td>31738</td>\n",
       "      <td>25458</td>\n",
       "      <td>14042</td>\n",
       "      <td>9777</td>\n",
       "      <td>13724</td>\n",
       "      <td>21833</td>\n",
       "      <td>23201</td>\n",
       "      <td>38139</td>\n",
       "      <td>29221</td>\n",
       "      <td>22661</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1997</td>\n",
       "      <td>16856</td>\n",
       "      <td>24151</td>\n",
       "      <td>33389</td>\n",
       "      <td>24343</td>\n",
       "      <td>14836</td>\n",
       "      <td>9973</td>\n",
       "      <td>16024</td>\n",
       "      <td>24772</td>\n",
       "      <td>24344</td>\n",
       "      <td>46110</td>\n",
       "      <td>30712</td>\n",
       "      <td>22909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1998</td>\n",
       "      <td>20124</td>\n",
       "      <td>27855</td>\n",
       "      <td>33097</td>\n",
       "      <td>28997</td>\n",
       "      <td>15647</td>\n",
       "      <td>11195</td>\n",
       "      <td>15724</td>\n",
       "      <td>26387</td>\n",
       "      <td>29241</td>\n",
       "      <td>49787</td>\n",
       "      <td>38587</td>\n",
       "      <td>23814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1999</td>\n",
       "      <td>20554</td>\n",
       "      <td>29259</td>\n",
       "      <td>38158</td>\n",
       "      <td>29637</td>\n",
       "      <td>22305</td>\n",
       "      <td>12731</td>\n",
       "      <td>16782</td>\n",
       "      <td>29402</td>\n",
       "      <td>33650</td>\n",
       "      <td>54099</td>\n",
       "      <td>38835</td>\n",
       "      <td>25431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2000</td>\n",
       "      <td>21092</td>\n",
       "      <td>33939</td>\n",
       "      <td>38959</td>\n",
       "      <td>36430</td>\n",
       "      <td>18658</td>\n",
       "      <td>12036</td>\n",
       "      <td>16842</td>\n",
       "      <td>27205</td>\n",
       "      <td>34643</td>\n",
       "      <td>51100</td>\n",
       "      <td>45318</td>\n",
       "      <td>31509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2001</td>\n",
       "      <td>25158</td>\n",
       "      <td>32763</td>\n",
       "      <td>40684</td>\n",
       "      <td>32211</td>\n",
       "      <td>17406</td>\n",
       "      <td>8929</td>\n",
       "      <td>13965</td>\n",
       "      <td>21658</td>\n",
       "      <td>26132</td>\n",
       "      <td>37198</td>\n",
       "      <td>25795</td>\n",
       "      <td>15018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2002</td>\n",
       "      <td>13180</td>\n",
       "      <td>16960</td>\n",
       "      <td>25102</td>\n",
       "      <td>16877</td>\n",
       "      <td>11751</td>\n",
       "      <td>8338</td>\n",
       "      <td>9962</td>\n",
       "      <td>15515</td>\n",
       "      <td>18768</td>\n",
       "      <td>30251</td>\n",
       "      <td>24044</td>\n",
       "      <td>17943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2003</td>\n",
       "      <td>15659</td>\n",
       "      <td>19321</td>\n",
       "      <td>22260</td>\n",
       "      <td>20303</td>\n",
       "      <td>15288</td>\n",
       "      <td>7835</td>\n",
       "      <td>13607</td>\n",
       "      <td>19149</td>\n",
       "      <td>22577</td>\n",
       "      <td>38040</td>\n",
       "      <td>31750</td>\n",
       "      <td>25980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2004</td>\n",
       "      <td>22947</td>\n",
       "      <td>28743</td>\n",
       "      <td>35468</td>\n",
       "      <td>26279</td>\n",
       "      <td>15581</td>\n",
       "      <td>9776</td>\n",
       "      <td>17070</td>\n",
       "      <td>27657</td>\n",
       "      <td>21829</td>\n",
       "      <td>38104</td>\n",
       "      <td>29330</td>\n",
       "      <td>22187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2005</td>\n",
       "      <td>19531</td>\n",
       "      <td>17061</td>\n",
       "      <td>25847</td>\n",
       "      <td>18311</td>\n",
       "      <td>15438</td>\n",
       "      <td>11170</td>\n",
       "      <td>14921</td>\n",
       "      <td>26119</td>\n",
       "      <td>27413</td>\n",
       "      <td>40553</td>\n",
       "      <td>34778</td>\n",
       "      <td>27822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2006</td>\n",
       "      <td>21126</td>\n",
       "      <td>21320</td>\n",
       "      <td>30169</td>\n",
       "      <td>18435</td>\n",
       "      <td>13517</td>\n",
       "      <td>11841</td>\n",
       "      <td>15066</td>\n",
       "      <td>24966</td>\n",
       "      <td>26327</td>\n",
       "      <td>43026</td>\n",
       "      <td>37402</td>\n",
       "      <td>27009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2007</td>\n",
       "      <td>25857</td>\n",
       "      <td>33133</td>\n",
       "      <td>48022</td>\n",
       "      <td>32794</td>\n",
       "      <td>23296</td>\n",
       "      <td>18937</td>\n",
       "      <td>26160</td>\n",
       "      <td>37658</td>\n",
       "      <td>38813</td>\n",
       "      <td>65745</td>\n",
       "      <td>46822</td>\n",
       "      <td>33458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2008</td>\n",
       "      <td>30473</td>\n",
       "      <td>40334</td>\n",
       "      <td>51364</td>\n",
       "      <td>31952</td>\n",
       "      <td>19619</td>\n",
       "      <td>12922</td>\n",
       "      <td>18097</td>\n",
       "      <td>32084</td>\n",
       "      <td>33870</td>\n",
       "      <td>60938</td>\n",
       "      <td>47467</td>\n",
       "      <td>29980</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2009</td>\n",
       "      <td>23969</td>\n",
       "      <td>34594</td>\n",
       "      <td>45950</td>\n",
       "      <td>34938</td>\n",
       "      <td>20362</td>\n",
       "      <td>17078</td>\n",
       "      <td>19942</td>\n",
       "      <td>36121</td>\n",
       "      <td>36241</td>\n",
       "      <td>65592</td>\n",
       "      <td>48667</td>\n",
       "      <td>32618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2010</td>\n",
       "      <td>28076</td>\n",
       "      <td>43289</td>\n",
       "      <td>56632</td>\n",
       "      <td>37208</td>\n",
       "      <td>21053</td>\n",
       "      <td>17967</td>\n",
       "      <td>24273</td>\n",
       "      <td>43172</td>\n",
       "      <td>44650</td>\n",
       "      <td>69982</td>\n",
       "      <td>57304</td>\n",
       "      <td>38363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2011</td>\n",
       "      <td>34541</td>\n",
       "      <td>48045</td>\n",
       "      <td>58455</td>\n",
       "      <td>49089</td>\n",
       "      <td>29692</td>\n",
       "      <td>25081</td>\n",
       "      <td>28875</td>\n",
       "      <td>55204</td>\n",
       "      <td>50560</td>\n",
       "      <td>86988</td>\n",
       "      <td>72436</td>\n",
       "      <td>47745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2012</td>\n",
       "      <td>42055</td>\n",
       "      <td>55301</td>\n",
       "      <td>72882</td>\n",
       "      <td>53745</td>\n",
       "      <td>30140</td>\n",
       "      <td>30084</td>\n",
       "      <td>34837</td>\n",
       "      <td>57590</td>\n",
       "      <td>4654</td>\n",
       "      <td>79536</td>\n",
       "      <td>74603</td>\n",
       "      <td>51850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2013</td>\n",
       "      <td>40296</td>\n",
       "      <td>58195</td>\n",
       "      <td>73434</td>\n",
       "      <td>53079</td>\n",
       "      <td>33295</td>\n",
       "      <td>28507</td>\n",
       "      <td>37666</td>\n",
       "      <td>57642</td>\n",
       "      <td>51912</td>\n",
       "      <td>77163</td>\n",
       "      <td>59630</td>\n",
       "      <td>45822</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Year    Jan    Feb    Mar    Apr    May    Jun   July    Aug    Sep  \\\n",
       "0   1992  12560  20331  24792  20295  11380   7264  12708  20198  18442   \n",
       "1   1993  14147  18164  25200  14594   9355   8536   9076  16671  18293   \n",
       "2   1994  14795  19794  24856  19778  12244   8561  13352  20524  21289   \n",
       "3   1995  15758  19482  25381  23419  12491   9270  14141  20211  22344   \n",
       "4   1996  17678  23629  31738  25458  14042   9777  13724  21833  23201   \n",
       "5   1997  16856  24151  33389  24343  14836   9973  16024  24772  24344   \n",
       "6   1998  20124  27855  33097  28997  15647  11195  15724  26387  29241   \n",
       "7   1999  20554  29259  38158  29637  22305  12731  16782  29402  33650   \n",
       "8   2000  21092  33939  38959  36430  18658  12036  16842  27205  34643   \n",
       "9   2001  25158  32763  40684  32211  17406   8929  13965  21658  26132   \n",
       "10  2002  13180  16960  25102  16877  11751   8338   9962  15515  18768   \n",
       "11  2003  15659  19321  22260  20303  15288   7835  13607  19149  22577   \n",
       "12  2004  22947  28743  35468  26279  15581   9776  17070  27657  21829   \n",
       "13  2005  19531  17061  25847  18311  15438  11170  14921  26119  27413   \n",
       "14  2006  21126  21320  30169  18435  13517  11841  15066  24966  26327   \n",
       "15  2007  25857  33133  48022  32794  23296  18937  26160  37658  38813   \n",
       "16  2008  30473  40334  51364  31952  19619  12922  18097  32084  33870   \n",
       "17  2009  23969  34594  45950  34938  20362  17078  19942  36121  36241   \n",
       "18  2010  28076  43289  56632  37208  21053  17967  24273  43172  44650   \n",
       "19  2011  34541  48045  58455  49089  29692  25081  28875  55204  50560   \n",
       "20  2012  42055  55301  72882  53745  30140  30084  34837  57590   4654   \n",
       "21  2013  40296  58195  73434  53079  33295  28507  37666  57642  51912   \n",
       "\n",
       "      Oct    Nov    Dec  \n",
       "0   33834  25862  20113  \n",
       "1   34415  23715  18039  \n",
       "2   30063  20556  18179  \n",
       "3   38398  28177  17063  \n",
       "4   38139  29221  22661  \n",
       "5   46110  30712  22909  \n",
       "6   49787  38587  23814  \n",
       "7   54099  38835  25431  \n",
       "8   51100  45318  31509  \n",
       "9   37198  25795  15018  \n",
       "10  30251  24044  17943  \n",
       "11  38040  31750  25980  \n",
       "12  38104  29330  22187  \n",
       "13  40553  34778  27822  \n",
       "14  43026  37402  27009  \n",
       "15  65745  46822  33458  \n",
       "16  60938  47467  29980  \n",
       "17  65592  48667  32618  \n",
       "18  69982  57304  38363  \n",
       "19  86988  72436  47745  \n",
       "20  79536  74603  51850  \n",
       "21  77163  59630  45822  "
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "months = list(df.columns)\n",
    "#months\n",
    "year = list(range(1992, 2014,1))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 22 entries, 0 to 21\n",
      "Data columns (total 13 columns):\n",
      "Year    22 non-null int64\n",
      "Jan     22 non-null int64\n",
      "Feb     22 non-null int64\n",
      "Mar     22 non-null int64\n",
      "Apr     22 non-null int64\n",
      "May     22 non-null int64\n",
      "Jun     22 non-null int64\n",
      "July    22 non-null int64\n",
      "Aug     22 non-null int64\n",
      "Sep     22 non-null int64\n",
      "Oct     22 non-null int64\n",
      "Nov     22 non-null int64\n",
      "Dec     22 non-null int64\n",
      "dtypes: int64(13)\n",
      "memory usage: 2.3 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new = pd.melt(df, id_vars = 'Year', var_name='Month', value_name = 'Visitors')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Visitors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>1993</td>\n",
       "      <td>Sep</td>\n",
       "      <td>18293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2008</td>\n",
       "      <td>Oct</td>\n",
       "      <td>60938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>1994</td>\n",
       "      <td>Sep</td>\n",
       "      <td>21289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2009</td>\n",
       "      <td>Jun</td>\n",
       "      <td>17078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2004</td>\n",
       "      <td>Jan</td>\n",
       "      <td>22947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>1992</td>\n",
       "      <td>Nov</td>\n",
       "      <td>25862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>1998</td>\n",
       "      <td>May</td>\n",
       "      <td>15647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>1995</td>\n",
       "      <td>Jun</td>\n",
       "      <td>9270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>2007</td>\n",
       "      <td>Aug</td>\n",
       "      <td>37658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2001</td>\n",
       "      <td>Mar</td>\n",
       "      <td>40684</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year Month  Visitors\n",
       "177  1993   Sep     18293\n",
       "214  2008   Oct     60938\n",
       "178  1994   Sep     21289\n",
       "127  2009   Jun     17078\n",
       "12   2004   Jan     22947\n",
       "220  1992   Nov     25862\n",
       "94   1998   May     15647\n",
       "113  1995   Jun      9270\n",
       "169  2007   Aug     37658\n",
       "53   2001   Mar     40684"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "month_dict = {\"Jan\":1,\"Feb\":2,\"Mar\":3,\"Apr\":4, \"May\":5, \"Jun\":6,\n",
    "     \"July\":7,\"Aug\":8,\"Sep\":9,\"Oct\":10,\"Nov\":11,\"Dec\":12}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "def change_month(x):\n",
    "    return month_dict[x]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new['Month'] = df_new['Month'].apply(change_month)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Visitors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1997</td>\n",
       "      <td>3</td>\n",
       "      <td>33389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2007</td>\n",
       "      <td>2</td>\n",
       "      <td>33133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1996</td>\n",
       "      <td>5</td>\n",
       "      <td>14042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1993</td>\n",
       "      <td>2</td>\n",
       "      <td>18164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>1995</td>\n",
       "      <td>6</td>\n",
       "      <td>9270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>2004</td>\n",
       "      <td>7</td>\n",
       "      <td>17070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1992</td>\n",
       "      <td>5</td>\n",
       "      <td>11380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>1998</td>\n",
       "      <td>8</td>\n",
       "      <td>26387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>2009</td>\n",
       "      <td>5</td>\n",
       "      <td>20362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>1995</td>\n",
       "      <td>12</td>\n",
       "      <td>17063</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year  Month  Visitors\n",
       "49   1997      3     33389\n",
       "37   2007      2     33133\n",
       "92   1996      5     14042\n",
       "23   1993      2     18164\n",
       "113  1995      6      9270\n",
       "144  2004      7     17070\n",
       "88   1992      5     11380\n",
       "160  1998      8     26387\n",
       "105  2009      5     20362\n",
       "245  1995     12     17063"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_new.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new['day'] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_new['date'] = pd.to_datetime(df_new[['Year', 'Month', 'day']])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = df_new[['date', 'Visitors']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>Visitors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1992-01-01</td>\n",
       "      <td>12560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1993-01-01</td>\n",
       "      <td>14147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1994-01-01</td>\n",
       "      <td>14795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1995-01-01</td>\n",
       "      <td>15758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1996-01-01</td>\n",
       "      <td>17678</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date  Visitors\n",
       "0 1992-01-01     12560\n",
       "1 1993-01-01     14147\n",
       "2 1994-01-01     14795\n",
       "3 1995-01-01     15758\n",
       "4 1996-01-01     17678"
      ]
     },
     "execution_count": 120,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_sorted = data.sort_values(by=['date'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>Visitors</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1992-01-01</td>\n",
       "      <td>12560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1992-02-01</td>\n",
       "      <td>20331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1992-03-01</td>\n",
       "      <td>24792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>1992-04-01</td>\n",
       "      <td>20295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1992-05-01</td>\n",
       "      <td>11380</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date  Visitors\n",
       "0  1992-01-01     12560\n",
       "22 1992-02-01     20331\n",
       "44 1992-03-01     24792\n",
       "66 1992-04-01     20295\n",
       "88 1992-05-01     11380"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_sorted.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['index', 'date', 'Visitors'])"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Convert dataframe to column data source for hover toos\n",
    "src = ColumnDataSource(data_sorted[['date', 'Visitors']])\n",
    "src.data.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "metadata": {},
   "outputs": [],
   "source": [
    "hover = HoverTool(tooltips = [('date ', '@date{%F}'),\n",
    "                             ('Num of Tourist', '@Visitors')],\n",
    "                  formatters={'date': 'datetime'})\n",
    "# use 'datetime' formatter for 'date' field })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "metadata": {},
   "outputs": [],
   "source": [
    "TOOLS = 'crosshair,save,pan,box_zoom,reset,wheel_zoom'\n",
    "p = figure(title=\"No of visitors by Time\", y_axis_type=\"linear\",x_axis_type='datetime',plot_width=1300, tools = TOOLS)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [],
   "source": [
    "p.add_tools(hover)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [],
   "source": [
    "p.line('date', 'Visitors',source=src, legend=\"visitors\", line_color=\"purple\", line_width =3)\n",
    "p.legend.location = \"top_left\"\n",
    "\n",
    "p.xaxis.axis_label = 'Year'\n",
    "p.yaxis.axis_label = 'number of visitors'\n",
    "\n",
    "output_file(\"hover_plot.html\", title=\"No of visitors in Nepal\")\n",
    "\n",
    "show(p)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}