ETL - Elections 2019

📄 Objective

Develop an ETL (Extract, Load, Transform) of data related with national spanish elections from 2019. These data is enriched with unemployment rates by province and rent per capita.

🔩 Deployment

🔑 Prerequisites

1. To have installed conda
2. To have installed git

1️⃣ Installation instructions

The installation process is the next:

1. Clone this repository

git clone <url-repo>

2. Execute in the terminal

conda env create -n etl -f environment.yml

---

📁 Folder structure

└── Elections
    ├── .gitignore
    ├── data
        ├── 
        ├── 
        ├──      
    ├── nb
        ├── data_extraction.ipynb
        ├── 
        ├──     
    ├── img
        ├── 
        ├── 
        ├──    
    ├── sql
        ├──
        ├── 
        ├──  
    ├── environment.yml
    ├── README.md   

💻 Technology stack

---

• Jupyter Notebook
• MySQL

---

💥 Analysis developed

1. Data extraction

• WebScraping
  • Agencia Tributaria - Rent per capita by province
  • Unemployment rate in 2019 (datos.gob.es)
• CSV download
  • Election result data (infoelectoral)

---

📌 Some insights

---

💩 ToDo