Home Applications generate-dates

generate-dates

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
3.5
1 reviews
0
Awards
94
Views
0
IPM installs
0
0
Details
Releases
Reviews
Issues
Pull requests
Generate a CSV file containing dates with additional information

What's new in this version

Initial Release

generate-dates

Generate Dates Utility (not a dating app!)

This utility generates a CSV file containing dates between 1990-01-01 and 2030-12-31, along with some relevant information about each date.

This is especially useful for InterSystems Adaptive Analytics users because AtScale requires an independent dates table to use dates in your AtScale models.

Sample dates.csv file is included in the repo, you can simply download it if the date range and additional columns are good enough for you.

Usage

To use the utility, simply run the generate_dates.py script. The generated CSV file will be saved in the data subfolder. If the subfolder does not exist, it will be created.

Generated CSV

The CSV file contains the following columns:

  • Day: The date in YYYY-MM-DD format
  • Year: The year of the date
  • Month: The month of the date as an integer
  • MonthName: The name of the month
  • Weekday: The day of the week as an integer (0 = Monday, 1 = Tuesday, etc.)
  • WeekdayName: The name of the day of the week
  • IsWeekend: True if the day is a Saturday or Sunday, False otherwise
  • IsHoliday: True if the day is a US federal holiday, False otherwise
  • Holiday: The name of the holiday (empty string if not a holiday)

Dependencies

This utility requires the following Python packages:
• datetime
• holidays

These packages can be installed using pip:

pip install datetime holidays

License

This project is licensed under the MIT License - see the LICENSE file for details.

Made with
Version
1.0.004 May, 2023
Category
Analytics
Works with
InterSystems IRISInterSystems IRIS for HealthInterSystems IRIS BI
First published
04 May, 2023