In [8]:
#/##################/#
# Read data
#
#import
import pandas as pd
#open
TrajectoryDataFrame=pd.read_csv('trajectory.csv')
#count
TotalCountInt=TrajectoryDataFrame['lat'].count()
#print
TrajectoryDataFrame
Out[8]:
In [40]:
#/##################/#
# Short visualisation on google map
#
#import
import gmaps
import numpy as np
#array
CoordinatesArray=np.array(TrajectoryDataFrame[['lat','lon']])
#display
print(dir(gmaps))
"""
map = gmaps.heatmap(CoordinatesArray)
gmaps.display(map)
#Visualisation interpretation
"""
Out[40]:
In [6]:
#/##################/#
# Convert time
# Notice that all data belongs to the same day record 2014-05-09
# So just keep Hours, Minutes and Seconds
#import
import datetime
import time
#map
TrajectoryTimesList=map(
lambda __DateTimeStr:
time.strptime(
__DateTimeStr.split(' ')[-1],
'%H:%M:%S'
),
TrajectoryDataFrame['datetime']
)
#map, project in the seconds subspace
TrajectorySecondIntsList=map(
lambda __TrajectoryTime:
int(
datetime.timedelta(
hours=__TrajectoryTime.tm_hour,
minutes=__TrajectoryTime.tm_min,
seconds=__TrajectoryTime.tm_sec
).total_seconds(
)
),
TrajectoryTimesList
)
#add in df
TrajectoryDataFrame['second']=pd.Series(
TrajectorySecondIntsList
)
#print
print(TrajectoryDataFrame)
In [45]:
%%javascript
GMaps
In [ ]: