How to change UTC time to local time in Python DataFrame?

[SamKnight]

Help convert UTC time to local. Here is a getter function that outputs the time in UTC in columns.

 def getminutedata(symbol, interval, lookback):
     frame = pd.DataFrame(client.get_historical_klines(symbol, interval, lookback + 'min ago UTC'))
     frame = frame.iloc[:,:6]
     frame.columns = ['Time', 'Open', 'High', 'Low', 'Close', 'Volume']
     frame = frame.set_index('Time')
     frame.index = pd.to_datetime(frame.index, unit='ms')
     frame = frame.astype(float)
     return frame

I've tried to change time in three ways, using pandas, dateutil and pytz, but nothing worked, not enough knowledge in Python. Knowledgeable people help write down the necessary lines of code to change time. Thank you in advance.

[rob101]

@snippsat posted some good info on this topic here: https://python-forum.io/thread-37473-pos...#pid158374

... which may be of help to you.

It's not an easy subject.

[Pedroski55]

I think many webhosts set their servers to UTC (a French abbreviation, I believe).

Chinese time is 8 hours or 28800 seconds behind UTC, so if the webhost is on UTC, I just subtract 28800 if I want the Chinese time.

My current webhost runs on Chinese local time, which makes things easier for me, being in China.

But I still need to change opening and closing times for classwork webpages. I know the time the first class starts, then just add on the timedelta for the other classes in a loop using the class names.

Look at the docs here.

from datetime import datetime, timedelta
# time the first class starts
my_string = 'September 13 2021 09:50:00'
my_date = datetime.strptime(my_string, "%B %d %Y %H:%M:%S")
print(my_date)
# set the required timedelta
BE1_start = timedelta(days=+2, hours=+5, minutes=+55)
new_date = my_date + BE1_start
print(new_date)

Once you know your timedelta, just make a function to add or subtract the correct amount of time from the UTC time.