w3resource

Pandas: Calculate all Thursdays between two given days


21. Calculate All Thursdays Between Two Dates

Write a Pandas program to calculate all Thursdays between two given days.

Sample Solution:

Python Code :

import pandas as pd
thursdays  = pd.date_range('2020-01-01', 
                           '2020-12-31', freq="W-THU")
print("All Thursdays between 2020-01-01 and 2020-12-31:\n")
print(thursdays.values)

Sample Output:

All Thursdays between 2020-01-01 and 2020-12-31:

['2020-01-02T00:00:00.000000000' '2020-01-09T00:00:00.000000000'
 '2020-01-16T00:00:00.000000000' '2020-01-23T00:00:00.000000000'
 '2020-01-30T00:00:00.000000000' '2020-02-06T00:00:00.000000000'
 '2020-02-13T00:00:00.000000000' '2020-02-20T00:00:00.000000000'
 '2020-02-27T00:00:00.000000000' '2020-03-05T00:00:00.000000000'
 '2020-03-12T00:00:00.000000000' '2020-03-19T00:00:00.000000000'
 '2020-03-26T00:00:00.000000000' '2020-04-02T00:00:00.000000000'
 '2020-04-09T00:00:00.000000000' '2020-04-16T00:00:00.000000000'
 '2020-04-23T00:00:00.000000000' '2020-04-30T00:00:00.000000000'
 '2020-05-07T00:00:00.000000000' '2020-05-14T00:00:00.000000000'
 '2020-05-21T00:00:00.000000000' '2020-05-28T00:00:00.000000000'
 '2020-06-04T00:00:00.000000000' '2020-06-11T00:00:00.000000000'
 '2020-06-18T00:00:00.000000000' '2020-06-25T00:00:00.000000000'
 '2020-07-02T00:00:00.000000000' '2020-07-09T00:00:00.000000000'
 '2020-07-16T00:00:00.000000000' '2020-07-23T00:00:00.000000000'
 '2020-07-30T00:00:00.000000000' '2020-08-06T00:00:00.000000000'
 '2020-08-13T00:00:00.000000000' '2020-08-20T00:00:00.000000000'
 '2020-08-27T00:00:00.000000000' '2020-09-03T00:00:00.000000000'
 '2020-09-10T00:00:00.000000000' '2020-09-17T00:00:00.000000000'
 '2020-09-24T00:00:00.000000000' '2020-10-01T00:00:00.000000000'
 '2020-10-08T00:00:00.000000000' '2020-10-15T00:00:00.000000000'
 '2020-10-22T00:00:00.000000000' '2020-10-29T00:00:00.000000000'
 '2020-11-05T00:00:00.000000000' '2020-11-12T00:00:00.000000000'
 '2020-11-19T00:00:00.000000000' '2020-11-26T00:00:00.000000000'
 '2020-12-03T00:00:00.000000000' '2020-12-10T00:00:00.000000000'
 '2020-12-17T00:00:00.000000000' '2020-12-24T00:00:00.000000000'
 '2020-12-31T00:00:00.000000000']

For more Practice: Solve these Related Problems:

  • Write a Pandas program to generate a date range and then extract all dates that fall on a Thursday.
  • Write a Pandas program to compute and list every Thursday between two specified dates using Pandas offsets.
  • Write a Pandas program to identify all Thursdays in a time-series and then mark each with a custom label.
  • Write a Pandas program to filter a time-series to include only Thursdays and then display their corresponding week numbers.

Go to:


Previous: Write a Pandas program to subtract two timestamps of same time zone or different time zone.
Next: Write a Pandas program to find the all the business quarterly begin and end dates of a specified year.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.