0

I have a data column in my Pandas data frame that looks like the following:

Date
========
2022-01-01T00:00:00.000Z
2022-01-01T08:00:00.000Z    
2022-01-01T16:00:00.000Z
2022-01-02T00:00:00.000Z
2022-01-02T08:00:00.000Z    
2022-01-02T16:00:00.000Z

I am trying to reformat the dates into %Y-%m-%d form, so I can perform a groupby operation on the dates.

I am currently trying to run this line of code

CombinedData['Date'] = CombinedData['Date'].dt.strftime("%Y-%m-%d")

but I keep getting an AttributeError: Can only use .dt accessor with datetimelike values. I am a little confused on why this error is occurring since my dates are formatted as dates in my data frame. Why is this happening, and what can I do to mend this issue?

325
  • 518
  • 2
  • 12

1 Answers1

1

Use:

CombinedData['Date'] = pd.to_datetime(CombinedData['Date']).dt.strftime("%Y-%m-%d")
jezrael
  • 729,927
  • 78
  • 1,141
  • 1,090