The dt.weekday attribute returns the day of the week. It is assumed the week starts on Monday, which is denoted by 0, and ends on Sunday which is denoted by 6.
Example
import pandas as pd
sr = pd.Series(['2012-10-21 09:30', '2019-7-18 12:30', '2008-02-2 10:30',
'2010-4-22 09:25', '2019-11-8 02:22'])
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
sr.index = idx
sr = pd.to_datetime(sr)
result = sr.dt.weekday
print(result)
|
Output:
Syntax
Syntax: Series.dt.weekday
Parameter: None
Returns: Series of integers representing week day.
How to Get Day of Week as Integer from Date in Pandas Series
To extract the day of the week as an integer from a date in Pandas Series we use the Series.dt.weekday attribute of the Pandas library in Python.
Integer Range from 0 to 6, where 0 is the beginning meaning Monday, and 6 is the end meaning Sunday.
Let us understand it better with an example:
Example:
Use the dt.weekday attribute to return the day of the week for the given DateTime in the underlying data of the given Series object.
# importing pandas as pd import pandas as pd
# Creating the Series sr = pd.Series(pd.date_range('2012-12-12 12:12', periods = 5, freq = 'M'))
# 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.weekday attribute to return the day of the week for the given DateTime in the underlying data of the given Series object.
# return the day of week result = sr.dt.weekday
# print the result print(result)
|
Output :
As we can see in the output, the Pandas dt.weekday attribute has successfully accessed and returned the day of the week in the underlying data of the given series object.