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

Question

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?

Achieving the result in one line is probably going to be a lot less readable than what you already have — Nick, Apr 24 '22 at 08:46
`df['Month'], df['Year'] = df["Date"].dt.month, df["Date"].dt.year` — Abhyuday Vaish, Apr 24 '22 at 08:46
@AbhyudayVaish Okay that's one good way to keep it both readable and one line...now I feel dumb — Zero, Apr 24 '22 at 09:37

score 1 · Accepted Answer · answered Apr 24 '22 at 09:37

1

Here's how you can do it:

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

answered Apr 24 '22 at 09:37

Abhyuday Vaish

2,357
5
11
27

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

1 Answers1