{ "cells": [ { "cell_type": "code", "execution_count": 49, "metadata": { "collapsed": true }, "outputs": [], "source": [ "%matplotlib inline" ] }, { "cell_type": "code", "execution_count": 50, "metadata": { "collapsed": true }, "outputs": [], "source": [ "from matplotlib import pyplot as plt" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": true }, "outputs": [], "source": [ "import sqlalchemy\n", "import pandas as pd\n", "\n", "import os.path" ] }, { "cell_type": "code", "execution_count": 47, "metadata": { "collapsed": false }, "outputs": [], "source": [ "from IPython.core.display import display, HTML" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [], "source": [ "engine = sqlalchemy.create_engine(open(os.path.expanduser('~/.sqlconninfo')).read())" ] }, { "cell_type": "code", "execution_count": 78, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
| \n", " | count | \n", "
|---|---|
| 0 | \n", "75006861 | \n", "
| \n", " | ca | \n", "
|---|---|
| 0 | \n", "R229 | \n", "
| 1 | \n", "R229 | \n", "
| 2 | \n", "R229 | \n", "
| 3 | \n", "R229 | \n", "
| 4 | \n", "R229 | \n", "
| 5 | \n", "R229 | \n", "
| 6 | \n", "R229 | \n", "
| 7 | \n", "R229 | \n", "
| 8 | \n", "R229 | \n", "
| 9 | \n", "R229 | \n", "
| 10 | \n", "R229 | \n", "
| 11 | \n", "R229 | \n", "
| 12 | \n", "R229 | \n", "
| 13 | \n", "R229 | \n", "
| 14 | \n", "R229 | \n", "
| 15 | \n", "R229 | \n", "
| 16 | \n", "R229 | \n", "
| 17 | \n", "R229 | \n", "
| 18 | \n", "R229 | \n", "
| 19 | \n", "R229 | \n", "
| 20 | \n", "R229 | \n", "
| 21 | \n", "R229 | \n", "
| 22 | \n", "R229 | \n", "
| 23 | \n", "R229 | \n", "
| 24 | \n", "R229 | \n", "
| 25 | \n", "R229 | \n", "
| 26 | \n", "R229 | \n", "
| 27 | \n", "R229 | \n", "
| 28 | \n", "R229 | \n", "
| 29 | \n", "R229 | \n", "
| ... | \n", "... | \n", "
| 75006831 | \n", "R229 | \n", "
| 75006832 | \n", "R229 | \n", "
| 75006833 | \n", "R229 | \n", "
| 75006834 | \n", "R229 | \n", "
| 75006835 | \n", "R229 | \n", "
| 75006836 | \n", "R229 | \n", "
| 75006837 | \n", "R229 | \n", "
| 75006838 | \n", "R229 | \n", "
| 75006839 | \n", "R229 | \n", "
| 75006840 | \n", "R229 | \n", "
| 75006841 | \n", "R229 | \n", "
| 75006842 | \n", "R229 | \n", "
| 75006843 | \n", "R229 | \n", "
| 75006844 | \n", "R229 | \n", "
| 75006845 | \n", "R229 | \n", "
| 75006846 | \n", "R229 | \n", "
| 75006847 | \n", "R229 | \n", "
| 75006848 | \n", "R229 | \n", "
| 75006849 | \n", "R229 | \n", "
| 75006850 | \n", "R229 | \n", "
| 75006851 | \n", "R229 | \n", "
| 75006852 | \n", "R229 | \n", "
| 75006853 | \n", "R229 | \n", "
| 75006854 | \n", "R229 | \n", "
| 75006855 | \n", "R229 | \n", "
| 75006856 | \n", "R229 | \n", "
| 75006857 | \n", "R229 | \n", "
| 75006858 | \n", "R229 | \n", "
| 75006859 | \n", "R229 | \n", "
| 75006860 | \n", "R229 | \n", "
75006861 rows × 1 columns
\n", "| \n", " | turnstile_id | \n", "endtime | \n", "ca | \n", "unit | \n", "scp | \n", "station | \n", "linename | \n", "division | \n", "description | \n", "cumul_entries | \n", "cumul_exits | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "50466 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "6001528 | \n", "26135188 | \n", "
| 1 | \n", "50619 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "6766725 | \n", "3846177 | \n", "
| 2 | \n", "50769 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "4571499 | \n", "5790326 | \n", "
| 3 | \n", "50819 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "8208958 | \n", "13612511 | \n", "
| 4 | \n", "50517 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "5405443 | \n", "7757147 | \n", "
| 5 | \n", "50568 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "444993 | \n", "338112 | \n", "
| 6 | \n", "50669 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9444698 | \n", "4628935 | \n", "
| 7 | \n", "50869 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "404 | \n", "0 | \n", "
| 8 | \n", "50719 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9150343 | \n", "7293811 | \n", "
| 9 | \n", "50918 | \n", "2010-04-17 00:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "0 | \n", "164 | \n", "
| 10 | \n", "50467 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "6001584 | \n", "26135243 | \n", "
| 11 | \n", "50620 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "6766760 | \n", "3846183 | \n", "
| 12 | \n", "50770 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "4571525 | \n", "5790357 | \n", "
| 13 | \n", "50820 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "8208973 | \n", "13612563 | \n", "
| 14 | \n", "50468 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "RECOVR | \n", "6001584 | \n", "26135243 | \n", "
| 15 | \n", "50870 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "404 | \n", "0 | \n", "
| 16 | \n", "50670 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9444725 | \n", "4628952 | \n", "
| 17 | \n", "50518 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "RECOVR | \n", "5405478 | \n", "7757182 | \n", "
| 18 | \n", "50569 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "445022 | \n", "338138 | \n", "
| 19 | \n", "50570 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "RECOVR | \n", "445022 | \n", "338138 | \n", "
| 20 | \n", "50519 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "AUD | \n", "5405478 | \n", "7757182 | \n", "
| 21 | \n", "50919 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "0 | \n", "164 | \n", "
| 22 | \n", "50720 | \n", "2010-04-17 04:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9150370 | \n", "7293828 | \n", "
| 23 | \n", "50721 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9150432 | \n", "7293853 | \n", "
| 24 | \n", "50469 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "AUD | \n", "6001662 | \n", "26135417 | \n", "
| 25 | \n", "50771 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "4571573 | \n", "5790414 | \n", "
| 26 | \n", "50621 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "6766786 | \n", "3846201 | \n", "
| 27 | \n", "50821 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "8209019 | \n", "13612637 | \n", "
| 28 | \n", "50871 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "404 | \n", "0 | \n", "
| 29 | \n", "50671 | \n", "2010-04-17 08:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "NULL | \n", "NULL | \n", "NULL | \n", "REGULAR | \n", "9444767 | \n", "4628968 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 163854 | \n", "74858154 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10398983 | \n", "5536196 | \n", "
| 163855 | \n", "74858070 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "2032119815 | \n", "1691969692 | \n", "
| 163856 | \n", "74858112 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "4136673 | \n", "3039303 | \n", "
| 163857 | \n", "74858406 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "0 | \n", "921 | \n", "
| 163858 | \n", "74858028 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10517661 | \n", "36488767 | \n", "
| 163859 | \n", "74858238 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13576767 | \n", "9504026 | \n", "
| 163860 | \n", "74858322 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "12483248 | \n", "19254001 | \n", "
| 163861 | \n", "74858196 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13749129 | \n", "6118249 | \n", "
| 163862 | \n", "74858364 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "100665861 | \n", "0 | \n", "
| 163863 | \n", "74858280 | \n", "2017-04-14 12:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "3475695 | \n", "3175792 | \n", "
| 163864 | \n", "74858113 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "4136946 | \n", "3039658 | \n", "
| 163865 | \n", "74858071 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "2032120173 | \n", "1691969072 | \n", "
| 163866 | \n", "74858239 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13577068 | \n", "9504292 | \n", "
| 163867 | \n", "74858029 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10518011 | \n", "36489976 | \n", "
| 163868 | \n", "74858197 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13749433 | \n", "6118443 | \n", "
| 163869 | \n", "74858155 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10399267 | \n", "5536454 | \n", "
| 163870 | \n", "74858281 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "3475966 | \n", "3176195 | \n", "
| 163871 | \n", "74858407 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "0 | \n", "921 | \n", "
| 163872 | \n", "74858365 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "100665861 | \n", "0 | \n", "
| 163873 | \n", "74858323 | \n", "2017-04-14 16:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "12483447 | \n", "19254631 | \n", "
| 163874 | \n", "74858156 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10399624 | \n", "5536893 | \n", "
| 163875 | \n", "74858198 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13749825 | \n", "6118743 | \n", "
| 163876 | \n", "74858282 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-03 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "3476324 | \n", "3176873 | \n", "
| 163877 | \n", "74858366 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "100665861 | \n", "0 | \n", "
| 163878 | \n", "74858072 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "2032120508 | \n", "1691967814 | \n", "
| 163879 | \n", "74858114 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "4137311 | \n", "3040353 | \n", "
| 163880 | \n", "74858408 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-05-01 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "0 | \n", "921 | \n", "
| 163881 | \n", "74858240 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-02 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "13577470 | \n", "9504660 | \n", "
| 163882 | \n", "74858030 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-00-00 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "10518384 | \n", "36491873 | \n", "
| 163883 | \n", "74858324 | \n", "2017-04-14 20:00:00 | \n", "N062 | \n", "R011 | \n", "01-03-04 | \n", "42 ST-PORT AUTH | \n", "ACENQRS1237W | \n", "IND | \n", "REGULAR | \n", "12483702 | \n", "19255474 | \n", "
163884 rows × 11 columns
\n", "