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.