extract month from date in python

Question

I have a column of dates in the format 2010-01-31. I can extract the year using

#extracting year year = df["date"].values year = [my_str.split("-")[0] for my_str in year] df["year"] = year 

I'm trying to get the month, but I don't understand how to get it on the second split.

Answer 1

import datetime  a = '2010-01-31'  datee = datetime.datetime.strptime(a, "%Y-%m-%d")   datee.month Out[9]: 1  datee.year Out[10]: 2010  datee.day Out[11]: 31 

Answer 2

Alternate solution

Create a column that will store the month:

data['month'] = data['date'].dt.month 

Create a column that will store the year:

data['year'] = data['date'].dt.year