# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

# # MSDS692 Project: Data Preprocessing - Holidays
# ## Natalia Weakly    
#
# ### Original data source http://www.calendarpedia.com
#  

# Imports
import pandas as pd
import numpy as np
import datetime

# Load data
holidays = pd.read_excel('Holidays2014_2019.xlsx', parsedates=True)

# Check load results
holidays

holidays.info()

# output holidays to a file for future use
holidays.to_csv('holidays.csv', date_format='%Y-%m-%d %H:%M:%S')



StarcoderdataJupyterScriptsDedupFiltered