I have a DataFrame column (named 'DateTime'), containing a time sequence with a timestep of one minute. They are objects. Each object has this format:
2018-01-10 00:00:00+01:00 2018-01-10 00:01:00+01:00 2018-01-10 00:02:00+01:00 .. 2019-02-04 23:57:00+01:00 2019-02-04 23:58:00+01:00 2019-02-04 23:59:00+01:00
I need to convert them into datetime, so that to get date and time. How can i do that?
I tried this code:
data['DateTime'] = pd.to_datetime(data['DateTime']) data['Date'] = data['DateTime'].dt.date data['Time'] = data['DateTime'].dt.time
But i got the following error:
'ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True'