Python | Pandas DatetimeIndex.to_frame()

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas DatetimeIndex.to_frame() function create a DataFrame with a column containing the Index. By default the labels of the DatetimeIndex object is used as an index for the newly constructed Dataframe.

Syntax: DatetimeIndex.to_frame(index=True) Parameters : index : Set the index of the returned DataFrame as the original Index Return : DataFrame containing the original Index data.

Example #1: Use DatetimeIndex.to_frame() function to create a DataFrame object from the given DatetimeIndex object. Also set the index value to False Python3

# importing pandas as pd
import pandas as pd

# Create the DatetimeIndex
# Here 'S' represents secondly frequency 
didx = pd.DatetimeIndex(start ='2018-11-15 09:45:10', freq ='S', periods = 5)

# Print the DatetimeIndex
print(didx)

Output : Now we want to construct a DataFrame out of the DatetimeIndex object. Python3

# construct the DataFrame
didx.to_frame(index = False)

Output : As we can see in the output, the function has returned a DataFrame object constructed from the didx DatetimeIndex object.   Example #2: Use DatetimeIndex.to_frame() function to create a DataFrame object from the given DatetimeIndex object. Python3

# importing pandas as pd
import pandas as pd

# Create the DatetimeIndex
# Here 'M' represents monthly frequency 
didx = pd.DatetimeIndex(start ='2015-03-02', freq ='M', periods = 5)

# Print the DatetimeIndex
print(didx)

Output : Now we want to construct a DataFrame out of the DatetimeIndex object. Python3

# construct the DataFrame
didx.to_frame(index = True)

Output : As we can see in the output, the function has returned a DataFrame object constructed from the didx DatetimeIndex object.