Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def resample(srcData):
- times = ['time%s' % i for i in range(1, 11)]
- srcData[times] = srcData[times].apply(pd.to_datetime)
- srcData['start_time'] = srcData['time1'].dt.hour
- srcData['total_time'] = 0
- for i in range(1, 10):
- srcData['time' + str(i)] = (srcData['time' + str((i+1))] - srcData['time' + str(i)]).fillna(0).dt.seconds
- times = ['time%s' % i for i in range(1,10)]
- srcData.drop('time10',1,inplace=True)
- srcData.drop('session_id',1,inplace=True)
- data['total_time'] = data[times].sum(axis=1)
Add Comment
Please, Sign In to add comment