Data Analysis with SQLite.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Part 1: Starting the project and creating the database"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The necessary packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import sqlite3\n",
    "import requests\n",
    "import json\n",
    "from datetime import date, timedelta"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creation of the SQLite database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "con = sqlite3.connect(\"country_code.db\")\n",
    "cur = con.cursor()\n",
    "cur.execute(\"CREATE TABLE Country(Name text, Code text)\")\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data recovery from CSV file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AF</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Albanie</td>\n",
       "      <td>AL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AlgÄrie</td>\n",
       "      <td>DZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Samoa orientales</td>\n",
       "      <td>AS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Andorre</td>\n",
       "      <td>AD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Name Code\n",
       "1       Afghanistan   AF\n",
       "2           Albanie   AL\n",
       "3           AlgÄrie   DZ\n",
       "4  Samoa orientales   AS\n",
       "5           Andorre   AD"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"country_code.csv\", delimiter=\";\", index_col=0, encoding=\"cp437\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "149    NaN\n",
      "Name: Code, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(df.Code[df[\"Name\"]==\"Namibie\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.Code[df[\"Name\"]==\"Namibie\"]=\"NA\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "149    NA\n",
      "Name: Code, dtype: object\n"
     ]
    }
   ],
   "source": [
    "print(df.Code[df[\"Name\"]==\"Namibie\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Insertion of data into the database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "cur = con.cursor()\n",
    "for index, row in df.iterrows():\n",
    "    cur.execute(\"INSERT INTO Country(Name, Code) values (?, ?)\", row)\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Part 2: Data Recovery from an API"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## API test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "API response: 200\n"
     ]
    }
   ],
   "source": [
    "url = \"https://date.nager.at/api\"\n",
    "response = requests.get(url)\n",
    "# The state of the response\n",
    "print(\"API response:\",response.status_code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "Json_Files = []\n",
    "for index, row in df.iterrows():\n",
    "    response = requests.get(\"https://date.nager.at/api/v2/publicholidays/2017/\"+row[\"Code\"])\n",
    "    if response.status_code==200:\n",
    "        data = response.json()\n",
    "        # Creation of JSON files\n",
    "        with open(row[\"Code\"]+\".json\", \"w\") as json_file:\n",
    "            json.dump(data, json_file)\n",
    "            Json_Files.append(row[\"Code\"]+\".json\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Part 3: Data storage in the database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Creation of a public holiday table\n",
    "cur = con.cursor()\n",
    "cur.execute(\"CREATE TABLE Holidays(countryCode text, name text, localName text, type text, global text, fixed text, date text)\")\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Insertion of data\n",
    "cur = con.cursor()\n",
    "for file in Json_Files:\n",
    "    with open(file) as json_file:\n",
    "        data = json.load(json_file)\n",
    "        for row in data:\n",
    "            cur.execute(\"INSERT INTO Holidays(countryCode, name, localName, type, global, fixed, date) values (?, ?, ?, ?, ?, ?, ?)\", [row[\"countryCode\"], row[\"name\"], row[\"localName\"], row[\"type\"], row[\"global\"], row[\"fixed\"], row[\"date\"]])\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Partie 4 : Database data analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The country with the most public holidays in 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The country with the most public holidays in 2017 est: Andorre\n"
     ]
    }
   ],
   "source": [
    "cur = con.cursor()\n",
    "cur.execute(\"SELECT c.name FROM Holidays as h JOIN Country as c WHERE c.Code=h.countryCode GROUP BY countryCode ORDER BY COUNT(countryCode) LIMIT 1\")\n",
    "for row in cur:\n",
    "    print(\"The country with the most public holidays in 2017 est:\",str(row[0]))\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The country with the fewest public holidays in 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The country with the fewest public holidays in 2017 est: VÄnÄzuela\n"
     ]
    }
   ],
   "source": [
    "cur = con.cursor()\n",
    "cur.execute(\"SELECT c.name FROM Holidays as h JOIN Country as c WHERE c.Code=h.countryCode GROUP BY countryCode ORDER BY COUNT(countryCode) DESC LIMIT 1\")\n",
    "for row in cur:\n",
    "    print(\"The country with the fewest public holidays in 2017 est:\",str(row[0]))\n",
    "cur.close()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Holidays of 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2017-01-01',\n",
       " '2017-01-02',\n",
       " '2017-03-14',\n",
       " '2017-03-22',\n",
       " '2017-04-16',\n",
       " '2017-04-17',\n",
       " '2017-05-01',\n",
       " '2017-10-19',\n",
       " '2017-11-28',\n",
       " '2017-11-29',\n",
       " '2017-12-08',\n",
       " '2017-12-25',\n",
       " '2017-02-27',\n",
       " '2017-02-28',\n",
       " '2017-03-24',\n",
       " '2017-04-02',\n",
       " '2017-04-14',\n",
       " '2017-05-25',\n",
       " '2017-06-17',\n",
       " '2017-06-20',\n",
       " '2017-07-09',\n",
       " '2017-08-21',\n",
       " '2017-10-09',\n",
       " '2017-11-20',\n",
       " '2017-01-26',\n",
       " '2017-03-06',\n",
       " '2017-03-13',\n",
       " '2017-04-15',\n",
       " '2017-04-25',\n",
       " '2017-05-29',\n",
       " '2017-06-05',\n",
       " '2017-06-12',\n",
       " '2017-08-07',\n",
       " '2017-10-02',\n",
       " '2017-12-26',\n",
       " '2017-01-06',\n",
       " '2017-06-15',\n",
       " '2017-08-15',\n",
       " '2017-10-26',\n",
       " '2017-11-01',\n",
       " '2017-01-10',\n",
       " '2017-04-01',\n",
       " '2017-07-10',\n",
       " '2017-08-05',\n",
       " '2017-10-12',\n",
       " '2017-01-21',\n",
       " '2017-04-28',\n",
       " '2017-08-01',\n",
       " '2017-11-30',\n",
       " '2017-01-07',\n",
       " '2017-03-08',\n",
       " '2017-05-09',\n",
       " '2017-07-03',\n",
       " '2017-11-07',\n",
       " '2017-07-21',\n",
       " '2017-11-11',\n",
       " '2017-05-22',\n",
       " '2017-09-10',\n",
       " '2017-09-21',\n",
       " '2017-11-19',\n",
       " '2017-02-02',\n",
       " '2017-06-21',\n",
       " '2017-08-02',\n",
       " '2017-08-06',\n",
       " '2017-11-02',\n",
       " '2017-07-01',\n",
       " '2017-07-17',\n",
       " '2017-09-30',\n",
       " '2017-10-01',\n",
       " '2017-04-21',\n",
       " '2017-09-07',\n",
       " '2017-11-15',\n",
       " '2017-03-03',\n",
       " '2017-05-06',\n",
       " '2017-05-24',\n",
       " '2017-09-06',\n",
       " '2017-09-22',\n",
       " '2017-12-24',\n",
       " '2017-02-13',\n",
       " '2017-02-20',\n",
       " '2017-03-17',\n",
       " '2017-04-23',\n",
       " '2017-06-24',\n",
       " '2017-07-12',\n",
       " '2017-09-04',\n",
       " '2017-05-21',\n",
       " '2017-06-07',\n",
       " '2017-06-26',\n",
       " '2017-07-16',\n",
       " '2017-08-10',\n",
       " '2017-09-18',\n",
       " '2017-09-19',\n",
       " '2017-09-20',\n",
       " '2017-10-27',\n",
       " '2017-01-28',\n",
       " '2017-04-05',\n",
       " '2017-05-30',\n",
       " '2017-10-04',\n",
       " '2017-03-19',\n",
       " '2017-04-13',\n",
       " '2017-06-23',\n",
       " '2017-06-29',\n",
       " '2017-07-20',\n",
       " '2017-04-11',\n",
       " '2017-07-25',\n",
       " '2017-09-15',\n",
       " '2017-06-22',\n",
       " '2017-06-25',\n",
       " '2017-10-08',\n",
       " '2017-07-26',\n",
       " '2017-07-27',\n",
       " '2017-10-10',\n",
       " '2017-03-25',\n",
       " '2017-04-18',\n",
       " '2017-06-04',\n",
       " '2017-10-28',\n",
       " '2017-05-08',\n",
       " '2017-07-05',\n",
       " '2017-07-06',\n",
       " '2017-09-28',\n",
       " '2017-11-17',\n",
       " '2017-05-12',\n",
       " '2017-05-26',\n",
       " '2017-12-31',\n",
       " '2017-05-28',\n",
       " '2017-08-16',\n",
       " '2017-09-24',\n",
       " '2017-11-06',\n",
       " '2017-11-03',\n",
       " '2017-01-25',\n",
       " '2017-07-23',\n",
       " '2017-10-06',\n",
       " '2017-05-03',\n",
       " '2017-05-07',\n",
       " '2017-05-10',\n",
       " '2017-08-03',\n",
       " '2017-08-04',\n",
       " '2017-11-08',\n",
       " '2017-11-09',\n",
       " '2017-11-10',\n",
       " '2017-11-12',\n",
       " '2017-11-13',\n",
       " '2017-11-21',\n",
       " '2017-02-24',\n",
       " '2017-08-20',\n",
       " '2017-07-28',\n",
       " '2017-07-29',\n",
       " '2017-11-04',\n",
       " '2017-12-06',\n",
       " '2017-05-27',\n",
       " '2017-07-14',\n",
       " '2017-03-12',\n",
       " '2017-08-17',\n",
       " '2017-02-18',\n",
       " '2017-07-22',\n",
       " '2017-10-03',\n",
       " '2017-10-31',\n",
       " '2017-11-22',\n",
       " '2017-02-07',\n",
       " '2017-08-11',\n",
       " '2017-10-25',\n",
       " '2017-06-30',\n",
       " '2017-10-20',\n",
       " '2017-02-23',\n",
       " '2017-05-05',\n",
       " '2017-03-01',\n",
       " '2017-05-18',\n",
       " '2017-10-17',\n",
       " '2017-11-18',\n",
       " '2017-12-05',\n",
       " '2017-02-11',\n",
       " '2017-09-08',\n",
       " '2017-10-21',\n",
       " '2017-03-15',\n",
       " '2017-10-23',\n",
       " '2017-04-20',\n",
       " '2017-06-01',\n",
       " '2017-10-30',\n",
       " '2017-06-02',\n",
       " '2017-05-23',\n",
       " '2017-10-16',\n",
       " '2017-01-09',\n",
       " '2017-04-29',\n",
       " '2017-05-04',\n",
       " '2017-11-23',\n",
       " '2017-12-23',\n",
       " '2017-05-14',\n",
       " '2017-03-11',\n",
       " '2017-02-16',\n",
       " '2017-10-11',\n",
       " '2017-03-29',\n",
       " '2017-02-10',\n",
       " '2017-03-31',\n",
       " '2017-12-13',\n",
       " '2017-02-06',\n",
       " '2017-03-20',\n",
       " '2017-01-08',\n",
       " '2017-08-27',\n",
       " '2017-08-28',\n",
       " '2017-08-31',\n",
       " '2017-09-03',\n",
       " '2017-10-14',\n",
       " '2017-01-27',\n",
       " '2017-07-11',\n",
       " '2017-07-13',\n",
       " '2017-07-15',\n",
       " '2017-11-26',\n",
       " '2017-12-29',\n",
       " '2017-01-11',\n",
       " '2017-07-30',\n",
       " '2017-08-14',\n",
       " '2017-02-03',\n",
       " '2017-04-07',\n",
       " '2017-09-25',\n",
       " '2017-03-21',\n",
       " '2017-08-26',\n",
       " '2017-12-10',\n",
       " '2017-04-27',\n",
       " '2017-02-01',\n",
       " '2017-04-06',\n",
       " '2017-07-19',\n",
       " '2017-09-14',\n",
       " '2017-04-24',\n",
       " '2017-12-18',\n",
       " '2017-05-17',\n",
       " '2017-11-05',\n",
       " '2017-05-15',\n",
       " '2017-09-29',\n",
       " '2017-08-30',\n",
       " '2017-06-10',\n",
       " '2017-10-05',\n",
       " '2017-12-01',\n",
       " '2017-01-16',\n",
       " '2017-07-04',\n",
       " '2017-01-24',\n",
       " '2017-01-03',\n",
       " '2017-01-04',\n",
       " '2017-01-05',\n",
       " '2017-02-05',\n",
       " '2017-08-29',\n",
       " '2017-09-01',\n",
       " '2017-02-08',\n",
       " '2017-05-02',\n",
       " '2017-06-16',\n",
       " '2017-08-09',\n",
       " '2017-12-16',\n",
       " '2017-05-31',\n",
       " '2017-06-09',\n",
       " '2017-09-02',\n",
       " '2017-09-11',\n",
       " '2017-02-25',\n",
       " '2017-08-08',\n",
       " '2017-11-25',\n",
       " '2017-06-06',\n",
       " '2017-01-14',\n",
       " '2017-04-09',\n",
       " '2017-08-13',\n",
       " '2017-10-15',\n",
       " '2017-05-19',\n",
       " '2017-10-29',\n",
       " '2017-06-28',\n",
       " '2017-08-24',\n",
       " '2017-01-20',\n",
       " '2017-04-19',\n",
       " '2017-06-19',\n",
       " '2017-07-18',\n",
       " '2017-08-25',\n",
       " '2017-01-15',\n",
       " '2017-02-12',\n",
       " '2017-06-18',\n",
       " '2017-06-27',\n",
       " '2017-07-24',\n",
       " '2017-12-17',\n",
       " '2017-04-30',\n",
       " '2017-02-21',\n",
       " '2017-12-22']"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Holidays\n",
    "Holidays = []\n",
    "cur = con.cursor()\n",
    "cur.execute(\"SELECT DISTINCT(date) FROM Holidays\")\n",
    "for row in cur:\n",
    "    Holidays.append(row[0])\n",
    "cur.close()\n",
    "Holidays"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The days of the year 2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2017-01-01',\n",
       " '2017-01-02',\n",
       " '2017-01-03',\n",
       " '2017-01-04',\n",
       " '2017-01-05',\n",
       " '2017-01-06',\n",
       " '2017-01-07',\n",
       " '2017-01-08',\n",
       " '2017-01-09',\n",
       " '2017-01-10',\n",
       " '2017-01-11',\n",
       " '2017-01-12',\n",
       " '2017-01-13',\n",
       " '2017-01-14',\n",
       " '2017-01-15',\n",
       " '2017-01-16',\n",
       " '2017-01-17',\n",
       " '2017-01-18',\n",
       " '2017-01-19',\n",
       " '2017-01-20',\n",
       " '2017-01-21',\n",
       " '2017-01-22',\n",
       " '2017-01-23',\n",
       " '2017-01-24',\n",
       " '2017-01-25',\n",
       " '2017-01-26',\n",
       " '2017-01-27',\n",
       " '2017-01-28',\n",
       " '2017-01-29',\n",
       " '2017-01-30',\n",
       " '2017-01-31',\n",
       " '2017-02-01',\n",
       " '2017-02-02',\n",
       " '2017-02-03',\n",
       " '2017-02-04',\n",
       " '2017-02-05',\n",
       " '2017-02-06',\n",
       " '2017-02-07',\n",
       " '2017-02-08',\n",
       " '2017-02-09',\n",
       " '2017-02-10',\n",
       " '2017-02-11',\n",
       " '2017-02-12',\n",
       " '2017-02-13',\n",
       " '2017-02-14',\n",
       " '2017-02-15',\n",
       " '2017-02-16',\n",
       " '2017-02-17',\n",
       " '2017-02-18',\n",
       " '2017-02-19',\n",
       " '2017-02-20',\n",
       " '2017-02-21',\n",
       " '2017-02-22',\n",
       " '2017-02-23',\n",
       " '2017-02-24',\n",
       " '2017-02-25',\n",
       " '2017-02-26',\n",
       " '2017-02-27',\n",
       " '2017-02-28',\n",
       " '2017-03-01',\n",
       " '2017-03-02',\n",
       " '2017-03-03',\n",
       " '2017-03-04',\n",
       " '2017-03-05',\n",
       " '2017-03-06',\n",
       " '2017-03-07',\n",
       " '2017-03-08',\n",
       " '2017-03-09',\n",
       " '2017-03-10',\n",
       " '2017-03-11',\n",
       " '2017-03-12',\n",
       " '2017-03-13',\n",
       " '2017-03-14',\n",
       " '2017-03-15',\n",
       " '2017-03-16',\n",
       " '2017-03-17',\n",
       " '2017-03-18',\n",
       " '2017-03-19',\n",
       " '2017-03-20',\n",
       " '2017-03-21',\n",
       " '2017-03-22',\n",
       " '2017-03-23',\n",
       " '2017-03-24',\n",
       " '2017-03-25',\n",
       " '2017-03-26',\n",
       " '2017-03-27',\n",
       " '2017-03-28',\n",
       " '2017-03-29',\n",
       " '2017-03-30',\n",
       " '2017-03-31',\n",
       " '2017-04-01',\n",
       " '2017-04-02',\n",
       " '2017-04-03',\n",
       " '2017-04-04',\n",
       " '2017-04-05',\n",
       " '2017-04-06',\n",
       " '2017-04-07',\n",
       " '2017-04-08',\n",
       " '2017-04-09',\n",
       " '2017-04-10',\n",
       " '2017-04-11',\n",
       " '2017-04-12',\n",
       " '2017-04-13',\n",
       " '2017-04-14',\n",
       " '2017-04-15',\n",
       " '2017-04-16',\n",
       " '2017-04-17',\n",
       " '2017-04-18',\n",
       " '2017-04-19',\n",
       " '2017-04-20',\n",
       " '2017-04-21',\n",
       " '2017-04-22',\n",
       " '2017-04-23',\n",
       " '2017-04-24',\n",
       " '2017-04-25',\n",
       " '2017-04-26',\n",
       " '2017-04-27',\n",
       " '2017-04-28',\n",
       " '2017-04-29',\n",
       " '2017-04-30',\n",
       " '2017-05-01',\n",
       " '2017-05-02',\n",
       " '2017-05-03',\n",
       " '2017-05-04',\n",
       " '2017-05-05',\n",
       " '2017-05-06',\n",
       " '2017-05-07',\n",
       " '2017-05-08',\n",
       " '2017-05-09',\n",
       " '2017-05-10',\n",
       " '2017-05-11',\n",
       " '2017-05-12',\n",
       " '2017-05-13',\n",
       " '2017-05-14',\n",
       " '2017-05-15',\n",
       " '2017-05-16',\n",
       " '2017-05-17',\n",
       " '2017-05-18',\n",
       " '2017-05-19',\n",
       " '2017-05-20',\n",
       " '2017-05-21',\n",
       " '2017-05-22',\n",
       " '2017-05-23',\n",
       " '2017-05-24',\n",
       " '2017-05-25',\n",
       " '2017-05-26',\n",
       " '2017-05-27',\n",
       " '2017-05-28',\n",
       " '2017-05-29',\n",
       " '2017-05-30',\n",
       " '2017-05-31',\n",
       " '2017-06-01',\n",
       " '2017-06-02',\n",
       " '2017-06-03',\n",
       " '2017-06-04',\n",
       " '2017-06-05',\n",
       " '2017-06-06',\n",
       " '2017-06-07',\n",
       " '2017-06-08',\n",
       " '2017-06-09',\n",
       " '2017-06-10',\n",
       " '2017-06-11',\n",
       " '2017-06-12',\n",
       " '2017-06-13',\n",
       " '2017-06-14',\n",
       " '2017-06-15',\n",
       " '2017-06-16',\n",
       " '2017-06-17',\n",
       " '2017-06-18',\n",
       " '2017-06-19',\n",
       " '2017-06-20',\n",
       " '2017-06-21',\n",
       " '2017-06-22',\n",
       " '2017-06-23',\n",
       " '2017-06-24',\n",
       " '2017-06-25',\n",
       " '2017-06-26',\n",
       " '2017-06-27',\n",
       " '2017-06-28',\n",
       " '2017-06-29',\n",
       " '2017-06-30',\n",
       " '2017-07-01',\n",
       " '2017-07-02',\n",
       " '2017-07-03',\n",
       " '2017-07-04',\n",
       " '2017-07-05',\n",
       " '2017-07-06',\n",
       " '2017-07-07',\n",
       " '2017-07-08',\n",
       " '2017-07-09',\n",
       " '2017-07-10',\n",
       " '2017-07-11',\n",
       " '2017-07-12',\n",
       " '2017-07-13',\n",
       " '2017-07-14',\n",
       " '2017-07-15',\n",
       " '2017-07-16',\n",
       " '2017-07-17',\n",
       " '2017-07-18',\n",
       " '2017-07-19',\n",
       " '2017-07-20',\n",
       " '2017-07-21',\n",
       " '2017-07-22',\n",
       " '2017-07-23',\n",
       " '2017-07-24',\n",
       " '2017-07-25',\n",
       " '2017-07-26',\n",
       " '2017-07-27',\n",
       " '2017-07-28',\n",
       " '2017-07-29',\n",
       " '2017-07-30',\n",
       " '2017-07-31',\n",
       " '2017-08-01',\n",
       " '2017-08-02',\n",
       " '2017-08-03',\n",
       " '2017-08-04',\n",
       " '2017-08-05',\n",
       " '2017-08-06',\n",
       " '2017-08-07',\n",
       " '2017-08-08',\n",
       " '2017-08-09',\n",
       " '2017-08-10',\n",
       " '2017-08-11',\n",
       " '2017-08-12',\n",
       " '2017-08-13',\n",
       " '2017-08-14',\n",
       " '2017-08-15',\n",
       " '2017-08-16',\n",
       " '2017-08-17',\n",
       " '2017-08-18',\n",
       " '2017-08-19',\n",
       " '2017-08-20',\n",
       " '2017-08-21',\n",
       " '2017-08-22',\n",
       " '2017-08-23',\n",
       " '2017-08-24',\n",
       " '2017-08-25',\n",
       " '2017-08-26',\n",
       " '2017-08-27',\n",
       " '2017-08-28',\n",
       " '2017-08-29',\n",
       " '2017-08-30',\n",
       " '2017-08-31',\n",
       " '2017-09-01',\n",
       " '2017-09-02',\n",
       " '2017-09-03',\n",
       " '2017-09-04',\n",
       " '2017-09-05',\n",
       " '2017-09-06',\n",
       " '2017-09-07',\n",
       " '2017-09-08',\n",
       " '2017-09-09',\n",
       " '2017-09-10',\n",
       " '2017-09-11',\n",
       " '2017-09-12',\n",
       " '2017-09-13',\n",
       " '2017-09-14',\n",
       " '2017-09-15',\n",
       " '2017-09-16',\n",
       " '2017-09-17',\n",
       " '2017-09-18',\n",
       " '2017-09-19',\n",
       " '2017-09-20',\n",
       " '2017-09-21',\n",
       " '2017-09-22',\n",
       " '2017-09-23',\n",
       " '2017-09-24',\n",
       " '2017-09-25',\n",
       " '2017-09-26',\n",
       " '2017-09-27',\n",
       " '2017-09-28',\n",
       " '2017-09-29',\n",
       " '2017-09-30',\n",
       " '2017-10-01',\n",
       " '2017-10-02',\n",
       " '2017-10-03',\n",
       " '2017-10-04',\n",
       " '2017-10-05',\n",
       " '2017-10-06',\n",
       " '2017-10-07',\n",
       " '2017-10-08',\n",
       " '2017-10-09',\n",
       " '2017-10-10',\n",
       " '2017-10-11',\n",
       " '2017-10-12',\n",
       " '2017-10-13',\n",
       " '2017-10-14',\n",
       " '2017-10-15',\n",
       " '2017-10-16',\n",
       " '2017-10-17',\n",
       " '2017-10-18',\n",
       " '2017-10-19',\n",
       " '2017-10-20',\n",
       " '2017-10-21',\n",
       " '2017-10-22',\n",
       " '2017-10-23',\n",
       " '2017-10-24',\n",
       " '2017-10-25',\n",
       " '2017-10-26',\n",
       " '2017-10-27',\n",
       " '2017-10-28',\n",
       " '2017-10-29',\n",
       " '2017-10-30',\n",
       " '2017-10-31',\n",
       " '2017-11-01',\n",
       " '2017-11-02',\n",
       " '2017-11-03',\n",
       " '2017-11-04',\n",
       " '2017-11-05',\n",
       " '2017-11-06',\n",
       " '2017-11-07',\n",
       " '2017-11-08',\n",
       " '2017-11-09',\n",
       " '2017-11-10',\n",
       " '2017-11-11',\n",
       " '2017-11-12',\n",
       " '2017-11-13',\n",
       " '2017-11-14',\n",
       " '2017-11-15',\n",
       " '2017-11-16',\n",
       " '2017-11-17',\n",
       " '2017-11-18',\n",
       " '2017-11-19',\n",
       " '2017-11-20',\n",
       " '2017-11-21',\n",
       " '2017-11-22',\n",
       " '2017-11-23',\n",
       " '2017-11-24',\n",
       " '2017-11-25',\n",
       " '2017-11-26',\n",
       " '2017-11-27',\n",
       " '2017-11-28',\n",
       " '2017-11-29',\n",
       " '2017-11-30',\n",
       " '2017-12-01',\n",
       " '2017-12-02',\n",
       " '2017-12-03',\n",
       " '2017-12-04',\n",
       " '2017-12-05',\n",
       " '2017-12-06',\n",
       " '2017-12-07',\n",
       " '2017-12-08',\n",
       " '2017-12-09',\n",
       " '2017-12-10',\n",
       " '2017-12-11',\n",
       " '2017-12-12',\n",
       " '2017-12-13',\n",
       " '2017-12-14',\n",
       " '2017-12-15',\n",
       " '2017-12-16',\n",
       " '2017-12-17',\n",
       " '2017-12-18',\n",
       " '2017-12-19',\n",
       " '2017-12-20',\n",
       " '2017-12-21',\n",
       " '2017-12-22',\n",
       " '2017-12-23',\n",
       " '2017-12-24',\n",
       " '2017-12-25',\n",
       " '2017-12-26',\n",
       " '2017-12-27',\n",
       " '2017-12-28',\n",
       " '2017-12-29',\n",
       " '2017-12-30',\n",
       " '2017-12-31']"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Days of the year 2017\n",
    "daysOfYear = []\n",
    "days = date(2017, 1, 1)\n",
    "while days.year == 2017:\n",
    "    daysOfYear.append(str(days))\n",
    "    days += timedelta(days=1)\n",
    "daysOfYear"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The days that are not public holidays"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The days that are not public holidays are: \n",
      "2017-01-01\n",
      "2017-01-02\n",
      "2017-03-14\n",
      "2017-03-22\n",
      "2017-04-16\n",
      "2017-04-17\n",
      "2017-05-01\n",
      "2017-10-19\n",
      "2017-11-28\n",
      "2017-11-29\n",
      "2017-12-08\n",
      "2017-12-25\n",
      "2017-02-27\n",
      "2017-02-28\n",
      "2017-03-24\n",
      "2017-04-02\n",
      "2017-04-14\n",
      "2017-05-25\n",
      "2017-06-17\n",
      "2017-06-20\n",
      "2017-07-09\n",
      "2017-08-21\n",
      "2017-10-09\n",
      "2017-11-20\n",
      "2017-01-26\n",
      "2017-03-06\n",
      "2017-03-13\n",
      "2017-04-15\n",
      "2017-04-25\n",
      "2017-05-29\n",
      "2017-06-05\n",
      "2017-06-12\n",
      "2017-08-07\n",
      "2017-10-02\n",
      "2017-12-26\n",
      "2017-01-06\n",
      "2017-06-15\n",
      "2017-08-15\n",
      "2017-10-26\n",
      "2017-11-01\n",
      "2017-01-10\n",
      "2017-04-01\n",
      "2017-07-10\n",
      "2017-08-05\n",
      "2017-10-12\n",
      "2017-01-21\n",
      "2017-04-28\n",
      "2017-08-01\n",
      "2017-11-30\n",
      "2017-01-07\n",
      "2017-03-08\n",
      "2017-05-09\n",
      "2017-07-03\n",
      "2017-11-07\n",
      "2017-07-21\n",
      "2017-11-11\n",
      "2017-05-22\n",
      "2017-09-10\n",
      "2017-09-21\n",
      "2017-11-19\n",
      "2017-02-02\n",
      "2017-06-21\n",
      "2017-08-02\n",
      "2017-08-06\n",
      "2017-11-02\n",
      "2017-07-01\n",
      "2017-07-17\n",
      "2017-09-30\n",
      "2017-10-01\n",
      "2017-04-21\n",
      "2017-09-07\n",
      "2017-11-15\n",
      "2017-03-03\n",
      "2017-05-06\n",
      "2017-05-24\n",
      "2017-09-06\n",
      "2017-09-22\n",
      "2017-12-24\n",
      "2017-02-13\n",
      "2017-02-20\n",
      "2017-03-17\n",
      "2017-04-23\n",
      "2017-06-24\n",
      "2017-07-12\n",
      "2017-09-04\n",
      "2017-05-21\n",
      "2017-06-07\n",
      "2017-06-26\n",
      "2017-07-16\n",
      "2017-08-10\n",
      "2017-09-18\n",
      "2017-09-19\n",
      "2017-09-20\n",
      "2017-10-27\n",
      "2017-01-28\n",
      "2017-04-05\n",
      "2017-05-30\n",
      "2017-10-04\n",
      "2017-03-19\n",
      "2017-04-13\n",
      "2017-06-23\n",
      "2017-06-29\n",
      "2017-07-20\n",
      "2017-04-11\n",
      "2017-07-25\n",
      "2017-09-15\n",
      "2017-06-22\n",
      "2017-06-25\n",
      "2017-10-08\n",
      "2017-07-26\n",
      "2017-07-27\n",
      "2017-10-10\n",
      "2017-03-25\n",
      "2017-04-18\n",
      "2017-06-04\n",
      "2017-10-28\n",
      "2017-05-08\n",
      "2017-07-05\n",
      "2017-07-06\n",
      "2017-09-28\n",
      "2017-11-17\n",
      "2017-05-12\n",
      "2017-05-26\n",
      "2017-12-31\n",
      "2017-05-28\n",
      "2017-08-16\n",
      "2017-09-24\n",
      "2017-11-06\n",
      "2017-11-03\n",
      "2017-01-25\n",
      "2017-07-23\n",
      "2017-10-06\n",
      "2017-05-03\n",
      "2017-05-07\n",
      "2017-05-10\n",
      "2017-08-03\n",
      "2017-08-04\n",
      "2017-11-08\n",
      "2017-11-09\n",
      "2017-11-10\n",
      "2017-11-12\n",
      "2017-11-13\n",
      "2017-11-21\n",
      "2017-02-24\n",
      "2017-08-20\n",
      "2017-07-28\n",
      "2017-07-29\n",
      "2017-11-04\n",
      "2017-12-06\n",
      "2017-05-27\n",
      "2017-07-14\n",
      "2017-03-12\n",
      "2017-08-17\n",
      "2017-02-18\n",
      "2017-07-22\n",
      "2017-10-03\n",
      "2017-10-31\n",
      "2017-11-22\n",
      "2017-02-07\n",
      "2017-08-11\n",
      "2017-10-25\n",
      "2017-06-30\n",
      "2017-10-20\n",
      "2017-02-23\n",
      "2017-05-05\n",
      "2017-03-01\n",
      "2017-05-18\n",
      "2017-10-17\n",
      "2017-11-18\n",
      "2017-12-05\n",
      "2017-02-11\n",
      "2017-09-08\n",
      "2017-10-21\n",
      "2017-03-15\n",
      "2017-10-23\n",
      "2017-04-20\n",
      "2017-06-01\n",
      "2017-10-30\n",
      "2017-06-02\n",
      "2017-05-23\n",
      "2017-10-16\n",
      "2017-01-09\n",
      "2017-04-29\n",
      "2017-05-04\n",
      "2017-11-23\n",
      "2017-12-23\n",
      "2017-05-14\n",
      "2017-03-11\n",
      "2017-02-16\n",
      "2017-10-11\n",
      "2017-03-29\n",
      "2017-02-10\n",
      "2017-03-31\n",
      "2017-12-13\n",
      "2017-02-06\n",
      "2017-03-20\n",
      "2017-01-08\n",
      "2017-08-27\n",
      "2017-08-28\n",
      "2017-08-31\n",
      "2017-09-03\n",
      "2017-10-14\n",
      "2017-01-27\n",
      "2017-07-11\n",
      "2017-07-13\n",
      "2017-07-15\n",
      "2017-11-26\n",
      "2017-12-29\n",
      "2017-01-11\n",
      "2017-07-30\n",
      "2017-08-14\n",
      "2017-02-03\n",
      "2017-04-07\n",
      "2017-09-25\n",
      "2017-03-21\n",
      "2017-08-26\n",
      "2017-12-10\n",
      "2017-04-27\n",
      "2017-02-01\n",
      "2017-04-06\n",
      "2017-07-19\n",
      "2017-09-14\n",
      "2017-04-24\n",
      "2017-12-18\n",
      "2017-05-17\n",
      "2017-11-05\n",
      "2017-05-15\n",
      "2017-09-29\n",
      "2017-08-30\n",
      "2017-06-10\n",
      "2017-10-05\n",
      "2017-12-01\n",
      "2017-01-16\n",
      "2017-07-04\n",
      "2017-01-24\n",
      "2017-01-03\n",
      "2017-01-04\n",
      "2017-01-05\n",
      "2017-02-05\n",
      "2017-08-29\n",
      "2017-09-01\n",
      "2017-02-08\n",
      "2017-05-02\n",
      "2017-06-16\n",
      "2017-08-09\n",
      "2017-12-16\n",
      "2017-05-31\n",
      "2017-06-09\n",
      "2017-09-02\n",
      "2017-09-11\n",
      "2017-02-25\n",
      "2017-08-08\n",
      "2017-11-25\n",
      "2017-06-06\n",
      "2017-01-14\n",
      "2017-04-09\n",
      "2017-08-13\n",
      "2017-10-15\n",
      "2017-05-19\n",
      "2017-10-29\n",
      "2017-06-28\n",
      "2017-08-24\n",
      "2017-01-20\n",
      "2017-04-19\n",
      "2017-06-19\n",
      "2017-07-18\n",
      "2017-08-25\n",
      "2017-01-15\n",
      "2017-02-12\n",
      "2017-06-18\n",
      "2017-06-27\n",
      "2017-07-24\n",
      "2017-12-17\n",
      "2017-04-30\n",
      "2017-02-21\n",
      "2017-12-22\n"
     ]
    }
   ],
   "source": [
    "for day in Holidays:\n",
    "    daysOfYear.remove(day)\n",
    "Non_holidays = Holidays\n",
    "print(\"The days that are not public holidays are: \",*Non_holidays, sep = \"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}