Skip to content
Related Articles

Related Articles

Save Article
Improve Article
Save Article
Like Article

Python | Pandas DatetimeIndex.weekday

  • Last Updated : 24 Dec, 2018

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.weekday 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. This attribute is similar to the DatetimeIndex.dayofweek.

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

Syntax: DatetimeIndex.weekday



Return: Index object

Example #1: Use DatetimeIndex.weekday 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.weekday

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.weekday 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.weekday

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.




My Personal Notes arrow_drop_up
Recommended Articles
Page :