UTC to PST with multiple columns using Python

Question

Background

I have a dataframe, df: I would like to convert the date timestamps from UTC to PST in both columns.

  Connected                    Ended

  3/3/2020 1:00:00 PM          3/3/2020 1:01:00 PM
  3/4/2020 4:00:00 PM          3/4/2020 4:05:00 PM

Desired Output:

  ConnectedPST                 EndedPST

  3/3/2020 6:00:00 AM          3/3/2020 6:01:00 AM                    
  3/4/2020 9:00:00 AM          3/4/2020 9:05:00 AM

Structure:

   'Connected    Ended\n0  3/3/2020 1:00:00 PM  3/3/2020 1:01:00 PM\n1  3/4/2020     4:00:00 PM  3/4/2020 4:05:00 PM'

What I have tried:

 from datetime import datetime
 from pytz import timezone

 datetime_obj_pacific = timezone('US/Pacific').localize(datetime_obj_naive)
 print datetime_obj_pacific.strftime ("%Y-%m-%d %H:%M:%S %Z%z")

However, I am not sure how to incorporate this into my dataframe. Any assistance is appreciated.

However, I am not sure how to incorporate this into my dataframe. Can you be more specific? Have you done any research, read the documentation? Also, please provide the data in a more convenient format. — AMC
– AMC, Commented Apr 24, 2020 at 2:43
I have done research and still am unsure about this. Why would you downvote as I am trying to learn and I provided what I have done within both of my recent questions. — Lynn
– Lynn, Commented Apr 24, 2020 at 3:17
Does this answer your question? Converting time zone pandas dataframe — AMC
– AMC, Commented Apr 24, 2020 at 3:25

Rajat Mishra · Accepted Answer · 2020-04-24 00:14:44Z

0

you can try something like this:

In [22]: import pandas as pd
    ...: d = pd.Series(['2020-04-23 19:57:55', '2020-04-23 19:59:46'])
    ...: d = pd.to_datetime(d)
    ...: d
    ...:
Out[22]:
0   2020-04-23 19:57:55
1   2020-04-23 19:59:46
dtype: datetime64[ns]

In [23]: d_pacific_tz_aware = d.dt.tz_localize("GMT").dt.tz_convert('America/Los_Angeles')

In [24]: d_pacific_tz_aware
Out[24]:
0   2020-04-23 12:57:55-07:00
1   2020-04-23 12:59:46-07:00
dtype: datetime64[ns, America/Los_Angeles]

In [25]: d_pacific_tz_naive = d.dt.tz_localize("GMT").dt.tz_convert('America/Los_Angeles').dt.tz_localize(None)

In [26]: d_pacific_tz_naive
Out[26]:
0   2020-04-23 12:57:55
1   2020-04-23 12:59:46
dtype: datetime64[ns]

You need to convert the column to datetime64[ns] format before changing the timezone

answered Apr 24, 2020 at 0:14

Rajat Mishra

3,7904 gold badges32 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rajat Mishra Over a year ago

@TanishaHudson please consider to accept the answer if it worked for you

Lynn Over a year ago

Yes, I will try this later today!

AMC Over a year ago

stackoverflow.com/questions/22800079/…

Collectives™ on Stack Overflow

UTC to PST with multiple columns using Python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related