Extract the public holidays for each federal geman state ("Bundesland") - also extract the vacations ("Schulferien") for a given year.

You can adapt this for other countries as well. Let ChatGPT give you a list of holidays and vacations.

You will have a list of the dates and you can then match which day is a holiday or when schools will be closed. You can count how many states are on holiday. If it is 16 it is a national holiday.

You might have to deal with regional special holiday like the 8th of August in Augsburg "Hohes Friedensfest" or carnival ("Rosenmontag").

--------

Also: Calculate the number of working days between any give dates. Excluding Saturdays and Sundays and also a given list of dates

--------

Also: Check how many Bundesländer's schools will be closed on any given day - for ML you could give weights by the population or use this if you have a location based task

--------

Also: Mark gap days (Brückentage) that are between a public holiday and a weekend for example

	Go back to parent directory
	data
	dbc_compressed
	dbf_uncompressed
	DATASUS - Download DBC Files
	DATASUS - Import DBC Files - Convert into DBF and Parquet

Examples