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.

if you are using pandas you can make them datetime objects using `df.apply` which may be a more useful way to store the data — Padraic Cunningham, Sep 29 '14 at 18:04

Abdelouahab · Answer 1 · 2014-09-29T18:05:55.803

77

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

edited Sep 29 '14 at 18:05

answered Sep 29 '14 at 17:52

Abdelouahab

7,331
11
52
82

2

except the question asks for the month – Padraic Cunningham Sep 29 '14 at 17:55
5

@PadraicCunningham I would hope the OP wouldn't need so much hand-holding that they would see "then extract the year" and think "but wait, I really wanted to extract the month! I can't use this answer!" – SethMMorton Sep 29 '14 at 17:57
4

@SethMMorton, well the answer does not actually show how to extract the year either so unless you have used datetime before it may not be obvious to a beginner. – Padraic Cunningham Sep 29 '14 at 18:01
Using the code, I am getting: AttributeError: type object 'datetime.datetime' has no attribute 'datetime' – qqqqq Apr 16 '22 at 23:00

score 25 · Answer 2 · edited Jun 28 '20 at 16:25

25

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

edited Jun 28 '20 at 16:25

Matt Ke

3,599
12
30
49

answered Jun 28 '20 at 15:41

Michael Kramer

259
3
2

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.dt.html – Michael Kramer Jun 28 '20 at 15:41
How do I get one column in 'year-month' format? For example: '2022-07' – Nina van Bruggen Jul 21 '22 at 11:37

score 5 · Answer 3 · answered Sep 29 '14 at 17:50

5

>>> a='2010-01-31'
>>> a.split('-')
['2010', '01', '31']
>>> year,month,date=a.split('-')
>>> year
'2010'
>>> month
'01'
>>> date
'31'

answered Sep 29 '14 at 17:50

g4ur4v

3,210
5
32
57

36

Really? What did you have against `datetime` standard lib? – Mauro Baraldi Sep 29 '14 at 18:24
1

@MauroBaraldi perhaps it's too mainstream to him – rolodex Jun 16 '21 at 02:33

score 3 · Answer 4 · answered Jan 03 '22 at 17:37

3

if you use datetime, you can simply add .month at the end of the datetime method

>>> from datetime import datetime, date, time, timedelta, timezone
>>> datetime.now()
datetime.datetime(2022, 1, 3, 11, 33, 16, 609052)
>>> datetime.now().date()
datetime.date(2022, 1, 3)
>>> datetime.now().date().month
1

answered Jan 03 '22 at 17:37

Koops

422
3
11

1

I understand it is not directly answering the question, but at the same time, it is also addressing the splitting of date formatting. This might come in handy to someone who is having a similar problem. – Koops Jan 03 '22 at 17:38

extract month from date in python

4 Answers4

Linked