Guest User

Untitled

a guest
Oct 15th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. "2018-05-30 21:26:43",20.61129150,-100.40933971
  2. "2018-05-30 21:26:43",20.61127415,-100.41146822
  3. "2018-06-02 21:56:12",21.15633228,-100.93766080
  4. "2018-06-05 22:57:40",20.59734201,-100.38091286
  5. "2018-06-05 22:57:40",20.59875096,-100.37821426
  6. "2018-06-06 20:56:22",20.61278120,-100.38446619
  7. "2018-06-06 20:56:22",20.59865452,-100.37827264
  8. "2018-06-06 21:57:15",20.59862012,-100.37817348
  9. "2018-06-06 21:57:15",20.59864713,-100.37821263
  10. "2018-06-06 21:57:15",20.59862915,-100.37825902
  11. "2018-06-07 15:54:29",20.61280757,-100.39768857
  12. "2018-06-07 15:54:29",20.61276216,-100.39769379
  13.  
  14. col_names = ['date', 'latitude', 'longitude']
  15. df = pd.read_csv('marco.csv', names=col_names, sep=',', skiprows=1)
  16.  
  17. # merge
  18. m = df.reset_index().merge(df.reset_index(), on='date')
  19.  
  20. 2018-05-30, 2018-06-05, 2018-06-06, 2018-06-07
Add Comment
Please, Sign In to add comment