Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. df = pd.DataFrame({ "id":[1,1,1,1,1,2,2,2,2,2,3,3,3,3,3,3,3,4,4],
  2. "date":("2000-07-06","2000-07-07","2000-07-08","2000-07-09","2000-07-10","2000-07-06","2000-07-10","2000-07-11","2000-07-17","2000-07-20","2000-07-06","2000-07-07","2000-07-08","2000-07-10","2000-07-15","2000-07-16","2000-07-25","2000-07-11","2000-07-20")})
  3. df.date =pd.to_datetime(df.date)
  4.  
  5. date id
  6. 1 2000-07-06 1
  7. 2 2000-07-07 1
  8. 3 2000-07-08 1
  9. 4 2000-07-09 1
  10. 5 2000-07-10 1
  11. 6 2000-07-06 2
  12. 7 2000-07-10 2
  13. 8 2000-07-11 2
  14. 9 2000-07-17 2
  15. 10 2000-07-20 2
  16. 11 2000-07-06 3
  17. 12 2000-07-07 3
  18. 13 2000-07-08 3
  19. 14 2000-07-10 3
  20. 15 2000-07-15 3
  21. 16 2000-07-16 3
  22. 17 2000-07-25 3
  23. 18 2000-07-11 4
  24. 19 2000-07-20 4
  25.  
  26. count id
  27. 1 4 1
  28. 2 1 2
  29. 3 3 3
  30. 3 0 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement