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.
Python3
# 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.
Python3
# 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.
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
Python3
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: