timezone conversion in dataframe

Asked May 16 '19 at 18:58

Active May 16 '19 at 19:38

Viewed 37 times

I have a datetime column in my dataframe and I need to get the date out of it and put it in a separate column.

Format of values in dataframe:

column name: timeinutc 
value: 2019-03-20T20:00:29.6259945Z
Desired Output: 2019-03-20

So i tried this:

payers['eventtime']=pd.to_datetime(payers['timeinutc'],infer_datetime_format=True)

got result like this eventtime: 2019-03-20 20:00:29.625994500+00:00

Next thing I did:

payers['eventtime2'] = pd.to_datetime(payers['eventtime'].dt.tz_localize(None),infer_datetime_format=True)

it resulted in 2019-03-20 20:00:29.625994500

I only want the date out of my timeinutc column

edited May 16 '19 at 19:38

Yuca

asked May 16 '19 at 18:58

irum zahra

Take a look at [How can I remove a pytz timezone from a datetime object?](https://stackoverflow.com/a/10944136/10716506), I had the same issue and that worked for me :) – Jules May 16 '19 at 19:03
1

payers['eventtime'].dt.date – BENY May 16 '19 at 19:03
@WeNYoBen it worked !! Thanks so much – irum zahra May 16 '19 at 19:11

0 Answers0