Advertisement
Guest User

Untitled

a guest
Feb 24th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. from datetime import datetime
  2. def date_split(calendar):
  3. for row in calendar:
  4. new_calendar={}
  5. listdate=datetime.strptime(row['date'],'%Y-%M-%D')
  6.  
  7. ----> 7 listdate=datetime.strptime(row['date'],'%Y-%M-%D')
  8. TypeError: string indices must be integers
  9.  
  10. print (df['date'].dtype)
  11. object
  12.  
  13. df['date'] = pd.to_datetime(df['date'])
  14.  
  15. print (df['date'].dtype)
  16. datetime64[ns]
  17.  
  18. df['year'] = df['date'].dt.year
  19. df['month'] = df['date'].dt.month
  20. df['day'] = df['date'].dt.day
  21.  
  22. listdate = df['date'].dt.date.tolist()
  23. print (listdate)
  24.  
  25. [datetime.date(2017, 9, 5),
  26. datetime.date(2017, 9, 4),
  27. datetime.date(2017, 9, 3),
  28. datetime.date(2017, 9, 2),
  29. datetime.date(2017, 9, 1)]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement