API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
raw download clone embed print report
  1. 2009-08-07 16:16:44 [37.800185, -122.426361]
  2. 2009-08-07 16:16:48 [37.800214, -122.426153]
  3. 2009-08-07 16:16:49 [37.800222, -122.426118]
  4. 2009-08-07 16:16:52 [37.800197, -122.426072]
  5. 2009-08-07 16:17:32 [37.800214, -122.425903]
  6. 2009-08-07 16:17:34 [37.800236, -122.425826]
  7. 2009-08-07 16:17:40 [37.800282, -122.425534]
  8. 2009-08-07 16:17:44 [37.800307, -122.425315]
  9. 2009-08-07 16:17:46 [37.800324, -122.425207]
  10. 2009-08-07 16:17:47 [37.800331, -122.425153]
  11. 2009-08-07 16:17:49 [37.800343, -122.425047]
  12. 2009-08-07 16:17:50 [37.800355, -122.424994]
  13. 2009-08-07 16:17:51 [37.800362, -122.424942]
  14. 2009-08-07 16:17:54 [37.800378, -122.424796]
  15. 2009-08-07 16:17:56 [37.800357, -122.424764]
  16.  
  17. In [99]: df
  18. Out[99]:
  19. X Y
  20. 2009-08-07 00:00:00 -0.900602 -1.107547
  21. 2009-08-07 01:00:00 0.398914 1.545534
  22. 2009-08-07 02:00:00 -0.429100 2.052242
  23. 2009-08-07 03:00:00 0.857940 -0.348118
  24. 2009-08-07 04:00:00 0.394655 -1.578197
  25. 2009-08-07 05:00:00 -0.240995 -1.474097
  26. 2009-08-07 06:00:00 0.619148 -0.040635
  27. 2009-08-07 07:00:00 -1.403177 -0.187540
  28. 2009-08-07 08:00:00 -0.360626 -0.399728
  29. 2009-08-07 09:00:00 0.179741 -2.709712
  30.  
  31. In [100]: df['Time'] = df.index.asi8
  32.  
  33. In [101]: dist = df.diff().fillna(0.)
  34.  
  35. In [102]: dist['Dist'] = np.sqrt(dist.X**2 + dist.Y**2)
  36.  
  37. In [103]: dist['Speed'] = dist.Dist / (dist.Time / 1e9)
  38.  
  39. In [104]: dist
  40. Out[104]:
  41. X Y Time Dist Speed
  42. 2009-08-07 00:00:00 0.000000 0.000000 0.000000e+00 0.000000 NaN
  43. 2009-08-07 01:00:00 1.299516 2.653081 3.600000e+12 2.954248 0.000821
  44. 2009-08-07 02:00:00 -0.828013 0.506708 3.600000e+12 0.970752 0.000270
  45. 2009-08-07 03:00:00 1.287040 -2.400360 3.600000e+12 2.723637 0.000757
  46. 2009-08-07 04:00:00 -0.463285 -1.230079 3.600000e+12 1.314430 0.000365
  47. 2009-08-07 05:00:00 -0.635650 0.104100 3.600000e+12 0.644118 0.000179
  48. 2009-08-07 06:00:00 0.860143 1.433462 3.600000e+12 1.671724 0.000464
  49. 2009-08-07 07:00:00 -2.022324 -0.146906 3.600000e+12 2.027653 0.000563
  50. 2009-08-07 08:00:00 1.042550 -0.212188 3.600000e+12 1.063924 0.000296
  51. 2009-08-07 09:00:00 0.540367 -2.309984 3.600000e+12 2.372345 0.000659
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!