pandas datetime to unix timestamp

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

View another examples Add Own solution

Log in, to leave a comment

3.33

3

Intesar 80 points

                                    # 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')

Thank you! 3

3.33 (3 Votes)

0

3.57

8

Aram Papazian 95 points

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

Thank you! 8

3.57 (14 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category Python

Python 2023-04-11 03:04:20
Python 2022-03-27 22:40:04 pycharm no module named
Python 2022-03-27 22:25:05 assign multiple variablesin one line
Python 2022-03-27 22:20:02 levenshtein distance
Python 2022-03-27 21:35:09 get text from url python last slash
Python 2022-03-27 21:30:30 df concatenate df
Python 2022-03-27 21:25:09 python odd or even
Python 2022-03-27 21:15:32 python include function from another file
Python 2022-03-27 21:10:01 color module python
Python 2022-03-27 21:00:27 python tkinter cursor types

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

datetime to unix timestamp pandas timestamp pandas to datetime convert to unix timestamp dataframe convert datetime to unix timestamp python dataframe datetime string to unix timestamp dataframe pandas timestamp to datetime python python pandas unix timestamp to datetime convert timestamp to date time pandas pandas convert timestamp to unix epoch pandas convert datetime to unix ms pandas timestamp to datetime unix timestamp ms to datetime pandas pd.to_datetime UNIX timestamp format dataframe unix timestamp to datetime convert timestamp to datetime python pandas unix to datetime pandas dataframe UNIX timestamp format timestamp to datetime pandas convert unix timestamp to date pandas how to convert unix timestamp to date in pandas panda timestamp to datetime pandas from timestamp to datetime convert datetime to pandas timestamp from unix timestamp to datetime pandas convert unix to date in python pandas unix timestamp converter pandas converting unix time to datetime df python convert a unix timestamp column to time in python pandas convert timestamp to unix pandas convert to unix timestamp pandas date from unix timestamp python Pandas df date column to UNIX timestamp python Pandas df timestamp to UNIX unix timestamp to datetime pandas unix time to datetime python pandas pandas dataframe convert unix timestamp to datetime pythom convert pandas Timestamp to datime python convert pandas timestamp to datetime pandas convert unix ms timestamp to datetime convert timestamp to pandas datetime pandas convert datetime64 ns to unix timestamp convert timestamp to unix time pandas pandas to datetime from unix timestamp convert unix to date pandas unix timestamp to date pandas unix timestamp to datetime in python column pandas unix to timestamp datetime convert unix timestamp python dataframe pandas timestamp to unix time unix timestamp to date python pandas pandas convert unix timestamp to datetime pandas to unix timestamp convert unix timestamp to datetime pandas dataframe column unix timestamp to datetime pandas unix timestamp to datetime unix timestamp pandas pandas timedelta to minutes turn column to datetime pandas datetime to miilss javascript format time to unix timestamp pandas timestamp to datetime example pandas using timestamp as index pandas timestamp pandas from timestamp to date add seconds to current epoch pandas dataframe to_datetime unixtime pandas convert utc timestamp to datetime unix timestamp to utc datetime convert numpy datetime to pandas timestamp convert timestamp to datetime pandas convert unix timestamp to datetime pandns dateto time pandas datetime to timestamp pandas datetime to unix pandas work with unix timestamp convert datetime to unix timestamp python convert unix timestamp to datetime python pandas convert epoch time "Float64Index" to datetime python python datetime unix timestamp unix timestamp to datetime datetime to unix timestamp python convert datetime datetime to unix timestamp python pandas convert datetime column to unix timestamp pandas unix time to datetime python unix timestamp to datetime convert date to unix timestamp date to unix timestamp pandas date to unix timestamp unix code with base 10 to datetime pandas convert time to unix time python pandas how to convert object to to unix time in nanoseconds in pandas# datetime to unix epoch time in Python timestamp using pandas pandas datetime to epoch seconds pandas datetime to unix timestamp

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example