'How to extract month and year from a datetime series and store them into two separate columns?

I have a dataframe with a Date column that has datetime objects in it. I can extract the month and year from the Date column and store them in columns of the respective names using the code below.

df["Month"] = df["Date"].dt.month
df["Year"] = df["Date"].dt.year

But is there a way to do this in just one line?



Solution 1:[1]

Here's how you can do it:

df['Month'], df['Year'] = df["Date"].dt.month, df["Date"].dt.year 

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Abhyuday Vaish