While working on assigning dates to pages in the ANU Archives' Stock Exchange records, I needed information about holidays in NSW. So here we go...
import datetime
import calendar
import arrow
import pandas as pd
from IPython.display import display, FileLink
What days was the Stock Market closed? I'm assuming it will be for the standard bank holidays. These are set out in legislation. See AustLII:
Of course, the legislation also allowed the government to proclaim other holidays as required, so there could be ones that I'm missing...
If any of the above fall on Sunday, there's a holiday on the following Monday. If 26 December is a Monday, holiday is on the Tuesday.
If any of the above are not on a Monday, the holiday will be on the following Monday.
If any of the above fall on Sunday, there's a holiday on the following Monday. If 26 December is a Monday, holiday is on the Tuesday.
If any of the above are not on a Monday, the holiday will be on the following Monday.
If 1 Jan or 25 Dec fall on Sunday, there's a holiday on the following Monday. If 26 December is a Monday, holiday is on the Tuesday. This seems to indicate that if Boxing Day is on a Sunday, there's no holiday on Monday, but in 1915 when this happened there was a holiday on Monday. So it seems Boxing Day was in practice treated like NY Day and Christmas Day. Same goes for Australia (Anniversary) Day, in 1913 and 1919 ther was a holiday Monday.
If any of the above are not on a Monday, the holiday will be on the following Monday.
If 1 or 26 Jan or 25 or 26 Dec fall on Sunday, there's a holiday on the following Monday. If 26 December is a Monday, holiday is on the Tuesday.
If any of the above are not on a Monday, the holiday will be on the following Monday.
If any of the above fall on Sunday, there's a holiday on the following Monday. If 26 December is a Monday, holiday is on the Tuesday.
If any of the above are not on a Monday, the holiday will be on the following Monday.
It seems that from 1935 it was decided that if Australia (Anniversary) Day didn't fall on a Monday, the holiday would be on the following Monday. See: https://trove.nla.gov.au/newspaper/article/17128813
But in 1938 it was held on the actual day because of the 150th celebtrations.
Despite what the legislation seems to indicate, it appears that if any of 1 Jan, 26 Jan, 25 April, 25 Dec, 26 Dec fell on a Sunday, there was a holiday on the Monday. In any case, that's what I'll assume unless proven otherwise.
1901: Anniversary Day was cancelled
Although it's not in the legislation, there was also a Labour Day holiday on the first Monday in October.
See https://www.assa.org.au/edm.
Victoria was born on 24 May 1819. She died on 22 January 1901.
Edward VII was born on 9 November 1841. He died on 6 May 1910.
George V was born on 3 June 1865. He died on 20 January 1936.
Edward VIII was born on 23 June 1894. He abdicated on 11 December 1936.
George VI was born on 14 December 1895. He died on 6 February 1952.
Albert Edward: born 9 November 1841, became King 22 January 1901
George Frederick Ernest Albert: born 3 June 1865, became king 6 May 1910
Edward Albert Christian George Andrew Patrick David: born 23 June 1894, became king 20 January 1936
This holiday was replaced by Anzac Day in 1925.
# Dates from https://www.assa.org.au/edm
e_dates = """
15th April 1900 12th April 1925 9th April 1950 30th March 1975
7th April 1901 4th April 1926 25th March 1951 18th April 1976
30th March 1902 17th April 1927 13th April 1952 10th April 1977
12th April 1903 8th April 1928 5th April 1953 26th March 1978
3rd April 1904 31st March 1929 18th April 1954 15th April 1979
23rd April 1905 20th April 1930 10th April 1955 6th April 1980
15th April 1906 5th April 1931 1st April 1956 19th April 1981
31st March 1907 27th March 1932 21st April 1957 11th April 1982
19th April 1908 16th April 1933 6th April 1958 3rd April 1983
11th April 1909 1st April 1934 29th March 1959 22nd April 1984
27th March 1910 21st April 1935 17th April 1960 7th April 1985
16th April 1911 12th April 1936 2nd April 1961 30th March 1986
7th April 1912 28th March 1937 22nd April 1962 19th April 1987
23rd March 1913 17th April 1938 14th April 1963 3rd April 1988
12th April 1914 9th April 1939 29th March 1964 26th March 1989
4th April 1915 24th March 1940 18th April 1965 15th April 1990
23rd April 1916 13th April 1941 10th April 1966 31st March 1991
8th April 1917 5th April 1942 26th March 1967 19th April 1992
31st March 1918 25th April 1943 14th April 1968 11th April 1993
20th April 1919 9th April 1944 6th April 1969 3rd April 1994
4th April 1920 1st April 1945 29th March 1970 16th April 1995
27th March 1921 21st April 1946 11th April 1971 7th April 1996
16th April 1922 6th April 1947 2nd April 1972 30th March 1997
1st April 1923 28th March 1948 22nd April 1973 12th April 1998
20th April 1924 17th April 1949 14th April 1974 4th April 1999
"""
easter_exceptions = {
datetime.date(1942, 4, 6)
}
def check_exceptions(date):
if date in easter_exceptions:
return True
# Create a list of easter dates indexed by year.
e_dates = e_dates.split(' ')
e_dates = [d.strip() for d in e_dates]
easter_dates = {}
for e in e_dates:
edate = arrow.get(e, 'Do MMMM YYYY')
good_friday = edate.shift(days=-2)
easter_saturday = edate.shift(days=-1)
easter_monday = edate.shift(days=+1)
easter_dates[edate.year] = []
if not check_exceptions(good_friday.date()):
easter_dates[edate.year].append((good_friday.date(), 'Good Friday'))
if not check_exceptions(easter_saturday.date()):
easter_dates[edate.year].append((easter_saturday.date(), 'Easter Saturday'))
if not check_exceptions(easter_monday.date()):
easter_dates[edate.year].append((easter_monday.date(), 'Easter Monday'))
# Get Easter dates for 1930
easter_dates[1943]
[(datetime.date(1943, 4, 23), 'Good Friday'), (datetime.date(1943, 4, 24), 'Easter Saturday'), (datetime.date(1943, 4, 26), 'Easter Monday')]
Holidays were proclaimed for a variety of reasons. Here are some that I have found so far:
Below is the information summarised above converted into a machine-readable form. The four values for each holiday are:
0
– holiday is on the given date1
– holiday is on the given date unless it falls on a Sunday, then it's on a Monday. (And Boxing Day gets shifted to Tuesday if on a Monday.)2
– if the given date is not on a Monday then the holiday is on the next Mondaygeneral_holidays = {
'1900': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 1, 'Anniversary Day'), # Australia Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1901': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
# (26, 1, 1, 'Anniversary Day'), Cancelled in 1901!
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1902_1904': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 1, 'Anniversary Day'), # Australia Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1905': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1906_1921': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 1, 'Anniversary Day'), # Australia Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1922_1934': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 1, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day - included in legislation from 1925, but proclaimed in 1922-4
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1935_1937': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1938': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 0, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1939': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1940': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
# Bank holiday cancelled because of war
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1941': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1942': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(28, 12, 1, 'In place of New Year''s Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1943': [
# (1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 0, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
],
'1944_1950': [
(1, 1, 1, 'New Year''s day'),
(25, 12, 1, 'Christmas Day'),
(26, 12, 1, 'Boxing Day'),
(26, 1, 2, 'Anniversary Day'), # Australia Day,
(25, 4, 1, 'Anzac Day'), # Anzac Day
(1, 8, 2, 'Bank Holiday'), # Bank holiday
(1, 10, 2, 'Labour Day'), # Labour Day
]
}
royal_holidays = {
'1900': [
(25, 5, 0, 'Queen\'s Birthday'),
(9, 11, 2, 'Prince of Wales\'s Birthday')
],
'1901': [
(2, 2, 0, 'Day of Mourning for Queen'), # Mourning
(9, 11, 2, 'King\'s Birthday'),
(3, 6, 2, 'Prince of Wales\'s Birthday')
],
'1902_1909': [
(9, 11, 2, 'King\'s Birthday'),
(3, 6, 2, 'Prince of Wales\'s Birthday')
],
'1910': [
(20, 5, 0, 'Day of Mourning for King'), # Mourning
(3, 6, 2, 'King\'s Birthday'),
(27, 6, 0, 'Prince of Wales\'s Birthday')
],
'1911': [
(3, 6, 1, 'King\'s Birthday'),
(22, 6, 0, 'Coronation'), # Coronation
(22, 8, 0, 'Prince of Wales\'s Birthday')
],
'1912_1919': [
(3, 6, 2, 'King\'s Birthday'),
(23, 6, 2, 'Prince of Wales\'s Birthday')
],
'1920': [
(16, 6, 0, 'Prince of Wales\'s Visit'), # Prince of Wlaes visit
(17, 6, 0, 'Prince of Wales\'s Visit')
],
'1921_1924': [
(3, 6, 2, 'King\'s Birthday'),
(23, 6, 2, 'Prince of Wales\'s Birthday')
],
'1925_1935': [
(3, 6, 2, 'King\'s Birthday')
],
'1936': [
# (20, 5, 0, 'King\'s funeral'), # King's funeral
(23, 6, 2, 'King\'s Birthday')
],
'1937': [
(12, 5, 0, 'Coronation') # Coronation
],
'1938_1939': [
(9, 6, 2, 'King\'s Birthday') # 2nd monday in June
],
'1940': [
(17, 6, 2, 'King\'s Birthday') # For some reasons this was held a week later than usual in 1940
],
'1941': [
(16, 6, 2, 'King\'s Birthday') # For some reasons this was held a week later than usual in 1940
],
'1942': [
(9, 6, 2, 'King\'s Birthday')
],
'1943': [
(7, 6, 2, 'King\'s Birthday') # For some reasons this was held earlier than usual
],
'1944': [
(9, 6, 2, 'King\'s Birthday')
],
'1945': [
(18, 6, 2, 'King\'s Birthday')
],
'1946': [
(17, 6, 2, 'King\'s Birthday')
],
'1947': [
(16, 6, 2, 'King\'s Birthday') # 2nd monday in June
],
'1948_1950': [
(9, 6, 2, 'King\'s Birthday') # 2nd monday in June
]
}
other_holidays = {
'1901': [
(27, 5, 0, 'Visit of the Duke of Cornwall'),
(28, 5, 0, 'Visit of the Duke of Cornwall'),
(3, 7, 0, 'Polling day')
],
'1908': [
(20, 8, 0, 'Visit of the American Fleet'),
(24, 8, 0, 'Visit of the American Fleet'),
],
'1915': [
(24, 5, 0, 'Empire Day')
],
'1916': [
(28, 10, 0, 'Conscription referendum'),
(18, 11, 0, 'Postponed 8-hour-day procession')
],
'1945': [
(9, 5, 0, 'VE Day')
],
'1946': [
(10, 6, 0, 'Victory Day')
]
}
def not_on_sunday(day, month, year):
'''
If these holidays fall on a Sunday the holiday is the following Monday.
Additionally if Boxing Day is a Monday the holiday is Tuesday.
'''
date = datetime.date(year, month, day)
#print(f'Was {days[date.weekday()]}, {date}')
if date.weekday() == 6:
date = date.replace(day=day+1)
elif day == 26 and month == 12 and date.weekday() == 0:
date = date.replace(day=day+1)
#print(f'Now {days[date.weekday()]}, {date}')
return date
def always_on_monday(day, month, year):
'''
If these days are not a Monday, the holiday is the following Monday
'''
days = list(calendar.day_name)
date = arrow.get(year, month, day)
#print(f'Was {days[date.weekday()]}, {date}')
if date.weekday() != 0:
add = 7 - date.weekday()
date = date.shift(days=+add)
#print(f'Now {days[date.weekday()]}, {date}')
return date.date()
def get_dates(holiday_list, year):
'''
Get holiday dates for the specified year from one of the lists above.
'''
for key, dates in holiday_list.items():
years = key.split('_')
years = [int(y) for y in years]
if len(years) == 2:
years = list(range(years[0], years[1] + 1))
if year in years:
return dates
return []
def get_holidays(year):
'''
Get all holiday dates for the specified year, combining the lists above and Easter,
and shifting the dates as required.
'''
general = get_dates(general_holidays, year)
royal = get_dates(royal_holidays, year)
other = get_dates(other_holidays, year)
holiday_dates = [*general, *royal, *other]
holidays = []
for day, month, htype, hname in holiday_dates:
if htype == 0:
hdate = datetime.date(year, month, day)
elif htype == 1:
hdate = not_on_sunday(day, month, year)
elif htype == 2:
hdate = always_on_monday(day, month, year)
holidays.append((hdate, hname))
holidays += easter_dates[year]
return holidays
# Get all holidays for 1929
get_holidays(1929)
[(datetime.date(1929, 1, 1), 'New Years day'), (datetime.date(1929, 12, 25), 'Christmas Day'), (datetime.date(1929, 12, 26), 'Boxing Day'), (datetime.date(1929, 1, 26), 'Anniversary Day'), (datetime.date(1929, 4, 25), 'Anzac Day'), (datetime.date(1929, 8, 5), 'Bank Holiday'), (datetime.date(1929, 10, 7), 'Labour Day'), (datetime.date(1929, 6, 3), "King's Birthday"), (datetime.date(1929, 3, 29), 'Good Friday'), (datetime.date(1929, 3, 30), 'Easter Saturday'), (datetime.date(1929, 4, 1), 'Easter Monday')]
for year in list(range(1938, 1951)):
date = always_on_monday(9, 6, year)
print(date)
1938-06-13 1939-06-12 1940-06-10 1941-06-09 1942-06-15 1943-06-14 1944-06-12 1945-06-11 1946-06-10 1947-06-09 1948-06-14 1949-06-13 1950-06-12
for year in range(1900, 1951):
holidays = sorted(get_holidays(year))
print(f'\n{year}')
for d, h in holidays:
print(f'\t{arrow.get(d).format("D MMMM YYYY")} ({h})')
1900 1 January 1900 (New Years day) 26 January 1900 (Anniversary Day) 13 April 1900 (Good Friday) 14 April 1900 (Easter Saturday) 16 April 1900 (Easter Monday) 25 May 1900 (Queen's Birthday) 6 August 1900 (Bank Holiday) 1 October 1900 (Labour Day) 12 November 1900 (Prince of Wales's Birthday) 25 December 1900 (Christmas Day) 26 December 1900 (Boxing Day) 1901 1 January 1901 (New Years day) 2 February 1901 (Day of Mourning for Queen) 5 April 1901 (Good Friday) 6 April 1901 (Easter Saturday) 8 April 1901 (Easter Monday) 27 May 1901 (Visit of the Duke of Cornwall) 28 May 1901 (Visit of the Duke of Cornwall) 3 June 1901 (Prince of Wales's Birthday) 3 July 1901 (Polling day) 5 August 1901 (Bank Holiday) 7 October 1901 (Labour Day) 11 November 1901 (King's Birthday) 25 December 1901 (Christmas Day) 26 December 1901 (Boxing Day) 1902 1 January 1902 (New Years day) 27 January 1902 (Anniversary Day) 28 March 1902 (Good Friday) 29 March 1902 (Easter Saturday) 31 March 1902 (Easter Monday) 9 June 1902 (Prince of Wales's Birthday) 4 August 1902 (Bank Holiday) 6 October 1902 (Labour Day) 10 November 1902 (King's Birthday) 25 December 1902 (Christmas Day) 26 December 1902 (Boxing Day) 1903 1 January 1903 (New Years day) 26 January 1903 (Anniversary Day) 10 April 1903 (Good Friday) 11 April 1903 (Easter Saturday) 13 April 1903 (Easter Monday) 8 June 1903 (Prince of Wales's Birthday) 3 August 1903 (Bank Holiday) 5 October 1903 (Labour Day) 9 November 1903 (King's Birthday) 25 December 1903 (Christmas Day) 26 December 1903 (Boxing Day) 1904 1 January 1904 (New Years day) 26 January 1904 (Anniversary Day) 1 April 1904 (Good Friday) 2 April 1904 (Easter Saturday) 4 April 1904 (Easter Monday) 6 June 1904 (Prince of Wales's Birthday) 1 August 1904 (Bank Holiday) 3 October 1904 (Labour Day) 14 November 1904 (King's Birthday) 26 December 1904 (Christmas Day) 27 December 1904 (Boxing Day) 1905 2 January 1905 (New Years day) 30 January 1905 (Anniversary Day) 21 April 1905 (Good Friday) 22 April 1905 (Easter Saturday) 24 April 1905 (Easter Monday) 5 June 1905 (Prince of Wales's Birthday) 7 August 1905 (Bank Holiday) 2 October 1905 (Labour Day) 13 November 1905 (King's Birthday) 25 December 1905 (Christmas Day) 26 December 1905 (Boxing Day) 1906 1 January 1906 (New Years day) 26 January 1906 (Anniversary Day) 13 April 1906 (Good Friday) 14 April 1906 (Easter Saturday) 16 April 1906 (Easter Monday) 4 June 1906 (Prince of Wales's Birthday) 6 August 1906 (Bank Holiday) 1 October 1906 (Labour Day) 12 November 1906 (King's Birthday) 25 December 1906 (Christmas Day) 26 December 1906 (Boxing Day) 1907 1 January 1907 (New Years day) 26 January 1907 (Anniversary Day) 29 March 1907 (Good Friday) 30 March 1907 (Easter Saturday) 1 April 1907 (Easter Monday) 3 June 1907 (Prince of Wales's Birthday) 5 August 1907 (Bank Holiday) 7 October 1907 (Labour Day) 11 November 1907 (King's Birthday) 25 December 1907 (Christmas Day) 26 December 1907 (Boxing Day) 1908 1 January 1908 (New Years day) 27 January 1908 (Anniversary Day) 17 April 1908 (Good Friday) 18 April 1908 (Easter Saturday) 20 April 1908 (Easter Monday) 8 June 1908 (Prince of Wales's Birthday) 3 August 1908 (Bank Holiday) 20 August 1908 (Visit of the American Fleet) 24 August 1908 (Visit of the American Fleet) 5 October 1908 (Labour Day) 9 November 1908 (King's Birthday) 25 December 1908 (Christmas Day) 26 December 1908 (Boxing Day) 1909 1 January 1909 (New Years day) 26 January 1909 (Anniversary Day) 9 April 1909 (Good Friday) 10 April 1909 (Easter Saturday) 12 April 1909 (Easter Monday) 7 June 1909 (Prince of Wales's Birthday) 2 August 1909 (Bank Holiday) 4 October 1909 (Labour Day) 15 November 1909 (King's Birthday) 25 December 1909 (Christmas Day) 27 December 1909 (Boxing Day) 1910 1 January 1910 (New Years day) 26 January 1910 (Anniversary Day) 25 March 1910 (Good Friday) 26 March 1910 (Easter Saturday) 28 March 1910 (Easter Monday) 20 May 1910 (Day of Mourning for King) 6 June 1910 (King's Birthday) 27 June 1910 (Prince of Wales's Birthday) 1 August 1910 (Bank Holiday) 3 October 1910 (Labour Day) 26 December 1910 (Christmas Day) 27 December 1910 (Boxing Day) 1911 2 January 1911 (New Years day) 26 January 1911 (Anniversary Day) 14 April 1911 (Good Friday) 15 April 1911 (Easter Saturday) 17 April 1911 (Easter Monday) 3 June 1911 (King's Birthday) 22 June 1911 (Coronation) 7 August 1911 (Bank Holiday) 22 August 1911 (Prince of Wales's Birthday) 2 October 1911 (Labour Day) 25 December 1911 (Christmas Day) 26 December 1911 (Boxing Day) 1912 1 January 1912 (New Years day) 26 January 1912 (Anniversary Day) 5 April 1912 (Good Friday) 6 April 1912 (Easter Saturday) 8 April 1912 (Easter Monday) 3 June 1912 (King's Birthday) 24 June 1912 (Prince of Wales's Birthday) 5 August 1912 (Bank Holiday) 7 October 1912 (Labour Day) 25 December 1912 (Christmas Day) 26 December 1912 (Boxing Day) 1913 1 January 1913 (New Years day) 27 January 1913 (Anniversary Day) 21 March 1913 (Good Friday) 22 March 1913 (Easter Saturday) 24 March 1913 (Easter Monday) 9 June 1913 (King's Birthday) 23 June 1913 (Prince of Wales's Birthday) 4 August 1913 (Bank Holiday) 6 October 1913 (Labour Day) 25 December 1913 (Christmas Day) 26 December 1913 (Boxing Day) 1914 1 January 1914 (New Years day) 26 January 1914 (Anniversary Day) 10 April 1914 (Good Friday) 11 April 1914 (Easter Saturday) 13 April 1914 (Easter Monday) 8 June 1914 (King's Birthday) 29 June 1914 (Prince of Wales's Birthday) 3 August 1914 (Bank Holiday) 5 October 1914 (Labour Day) 25 December 1914 (Christmas Day) 26 December 1914 (Boxing Day) 1915 1 January 1915 (New Years day) 26 January 1915 (Anniversary Day) 2 April 1915 (Good Friday) 3 April 1915 (Easter Saturday) 5 April 1915 (Easter Monday) 24 May 1915 (Empire Day) 7 June 1915 (King's Birthday) 28 June 1915 (Prince of Wales's Birthday) 2 August 1915 (Bank Holiday) 4 October 1915 (Labour Day) 25 December 1915 (Christmas Day) 27 December 1915 (Boxing Day) 1916 1 January 1916 (New Years day) 26 January 1916 (Anniversary Day) 21 April 1916 (Good Friday) 22 April 1916 (Easter Saturday) 24 April 1916 (Easter Monday) 5 June 1916 (King's Birthday) 26 June 1916 (Prince of Wales's Birthday) 7 August 1916 (Bank Holiday) 2 October 1916 (Labour Day) 28 October 1916 (Conscription referendum) 18 November 1916 (Postponed 8-hour-day procession) 25 December 1916 (Christmas Day) 26 December 1916 (Boxing Day) 1917 1 January 1917 (New Years day) 26 January 1917 (Anniversary Day) 6 April 1917 (Good Friday) 7 April 1917 (Easter Saturday) 9 April 1917 (Easter Monday) 4 June 1917 (King's Birthday) 25 June 1917 (Prince of Wales's Birthday) 6 August 1917 (Bank Holiday) 1 October 1917 (Labour Day) 25 December 1917 (Christmas Day) 26 December 1917 (Boxing Day) 1918 1 January 1918 (New Years day) 26 January 1918 (Anniversary Day) 29 March 1918 (Good Friday) 30 March 1918 (Easter Saturday) 1 April 1918 (Easter Monday) 3 June 1918 (King's Birthday) 24 June 1918 (Prince of Wales's Birthday) 5 August 1918 (Bank Holiday) 7 October 1918 (Labour Day) 25 December 1918 (Christmas Day) 26 December 1918 (Boxing Day) 1919 1 January 1919 (New Years day) 27 January 1919 (Anniversary Day) 18 April 1919 (Good Friday) 19 April 1919 (Easter Saturday) 21 April 1919 (Easter Monday) 9 June 1919 (King's Birthday) 23 June 1919 (Prince of Wales's Birthday) 4 August 1919 (Bank Holiday) 6 October 1919 (Labour Day) 25 December 1919 (Christmas Day) 26 December 1919 (Boxing Day) 1920 1 January 1920 (New Years day) 26 January 1920 (Anniversary Day) 2 April 1920 (Good Friday) 3 April 1920 (Easter Saturday) 5 April 1920 (Easter Monday) 16 June 1920 (Prince of Wales's Visit) 17 June 1920 (Prince of Wales's Visit) 2 August 1920 (Bank Holiday) 4 October 1920 (Labour Day) 25 December 1920 (Christmas Day) 27 December 1920 (Boxing Day) 1921 1 January 1921 (New Years day) 26 January 1921 (Anniversary Day) 25 March 1921 (Good Friday) 26 March 1921 (Easter Saturday) 28 March 1921 (Easter Monday) 6 June 1921 (King's Birthday) 27 June 1921 (Prince of Wales's Birthday) 1 August 1921 (Bank Holiday) 3 October 1921 (Labour Day) 26 December 1921 (Christmas Day) 27 December 1921 (Boxing Day) 1922 2 January 1922 (New Years day) 26 January 1922 (Anniversary Day) 14 April 1922 (Good Friday) 15 April 1922 (Easter Saturday) 17 April 1922 (Easter Monday) 25 April 1922 (Anzac Day) 5 June 1922 (King's Birthday) 26 June 1922 (Prince of Wales's Birthday) 7 August 1922 (Bank Holiday) 2 October 1922 (Labour Day) 25 December 1922 (Christmas Day) 26 December 1922 (Boxing Day) 1923 1 January 1923 (New Years day) 26 January 1923 (Anniversary Day) 30 March 1923 (Good Friday) 31 March 1923 (Easter Saturday) 2 April 1923 (Easter Monday) 25 April 1923 (Anzac Day) 4 June 1923 (King's Birthday) 25 June 1923 (Prince of Wales's Birthday) 6 August 1923 (Bank Holiday) 1 October 1923 (Labour Day) 25 December 1923 (Christmas Day) 26 December 1923 (Boxing Day) 1924 1 January 1924 (New Years day) 26 January 1924 (Anniversary Day) 18 April 1924 (Good Friday) 19 April 1924 (Easter Saturday) 21 April 1924 (Easter Monday) 25 April 1924 (Anzac Day) 9 June 1924 (King's Birthday) 23 June 1924 (Prince of Wales's Birthday) 4 August 1924 (Bank Holiday) 6 October 1924 (Labour Day) 25 December 1924 (Christmas Day) 26 December 1924 (Boxing Day) 1925 1 January 1925 (New Years day) 26 January 1925 (Anniversary Day) 10 April 1925 (Good Friday) 11 April 1925 (Easter Saturday) 13 April 1925 (Easter Monday) 25 April 1925 (Anzac Day) 8 June 1925 (King's Birthday) 3 August 1925 (Bank Holiday) 5 October 1925 (Labour Day) 25 December 1925 (Christmas Day) 26 December 1925 (Boxing Day) 1926 1 January 1926 (New Years day) 26 January 1926 (Anniversary Day) 2 April 1926 (Good Friday) 3 April 1926 (Easter Saturday) 5 April 1926 (Easter Monday) 26 April 1926 (Anzac Day) 7 June 1926 (King's Birthday) 2 August 1926 (Bank Holiday) 4 October 1926 (Labour Day) 25 December 1926 (Christmas Day) 27 December 1926 (Boxing Day) 1927 1 January 1927 (New Years day) 26 January 1927 (Anniversary Day) 15 April 1927 (Good Friday) 16 April 1927 (Easter Saturday) 18 April 1927 (Easter Monday) 25 April 1927 (Anzac Day) 6 June 1927 (King's Birthday) 1 August 1927 (Bank Holiday) 3 October 1927 (Labour Day) 26 December 1927 (Christmas Day) 27 December 1927 (Boxing Day) 1928 2 January 1928 (New Years day) 26 January 1928 (Anniversary Day) 6 April 1928 (Good Friday) 7 April 1928 (Easter Saturday) 9 April 1928 (Easter Monday) 25 April 1928 (Anzac Day) 4 June 1928 (King's Birthday) 6 August 1928 (Bank Holiday) 1 October 1928 (Labour Day) 25 December 1928 (Christmas Day) 26 December 1928 (Boxing Day) 1929 1 January 1929 (New Years day) 26 January 1929 (Anniversary Day) 29 March 1929 (Good Friday) 30 March 1929 (Easter Saturday) 1 April 1929 (Easter Monday) 25 April 1929 (Anzac Day) 3 June 1929 (King's Birthday) 5 August 1929 (Bank Holiday) 7 October 1929 (Labour Day) 25 December 1929 (Christmas Day) 26 December 1929 (Boxing Day) 1930 1 January 1930 (New Years day) 27 January 1930 (Anniversary Day) 18 April 1930 (Good Friday) 19 April 1930 (Easter Saturday) 21 April 1930 (Easter Monday) 25 April 1930 (Anzac Day) 9 June 1930 (King's Birthday) 4 August 1930 (Bank Holiday) 6 October 1930 (Labour Day) 25 December 1930 (Christmas Day) 26 December 1930 (Boxing Day) 1931 1 January 1931 (New Years day) 26 January 1931 (Anniversary Day) 3 April 1931 (Good Friday) 4 April 1931 (Easter Saturday) 6 April 1931 (Easter Monday) 25 April 1931 (Anzac Day) 8 June 1931 (King's Birthday) 3 August 1931 (Bank Holiday) 5 October 1931 (Labour Day) 25 December 1931 (Christmas Day) 26 December 1931 (Boxing Day) 1932 1 January 1932 (New Years day) 26 January 1932 (Anniversary Day) 25 March 1932 (Good Friday) 26 March 1932 (Easter Saturday) 28 March 1932 (Easter Monday) 25 April 1932 (Anzac Day) 6 June 1932 (King's Birthday) 1 August 1932 (Bank Holiday) 3 October 1932 (Labour Day) 26 December 1932 (Christmas Day) 27 December 1932 (Boxing Day) 1933 2 January 1933 (New Years day) 26 January 1933 (Anniversary Day) 14 April 1933 (Good Friday) 15 April 1933 (Easter Saturday) 17 April 1933 (Easter Monday) 25 April 1933 (Anzac Day) 5 June 1933 (King's Birthday) 7 August 1933 (Bank Holiday) 2 October 1933 (Labour Day) 25 December 1933 (Christmas Day) 26 December 1933 (Boxing Day) 1934 1 January 1934 (New Years day) 26 January 1934 (Anniversary Day) 30 March 1934 (Good Friday) 31 March 1934 (Easter Saturday) 2 April 1934 (Easter Monday) 25 April 1934 (Anzac Day) 4 June 1934 (King's Birthday) 6 August 1934 (Bank Holiday) 1 October 1934 (Labour Day) 25 December 1934 (Christmas Day) 26 December 1934 (Boxing Day) 1935 1 January 1935 (New Years day) 28 January 1935 (Anniversary Day) 19 April 1935 (Good Friday) 20 April 1935 (Easter Saturday) 22 April 1935 (Easter Monday) 25 April 1935 (Anzac Day) 3 June 1935 (King's Birthday) 5 August 1935 (Bank Holiday) 7 October 1935 (Labour Day) 25 December 1935 (Christmas Day) 26 December 1935 (Boxing Day) 1936 1 January 1936 (New Years day) 27 January 1936 (Anniversary Day) 10 April 1936 (Good Friday) 11 April 1936 (Easter Saturday) 13 April 1936 (Easter Monday) 25 April 1936 (Anzac Day) 29 June 1936 (King's Birthday) 3 August 1936 (Bank Holiday) 5 October 1936 (Labour Day) 25 December 1936 (Christmas Day) 26 December 1936 (Boxing Day) 1937 1 January 1937 (New Years day) 1 February 1937 (Anniversary Day) 26 March 1937 (Good Friday) 27 March 1937 (Easter Saturday) 29 March 1937 (Easter Monday) 26 April 1937 (Anzac Day) 12 May 1937 (Coronation) 2 August 1937 (Bank Holiday) 4 October 1937 (Labour Day) 25 December 1937 (Christmas Day) 27 December 1937 (Boxing Day) 1938 1 January 1938 (New Years day) 26 January 1938 (Anniversary Day) 15 April 1938 (Good Friday) 16 April 1938 (Easter Saturday) 18 April 1938 (Easter Monday) 25 April 1938 (Anzac Day) 13 June 1938 (King's Birthday) 1 August 1938 (Bank Holiday) 3 October 1938 (Labour Day) 26 December 1938 (Christmas Day) 27 December 1938 (Boxing Day) 1939 2 January 1939 (New Years day) 30 January 1939 (Anniversary Day) 7 April 1939 (Good Friday) 8 April 1939 (Easter Saturday) 10 April 1939 (Easter Monday) 25 April 1939 (Anzac Day) 12 June 1939 (King's Birthday) 7 August 1939 (Bank Holiday) 2 October 1939 (Labour Day) 25 December 1939 (Christmas Day) 26 December 1939 (Boxing Day) 1940 1 January 1940 (New Years day) 29 January 1940 (Anniversary Day) 22 March 1940 (Good Friday) 23 March 1940 (Easter Saturday) 25 March 1940 (Easter Monday) 25 April 1940 (Anzac Day) 17 June 1940 (King's Birthday) 7 October 1940 (Labour Day) 25 December 1940 (Christmas Day) 26 December 1940 (Boxing Day) 1941 1 January 1941 (New Years day) 27 January 1941 (Anniversary Day) 11 April 1941 (Good Friday) 12 April 1941 (Easter Saturday) 14 April 1941 (Easter Monday) 25 April 1941 (Anzac Day) 16 June 1941 (King's Birthday) 4 August 1941 (Bank Holiday) 6 October 1941 (Labour Day) 25 December 1941 (Christmas Day) 26 December 1941 (Boxing Day) 1942 1 January 1942 (New Years day) 26 January 1942 (Anniversary Day) 3 April 1942 (Good Friday) 4 April 1942 (Easter Saturday) 25 April 1942 (Anzac Day) 15 June 1942 (King's Birthday) 3 August 1942 (Bank Holiday) 5 October 1942 (Labour Day) 25 December 1942 (Christmas Day) 26 December 1942 (Boxing Day) 28 December 1942 (In place of New Years Day) 1943 26 January 1943 (Anniversary Day) 23 April 1943 (Good Friday) 24 April 1943 (Easter Saturday) 26 April 1943 (Anzac Day) 26 April 1943 (Easter Monday) 7 June 1943 (King's Birthday) 2 August 1943 (Bank Holiday) 4 October 1943 (Labour Day) 25 December 1943 (Christmas Day) 27 December 1943 (Boxing Day) 1944 1 January 1944 (New Years day) 31 January 1944 (Anniversary Day) 7 April 1944 (Good Friday) 8 April 1944 (Easter Saturday) 10 April 1944 (Easter Monday) 25 April 1944 (Anzac Day) 12 June 1944 (King's Birthday) 7 August 1944 (Bank Holiday) 2 October 1944 (Labour Day) 25 December 1944 (Christmas Day) 26 December 1944 (Boxing Day) 1945 1 January 1945 (New Years day) 29 January 1945 (Anniversary Day) 30 March 1945 (Good Friday) 31 March 1945 (Easter Saturday) 2 April 1945 (Easter Monday) 25 April 1945 (Anzac Day) 9 May 1945 (VE Day) 18 June 1945 (King's Birthday) 6 August 1945 (Bank Holiday) 1 October 1945 (Labour Day) 25 December 1945 (Christmas Day) 26 December 1945 (Boxing Day) 1946 1 January 1946 (New Years day) 28 January 1946 (Anniversary Day) 19 April 1946 (Good Friday) 20 April 1946 (Easter Saturday) 22 April 1946 (Easter Monday) 25 April 1946 (Anzac Day) 10 June 1946 (Victory Day) 17 June 1946 (King's Birthday) 5 August 1946 (Bank Holiday) 7 October 1946 (Labour Day) 25 December 1946 (Christmas Day) 26 December 1946 (Boxing Day) 1947 1 January 1947 (New Years day) 27 January 1947 (Anniversary Day) 4 April 1947 (Good Friday) 5 April 1947 (Easter Saturday) 7 April 1947 (Easter Monday) 25 April 1947 (Anzac Day) 16 June 1947 (King's Birthday) 4 August 1947 (Bank Holiday) 6 October 1947 (Labour Day) 25 December 1947 (Christmas Day) 26 December 1947 (Boxing Day) 1948 1 January 1948 (New Years day) 26 January 1948 (Anniversary Day) 26 March 1948 (Good Friday) 27 March 1948 (Easter Saturday) 29 March 1948 (Easter Monday) 26 April 1948 (Anzac Day) 14 June 1948 (King's Birthday) 2 August 1948 (Bank Holiday) 4 October 1948 (Labour Day) 25 December 1948 (Christmas Day) 27 December 1948 (Boxing Day) 1949 1 January 1949 (New Years day) 31 January 1949 (Anniversary Day) 15 April 1949 (Good Friday) 16 April 1949 (Easter Saturday) 18 April 1949 (Easter Monday) 25 April 1949 (Anzac Day) 13 June 1949 (King's Birthday) 1 August 1949 (Bank Holiday) 3 October 1949 (Labour Day) 26 December 1949 (Christmas Day) 27 December 1949 (Boxing Day) 1950 2 January 1950 (New Years day) 30 January 1950 (Anniversary Day) 7 April 1950 (Good Friday) 8 April 1950 (Easter Saturday) 10 April 1950 (Easter Monday) 25 April 1950 (Anzac Day) 12 June 1950 (King's Birthday) 7 August 1950 (Bank Holiday) 2 October 1950 (Labour Day) 25 December 1950 (Christmas Day) 26 December 1950 (Boxing Day)
holidays_1900_1950 = []
# Loop through years collecting holidays
for year in range(1900, 1951):
holidays = sorted(get_holidays(year))
for d, h in holidays:
holidays_1900_1950.append({'year': year, 'date': d, 'holiday': h})
# Convert to a dataframe
df_holidays = pd.DataFrame(holidays_1900_1950)
df_holidays.head()
year | date | holiday | |
---|---|---|---|
0 | 1900 | 1900-01-01 | New Years day |
1 | 1900 | 1900-01-26 | Anniversary Day |
2 | 1900 | 1900-04-13 | Good Friday |
3 | 1900 | 1900-04-14 | Easter Saturday |
4 | 1900 | 1900-04-16 | Easter Monday |
# Save as CSV
df_holidays.to_csv('nsw_holidays_1900_1950.csv', index=False)
display(FileLink('nsw_holidays_1900_1950.csv'))