I got this error when trying to convert dateto week Could it be the date values not datetime like values?
data['DATECREATED'].dt.week
Asked
Active
Viewed 6,450 times
2
-
What is `print(data['DATECREATED'].dtype)` Is it datetime? If not, uncomment row above. – jezrael Mar 01 '18 at 13:04
-
Hi it is "Object" ?? – okl Mar 01 '18 at 13:06
-
OK, use `data['DATECREATED'] = pd.to_datetime(data['DATECREATED'])` – jezrael Mar 01 '18 at 13:07
-
this work perfect! – okl Mar 01 '18 at 13:17
-
that is good that it works - could you please add data from screenshot as text to your question? – rudolf_franek Mar 01 '18 at 13:48
-
@rudolf_franek how do I do that ?? – okl Mar 01 '18 at 14:22
1 Answers
2
I think you need convert column to datetime first and assign back to column:
data['DATECREATED'] = pd.to_datetime(data['DATECREATED'])
data['new'] = data['DATECREATED'].dt.strftime('%Y%V')
data['CreatedWW'] = data['DATECREATED'].dt.week
jezrael
- 822,522
- 95
- 1,334
- 1,252
-
got this error: ValueError: time data '26/01/2018' does not match format '%d/%b/%y %H:%M %p' (match) – okl Mar 01 '18 at 13:17