Skip to Content

Pandas – Get Month from Date

In this tutorial, we’ll try to solve 2 problems:

  1. Extract the month from a specific cell of dataframe
  2. Extract the month from all the cells in the column of a dataframe

Datatype conversion:

Before going through the below solutions for the problem, we first need to make sure that the datatype of the date_column for which we need the month has to be pandas datetime. In case you have strings in the column then try to use pandas.to_datetime method to convert the datatype of the column to pandas datetime.

code:

df['date_column'] = pd.to_datetime(df['date_column'])

The above line of code changes the datatype of the ‘date_column’ column to pandas datetime.

Problem – 1: Extract month from a specific cell of dataframe

Here, we’re trying to extract the month from a specific cell of a pandas dataframe object. To achieve this we need to follow the below steps.

Highlighted programs for you

Important information for students ×

Put simply, All Star is in the business of connecting students and schools. We help students find schools that are great matches for their educational needs, personal preferences and lifestyles, and schools pay us for our work.

Here's a quick Q & A of information we think you should know if you choose to use our websites. The main takeaways: Using our services is free, but starting and completing a degree, certificate or diploma program takes commitment and effort and should be considered carefully.

1. How do you provide your services for free?

Schools pay to advertise on our sites. This allows us to offer our service to prospective students like you for free.

Schools place a very high priority on enrolling students who go on to graduate. By using All Star's focused, information-rich services, schools can be more confident that the prospective students we introduce them to are truly committed to their education and to succeeding once they're enrolled in school.

2. How do you differ from your competitors?

There are other companies out there that do what we do. But there is no one that does it with more integrity or respect for our users and their choices. We put you, the student, in control. You get to choose the schools you're interested in, and you get to choose what programs you'd like to learn more about. We will never submit your contact information to a school without your consent.

3. Do you really work with ALL schools?

No. Our listings are not exhaustive, we do not list all schools, but they do include a rich selection of options. We believe this wide variety of options from hundreds of schools meets the needs of most prospective students who visit our sites. We partner with smaller schools that specialize in one particular career field, such as Pima Medical Institute, as well as world-class, multi-discipline institutions like the University of Southern California.

4. Is getting a degree really going to open up doors for me?

We really want you to succeed in the program you choose. So does your school. But we feel compelled to be very frank and upfront: You must work hard and stay committed to graduate. And assuming you do graduate, there is no guarantee you will find a job in your chosen field, or any job for that matter.

Obtaining an education has many personal benefits and can also improve your financial prospects. However, it's important to keep in mind that obtaining an education does not guarantee financial success or even a job. Job markets vary greatly by region, state, and even locally, and are affected by trends in the national economy and even international events. Other factors affecting your job-hunting success may include your job history and experience, and your level of education, degree, or certificate type. Your area of specialization plays a role, too.

5. If I do find a job, what can I expect in terms of salary?

The government publishes a great deal of information related to hundreds of jobs on the Bureau of Labor Statistics (BLS) website. We use this as a resource for many of the articles on the All Star websites. As comprehensive as the BLS information is, it is neither complete nor entirely accurate. The BLS salary information we publish is a national average. Actual salaries for a particular job or skill may be different where you live. For example, if you live in a large city or where the job market for particular skills is especially competitive, such as Silicon Valley in California, you're likely to receive a higher wage or salary for the same job than you would in a rural or economically depressed market. Other factors that can affect salary rates include the size of the employer, union contracts and governmental regulations to name a few.

6. Where are you located? How can I contact you?

All Star Directories is located at P.O. Box 1677 Renton, WA 98057. You can reach us at (206) 436-7500 or at customerservice@allstardirectories.com.

Flatiron School

Flatiron School

Data Science Bootcamp
Product Design UX/UI Bootcamp

University of Maryland Global Campus

University of Maryland Global Campus

Cloud Computing Systems Master's
Digital Forensics & Cyber Investigation Master's

Creighton University

Creighton University

Health Informatics Master's

  1. Make sure that the datatype of the column is pandas datetime. If not, then use the above step specified in Datatype conversion section
  2. Once, you make sure the datatype of the column is pandas datetime, then select the specific cell which you need to extract the month from.
  3. Then use the .month attribute over the selected cell, which gives the month of the date specified by the cell.

Basic Syntax:

df['date_column'] = pd.to_datetime(df['date_column'])
df['date_column'][0].month

The above code first converts the data type of the column to pandas datetime and then extracts the month of the specified cell using the .month attribute which is an inbuilt attribute for the timestamp datatype.

Examples

Now, let us have a look at some of the examples to demonstrate the above solution.

Note:
In case you don’t have any dataframe to try the solution, use the below implementation to create a dataframe with some dates as cells. The below-given dataframe will be used to demonstrate all below examples.

import pandas as pd
dates = {'date_column':['14 - 05 - 2017', '2017', '07 - 09 - 2017']}
df = pd.DataFrame(dates)
df['date_column'] = pd.to_datetime(df['date_column'], dayfirst = True)
df

Output:

pandas dataframe with datetime type column

Example – 1

code:

df['date_column'][0].month

Output:


5

Example – 2

code:

df['date_column'][2].month

Output:

9

Problem – 2: Extract the month from all the cells in the column of a dataframe

get month from date in a pandas dataframe

Here, we’re trying to extract the month from all the cells in the column of a dataframe object. To achieve this we need to follow the below steps.

  1. Make sure that the datatype of the column is pandas datetime. If not, then use the above step specified in Datatype conversion section
  2. Then use the .dt.month attribute over the selected column which gives the month of the all dates in the column.

Basic Syntax:

df['date_column'] = pd.to_datetime(df['date_column'])
df['date_column'].dt.month

The above code first converts the data type of the column to pandas datetime and then extracts the month of all the cells in the column using the .dt.month attribute.

Examples

Now, let us have a look at some of the examples to demonstrate the above solution.

Note:
In case you don’t have any dataframe to try the solution, use the below implementation to create a dataframe with some dates as cells. The below-given dataframe will be used to demonstrate all below examples.


import pandas as pd
dates = {'date_column':['14 - 05 - 2017', '2017', '07 - 09 - 2017']}
df = pd.DataFrame(dates)
df['date_column'] = pd.to_datetime(df['date_column'], dayfirst = True)
df

Output:

pandas dataframe with datetime type column

Example – 1

code:

df['date_column'].dt.month

Output:

0    5
1    1
2    7
Name: date_column, dtype: int64

Summary

In this we looked at 2 different problems and tried to solve each one separately

  1. Extract the month from a specific cell of dataframe

    Solution: Using .month attribute

    Result: Month of the date (integer)

  2. Extract the month from all the cells in the column of a dataframe

    Solution: Using .dt.month attribute

    Result: Series of interger values specifying month of each date in the cells

You might also be interested in –


Subscribe to our newsletter for more informative guides and tutorials.
We do not spam and you can opt out any time.


Author

  • Chaitanya Betha

    I'm an undergrad student at IIT Madras interested in exploring new technologies. I have worked on various projects related to Data science, Machine learning & Neural Networks, including image classification using Convolutional Neural Networks, Stock prediction using Recurrent Neural Networks, and many more machine learning model training. I write blog articles in which I would try to provide a complete guide on a particular topic and try to cover as many different examples as possible with all the edge cases to understand the topic better and have a complete glance over the topic.

    View all posts