Python | Pandas DatetimeIndex.dayofweek

Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.

Pandas DatetimeIndex.dayofweek attribute outputs the ordinal value of the day of the week for each entries of the DatetimeIndex object. The values for Monday to Sunday ranges from 0 to 6.

Syntax: DatetimeIndex.dayofweek

Return: Index object

Example #1: Use DatetimeIndex.dayofweek attribute to find the ordinal value of the day of the week for each entries in the DatetimeIndex object.

# importing pandas as pd
import pandas as pd

# Create the DatetimeIndex
# Here 'D' represents Daily frequency
didx = pd.DatetimeIndex(start ='2000-01-10 06:30', freq ='D',
                            periods = 3, tz ='Asia/Calcutta')

# Print the DatetimeIndex
print(didx)

Output :

Now we want to find ordinal value of the day of the week for each entries in the DatetimeIndex object.

# find the ordinal value of the day
# of the week for each entries present in the object
didx.dayofweek

Output :

As we can see in the output, the function has returned an Index object containing the ordinal values of the days of the weeks for each entry of the DatetimeIndex object.

Example #2: Use DatetimeIndex.dayofweek attribute to find the ordinal value of the day of the week for each entries in the DatetimeIndex object.

# importing pandas as pd
import pandas as pd

# Create the DatetimeIndex
# Here 'M' represents monthly frequency
didx = pd.DatetimeIndex(start ='2014-08-01 10:05:45', freq ='M',
                               periods = 5, tz ='Asia/Calcutta')

# Print the DatetimeIndex
print(didx)

Output :

Now we want to find ordinal value of the day of the week for each entries in the DatetimeIndex object.

# find the ordinal value of the day of the week
# for each entries present in the object
didx.dayofweek

Output :

As we can see in the output, the function has returned an Index object containing the ordinal values of the days of the weeks for each entry of the DatetimeIndex object.