pandas timestamp to date code example

Example 1: timestamp to date python

from datetime import datetime

timestamp = 1586507536367
dt_object = datetime.fromtimestamp(timestamp)

Example 2: pandas timestamp to string

Consider the dataframe df

df = pd.DataFrame(dict(timestamp=pd.to_datetime(['2000-01-01'])))

df

   timestamp
0 2000-01-01
Use the datetime accessor dt to access the strftime method. You can pass a format string to strftime and it will return a formatted string. When used with the dt accessor you will get a series of strings.

df.timestamp.dt.strftime('%Y-%m-%d')

0    2000-01-01
Name: timestamp, dtype: object
Visit strftime.org for a handy set of format strings.

Example 3: pandas change dtype to timestamp

pd.to_datetime(df.column)

Example 4: convert column to timestamp pandas

df2 = pd.to_datetime(df['col1'])
df2