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:
Last updated: 3rd May, 2024 Have you ever wondered why some machine learning models perform…
Last updated: 2nd May, 2024 The success of machine learning models often depends on the…
When working on a machine learning project, one of the key challenges faced by data…
Last updated: 1st May, 2024 The bias-variance trade-off is a fundamental concept in machine learning…
Last updated: 1st May, 2024 As a data scientist, understanding the nuances of various cost…
Last updated: 1st May, 2024 In this post, you will learn the concepts related to…