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 IndexReturn : 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
# 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.
# 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.
# 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.
# 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.
