How To Convert A List Of Timestamps In An Excel File From Utc To San Francisco Time (pacific Time) With Python?

Let's say I have an excel file named 'hello123.xlsx'. There is a column of timestamps that has a lot of rows (more than 50,000 rows). The image attached here is basically what the

Solution 1:

Please take a look at this post: need to convert UTC (aws ec2) to PST in python

from datetime import datetime
from pytz import timezone
import pytz

date_format='%m/%d/%Y %H:%M:%S %Z'
date = datetime.now(tz=pytz.utc)
print 'Current date & time is:', date.strftime(date_format)

date = date.astimezone(timezone('US/Pacific'))

print 'Local date & time is  :', date.strftime(date_format)