{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib inline\n", "import matplotlib.pyplot as plt\n", "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns; sns.set()" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "trips = pd.read_csv('2015_trip_data.csv',\n", " parse_dates=['starttime', 'stoptime'],\n", " infer_datetime_format=True)" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [], "source": [ "ind = pd.DatetimeIndex(trips.starttime)\n", "trips['date'] = ind.date.astype('datetime64')\n", "trips['hour'] = ind.hour" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | hour | \n", "0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "7 | \n", "8 | \n", "9 | \n", "... | \n", "14 | \n", "15 | \n", "16 | \n", "17 | \n", "18 | \n", "19 | \n", "20 | \n", "21 | \n", "22 | \n", "23 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
usertype | \n", "date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Annual Member | \n", "2014-10-13 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "... | \n", "32 | \n", "23 | \n", "23 | \n", "28 | \n", "21 | \n", "8 | \n", "11 | \n", "9 | \n", "3 | \n", "1 | \n", "
2014-10-14 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "4 | \n", "16 | \n", "28 | \n", "13 | \n", "... | \n", "13 | \n", "16 | \n", "19 | \n", "28 | \n", "25 | \n", "14 | \n", "8 | \n", "10 | \n", "1 | \n", "2 | \n", "|
2014-10-15 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "5 | \n", "7 | \n", "11 | \n", "16 | \n", "... | \n", "7 | \n", "10 | \n", "32 | \n", "33 | \n", "15 | \n", "15 | \n", "9 | \n", "9 | \n", "2 | \n", "1 | \n", "|
2014-10-16 | \n", "2 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "2 | \n", "6 | \n", "8 | \n", "27 | \n", "19 | \n", "... | \n", "8 | \n", "10 | \n", "27 | \n", "40 | \n", "20 | \n", "17 | \n", "6 | \n", "6 | \n", "3 | \n", "4 | \n", "|
2014-10-17 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "4 | \n", "13 | \n", "20 | \n", "19 | \n", "... | \n", "3 | \n", "5 | \n", "17 | \n", "17 | \n", "20 | \n", "10 | \n", "5 | \n", "10 | \n", "2 | \n", "1 | \n", "
5 rows × 24 columns
\n", "hour | \n", "usertype | \n", "projection1 | \n", "projection2 | \n", "
---|---|---|---|
date | \n", "\n", " | \n", " | \n", " |
2014-10-13 | \n", "Annual Member | \n", "11.801941 | \n", "-47.055049 | \n", "
2014-11-27 | \n", "Annual Member | \n", "-39.257659 | \n", "8.284703 | \n", "
2014-11-28 | \n", "Annual Member | \n", "-37.617643 | \n", "12.843594 | \n", "
2014-12-23 | \n", "Annual Member | \n", "-21.424691 | \n", "9.384624 | \n", "
2014-12-24 | \n", "Annual Member | \n", "-22.459886 | \n", "4.800410 | \n", "
2014-12-25 | \n", "Annual Member | \n", "-43.631130 | \n", "10.346482 | \n", "
2014-12-26 | \n", "Annual Member | \n", "-27.541947 | \n", "4.615430 | \n", "
2014-12-31 | \n", "Annual Member | \n", "-24.510922 | \n", "10.280756 | \n", "
2015-01-01 | \n", "Annual Member | \n", "-36.385406 | \n", "4.758340 | \n", "
2015-01-02 | \n", "Annual Member | \n", "-17.244472 | \n", "7.139373 | \n", "
2015-05-25 | \n", "Annual Member | \n", "-21.178644 | \n", "-4.670879 | \n", "
2015-07-03 | \n", "Annual Member | \n", "-5.304581 | \n", "-3.541451 | \n", "
2015-09-07 | \n", "Annual Member | \n", "-20.792607 | \n", "0.447123 | \n", "