Advertisement
Guest User

Untitled

a guest
Apr 19th, 2019
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. import csv
  2. from dateutil import parser
  3. import datetime
  4.  
  5. def parse_time(datetime_str):
  6. return parser.parse(datetime_str).replace(tzinfo=datetime.timezone.utc).isoformat()
  7.  
  8. with open("sample_schedule.csv", "r") as f:
  9. reader = csv.reader(f, delimiter=",")
  10.  
  11. keyed_schedule = {}
  12. first_line = True
  13. for line in reader:
  14. schedule = {}
  15. if first_line:
  16. first_line = False
  17. continue
  18.  
  19. schedule["agent_id"] = line[0]
  20. schedule["agent_name"] = line[1]
  21. schedule["start"] = parse_time(line[2])
  22. schedule["end"] = parse_time(line[3])
  23.  
  24. keyed_schedule[line[0]] = schedule
  25.  
  26. print(keyed_schedule)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement