Get_BarclayEvents.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data Management: Barclays Center Events Dataset\n",
    "\n",
    "## This notebook:\n",
    "1. Parse event info of 2016 from Barclays Center's Facebook page\n",
    "2. Returns a csv with events ('events_2016.csv')\n",
    "3. Manage time variables and subset events beginning after 17:00\n",
    "4. Returns a csv with subset events ('events_2016_subset.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Parse events data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import os\n",
    "import requests\n",
    "import facebook\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pylab as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# define a function that parse event info from Facebook\n",
    "# sample code retrieved from https://gist.github.com/mylsb/10294040\n",
    "def some_action(event,results):\n",
    "    \"\"\" Here you might want to do something with each post. E.g. grab the\n",
    "    post's message (post['message']) or the post's picture (post['picture']).\n",
    "    In this implementation we just print the post's created time.\n",
    "    \"\"\"\n",
    "    #print(event['start_time'])\n",
    "    date = event['start_time'].split('-')\n",
    "    if date[0] == '2016':\n",
    "        results.append([event['id'], event['name'], event['start_time']])\n",
    "        #print(event['id'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# set up parameters for parsing\n",
    "results = []\n",
    "\n",
    "# API token: https://developers.facebook.com/tools/explorer/\n",
    "access_token = os.getenv('$FBAPIKEY')\n",
    "\n",
    "# Barclays Center Facebook id\n",
    "user = 'barclayscenter'\n",
    "\n",
    "graph = facebook.GraphAPI(access_token)\n",
    "profile = graph.get_object(user)\n",
    "events = graph.get_connections(profile['id'], 'events')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# run code\n",
    "while True:\n",
    "    try:\n",
    "        # Perform some action on each post in the collection we receive from\n",
    "        # Facebook.\n",
    "        [some_action(event, results) for event in events['data']]\n",
    "        # Attempt to make a request to the next page of data, if it exists.\n",
    "        events = requests.get(events['paging']['next']).json()\n",
    "    except KeyError:\n",
    "        # When there are no more pages (['paging']['next']), break from the\n",
    "        # loop and end the script.\n",
    "        break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# examine and clean up dataframe\n",
    "df = pd.DataFrame(results)\n",
    "df.columns = ['EventID','Name','Start_Time']\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('events_2016.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## Manually assign event types outside of notebook\n",
    "events_2016.csv -> events_2016_modified.csv\n",
    "## Add event end time variable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EventID</th>\n",
       "      <th>Event_type</th>\n",
       "      <th>Name</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>Start_Hour</th>\n",
       "      <th>End_Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.520000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02T14:00:00-0500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-02T16:00:00-0500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.490000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02T19:00:00-0500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-02T21:00:00-0500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.010000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Boston Celtics</td>\n",
       "      <td>2016-01-04T19:30:00-0500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-04T21:30:00-0500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.080000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Toronto Raptors</td>\n",
       "      <td>2016-01-06T19:30:00-0500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-06T21:30:00-0500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.390000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Orlando Magic</td>\n",
       "      <td>2016-01-08T19:30:00-0500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-08T21:30:00-0500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        EventID  Event_type                               Name  \\\n",
       "0  1.520000e+15  basketball               Harlem Globetrotters   \n",
       "1  1.490000e+15  basketball               Harlem Globetrotters   \n",
       "2  2.010000e+14  basketball   Brooklyn Nets vs. Boston Celtics   \n",
       "3  1.080000e+15  basketball  Brooklyn Nets vs. Toronto Raptors   \n",
       "4  1.390000e+15  basketball    Brooklyn Nets vs. Orlando Magic   \n",
       "\n",
       "                 Start_Time  Start_Hour                  End_Time  \n",
       "0  2016-01-02T14:00:00-0500         NaN  2016-01-02T16:00:00-0500  \n",
       "1  2016-01-02T19:00:00-0500         NaN  2016-01-02T21:00:00-0500  \n",
       "2  2016-01-04T19:30:00-0500         NaN  2016-01-04T21:30:00-0500  \n",
       "3  2016-01-06T19:30:00-0500         NaN  2016-01-06T21:30:00-0500  \n",
       "4  2016-01-08T19:30:00-0500         NaN  2016-01-08T21:30:00-0500  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "event = pd.read_csv('events_2016_modified.csv')\n",
    "event.drop('Unnamed: 0', axis=1, inplace=True)\n",
    "event.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EventID</th>\n",
       "      <th>Event_type</th>\n",
       "      <th>Name</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>Start_Hour</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>End_Hour</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.520000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02 14:00:00</td>\n",
       "      <td>14</td>\n",
       "      <td>2016-01-02 16:00:00</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.490000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-02 21:00:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.010000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Boston Celtics</td>\n",
       "      <td>2016-01-04 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-04 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.080000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Toronto Raptors</td>\n",
       "      <td>2016-01-06 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-06 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.390000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Orlando Magic</td>\n",
       "      <td>2016-01-08 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-08 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        EventID  Event_type                               Name  \\\n",
       "0  1.520000e+15  basketball               Harlem Globetrotters   \n",
       "1  1.490000e+15  basketball               Harlem Globetrotters   \n",
       "2  2.010000e+14  basketball   Brooklyn Nets vs. Boston Celtics   \n",
       "3  1.080000e+15  basketball  Brooklyn Nets vs. Toronto Raptors   \n",
       "4  1.390000e+15  basketball    Brooklyn Nets vs. Orlando Magic   \n",
       "\n",
       "           Start_Time  Start_Hour            End_Time  End_Hour  \n",
       "0 2016-01-02 14:00:00          14 2016-01-02 16:00:00        16  \n",
       "1 2016-01-02 19:00:00          19 2016-01-02 21:00:00        21  \n",
       "2 2016-01-04 19:30:00          19 2016-01-04 21:30:00        21  \n",
       "3 2016-01-06 19:30:00          19 2016-01-06 21:30:00        21  \n",
       "4 2016-01-08 19:30:00          19 2016-01-08 21:30:00        21  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove unreasonable timezone element\n",
    "event['Start_Time'] = [str(i)[:-5] for i in event['Start_Time']]\n",
    "event['End_Time'] = [str(i)[:-5] for i in event['End_Time']]\n",
    "\n",
    "# extract hour element from time\n",
    "event['Start_Time'] = pd.to_datetime(event['Start_Time'], format='%Y-%m-%dT%H:%M:%S')\n",
    "event['Start_Hour'] = event['Start_Time'].dt.hour\n",
    "\n",
    "event['End_Time'] = pd.to_datetime(event['End_Time'], format='%Y-%m-%dT%H:%M:%S')\n",
    "event['End_Hour'] = event['End_Time'].dt.hour\n",
    "event.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EventID</th>\n",
       "      <th>Event_type</th>\n",
       "      <th>Name</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>Start_Hour</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>End_Hour</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.490000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-02 21:00:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.010000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Boston Celtics</td>\n",
       "      <td>2016-01-04 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-04 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.080000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Toronto Raptors</td>\n",
       "      <td>2016-01-06 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-06 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.390000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Orlando Magic</td>\n",
       "      <td>2016-01-08 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-08 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.230000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. San Antonio Spurs</td>\n",
       "      <td>2016-01-11 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-11 21:30:00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        EventID  Event_type                                 Name  \\\n",
       "1  1.490000e+15  basketball                 Harlem Globetrotters   \n",
       "2  2.010000e+14  basketball     Brooklyn Nets vs. Boston Celtics   \n",
       "3  1.080000e+15  basketball    Brooklyn Nets vs. Toronto Raptors   \n",
       "4  1.390000e+15  basketball      Brooklyn Nets vs. Orlando Magic   \n",
       "5  1.230000e+15  basketball  Brooklyn Nets vs. San Antonio Spurs   \n",
       "\n",
       "           Start_Time  Start_Hour            End_Time  End_Hour  \n",
       "1 2016-01-02 19:00:00          19 2016-01-02 21:00:00        21  \n",
       "2 2016-01-04 19:30:00          19 2016-01-04 21:30:00        21  \n",
       "3 2016-01-06 19:30:00          19 2016-01-06 21:30:00        21  \n",
       "4 2016-01-08 19:30:00          19 2016-01-08 21:30:00        21  \n",
       "5 2016-01-11 19:30:00          19 2016-01-11 21:30:00        21  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# subset events that began after 17:00\n",
    "event_evening = event[event['Start_Hour'] >= 17.0]\n",
    "event_evening.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/Yuwen/anaconda/lib/python3.6/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>EventID</th>\n",
       "      <th>Event_type</th>\n",
       "      <th>Name</th>\n",
       "      <th>Start_Time</th>\n",
       "      <th>Start_Hour</th>\n",
       "      <th>End_Time</th>\n",
       "      <th>End_Hour</th>\n",
       "      <th>weekday</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.490000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Harlem Globetrotters</td>\n",
       "      <td>2016-01-02 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-02 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.010000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Boston Celtics</td>\n",
       "      <td>2016-01-04 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-04 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.080000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Toronto Raptors</td>\n",
       "      <td>2016-01-06 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-06 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.390000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Orlando Magic</td>\n",
       "      <td>2016-01-08 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-08 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.230000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. San Antonio Spurs</td>\n",
       "      <td>2016-01-11 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-11 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>9.200000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. New York Knicks</td>\n",
       "      <td>2016-01-13 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-13 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.110000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Portland Trail Blazers</td>\n",
       "      <td>2016-01-15 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-15 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.720000e+15</td>\n",
       "      <td>boxing</td>\n",
       "      <td>Heavyweight Championship: Deontay Wilder v. Ar...</td>\n",
       "      <td>2016-01-16 18:00:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-01-16 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.650000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Cleveland Cavaliers</td>\n",
       "      <td>2016-01-20 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-20 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.660000e+15</td>\n",
       "      <td>concert</td>\n",
       "      <td>Kygo</td>\n",
       "      <td>2016-01-21 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-01-21 23:00:00</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>8.870000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Utah Jazz</td>\n",
       "      <td>2016-01-22 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-22 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>4.640000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Oklahoma City Thunder</td>\n",
       "      <td>2016-01-24 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-24 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.070000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Miami Heat</td>\n",
       "      <td>2016-01-26 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-26 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>9.170000e+14</td>\n",
       "      <td>concert</td>\n",
       "      <td>Muse: Drones World Tour</td>\n",
       "      <td>2016-01-27 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-01-27 22:30:00</td>\n",
       "      <td>22</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4.960000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Detroit Pistons</td>\n",
       "      <td>2016-02-01 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-01 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>8.510000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Indiana Pacers</td>\n",
       "      <td>2016-02-03 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-03 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1.270000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Sacramento Kings</td>\n",
       "      <td>2016-02-05 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-05 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1.720000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Denver Nuggets</td>\n",
       "      <td>2016-02-08 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-08 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1.520000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Memphis Grizzlies</td>\n",
       "      <td>2016-02-10 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-10 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>4.980000e+14</td>\n",
       "      <td>other</td>\n",
       "      <td>Ladies Night R&amp;B Super Jam</td>\n",
       "      <td>2016-02-12 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-02-12 23:00:00</td>\n",
       "      <td>23</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>9.260000e+14</td>\n",
       "      <td>concert</td>\n",
       "      <td>Maxwell and Nas</td>\n",
       "      <td>2016-02-14 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-02-14 23:00:00</td>\n",
       "      <td>23</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4.420000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. New York Knicks</td>\n",
       "      <td>2016-02-19 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-02-19 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>7.120000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Charlotte Hornets</td>\n",
       "      <td>2016-02-21 18:00:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-02-21 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5.140000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders vs. Pittsburgh Penguins</td>\n",
       "      <td>2016-03-08 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-03-08 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1.500000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Atlantic 10 Men's Basketball Championship: Fir...</td>\n",
       "      <td>2016-03-09 18:30:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-03-09 20:30:00</td>\n",
       "      <td>20</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>4.460000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Atlantic 10 Men's Basketball Championship: Sec...</td>\n",
       "      <td>2016-03-10 18:30:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-03-10 20:30:00</td>\n",
       "      <td>20</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1.680000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Atlantic 10 Men's Basketball Championship: Qua...</td>\n",
       "      <td>2016-03-11 18:30:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-03-11 20:30:00</td>\n",
       "      <td>20</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1.650000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Milwaukee Bucks</td>\n",
       "      <td>2016-03-13 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-03-13 22:00:00</td>\n",
       "      <td>22</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1.190000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets vs. Philadelphia 76ers</td>\n",
       "      <td>2016-03-15 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-03-15 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1.860000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders vs. Philadelphia Flyers</td>\n",
       "      <td>2016-03-21 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-03-21 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>8.930000e+14</td>\n",
       "      <td>family</td>\n",
       "      <td>Disney On Ice presents Follow Your Heart</td>\n",
       "      <td>2016-11-13 17:00:00</td>\n",
       "      <td>17</td>\n",
       "      <td>2016-11-13 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>1.570000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. Tampa Bay Lightning (Bro...</td>\n",
       "      <td>2016-11-14 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-14 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>1.640000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>LIU Brooklyn Blackbirds Men's Basketball vs. L...</td>\n",
       "      <td>2016-11-16 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-16 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>1.620000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders V Pittsburgh Penguins</td>\n",
       "      <td>2016-11-18 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-18 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2.370000e+14</td>\n",
       "      <td>concert</td>\n",
       "      <td>Keith Urban - ripCORD World Tour 2016</td>\n",
       "      <td>2016-11-19 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-19 22:30:00</td>\n",
       "      <td>22</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>1.780000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Legends Classic Basketball Doubleheader</td>\n",
       "      <td>2016-11-21 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-21 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>9.390000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Boston Celtics</td>\n",
       "      <td>2016-11-23 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-23 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>5.840000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Barclays Center Classic Day 1</td>\n",
       "      <td>2016-11-25 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-25 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>2.920000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Barclays Center Classic Day 2</td>\n",
       "      <td>2016-11-26 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-26 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>5.520000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Sacramento Kings (Texting Glo...</td>\n",
       "      <td>2016-11-27 18:00:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-11-27 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>1.770000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. Calgary Flames (Rally To...</td>\n",
       "      <td>2016-11-28 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-28 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>1.020000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Los Angeles Clippers</td>\n",
       "      <td>2016-11-29 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-11-29 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>2.620000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. Pittsburgh Penguins</td>\n",
       "      <td>2016-11-30 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-11-30 22:00:00</td>\n",
       "      <td>22</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>9.550000e+14</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Milwaukee Bucks</td>\n",
       "      <td>2016-12-01 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-01 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>2.020000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. Detroit Red Wings</td>\n",
       "      <td>2016-12-04 18:00:00</td>\n",
       "      <td>18</td>\n",
       "      <td>2016-12-04 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>1.770000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Washington Wizards</td>\n",
       "      <td>2016-12-05 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-05 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>6.570000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. New York Rangers</td>\n",
       "      <td>2016-12-06 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-06 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>1.220000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Denver Nuggets (Brook Lopez S...</td>\n",
       "      <td>2016-12-07 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-07 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>1.560000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. St. Louis Blues</td>\n",
       "      <td>2016-12-08 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-08 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>1.320000e+15</td>\n",
       "      <td>family</td>\n",
       "      <td>Wcbs-Fm 101.1 Presents Holiday in Brooklyn</td>\n",
       "      <td>2016-12-09 20:00:00</td>\n",
       "      <td>20</td>\n",
       "      <td>2016-12-09 22:00:00</td>\n",
       "      <td>22</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>9.740000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders v. Washington Capitals (Sta...</td>\n",
       "      <td>2016-12-13 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-13 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>1.250000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Los Angeles Lakers</td>\n",
       "      <td>2016-12-14 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-14 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>1.230000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders V Chicago Blackhawks</td>\n",
       "      <td>2016-12-15 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-15 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>2.390000e+14</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders V Ottawa Senators (Ugly Hol...</td>\n",
       "      <td>2016-12-18 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-18 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>1.200000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>LIU Brooklyn Blackbirds Men's Basketball vs. N...</td>\n",
       "      <td>2016-12-21 17:00:00</td>\n",
       "      <td>17</td>\n",
       "      <td>2016-12-21 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>1.180000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Golden State Warriors</td>\n",
       "      <td>2016-12-22 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-22 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>1.580000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders V Buffalo Sabres</td>\n",
       "      <td>2016-12-23 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-23 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>1.190000e+15</td>\n",
       "      <td>basketball</td>\n",
       "      <td>Brooklyn Nets v. Charlotte Hornets (Winter Sca...</td>\n",
       "      <td>2016-12-26 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-26 21:30:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>1.120000e+15</td>\n",
       "      <td>hockey</td>\n",
       "      <td>New York Islanders V Washington Capitals</td>\n",
       "      <td>2016-12-27 19:00:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-27 21:00:00</td>\n",
       "      <td>21</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>9.080000e+14</td>\n",
       "      <td>boxing</td>\n",
       "      <td>WWE Live Holiday Tour</td>\n",
       "      <td>2016-12-28 19:30:00</td>\n",
       "      <td>19</td>\n",
       "      <td>2016-12-28 20:30:00</td>\n",
       "      <td>20</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>135 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          EventID  Event_type  \\\n",
       "1    1.490000e+15  basketball   \n",
       "2    2.010000e+14  basketball   \n",
       "3    1.080000e+15  basketball   \n",
       "4    1.390000e+15  basketball   \n",
       "5    1.230000e+15  basketball   \n",
       "6    9.200000e+14  basketball   \n",
       "7    1.110000e+14  basketball   \n",
       "8    1.720000e+15      boxing   \n",
       "11   1.650000e+15  basketball   \n",
       "12   1.660000e+15     concert   \n",
       "13   8.870000e+14  basketball   \n",
       "14   4.640000e+14  basketball   \n",
       "15   1.070000e+15  basketball   \n",
       "16   9.170000e+14     concert   \n",
       "17   4.960000e+14  basketball   \n",
       "18   8.510000e+14  basketball   \n",
       "19   1.270000e+15  basketball   \n",
       "20   1.720000e+15  basketball   \n",
       "21   1.520000e+15  basketball   \n",
       "22   4.980000e+14       other   \n",
       "23   9.260000e+14     concert   \n",
       "24   4.420000e+14  basketball   \n",
       "25   7.120000e+14  basketball   \n",
       "28   5.140000e+14      hockey   \n",
       "29   1.500000e+15  basketball   \n",
       "31   4.460000e+14  basketball   \n",
       "33   1.680000e+15  basketball   \n",
       "37   1.650000e+15  basketball   \n",
       "38   1.190000e+15  basketball   \n",
       "39   1.860000e+14      hockey   \n",
       "..            ...         ...   \n",
       "130  8.930000e+14      family   \n",
       "131  1.570000e+14      hockey   \n",
       "132  1.640000e+15  basketball   \n",
       "133  1.620000e+15      hockey   \n",
       "134  2.370000e+14     concert   \n",
       "136  1.780000e+14  basketball   \n",
       "140  9.390000e+14  basketball   \n",
       "143  5.840000e+14  basketball   \n",
       "145  2.920000e+14  basketball   \n",
       "147  5.520000e+14  basketball   \n",
       "148  1.770000e+15      hockey   \n",
       "149  1.020000e+15  basketball   \n",
       "150  2.620000e+14      hockey   \n",
       "151  9.550000e+14  basketball   \n",
       "152  2.020000e+14      hockey   \n",
       "153  1.770000e+15  basketball   \n",
       "154  6.570000e+14      hockey   \n",
       "155  1.220000e+15  basketball   \n",
       "156  1.560000e+15      hockey   \n",
       "157  1.320000e+15      family   \n",
       "159  9.740000e+14      hockey   \n",
       "160  1.250000e+15  basketball   \n",
       "161  1.230000e+15      hockey   \n",
       "162  2.390000e+14      hockey   \n",
       "163  1.200000e+15  basketball   \n",
       "164  1.180000e+15  basketball   \n",
       "165  1.580000e+15      hockey   \n",
       "167  1.190000e+15  basketball   \n",
       "168  1.120000e+15      hockey   \n",
       "169  9.080000e+14      boxing   \n",
       "\n",
       "                                                  Name          Start_Time  \\\n",
       "1                                 Harlem Globetrotters 2016-01-02 19:00:00   \n",
       "2                     Brooklyn Nets vs. Boston Celtics 2016-01-04 19:30:00   \n",
       "3                    Brooklyn Nets vs. Toronto Raptors 2016-01-06 19:30:00   \n",
       "4                      Brooklyn Nets vs. Orlando Magic 2016-01-08 19:30:00   \n",
       "5                  Brooklyn Nets vs. San Antonio Spurs 2016-01-11 19:30:00   \n",
       "6                    Brooklyn Nets vs. New York Knicks 2016-01-13 19:30:00   \n",
       "7             Brooklyn Nets vs. Portland Trail Blazers 2016-01-15 19:30:00   \n",
       "8    Heavyweight Championship: Deontay Wilder v. Ar... 2016-01-16 18:00:00   \n",
       "11               Brooklyn Nets vs. Cleveland Cavaliers 2016-01-20 19:30:00   \n",
       "12                                                Kygo 2016-01-21 20:00:00   \n",
       "13                         Brooklyn Nets vs. Utah Jazz 2016-01-22 19:30:00   \n",
       "14             Brooklyn Nets vs. Oklahoma City Thunder 2016-01-24 19:30:00   \n",
       "15                        Brooklyn Nets vs. Miami Heat 2016-01-26 19:30:00   \n",
       "16                             Muse: Drones World Tour 2016-01-27 19:30:00   \n",
       "17                   Brooklyn Nets vs. Detroit Pistons 2016-02-01 19:30:00   \n",
       "18                    Brooklyn Nets vs. Indiana Pacers 2016-02-03 19:30:00   \n",
       "19                  Brooklyn Nets vs. Sacramento Kings 2016-02-05 19:30:00   \n",
       "20                    Brooklyn Nets vs. Denver Nuggets 2016-02-08 19:30:00   \n",
       "21                 Brooklyn Nets vs. Memphis Grizzlies 2016-02-10 19:30:00   \n",
       "22                          Ladies Night R&B Super Jam 2016-02-12 20:00:00   \n",
       "23                                     Maxwell and Nas 2016-02-14 20:00:00   \n",
       "24                   Brooklyn Nets vs. New York Knicks 2016-02-19 19:30:00   \n",
       "25                 Brooklyn Nets vs. Charlotte Hornets 2016-02-21 18:00:00   \n",
       "28          New York Islanders vs. Pittsburgh Penguins 2016-03-08 19:30:00   \n",
       "29   Atlantic 10 Men's Basketball Championship: Fir... 2016-03-09 18:30:00   \n",
       "31   Atlantic 10 Men's Basketball Championship: Sec... 2016-03-10 18:30:00   \n",
       "33   Atlantic 10 Men's Basketball Championship: Qua... 2016-03-11 18:30:00   \n",
       "37                   Brooklyn Nets vs. Milwaukee Bucks 2016-03-13 20:00:00   \n",
       "38                Brooklyn Nets vs. Philadelphia 76ers 2016-03-15 19:30:00   \n",
       "39          New York Islanders vs. Philadelphia Flyers 2016-03-21 19:30:00   \n",
       "..                                                 ...                 ...   \n",
       "130           Disney On Ice presents Follow Your Heart 2016-11-13 17:00:00   \n",
       "131  New York Islanders v. Tampa Bay Lightning (Bro... 2016-11-14 19:00:00   \n",
       "132  LIU Brooklyn Blackbirds Men's Basketball vs. L... 2016-11-16 19:00:00   \n",
       "133           New York Islanders V Pittsburgh Penguins 2016-11-18 19:00:00   \n",
       "134              Keith Urban - ripCORD World Tour 2016 2016-11-19 19:30:00   \n",
       "136            Legends Classic Basketball Doubleheader 2016-11-21 19:00:00   \n",
       "140                    Brooklyn Nets v. Boston Celtics 2016-11-23 19:30:00   \n",
       "143                      Barclays Center Classic Day 1 2016-11-25 19:00:00   \n",
       "145                      Barclays Center Classic Day 2 2016-11-26 19:00:00   \n",
       "147  Brooklyn Nets v. Sacramento Kings (Texting Glo... 2016-11-27 18:00:00   \n",
       "148  New York Islanders v. Calgary Flames (Rally To... 2016-11-28 19:00:00   \n",
       "149              Brooklyn Nets v. Los Angeles Clippers 2016-11-29 19:30:00   \n",
       "150          New York Islanders v. Pittsburgh Penguins 2016-11-30 20:00:00   \n",
       "151                   Brooklyn Nets v. Milwaukee Bucks 2016-12-01 19:30:00   \n",
       "152            New York Islanders v. Detroit Red Wings 2016-12-04 18:00:00   \n",
       "153                Brooklyn Nets v. Washington Wizards 2016-12-05 19:30:00   \n",
       "154             New York Islanders v. New York Rangers 2016-12-06 19:00:00   \n",
       "155  Brooklyn Nets v. Denver Nuggets (Brook Lopez S... 2016-12-07 19:30:00   \n",
       "156              New York Islanders v. St. Louis Blues 2016-12-08 19:00:00   \n",
       "157         Wcbs-Fm 101.1 Presents Holiday in Brooklyn 2016-12-09 20:00:00   \n",
       "159  New York Islanders v. Washington Capitals (Sta... 2016-12-13 19:00:00   \n",
       "160                Brooklyn Nets v. Los Angeles Lakers 2016-12-14 19:30:00   \n",
       "161            New York Islanders V Chicago Blackhawks 2016-12-15 19:00:00   \n",
       "162  New York Islanders V Ottawa Senators (Ugly Hol... 2016-12-18 19:00:00   \n",
       "163  LIU Brooklyn Blackbirds Men's Basketball vs. N... 2016-12-21 17:00:00   \n",
       "164             Brooklyn Nets v. Golden State Warriors 2016-12-22 19:30:00   \n",
       "165                New York Islanders V Buffalo Sabres 2016-12-23 19:00:00   \n",
       "167  Brooklyn Nets v. Charlotte Hornets (Winter Sca... 2016-12-26 19:30:00   \n",
       "168           New York Islanders V Washington Capitals 2016-12-27 19:00:00   \n",
       "169                              WWE Live Holiday Tour 2016-12-28 19:30:00   \n",
       "\n",
       "     Start_Hour            End_Time  End_Hour  weekday  \n",
       "1            19 2016-01-02 21:00:00        21    False  \n",
       "2            19 2016-01-04 21:30:00        21     True  \n",
       "3            19 2016-01-06 21:30:00        21     True  \n",
       "4            19 2016-01-08 21:30:00        21     True  \n",
       "5            19 2016-01-11 21:30:00        21     True  \n",
       "6            19 2016-01-13 21:30:00        21     True  \n",
       "7            19 2016-01-15 21:30:00        21     True  \n",
       "8            18 2016-01-16 19:00:00        19    False  \n",
       "11           19 2016-01-20 21:30:00        21     True  \n",
       "12           20 2016-01-21 23:00:00        23     True  \n",
       "13           19 2016-01-22 21:30:00        21     True  \n",
       "14           19 2016-01-24 21:30:00        21    False  \n",
       "15           19 2016-01-26 21:30:00        21     True  \n",
       "16           19 2016-01-27 22:30:00        22     True  \n",
       "17           19 2016-02-01 21:30:00        21     True  \n",
       "18           19 2016-02-03 21:30:00        21     True  \n",
       "19           19 2016-02-05 21:30:00        21     True  \n",
       "20           19 2016-02-08 21:30:00        21     True  \n",
       "21           19 2016-02-10 21:30:00        21     True  \n",
       "22           20 2016-02-12 23:00:00        23     True  \n",
       "23           20 2016-02-14 23:00:00        23    False  \n",
       "24           19 2016-02-19 21:30:00        21     True  \n",
       "25           18 2016-02-21 20:00:00        20    False  \n",
       "28           19 2016-03-08 21:30:00        21     True  \n",
       "29           18 2016-03-09 20:30:00        20     True  \n",
       "31           18 2016-03-10 20:30:00        20     True  \n",
       "33           18 2016-03-11 20:30:00        20     True  \n",
       "37           20 2016-03-13 22:00:00        22    False  \n",
       "38           19 2016-03-15 21:30:00        21     True  \n",
       "39           19 2016-03-21 21:30:00        21     True  \n",
       "..          ...                 ...       ...      ...  \n",
       "130          17 2016-11-13 19:00:00        19    False  \n",
       "131          19 2016-11-14 21:00:00        21     True  \n",
       "132          19 2016-11-16 21:00:00        21     True  \n",
       "133          19 2016-11-18 21:00:00        21     True  \n",
       "134          19 2016-11-19 22:30:00        22    False  \n",
       "136          19 2016-11-21 21:00:00        21     True  \n",
       "140          19 2016-11-23 21:30:00        21     True  \n",
       "143          19 2016-11-25 21:00:00        21     True  \n",
       "145          19 2016-11-26 21:00:00        21    False  \n",
       "147          18 2016-11-27 20:00:00        20    False  \n",
       "148          19 2016-11-28 21:00:00        21     True  \n",
       "149          19 2016-11-29 21:30:00        21     True  \n",
       "150          20 2016-11-30 22:00:00        22     True  \n",
       "151          19 2016-12-01 21:30:00        21     True  \n",
       "152          18 2016-12-04 20:00:00        20    False  \n",
       "153          19 2016-12-05 21:30:00        21     True  \n",
       "154          19 2016-12-06 21:00:00        21     True  \n",
       "155          19 2016-12-07 21:30:00        21     True  \n",
       "156          19 2016-12-08 21:00:00        21     True  \n",
       "157          20 2016-12-09 22:00:00        22     True  \n",
       "159          19 2016-12-13 21:00:00        21     True  \n",
       "160          19 2016-12-14 21:30:00        21     True  \n",
       "161          19 2016-12-15 21:00:00        21     True  \n",
       "162          19 2016-12-18 21:00:00        21    False  \n",
       "163          17 2016-12-21 19:00:00        19     True  \n",
       "164          19 2016-12-22 21:30:00        21     True  \n",
       "165          19 2016-12-23 21:00:00        21     True  \n",
       "167          19 2016-12-26 21:30:00        21     True  \n",
       "168          19 2016-12-27 21:00:00        21     True  \n",
       "169          19 2016-12-28 20:30:00        20     True  \n",
       "\n",
       "[135 rows x 8 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# create a dummy indicator for weekday\n",
    "event_evening['weekday'] = [i not in [5,6] for i in event_evening['Start_Time'].dt.weekday.values]\n",
    "event_evening"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "event_evening.to_csv('events_2016_subset.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}