Introduction

Last weekend, I dedicated my time to hone my Python skills through an end-to-end ETL project focused on extracting sustainability performance data from various universities.
Since the time I've been introduced to Python scripting—it has completely changed the way I process data! 🐍📊

Project Phases

Here’s a quick overview of the project phases:

1)Defining the data sources📥
As the first step of the project, I extracted URLs for the sustainability reports for over 350 Universities from the AASHE STARS Participants & Reports portal.
2)Data Extraction & Transformation 🔀
I then wrote a Python script that opened each report URL, accessed the first report for each university, and then finally extracted the necessary data. This extraction was done using the BeautifulSoup package in python.
3)Data Loading 📊
The extracted data was then organized into an output dataframe, prepared for analysis and visualization.
4)Data Visualization 📈 (This part is still work in progress)
Currently, I am focusing on the visualization of this data. I’m looking for someone with Python visualization skills to collaborate. If you’re interested, please reach out!

This project was updated on 27th May 2024.
I'm currently working on the data visualization for the project and I update the new visuals soon.

Thank you!