{ "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", "