Global holidays table in Python

make_holiday_table.py

import pandas as pd
from holidays import country_holidays, list_supported_countries


def main():
    """Get a global holidays table."""
    years = 2022, 2023, 2024
    all_holidays = {
        ct: country_holidays(ct, years=years) for ct in list_supported_countries().keys()
    }

    df = pd.DataFrame.from_dict(all_holidays).melt(ignore_index=False).dropna()
    df.index = pd.to_datetime(df.index)
    df.index.name = "Date"
    df.columns = ["Country", "Holiday"]
    df = df.sort_values(["Date", "Country"], ascending=[True, True])
    df.to_csv("global_holidays_2022_2024.csv")


if __name__ == "__main__":
    main()

To run:

pip install holidays pandas
python make_holiday_table.py