Public holisdays

Use the Azure Open Datasets Public Holidays dataset, which already contains worldwide holidays from 1970 to 2099, including 2026, with the columns Country/Region, Date, and Holiday name.

In Python, download the 2026 holidays and save them as CSV like this:

from azureml.opendatasets import PublicHolidays
from datetime import datetime

# Define 2026 date range
start_date = datetime(2026, 1, 1)
end_date = datetime(2026, 12, 31)

# Load dataset filtered to 2026
hol = PublicHolidays(start_date=start_date, end_date=end_date)
hol_df = hol.to_pandas_dataframe()

# Keep only Country, Date, Holiday columns
hol_df = hol_df[["countryOrRegion", "date", "holidayName"]]

# Save to CSV
hol_df.to_csv("public_holidays_2026.csv", index=False)

This produces a public_holidays_2026.csv file with:

• countryOrRegion (Country)
• date (Date of the holiday)
• holidayName (Holiday)

If needed, open the CSV in Excel for further filtering or formatting.

References:

• Public Holidays
• PublicHolidays Class