{"repo":"granthjoshi01/AQI-Analysis-Project","free":true,"listed":false,"github":"https://github.com/granthjoshi01/AQI-Analysis-Project","clone":"git clone https://github.com/granthjoshi01/AQI-Analysis-Project.git","description":"End-to-end AQI data pipeline with automated collection, historical storage, and live dashboard analytics.","language":"Python","stars":11,"topics":["air-quality-monitor","dashboard","data-engineering","etl-pipeline-automation","google-sheets-api","python3","time-series-analysis"],"license":"MIT","category":"dashboards-admin","readme_excerpt":"AQI Analysis & Live Monitoring Pipeline An end-to-end data engineering and analytics project that automatically collects air quality data, maintains historical records, and presents live analytical insights through a dashboard. This project focuses on correct data pipelines, reliable storage, and meaningful analytics, not just visualizations. ⸻ Project Overview This system continuously fetches Air Quality Index (AQI) and pollutant data for selected Indian cities, stores it as a clean historical dataset, and exposes it to a live dashboard for analysis. Key goals: • Automate AQI data collection • Preserve historical data (time-series) • Ensure data quality and consistency • Enable real-time analytical dashboards Note : AQI values are categorical (1–5) and based on pollutant thresholds. Once the Very Poor threshold is crossed, AQI saturates at 5 even if pollutant concentrations continue to increase. Differences between cities are better understood by comparing individual pollutant levels. ⸻ The Plunge in the dashboard was due to internet unstability during that day Live Dashboard : https://lookerstudio.google.com/reporting/febbd29c-ea0e-42f7-8d8c-a951bbfe91c0 Live spreadsheet :https://docs.google.com/spreadsheets/d/1lbDIBplg5ONuxJjtqAfFaY5IqHj0SAYDNaj0z58xGuc/edit?usp=sharing 📄 A production incident and lessons learned are documented in POSTMORTEM.md For a deeper understanding of AQI within this project—especially how cities like Delhi and Udaipur can both saturate at AQI 5 whi","default_branch":null,"files":null,"tree":[],"storefront":"/r/granthjoshi01","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/granthjoshi01/AQI-Analysis-Project/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}