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:
df.dtypes
The output looks like the following:
Date object
Price float64
dtype: object
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:
In recent years, artificial intelligence (AI) has evolved to include more sophisticated and capable agents,…
Adaptive learning helps in tailoring learning experiences to fit the unique needs of each student.…
With the increasing demand for more powerful machine learning (ML) systems that can handle diverse…
Anxiety is a common mental health condition that affects millions of people around the world.…
In machine learning, confounder features or variables can significantly affect the accuracy and validity of…
Last updated: 26 Sept, 2024 Credit card fraud detection is a major concern for credit…