Skip to main content

Calculating the number of business days between dates in Python

Written By: Aryav Nagar


Calculating the number of business days between varying lengths of time, even excluding federal holidays, may seem like a tricky problem to solve, but the solution is quite simple. While developing Stockscast, an AI-based stock market forecaster, I came across this issue as I needed to find the number of days the stock exchange would be open throughout the year. The solution I found involved the use of pandas.tseries.holiday.USFederalHolidayCalendar() and pandas.tseries.offsets.CustomBusinessDay() functions are found in the Pandas library. By creating a custom calendar, using the CustomBusinessDay function, with the frequency of USFederalHolidayCalendar, we can create a calendar excluding both weekends and federal holidays.

Next, find the length of time you want to calculate the number of business days in. In my case, I needed to find the number of business days between one week, one month, three months, six months, and one year from now. Finally, we can utilize our custom calendar to find the number of business days within these periods. By using the pandas.date_range() function, we can find the number of days between our start and end date using a frequency parameter: this would be our business day calendar we declared above. By finding the length of this argument, we can calculate the number of business days present between the start and end dates.


Full code below:


#Import the necessary packages import pandas as pd from pandas.tseries.holiday import USFederalHolidayCalendar from pandas.tseries.offsets import CustomBusinessDay #Other packages required to calculate current date varying time ranges from datetime import date from dateutil.relativedelta import relativedelta #Use the CustomBusinessDay function to create a calendar based on the USFederalHolidayCalendar us_business_days = CustomBusinessDay(calendar=USFederalHolidayCalendar()) #Calculate the dates from varying lengths of time, starting from the current date today = date.today() one_week = date.today() + relativedelta(weeks=+1) one_month = date.today() + relativedelta(months=+1) three_month = date.today() + relativedelta(months=+3) six_month = date.today() + relativedelta(months=+6) one_year = date.today() + relativedelta(years=+1) #Find the number of business days from your start date to your end date using a frequency of the us_business_days calendar (declared above) one_week_business_days = len(pd.date_range(start=today,end=one_week, freq=us_business_days)) one_month_business_days = len(pd.date_range(start=today,end=one_month, freq=us_business_days)) three_month_business_days =len(pd.date_range(start=today,end=three_month, freq=us_business_days)) six_month_business_days = len(pd.date_range(start=today,end=six_month, freq=us_business_days)) one_year_business_days = len(pd.date_range(start=today,end=one_year, freq=us_business_days))


Labels:

Comments

Post a Comment

Popular posts from this blog

React - Uncaught TypeError: destroy is not a function

Written by Aryan Mittal While experimenting with useEffect hooks in React and React Native, I came across the following error: Uncaught TypeError: destroy is not a function and my app was unable to run. After debugging and searching around, I found the cause and how to solve it. A simplified version of my code looked like this: The key here is that myFunction is async and the shorthand arrow function syntax I used. The reason the simple code above was crashing my app is due to how the useEffect hook, async functions, and the shorthand arrow function syntax works. One feature of the useEffect hook is a cleanup function. If you return anything from the useEffect hook function, it must be a cleanup function. This function will run when the component unmounts. This can be thought of as roughly equivalent to the componentWillUnmount lifecycle method in class components. In JavaScript, functions marked with the async keyword enable the use of the await feature, which lets developers paus...
Post a Comment
Read more

Achieving the iOS “glass” blur with React Native

Written By: Aryan Mittal Perhaps the most common component in every mobile app is the header. It tells your user where they are in your app, and it’s at the very top of the screen. So, it’s crucial to have a polished and native-feeling header in your React Native apps. I use the React Navigation library for Voluntime ’s mobile app, and I wanted to achieve the iOS “frosted glass” blur effect that Apple is known for. Most of Apple’s iOS apps utilize the blurred header, including Settings, the App Store, Notes, and Reminders. It gives the user a hint about what’s hiding behind the header, and it makes the app feel polished and thought out. Since I was using React Navigation, I started by searching for “react navigation blurred header” on Google. The results recommended writing your own custom header or installing additional libraries to achieve the blur effect. This wasn’t something I wanted to do for such a small change, so I dug deeper into React Navigation’s documentation. Finally, aft...
1 comment
Read more