Project-1
KevinKassabian/Project-1
This is a project showcasing a dataset which contains infographic information about a hypothetical London. The goal is to extract the raw data from excel files, clean them through various means and to analyze said data by creating insightful visualizations. Data Acquired from my ACA(Armenian Code Academy) Data Analytics course instructor.
Summary
A data cleaning and analysis project focused on a hypothetical London dataset. The project demonstrates a full pipeline: cleaning messy Excel data with Python (pandas, numpy, dateutil, re), further transforming and storing the data in PostgreSQL using SQL queries, and finally performing analysis and visualization in Power BI. The README documents the process with before/after screenshots and explains the logic for handling null values and data defects.