'Combining and Grouping By Dates using a Pandas Dataframe [duplicate]
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?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|