Python Time Series - Convert Date Index to Pandas Column

jeremy.cahill

Hi All,

In a simple time series, how do you convert the timestamp, which is in an index to a pandas column formated in dateimte?

Alex Putkov.1

If you have a dataframe named 'df' with DatetimeIndex, the following command will add a column labeled 'Timestamp' and the values corresponding to the values of the index:

df['Timestamp'] = df.index

E.g.

df = ek.get_timeseries('EUR=','CLOSE')
df['Timestamp'] = df.index
df.info()

This returns:

<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 71 entries, 2020-09-28 to 2021-01-04
Data columns (total 2 columns):
 #   Column     Non-Null Count  Dtype         
---  ------     --------------  -----         
 0   CLOSE      71 non-null     float64       
 1   Timestamp  71 non-null     datetime64[ns]
dtypes: datetime64[ns](1), float64(1)
memory usage: 1.7 KB