Python | Pandas Series.dt.dayofweek

Michael Zippo 18.07.2021

Series.dt can be used to access series values as datetimelike and return multiple properties. Series.dt.dayofweek Pandas Series.dt.dayofweek returns the day of the week. The week is assumed to start on Monday, which is 0 and ends on Sunday, which is 6.

Syntax: Series.dt.dayofweek

Parameter: None

Returns: numpy array

Example # 1: Use the Series.dt.dayofweek attribute to return the day of the week for a given datetime in the underlying data of this Series object.

# pandas import as pd

import pandas as pd

# Create series

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’ ])

# Create index

idx = [ ’ Day 1’ , ’Day 2’ , ’Day 3’ , ’ Day 4’ , ’ Day 5’ ]

# set index

sr.index = idx

# Convert base data to date and time

sr = pd.to_datetime (sr)

# Print series

print (sr)

Output:

We will now use the Series.dt.dayofweek attribute to return the day of the week for a given date and time in the underlying data of this Series object .

# return day of the week

result = sr.dt.dayofweek

    
  # print the result  
   print   (result )

Output:

As we can see from the output, the attribute is Series.dt.dayofweek successfully accessed and returned the day of the week in the underlying data of this series object.

Example # 2: Use the Series.dt.dayofweek attribute to return the day of the week for a given datetime in the underlying data of a given Series object.

# import pandas as pd

import pandas as pd

   
  # Create a series  
   sr   =   pd.Series (pd.date_range ( ’ 2012-12-12 12: 12’  , periods   =   5  , freq   =   ’M’  )) 
   
  # Create an index  
   idx   =   [  ’Day 1’  ,  ’ Day 2’   ,   ’Day 3’  ,  ’ Day 4’  ,   ’Day 5’  ] 
   
  # set index  
   sr.index   =   idx 
   
  # Print series  
   print   (sr)

Output:

Now we will use the attribute Series.dt.dayofweek to return the day of the week for a given date and time in the underlying data of this Series object.

# return the day of the week

result = sr.dt.dayofweek

< p>
# print the result

print (result)

Output:

As we can see from the output, the Series.dt.dayofweek successfully accessed and returned the day of the week in the underlying data of this series object.