Conversion of 'date' column in the historical data

Sashank_Chittipeddi

Hello,

I got a small piece of historical 15 min data

How is the 'date' column formatted. If I convert it to a pandas datetime object, the time is going haywire - 915 becomes 03:45. The other intervals increment by 15 min.

Ideally, I would want to convert it into a date time to perform some operations on the same. Any suggestions?

tonystark

Hi @Sashank_Chittipeddi,

You can try datetime.datetime.strptime("2015-12-28T09:15:00+0530", "%Y-%m-%dT%H:%M:%S+0530")

rajtk

Thanks Tonystark. Even I had to same query.