CODEWITHSUNDEEP
pythondatetime
huhh hhbhb
huhh hhbhb

Reputation: 603

Python - Convert Month Name to Integer

How can I convert 'Jan' to an integer using Datetime? When I try strptime, I get an error time data 'Jan' does not match format '%m'

Upvotes: 18

Views: 47112

Answers (4)

Kernel
Kernel

Reputation: 761

from calendar import month_abbr
month = "Jun"
for k, v in enumerate(month_abbr):
    if v == month:
        month = k
        break
print(month)

6

You will get the number of month 6

Upvotes: 1

AndrewSmiley
AndrewSmiley

Reputation: 1963

Off the cuff- Did you try %b?

Upvotes: 1

BlivetWidget
BlivetWidget

Reputation: 11093

This is straightforward enough that you could consider just using a dictionary, then you have fewer dependencies anyway.

months = dict(Jan=1, Feb=2, Mar=3, ...)
print(months['Jan'])
>>> 1

Upvotes: 1

Martijn Pieters
Martijn Pieters

Reputation: 1125368

You have an abbreviated month name, so use %b:

>>> from datetime import datetime
>>> datetime.strptime('Jan', '%b')
datetime.datetime(1900, 1, 1, 0, 0)
>>> datetime.strptime('Aug', '%b')
datetime.datetime(1900, 8, 1, 0, 0)
>>> datetime.strptime('Jan 15 2015', '%b %d %Y')
datetime.datetime(2015, 1, 15, 0, 0)

%m is for a numeric month.

However, if all you wanted to do was map an abbreviated month to a number, just use a dictionary. You can build one from calendar.month_abbr:

import calendar
abbr_to_num = {name: num for num, name in enumerate(calendar.month_abbr) if num}

Demo:

>>> import calendar
>>> abbr_to_num = {name: num for num, name in enumerate(calendar.month_abbr) if num}
>>> abbr_to_num['Jan']
1
>>> abbr_to_num['Aug']
8

Upvotes: 27

Related Questions