In [1]:
import pandas as pd
import numpy as np
import requests as req
import json
import csv
from datetime import datetime
import matplotlib.pyplot as plt
from scipy.misc import imread
import matplotlib.cbook as cbook
In [2]:
raw = pd.read_csv("outp.csv", names=["Linha", "Prefixo", "Latitude", "Longitude", "Rota", "Timestamp"])
raw["Timestamp"] = raw["Timestamp"] / 1000
In [3]:
raw["Timestamp"] = raw["Timestamp"].apply(datetime.fromtimestamp)
In [4]:
raw[raw.Linha == '297']
Out[4]:
Linha
Prefixo
Latitude
Longitude
Rota
Timestamp
4644
297
12021
-23.675739
-47.014908
volta
2016-03-28 18:15:34
4645
297
12023
-23.595232
-46.874828
ida
2016-03-28 18:15:35
4646
297
12018
-23.597254
-46.858765
volta
2016-03-28 18:14:03
4647
297
12099
-23.572042
-46.709078
volta
2016-03-28 18:15:10
4648
297
12021
-23.675739
-47.014908
volta
2016-03-28 18:15:34
4649
297
12023
-23.595232
-46.874828
ida
2016-03-28 18:15:35
4650
297
12018
-23.597254
-46.858765
volta
2016-03-28 18:14:03
4651
297
12099
-23.572042
-46.709078
volta
2016-03-28 18:15:10
4652
297
12021
-23.675739
-47.014908
volta
2016-03-28 18:15:34
4653
297
12023
-23.595232
-46.874828
ida
2016-03-28 18:15:35
4654
297
12018
-23.597254
-46.858765
volta
2016-03-28 18:14:03
4655
297
12099
-23.572042
-46.709078
volta
2016-03-28 18:15:10
4656
297
12021
-23.675739
-47.014908
volta
2016-03-28 18:15:34
4657
297
12023
-23.595232
-46.874828
ida
2016-03-28 18:15:35
4658
297
12018
-23.597254
-46.858765
volta
2016-03-28 18:14:03
4659
297
12099
-23.572042
-46.709078
volta
2016-03-28 18:15:10
4660
297
12021
-23.675739
-47.014908
volta
2016-03-28 18:15:34
4661
297
12023
-23.595232
-46.874828
ida
2016-03-28 18:15:35
4662
297
12018
-23.597254
-46.858765
volta
2016-03-28 18:14:03
4663
297
12099
-23.572042
-46.709078
volta
2016-03-28 18:15:10
7390
297
2043
-23.684745
-47.021805
volta
2016-03-28 18:09:03.887000
7391
297
12021
-23.684839
-47.021794
volta
2016-03-28 18:18:48
7392
297
12023
-23.595587
-46.868980
ida
2016-03-28 18:18:28
7393
297
12018
-23.597815
-46.881210
volta
2016-03-28 18:18:35
7394
297
12099
-23.573162
-46.712193
volta
2016-03-28 18:18:04
12830
297
12021
-23.687283
-47.020528
volta
2016-03-28 18:20:45
12831
297
12023
-23.595587
-46.868980
ida
2016-03-28 18:18:55
12832
297
12018
-23.600040
-46.902088
volta
2016-03-28 18:23:55
12833
297
12099
-23.581688
-46.731052
volta
2016-03-28 18:24:20
12834
297
12021
-23.687283
-47.020528
volta
2016-03-28 18:20:45
...
...
...
...
...
...
...
128061
297
2043
-23.681625
-47.018013
volta
2016-03-28 20:39:11.243000
128062
297
12021
-23.681872
-47.018217
volta
2016-03-28 20:51:47
128063
297
12023
-23.664837
-47.008385
ida
2016-03-28 20:50:01
128064
297
12018
-23.590359
-46.817844
volta
2016-03-28 20:51:35
130001
297
12021
-23.687361
-47.020400
ida
2016-03-28 20:54:43
130002
297
12023
-23.649050
-46.995491
ida
2016-03-28 20:53:35
130003
297
12018
-23.590725
-46.825054
volta
2016-03-28 20:53:12
130004
297
12021
-23.687361
-47.020400
ida
2016-03-28 20:54:43
130005
297
12023
-23.649050
-46.995491
ida
2016-03-28 20:53:35
130006
297
12018
-23.590725
-46.825054
volta
2016-03-28 20:53:12
130007
297
12021
-23.687361
-47.020400
ida
2016-03-28 20:54:43
130008
297
12023
-23.649050
-46.995491
ida
2016-03-28 20:53:35
130009
297
12018
-23.590637
-46.825172
volta
2016-03-28 20:53:16
130010
297
12021
-23.687361
-47.020400
ida
2016-03-28 20:54:43
130011
297
12023
-23.649050
-46.995491
ida
2016-03-28 20:53:35
130012
297
12018
-23.590637
-46.825172
volta
2016-03-28 20:53:16
137338
297
2043
-23.674820
-47.014952
ida
2016-03-28 21:03:51.927000
137339
297
12021
-23.683100
-47.019329
ida
2016-03-28 21:06:44
137340
297
12018
-23.602425
-46.912537
volta
2016-03-28 21:06:44
137341
297
2043
-23.674820
-47.014952
ida
2016-03-28 21:03:51.927000
137342
297
12021
-23.683100
-47.019329
ida
2016-03-28 21:06:44
137343
297
12018
-23.602425
-46.912537
volta
2016-03-28 21:06:44
145417
297
2043
-23.626778
-46.983760
ida
2016-03-28 21:14:34.617000
145418
297
12021
-23.622778
-46.977036
ida
2016-03-28 21:21:27
145419
297
12018
-23.626438
-46.982674
volta
2016-03-28 21:19:55
150317
297
12018
-23.658414
-47.001322
volta
2016-03-28 21:29:10
150321
297
12018
-23.658414
-47.001322
volta
2016-03-28 21:29:10
157477
297
12018
-23.683020
-47.019108
ida
2016-03-28 21:42:47
159324
297
12018
-23.668955
-47.010025
ida
2016-03-28 21:45:52
162421
297
12018
-23.644398
-46.991726
ida
2016-03-28 21:51:27
307 rows × 6 columns
In [8]:
img = imread("map.png")
plt.scatter(raw.Longitude, raw.Latitude, marker='.')
plt.imshow(img, zorder=0, extent=[-47.4, -45.9 , -23.99, -22.97])
plt.show()
In [78]:
raw
Out[78]:
Linha
Prefixo
Latitude
Longitude
Rota
Timestamp
0
020
21883
-23.564875
-46.693062
ida
2016-03-24 00:23:58
1
020
21893
-23.523790
-46.820938
volta
2016-03-24 00:24:03
2
022
21917
-23.535805
-46.772655
volta
2016-03-24 00:24:02
3
052
20677
-23.519903
-46.705344
volta
2016-03-24 00:15:43
4
052
20534
-23.513927
-46.776939
ida
2016-03-24 00:23:59
5
052
20552
-23.512225
-46.788083
volta
2016-03-24 00:23:57
6
053
20517
-23.496149
-46.792095
volta
2016-03-24 00:23:34
7
053
20031
-23.521231
-46.709885
ida
2016-03-24 00:23:53
8
053
20032
-23.501989
-46.773939
ida
2016-03-24 00:23:53
9
053
20014
-23.494205
-46.800003
volta
2016-03-24 00:23:11
10
054
20934
-23.506414
-46.750600
volta
2016-03-24 00:22:48
11
059
21222
-23.572175
-46.708883
volta
2016-03-24 00:21:55
12
060
21220
-23.571667
-46.721230
volta
2016-03-24 00:24:11
13
060
21170
-23.571144
-46.801933
volta
2016-03-24 00:22:50
14
061
21827
-23.544064
-46.763699
ida
2016-03-24 00:23:30
15
061
21826
-23.546797
-46.822006
volta
2016-03-24 00:22:16
16
080
20563
-23.501902
-46.775356
volta
2016-03-24 00:23:48
17
081
21963
-23.525070
-46.802319
volta
2016-03-24 00:23:43
18
082
21922
-23.538392
-46.775011
ida
2016-03-24 00:22:58
19
082
21940
-23.498415
-46.877117
volta
2016-03-24 00:24:04
20
082
21859
-23.406593
-46.992554
ida
2016-03-24 00:23:51
21
082
21954
-23.401392
-47.008640
ida
2016-03-24 00:23:48
22
085
20894
-23.497684
-46.855282
volta
2016-03-24 00:24:07
23
085
20897
-23.469639
-46.898563
volta
2016-03-24 00:21:52
24
085
20895
-23.549057
-46.737930
ida
2016-03-24 00:24:11
25
086
21226
-23.541386
-46.800789
volta
2016-03-24 00:24:09
26
086
21271
-23.525015
-46.716270
ida
2016-03-24 00:24:18
27
122
20501
-23.520691
-46.787189
volta
2016-03-24 00:23:53
28
122
2054
-23.502362
-46.814442
ida
2016-03-24 00:11:47.610000
29
122
2086
-23.500810
-46.806867
volta
2016-03-24 00:18:34.738000
...
...
...
...
...
...
...
407
422
12313
-23.584927
-46.745647
volta
2016-03-24 00:29:09
408
422
12363
-23.574162
-46.923809
ida
2016-03-24 00:29:26
409
422
12214
-23.552082
-46.936661
volta
2016-03-24 00:29:21
410
459
11585
-23.569941
-46.691490
circular
2016-03-24 00:29:10
411
488
12507
-23.581688
-46.731052
volta
2016-03-24 00:29:32
412
503
12212
-23.687236
-47.020761
volta
2016-03-24 00:28:16
413
503
12192
-23.619706
-46.974539
ida
2016-03-24 00:29:25
414
507
12287
-23.594236
-47.015294
ida
2016-03-24 00:26:22
415
507
12347
-23.603481
-46.918129
ida
2016-03-24 00:29:34
416
508
12377
-23.613115
-46.983101
volta
2016-03-24 00:28:36
417
508
12159
-23.668739
-47.079121
ida
2016-03-24 00:26:05
418
508
12387
-23.605135
-46.925915
volta
2016-03-24 00:29:28
419
510
15779
-23.582880
-46.714203
ida
2016-03-24 00:29:37
420
510
15765
-23.647579
-46.790737
volta
2016-03-24 00:29:37
421
513
15754
-23.729297
-46.786017
volta
2016-03-24 00:29:25
422
513
15755
-23.659764
-46.767950
volta
2016-03-24 00:29:14
423
513
15718
-23.757790
-46.808708
volta
2016-03-24 00:28:31
424
513
15717
-23.677820
-46.773155
volta
2016-03-24 00:29:40
425
551
15681
-23.660019
-46.767956
volta
2016-03-24 00:18:15
426
551
15641
-23.640311
-46.814561
volta
2016-03-24 00:29:16
427
558
12261
-23.663561
-46.769753
volta
2016-03-24 00:29:41
428
563
12477
-23.728418
-46.786182
volta
2016-03-24 00:28:53
429
563
12427
-23.836350
-46.810289
ida
2016-03-24 00:28:23
430
587
11648
-23.649344
-46.758744
volta
2016-03-24 00:27:29
431
806
15370
-23.722150
-46.828017
volta
2016-03-24 00:26:54
432
806
15652
-23.721066
-46.832657
volta
2016-03-24 00:27:34
433
811
15620
-23.782825
-46.833454
ida
2016-03-24 00:14:05
434
027
94
-23.645212
-46.526035
ida
2016-03-24 00:12:53.666000
435
004
3060
-23.689727
-46.582862
volta
2016-03-24 00:21:13.037000
436
004
2060
-23.605092
-46.599563
volta
2016-03-24 00:29:55.930000
437 rows × 6 columns
In [ ]:
Content source: danilolessa/playground
Similar notebooks: