convert unix timestamp string to readable date using pandas libraries

Question

unix_timestamp=1284105682
print(pd.to_datetime(unix_timestamp,unit='s',origin='unix'))

Expected Output : 2010-09-10 13:31:22 My Output: 2010-09-10 08:01:22

I am unable to figure out how time is getting wrong

Converting the timezone to Asia/Calcutta gives the expected output. — Ashok Arora
– Ashok Arora, Commented May 15, 2021 at 18:19
For Asia/Kolkata just change the tz_convert to tz_convert('Asia/Kolkata') — Gabriel Melo de Paula
– Gabriel Melo de Paula, Commented May 15, 2021 at 19:33

Gabriel Melo de Paula · Accepted Answer · 2021-05-15 18:12:27Z

1

It seems to be a UTC-related issue. You can create the datetime with UTC and then change it to your time-zone like this:

import pandas as pd
unix_timestamp=1284105682
df = pd.to_datetime(unix_timestamp, unit='s', origin='unix', utc=True)
df.tz_convert('America/Sao_Paulo')

answered May 15, 2021 at 18:12

Gabriel Melo de Paula

3511 silver badge7 bronze badges

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

2 Comments

user14286489 Over a year ago

using tz_convert showing this error 'NoneType' object has no attribute 'tz_convert'

Gabriel Melo de Paula Over a year ago

Did you use the entire code above? Also, can you share the version of pandas you’re using with print(pd.__version__)

Utsav · Accepted Answer · 2021-05-16 03:51:34Z

0

unix_timestamp=1284105682
pd.to_datetime(unix_timestamp,unit='s', utc=True).tz_convert('Asia/Kolkata')

Output

Timestamp('2010-09-10 13:31:22+0530', tz='Asia/Kolkata')

answered May 16, 2021 at 3:51

Utsav

6,0932 gold badges36 silver badges58 bronze badges

Collectives™ on Stack Overflow

convert unix timestamp string to readable date using pandas libraries

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related