UnknownTimeZoneError in Pandas.Timestamp.now

Question

I want to append the Timestamp of current time for my timezone, but don't know where to find the correct value of my timezone. Apparently, it's Islamabad/Karachi, but no success.

Here is my small code chunk

import pandas as pd
...
#df -> a dataframe
df.to_csv('C:/path/to/file-'+str(pd.Timestamp.now())+'.tsv', mode='a', index=None, sep='\t', header=False)

Desired output file name is

file-10;17;52--29-06-2020 for file-hour;minutes;sec--day-month-year

I know : is not allowed in names

if you are in your tz, them datetime.now() should give it; If not then use the UTC timeshift wrt you zone to create the correct time; — Aditya, Jun 29 '20 at 04:51
In my case timeshift is +5 hours. Can you please put an answer to make my code working? — DevLoverUmar, Jun 29 '20 at 04:54
Thanks for datetime module. I was going to kill a fly with Atomic Bomb(pandas timestamp) :p — DevLoverUmar, Jun 29 '20 at 05:11
that's fine, I've basically just added strftime to @Aditya 's answer. find more format codes here: https://strftime.org/ — FObersteiner, Jun 29 '20 at 05:56
the interesting thing here to me is actually *why* `pd.Timestamp.now()` throws `UnknownTimeZoneError` - what do you get if you call `datetime.now().astimezone()`? — FObersteiner, Jun 29 '20 at 05:58

Aditya · Accepted Answer · 2020-06-29T06:07:11.150

2

IF you are in the required TimeZone, then simply doing the below will work;

from datetime import datetime
time_now = datetime.now() # Will give your local time

OR,

We can get the same by shifting the UTC time by let's say by 5 hours

from datetime import datetime, timezone, timedelta
now_utc = datetime.utcnow() # Current time in UTC
my_tz_time = now_utc + timedelta(hours=5) # now we can shift the time by 5 hours easily

EDIT -1

Based on the link shared by @MrFuppes, in the second approach, we should do the below,

from datetime import datetime, timezone, timedelta
now_utc = datetime.now(tz=timezone.utc) # Time in UTC
my_tz_time = now_utc + timedelta(hours=5) # now we can shift the time by 5 hours easily

edited Jun 29 '20 at 06:07

answered Jun 29 '20 at 04:55

Aditya

2,380
2
14
39

1

save yourself some trouble and [avoid datetime.utcnow](https://blog.ganssle.io/articles/2019/11/utcnow.html) :) – FObersteiner Jun 29 '20 at 05:54
I have updated with the same for future visitors; Thanks @MrFuppes – Aditya Jun 29 '20 at 06:07

UnknownTimeZoneError in Pandas.Timestamp.now

1 Answers1