Project Workflow

Data Sources

Historical AQI Data

Used for Trend analysis, Seasonal analysis and Forecasting

Sources:

• Central Pollution Control Board (CPCB)

• Open Government Data Platform (OGD)

• Publicly available AQI datasets

Live AQI Data

Used for:  Real-time monitoring and Historical collection

Source:

• World Air Quality Index Project (AQICN)

https://aqicn.org/map/india/

This project combines publicly available historical AQI data with live observations collected through the World Air Quality Index (AQICN) API. Data is processed using Python, Google Apps Script, and Google Sheets before being visualized in Looker Studio.

Data Collection Process

Historical Dataset

Historical AQI observations spanning 2022–2025 were collected from publicly available environmental datasets. The Data underwent preprocessing, including cleaning, organization, and validation of missing values, before being used for exploratory analysis, visualization, and forecasting.

Live Dataset

Real-time AQI observations are collected automatically through the AQICN API using Google Apps Script. Each update is stored in Google Sheets, creating a continuously growing dataset that supports both live monitoring and historical trend analysis.

Tools & Technologies

Python

Data processing and forecasting.

Google Sheets

Data storage and automation.

Google Apps Script

Automated AQI collection.

Looker Studio

Dashboard creation and visualization.

Google Sites

Website development.

Limitations

Data Limitations

• Forecasts depend on historical trends.

• Air quality can change due to unexpected events.

• Some monitoring stations may experience temporary data gaps.

Analytical Limitations

• Forecasts cannot account for all future environmental conditions.

• Real-world AQI is influenced by weather, policy, and human activity.

Reproducibility & Transparency

This project emphasizes transparency by clearly documenting:

• Data sources

• Collection methods

• Analytical techniques

• Visualization approaches

The goal is to make environmental data easier to explore, understand, and discuss.

Disclaimer:  This project is an educational initiative developed for learning and research purposes. Live AQI data is sourced from the World Air Quality Index (AQICN), while historical analyses are based on publicly available datasets.  Data is processed using Python, Google Apps Script, and Google Sheets before being visualized in Looker Studio. Forecasts represent model-based estimates and should not be interpreted as official predictions.

Meet the Creator

Learn more about the motivation behind the project and the student who developed it.