Create a Holiday List for multiple countries using Python

Published on Feb 04, 2022:
In this video, we will learn to create a Holiday List for multiple countries using Python

###Code Starts###
#Import the holidays and pandas library
import holidays
import pandas as pd

# List object called Holiday List
HolidayList = []


# Get the holiday list for UK, US, India and Australia
for yrs in range(2000, 2020):
# Appending Holiday List for UK
for ptr in holidays.UnitedKingdom(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for US
for ptr in holidays.UnitedStates(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for India
for ptr in holidays.India(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for Australia
for ptr in holidays.Australia(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for China
for ptr in holidays.China(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for South Africa
for ptr in holidays.SouthAfrica(years=yrs).items():
HolidayList.append(ptr)
# Appending Holiday List for NewZealand
for ptr in holidays.NZL(years=yrs).items():
HolidayList.append(ptr)


#Create a data frame from the Holidays List

df = pd.DataFrame(HolidayList)

# saving the dataframe to a csv file
df.to_csv('C:\Data\HolidayList\Holidays.csv')


###Code Ends###

Link to holidays Library
https://bit.ly/3Hn3tCh


In the previous video, we learnt to model the holiday data in Power BI.
The code used for creating the holiday flag in Power BI is below:
HolidayFlag = If(ISBLANK(LOOKUPVALUE(DimDate[FullDateAlternateKey],HolidayData[HolidayDate],DimDate[FullDateAlternateKey])),False,True)

Link to the lookup value function is mentioned below.
https://bit.ly/3FL1o1q

I



Previous Video: https://youtu.be/HJHjeV8NUtU
Current Video: https://youtu.be/HlFwH4gCP0s
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
https://www.youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw


Download DAX Editor:
https://daxstudio.org/

Our Playists:
Extract Load and Transform data using Power Query: http://bit.ly/3orLRf4
Enhance Power BI Data model using DAX: https://bit.ly/2GbTENc
Python and Power BI:https://bit.ly/2EajdNc
Getting Started with AWS: https://bit.ly/2PgSCQX
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
Getting Started with Power BI:https://goo.gl/GHakLZ
Getting Started with Python: https://goo.gl/n24P3w
Data Science With Python:https://goo.gl/PeYCR5
Power BI service: http://tiny.cc/sjekmz
Data Modelling with Power BI:https://tinyurl.com/8b4srjrm


ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/tutorial-power-bi-desktop/


Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License