pandas.DatetimeIndex.to_frame

DatetimeIndex.to_frame(index=True, name=None)

Create a DataFrame with a column containing the Index.

New in version 0.24.0.

Parameters:

index : boolean, default True

Set the index of the returned DataFrame as the original Index.

name : object, default None

The passed name should substitute for the index name (if it has one).

Returns:

DataFrame

DataFrame containing the original Index data.

See also

Index.to_series

Convert an Index to a Series.

Series.to_frame

Convert Series to DataFrame.

Examples

>>> idx = pd.Index(['Ant', 'Bear', 'Cow'], name='animal')
>>> idx.to_frame()
       animal
animal
Ant       Ant
Bear     Bear
Cow       Cow

By default, the original Index is reused. To enforce a new Index:

>>> idx.to_frame(index=False)
    animal
0   Ant
1  Bear
2   Cow

To override the name of the resulting column, specify name:

>>> idx.to_frame(index=False, name='zoo')
    zoo
0   Ant
1  Bear
2   Cow