Skip to content

Latest commit

 

History

History
35 lines (28 loc) · 1.81 KB

README.md

File metadata and controls

35 lines (28 loc) · 1.81 KB

EU Power Plants Exploratory Data Analysis

This project is an Exploration of EU-27 Power Plants. The repository consists of the EDA, PostreSQL Database creation and an interactive map of the power plants.

Overview

The purpose of this project is to analyze EU-27 Power Plants, examining their source types, emissions, power, capacity, and efficiency.

Technologies Used

  • Python 3.11.6 (pandas, numpy, matplotlib, seaborn, psycopg, sqlalchemy)
  • PostreSQL
  • JavaScript (D3.js)
  • HTML, CSS

Structure

🔷 powerplants-to-sql.ipynb

  • Cleaning the downloaded csv data
  • Uploading data into PostreSQL database

🔷powerplants_db_create.sql

  • SQL Database creation query

🔷 powerplants-eda.ipynb

  • Quering the data from SQL database
  • Data Cleaning, Transformation and Feature Engineering
  • Exploratory Data Analysis
  • Data Visualization

🔷 /app

  • index.html, styles.css - HTML and CSS of the web map
  • script.js - D3.js SVG Map script

Data Sources