This is a quick post representing code sample related to how to extract month & year from datetime column of DataFrame in Pandas.
The code sample is shown using the sample data, BrentOilPrices downloaded from this Kaggle data page.
Here is the code to load the data frame.
import pandas as pd df = pd.read_csv('BrentOilPrices.csv')
Check the data type of the data using the following code:
The output looks like the following:
Use the following command to change the date data type from object to datetime and extract the month and year.
df['Date'] = pd.to_datetime(df['Date']) df['year'] = pd.DatetimeIndex(df['Date']).year df['month'] = pd.DatetimeIndex(df['Date']).month
Printing data using head command would print the following:
He has also authored the book, Building Web Apps with Spring 5 and Angular.
Latest posts by Ajitesh Kumar (see all)
- Difference between True Error & Sample Error - December 26, 2019
- Python – How to Create Dataframe using Numpy Array - December 15, 2019
- Hypergeometric Distribution Explained with 10+ Examples - December 14, 2019