/Python/From unix timestamp to datetime pandas

From unix timestamp to datetime pandas

Convert unix timestamp to datetime python pandas

In [23]: df.head()
Out[23]: 
         date  price
0  1349720105  12.08
1  1349806505  12.35
2  1349892905  12.15
3  1349979305  12.19
4  1350065705  12.15
In [25]: df['date'] = pd.to_datetime(df['date'],unit='s')

In [26]: df.head()
Out[26]: 
                 date  price
0 2012-10-08 18:15:05  12.08
1 2012-10-09 18:15:05  12.35
2 2012-10-10 18:15:05  12.15
3 2012-10-11 18:15:05  12.19
4 2012-10-12 18:15:05  12.15

In [27]: df.dtypes
Out[27]: 
date     datetime64[ns]
price           float64
dtype: object

Source: stackoverflow.com

Pandas datetime to unix timestamp

dates = pd.to_datetime(['2019-01-15 13:30:00'])
(dates - pd.Timestamp("1970-01-01")) // pd.Timedelta('1s')  
# Int64Index([1547559000], dtype='int64')

Source: stackoverflow.com

From unix timestamp to datetime pandas

# convert unix timestamp to datetime UTC
df['datetime'] = df['_ts'].map(lambda x: pendulum.from_timestamp(x)) 
df = df.set_index('datetime')
# convert timezone from UTC to GMT+7
df.index = df.index.tz_convert('Asia/Bangkok')

Similar codes

6 votes327 views1 answer
How to reverse word order in python
Python
0 vote377 views1 answer
Get index of first true value numpy
Python
130 votes340 views6 answers
Rename columns in dataframe
Python
18 votes373 views3 answers
How to use histogram in python
Python
0 vote322 views1 answer
Installing intelpython3_core using anaconda
Python
0 vote330 views1 answer
Pandas add quantile columns
Python
1 vote343 views1 answer
FileNotFoundError: [Errno 2] No such file or directory: 'ffprobe': 'ffprobe'
Python
5 votes285 views10 answers
Online python to c converter
Python
0 vote341 views1 answer
Python get focused window
Python
0 vote383 views2 answers
Blog in django
Python