How to create a timeindex from one datetime to another in pandas?
This recipe helps you create a timeindex from one datetime to another in pandas
Recipe Objective
Suppose you have a datetime data in form of index and you wish to convert it to datatime format and make it as index.
So this recipe is a short example on How to create a timeindex from one datetime to another in pandas. Let's get started.
Step 1 - Import the library
import pandas as pd
Let's pause and look at these imports. Pandas is generally used for performing mathematical operation and preferably over arrays.
Step 2 - Setup the Data
df = pd.DataFrame({'name':['john','mary','peter','jeff','bill'],'date_of_birth':['2000-01-01', '1999-12-20', '2000-11-01', '1995-02-25', '1992-06-30']})
print(df)
Here we have setup a dataframe of randome values with names and date_of_birth as columns.
Step 3 - Setting date time Index
df=df.set_index(pd.to_datetime(df['date_of_birth']))
df.drop('date_of_birth',axis=1,inplace=True)
print(df)
We have first coverted date_of_birth to date time index and finally set it as index. Now, we drop that particular column to have a clearity.
Step 4 - Let's look at our dataset now
Once we run the above code snippet, we will see:
Scroll down the ipython file to visualize the final output.
We can see date_of_birth used as datatime Index.
What Users are saying..
Abhinav Agarwal
I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More