Pandas Series dt.day_name() Method | Get Day From Date in Pandas

Pandas dt.day_name() method returns the day names of the DateTime Series objects with specified locale.

Example

import pandas as pd
sr = pd.Series(['2012-12-31 08:45', '2019-1-1 12:30', '2008-02-2 10:30',
                '2010-1-1 09:25', '2019-12-31 00:00'])
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
sr.index = idx
sr = pd.to_datetime(sr)
result = sr.dt.day_name(locale = 'English')
print(result)

Output:

Syntax

Syntax: Series.dt.day_name(locale) 

Parameter

• locale : Locale determining the language in which to return the day name. Default is English locale. 

Returns: Index of day names.

How to Extract Day Name from Date in Pandas Series

To extract the day name from a given date in the Pandas Series we use the Series.dt.day_name() method of the Pandas library in Python.

Let us understand it better with an example:

Example:

Use the dt.day_name() function to return the day names of the underlying DateTime data in the given Series object.

# importing pandas as pd
import pandas as pd

# Creating the Series
sr = pd.Series(pd.date_range('2012-12-31 09:45', periods = 5, freq = 'Q',
                            tz = 'Europe / Berlin'))

# Creating the index
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']

# set the index
sr.index = idx

# Print the series
print(sr)

Output :

Now we will use the Series.dt.day_name() function to return the names of the day of each timestamp in the given series object.

# return day name in french
result = sr.dt.day_name(locale = 'French')

# print the result
print(result)

Output :

As we can see in the output, the Series.dt.day_name() function has successfully returned the names of the day in the specified language.