Advertisement
Guest User

Untitled

a guest
Apr 2nd, 2020
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. file = 'info.csv'
  2. data = open(file,'r')
  3. reader = csv.reader(data)
  4.  
  5. header = next(reader)
  6.  
  7. for row in reader:
  8. date = datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S+%f')
  9. #outputs like
  10. #2020-03-29 05:01:28.030000
  11. #2020-03-28 09:48:25.020000
  12. #2020-03-29 17:05:29.030000
  13. #2020-03-29 06:06:16.030000
  14. #2020-03-29 05:57:07.030000
  15.  
  16. myformat = "%Y-%m-%d"
  17. dates = date.strftime(myformat)
  18. #after that outputs like
  19. #2020-03-29
  20. #2020-03-28
  21. #2020-03-29
  22. #2020-03-29
  23. #2020-03-29
  24. print(set(dates))
  25. #and after that i want to get unique values so i convert it to set, output:
  26. #{'2', '3', '0', '9', '-'}
  27. #{'2', '3', '0', '9', '-'}
  28. #{'2', '3', '0', '9', '-'}
  29. #{'2', '3', '0', '9', '-'}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement