In [49]:
%matplotlib inline
In [50]:
from matplotlib import pyplot as plt
In [4]:
import sqlalchemy
import pandas as pd
import os.path
In [47]:
from IPython.core.display import display, HTML
In [5]:
engine = sqlalchemy.create_engine(open(os.path.expanduser('~/.sqlconninfo')).read())
In [78]:
z = pd.read_sql('select count(*) from subway_ingest;', engine)
z
Out[78]:
count
0
75006861
In [ ]:
z = pd.read_sql('select ca, unit, scp, station, linename from subway_ingest;', engine)
In [84]:
z
Out[84]:
ca
0
R229
1
R229
2
R229
3
R229
4
R229
5
R229
6
R229
7
R229
8
R229
9
R229
10
R229
11
R229
12
R229
13
R229
14
R229
15
R229
16
R229
17
R229
18
R229
19
R229
20
R229
21
R229
22
R229
23
R229
24
R229
25
R229
26
R229
27
R229
28
R229
29
R229
...
...
75006831
R229
75006832
R229
75006833
R229
75006834
R229
75006835
R229
75006836
R229
75006837
R229
75006838
R229
75006839
R229
75006840
R229
75006841
R229
75006842
R229
75006843
R229
75006844
R229
75006845
R229
75006846
R229
75006847
R229
75006848
R229
75006849
R229
75006850
R229
75006851
R229
75006852
R229
75006853
R229
75006854
R229
75006855
R229
75006856
R229
75006857
R229
75006858
R229
75006859
R229
75006860
R229
75006861 rows × 1 columns
In [39]:
z2 = pd.read_sql("select * from subway_ingest where ca='N062' and unit='R011' and scp='01-03-00' ORDER BY endtime;", engine)
In [40]:
z3 = z2[1:].copy()
In [41]:
z3.cumul_entries = z2.cumul_entries.values[1:] - z2.cumul_entries.values[:-1]
In [42]:
z3.cumul_exits = z2.cumul_exits.values[1:] - z2.cumul_exits.values[:-1]
In [53]:
z4 = z3['endtime cumul_entries cumul_exits'.split()].groupby('endtime').sum()
In [73]:
plt.plot(z4.index.values, z4.cumul_entries.values
)
plt.plot(z4.index.values, z4.cumul_exits.values
)
# plt.ylim(0, 700)
plt.xlim('2010-04-01', '2010-06-01')
plt.gcf().set_size_inches(11, 4)
In [76]:
z3.endtime.dtype
Out[76]:
dtype('<M8[ns]')
In [48]:
display(HTML(z3.head(200).to_html()))
turnstile_id
endtime
ca
unit
scp
station
linename
division
description
cumul_entries
cumul_exits
1
50620
2010-04-17 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
35
6
2
50621
2010-04-17 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
26
18
3
50622
2010-04-17 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
143
74
4
50623
2010-04-17 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
208
104
5
50624
2010-04-17 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
230
142
6
50625
2010-04-18 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
176
103
7
50626
2010-04-18 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
39
7
8
50627
2010-04-18 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
22
11
9
50628
2010-04-18 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
109
69
10
50629
2010-04-18 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
214
136
11
50630
2010-04-18 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
246
148
12
50631
2010-04-19 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
199
55
13
50632
2010-04-19 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
18
1
14
50633
2010-04-19 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
273
38
15
50634
2010-04-19 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
620
84
16
50635
2010-04-19 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
214
122
17
50636
2010-04-19 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
369
294
18
50637
2010-04-20 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
124
41
19
50638
2010-04-20 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
14
6
20
50639
2010-04-20 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
0
0
21
50640
2010-04-20 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
AUD
280
20
22
50641
2010-04-20 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
563
85
23
50642
2010-04-20 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
200
108
24
50643
2010-04-20 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
323
305
25
50644
2010-04-21 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
131
65
26
50645
2010-04-21 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
7
4
27
50646
2010-04-21 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
289
22
28
50647
2010-04-21 08:17:06
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
69
7
29
50648
2010-04-21 09:14:43
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
272
15
30
50649
2010-04-21 09:16:12
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
5
0
31
50650
2010-04-21 09:17:33
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
10
0
32
50651
2010-04-21 09:18:53
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
5
0
33
50652
2010-04-21 09:30:54
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
35
4
34
50653
2010-04-21 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
192
45
35
50654
2010-04-21 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
216
94
36
50655
2010-04-21 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
351
330
37
50656
2010-04-22 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
131
62
38
50657
2010-04-22 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
7
5
39
50658
2010-04-22 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
0
0
40
50659
2010-04-22 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
273
30
41
50660
2010-04-22 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
569
82
42
50661
2010-04-22 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
246
114
43
50662
2010-04-22 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
332
288
44
50663
2010-04-23 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
120
111
45
50664
2010-04-23 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
13
7
46
50665
2010-04-23 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
268
25
47
50666
2010-04-23 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
506
88
48
50667
2010-04-23 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
227
144
49
50668
2010-04-23 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
405
343
50
290327
2010-05-01 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
9998
4154
51
290328
2010-05-01 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
26
13
52
290329
2010-05-01 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
31
18
53
290330
2010-05-01 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
119
101
54
290331
2010-05-01 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
205
159
55
290332
2010-05-01 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
236
202
56
290333
2010-05-02 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
268
161
57
290334
2010-05-02 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
31
12
58
290335
2010-05-02 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
19
9
59
290336
2010-05-02 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
108
57
60
290337
2010-05-02 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
191
116
61
290338
2010-05-02 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
238
109
62
290339
2010-05-03 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
201
69
63
290340
2010-05-03 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
20
7
64
290341
2010-05-03 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
372
36
65
290342
2010-05-03 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
779
109
66
290343
2010-05-03 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
226
119
67
290344
2010-05-03 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
327
268
68
290345
2010-05-04 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
135
57
69
290346
2010-05-04 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
8
5
70
290347
2010-05-04 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
292
27
71
290348
2010-05-04 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
569
93
72
290349
2010-05-04 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
256
98
73
290350
2010-05-04 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
257
281
74
290351
2010-05-05 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
133
72
75
290352
2010-05-05 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
11
0
76
290353
2010-05-05 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
0
0
77
290354
2010-05-05 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
AUD
310
21
78
290355
2010-05-05 10:29:01
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
563
54
79
290356
2010-05-05 10:29:09
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
0
0
80
290357
2010-05-05 10:30:12
N062
R011
01-03-00
NULL
NULL
NULL
OPEN
0
0
81
290358
2010-05-05 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
79
39
82
290359
2010-05-05 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
194
102
83
290360
2010-05-05 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
297
248
84
290361
2010-05-06 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
133
73
85
290362
2010-05-06 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
10
3
86
290363
2010-05-06 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
256
22
87
290364
2010-05-06 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
578
85
88
290365
2010-05-06 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
227
80
89
290366
2010-05-06 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
335
286
90
290367
2010-05-07 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
153
103
91
290368
2010-05-07 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
5
5
92
290369
2010-05-07 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
251
21
93
290370
2010-05-07 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
481
91
94
290371
2010-05-07 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
233
134
95
290372
2010-05-07 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
368
423
96
499482
2010-05-08 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
241
130
97
499483
2010-05-08 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
53
10
98
499484
2010-05-08 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
48
27
99
499485
2010-05-08 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
162
170
100
499486
2010-05-08 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
189
157
101
499487
2010-05-08 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
212
151
102
499488
2010-05-09 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
188
109
103
499489
2010-05-09 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
29
17
104
499490
2010-05-09 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
25
9
105
499491
2010-05-09 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
102
59
106
499492
2010-05-09 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
149
110
107
499493
2010-05-09 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
239
119
108
499494
2010-05-10 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
287
83
109
499495
2010-05-10 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
14
5
110
499496
2010-05-10 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
338
50
111
499497
2010-05-10 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
655
119
112
499498
2010-05-10 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
259
120
113
499499
2010-05-10 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
341
311
114
499500
2010-05-11 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
139
66
115
499501
2010-05-11 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
5
2
116
499502
2010-05-11 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
0
0
117
499503
2010-05-11 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
AUD
319
31
118
499504
2010-05-11 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
571
85
119
499505
2010-05-11 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
207
130
120
499506
2010-05-11 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
382
311
121
499507
2010-05-12 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
146
78
122
499508
2010-05-12 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
11
4
123
499509
2010-05-12 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
283
47
124
499510
2010-05-12 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
867
120
125
499511
2010-05-12 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
255
143
126
499512
2010-05-12 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
352
304
127
499513
2010-05-13 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
146
75
128
499514
2010-05-13 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
3
5
129
499515
2010-05-13 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
281
31
130
499516
2010-05-13 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
577
102
131
499517
2010-05-13 12:04:29
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
5
0
132
499518
2010-05-13 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
OPEN
227
97
133
499519
2010-05-13 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
374
295
134
499520
2010-05-14 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
172
111
135
499521
2010-05-14 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
6
3
136
499522
2010-05-14 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
0
0
137
499523
2010-05-14 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
AUD
225
29
138
499524
2010-05-14 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
490
124
139
499525
2010-05-14 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
231
140
140
499526
2010-05-14 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
409
350
141
713696
2010-05-22 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
10239
4595
142
713697
2010-05-22 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
21
15
143
713698
2010-05-22 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
38
12
144
713699
2010-05-22 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
138
105
145
713700
2010-05-22 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
222
185
146
713701
2010-05-22 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
213
159
147
713702
2010-05-23 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
237
105
148
713703
2010-05-23 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
31
18
149
713704
2010-05-23 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
14
8
150
713705
2010-05-23 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
RECOVR
93
63
151
713706
2010-05-23 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
AUD
193
115
152
713707
2010-05-23 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
274
168
153
713708
2010-05-24 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
197
92
154
713709
2010-05-24 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
16
5
155
713710
2010-05-24 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
314
34
156
713711
2010-05-24 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
669
114
157
713712
2010-05-24 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
258
138
158
713713
2010-05-24 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
377
294
159
713714
2010-05-25 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
163
88
160
713715
2010-05-25 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
14
3
161
713716
2010-05-25 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
279
32
162
713717
2010-05-25 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
562
108
163
713718
2010-05-25 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
270
98
164
713719
2010-05-25 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
399
309
165
713720
2010-05-26 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
176
79
166
713721
2010-05-26 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
11
4
167
713722
2010-05-26 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
228
28
168
713723
2010-05-26 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
650
119
169
713724
2010-05-26 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
277
134
170
713725
2010-05-26 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
403
289
171
713726
2010-05-27 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
181
106
172
713727
2010-05-27 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
9
3
173
713728
2010-05-27 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
259
24
174
713729
2010-05-27 09:02:48
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
277
39
175
713730
2010-05-27 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
280
61
176
713731
2010-05-27 12:08:32
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
10
3
177
713732
2010-05-27 12:08:38
N062
R011
01-03-00
NULL
NULL
NULL
OPEN
0
0
178
713733
2010-05-27 12:08:50
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
0
0
179
713734
2010-05-27 12:09:31
N062
R011
01-03-00
NULL
NULL
NULL
OPEN
0
0
180
713735
2010-05-27 12:11:12
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
0
0
181
713736
2010-05-27 12:11:15
N062
R011
01-03-00
NULL
NULL
NULL
DOOR
0
0
182
713737
2010-05-27 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
OPEN
212
120
183
713738
2010-05-27 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
423
331
184
713739
2010-05-28 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
118
100
185
713740
2010-05-28 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
21
5
186
713741
2010-05-28 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
233
25
187
713742
2010-05-28 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
433
133
188
713743
2010-05-28 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
307
207
189
713744
2010-05-28 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
358
366
190
928202
2010-05-29 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
243
173
191
928203
2010-05-29 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
31
19
192
928204
2010-05-29 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
25
29
193
928205
2010-05-29 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
140
146
194
928206
2010-05-29 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
205
210
195
928207
2010-05-29 20:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
317
227
196
928208
2010-05-30 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
249
132
197
928209
2010-05-30 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
22
10
198
928210
2010-05-30 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
27
20
199
928211
2010-05-30 12:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
123
116
200
928212
2010-05-30 16:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
203
174
In [38]:
z2
Out[38]:
turnstile_id
endtime
ca
unit
scp
station
linename
division
description
cumul_entries
cumul_exits
0
50466
2010-04-17 00:00:00
N062
R011
01-00-00
NULL
NULL
NULL
REGULAR
6001528
26135188
1
50619
2010-04-17 00:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
6766725
3846177
2
50769
2010-04-17 00:00:00
N062
R011
01-03-03
NULL
NULL
NULL
REGULAR
4571499
5790326
3
50819
2010-04-17 00:00:00
N062
R011
01-03-04
NULL
NULL
NULL
REGULAR
8208958
13612511
4
50517
2010-04-17 00:00:00
N062
R011
01-00-01
NULL
NULL
NULL
REGULAR
5405443
7757147
5
50568
2010-04-17 00:00:00
N062
R011
01-00-02
NULL
NULL
NULL
REGULAR
444993
338112
6
50669
2010-04-17 00:00:00
N062
R011
01-03-01
NULL
NULL
NULL
REGULAR
9444698
4628935
7
50869
2010-04-17 00:00:00
N062
R011
01-05-00
NULL
NULL
NULL
REGULAR
404
0
8
50719
2010-04-17 00:00:00
N062
R011
01-03-02
NULL
NULL
NULL
REGULAR
9150343
7293811
9
50918
2010-04-17 00:00:00
N062
R011
01-05-01
NULL
NULL
NULL
REGULAR
0
164
10
50467
2010-04-17 04:00:00
N062
R011
01-00-00
NULL
NULL
NULL
REGULAR
6001584
26135243
11
50620
2010-04-17 04:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
6766760
3846183
12
50770
2010-04-17 04:00:00
N062
R011
01-03-03
NULL
NULL
NULL
REGULAR
4571525
5790357
13
50820
2010-04-17 04:00:00
N062
R011
01-03-04
NULL
NULL
NULL
REGULAR
8208973
13612563
14
50468
2010-04-17 04:00:00
N062
R011
01-00-00
NULL
NULL
NULL
RECOVR
6001584
26135243
15
50870
2010-04-17 04:00:00
N062
R011
01-05-00
NULL
NULL
NULL
REGULAR
404
0
16
50670
2010-04-17 04:00:00
N062
R011
01-03-01
NULL
NULL
NULL
REGULAR
9444725
4628952
17
50518
2010-04-17 04:00:00
N062
R011
01-00-01
NULL
NULL
NULL
RECOVR
5405478
7757182
18
50569
2010-04-17 04:00:00
N062
R011
01-00-02
NULL
NULL
NULL
REGULAR
445022
338138
19
50570
2010-04-17 04:00:00
N062
R011
01-00-02
NULL
NULL
NULL
RECOVR
445022
338138
20
50519
2010-04-17 04:00:00
N062
R011
01-00-01
NULL
NULL
NULL
AUD
5405478
7757182
21
50919
2010-04-17 04:00:00
N062
R011
01-05-01
NULL
NULL
NULL
REGULAR
0
164
22
50720
2010-04-17 04:00:00
N062
R011
01-03-02
NULL
NULL
NULL
REGULAR
9150370
7293828
23
50721
2010-04-17 08:00:00
N062
R011
01-03-02
NULL
NULL
NULL
REGULAR
9150432
7293853
24
50469
2010-04-17 08:00:00
N062
R011
01-00-00
NULL
NULL
NULL
AUD
6001662
26135417
25
50771
2010-04-17 08:00:00
N062
R011
01-03-03
NULL
NULL
NULL
REGULAR
4571573
5790414
26
50621
2010-04-17 08:00:00
N062
R011
01-03-00
NULL
NULL
NULL
REGULAR
6766786
3846201
27
50821
2010-04-17 08:00:00
N062
R011
01-03-04
NULL
NULL
NULL
REGULAR
8209019
13612637
28
50871
2010-04-17 08:00:00
N062
R011
01-05-00
NULL
NULL
NULL
REGULAR
404
0
29
50671
2010-04-17 08:00:00
N062
R011
01-03-01
NULL
NULL
NULL
REGULAR
9444767
4628968
...
...
...
...
...
...
...
...
...
...
...
...
163854
74858154
2017-04-14 12:00:00
N062
R011
01-03-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10398983
5536196
163855
74858070
2017-04-14 12:00:00
N062
R011
01-00-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
2032119815
1691969692
163856
74858112
2017-04-14 12:00:00
N062
R011
01-00-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
4136673
3039303
163857
74858406
2017-04-14 12:00:00
N062
R011
01-05-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
0
921
163858
74858028
2017-04-14 12:00:00
N062
R011
01-00-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10517661
36488767
163859
74858238
2017-04-14 12:00:00
N062
R011
01-03-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13576767
9504026
163860
74858322
2017-04-14 12:00:00
N062
R011
01-03-04
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
12483248
19254001
163861
74858196
2017-04-14 12:00:00
N062
R011
01-03-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13749129
6118249
163862
74858364
2017-04-14 12:00:00
N062
R011
01-05-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
100665861
0
163863
74858280
2017-04-14 12:00:00
N062
R011
01-03-03
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
3475695
3175792
163864
74858113
2017-04-14 16:00:00
N062
R011
01-00-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
4136946
3039658
163865
74858071
2017-04-14 16:00:00
N062
R011
01-00-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
2032120173
1691969072
163866
74858239
2017-04-14 16:00:00
N062
R011
01-03-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13577068
9504292
163867
74858029
2017-04-14 16:00:00
N062
R011
01-00-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10518011
36489976
163868
74858197
2017-04-14 16:00:00
N062
R011
01-03-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13749433
6118443
163869
74858155
2017-04-14 16:00:00
N062
R011
01-03-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10399267
5536454
163870
74858281
2017-04-14 16:00:00
N062
R011
01-03-03
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
3475966
3176195
163871
74858407
2017-04-14 16:00:00
N062
R011
01-05-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
0
921
163872
74858365
2017-04-14 16:00:00
N062
R011
01-05-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
100665861
0
163873
74858323
2017-04-14 16:00:00
N062
R011
01-03-04
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
12483447
19254631
163874
74858156
2017-04-14 20:00:00
N062
R011
01-03-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10399624
5536893
163875
74858198
2017-04-14 20:00:00
N062
R011
01-03-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13749825
6118743
163876
74858282
2017-04-14 20:00:00
N062
R011
01-03-03
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
3476324
3176873
163877
74858366
2017-04-14 20:00:00
N062
R011
01-05-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
100665861
0
163878
74858072
2017-04-14 20:00:00
N062
R011
01-00-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
2032120508
1691967814
163879
74858114
2017-04-14 20:00:00
N062
R011
01-00-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
4137311
3040353
163880
74858408
2017-04-14 20:00:00
N062
R011
01-05-01
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
0
921
163881
74858240
2017-04-14 20:00:00
N062
R011
01-03-02
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
13577470
9504660
163882
74858030
2017-04-14 20:00:00
N062
R011
01-00-00
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
10518384
36491873
163883
74858324
2017-04-14 20:00:00
N062
R011
01-03-04
42 ST-PORT AUTH
ACENQRS1237W
IND
REGULAR
12483702
19255474
163884 rows × 11 columns
In [ ]:
Content source: r-shekhar/NYC-transport
Similar notebooks: