AQUI Air Index

This dataset provides a consolidated view of air quality and weather conditions across major Indian cities. The data is collected from live AQI monitoring stations and includes both environmental pollution metrics and current weather information.

The dataset was built as part of an automated data engineering project that collects, transforms, and stores real-time environmental data for analytics and dashboarding purposes.

Features Included
Air Quality Metrics
AQI (Air Quality Index)
AQI-IN (Indian AQI)
PM2.5
PM10
CO (Carbon Monoxide)
NO₂ (Nitrogen Dioxide)
O₃ (Ozone)
SO₂ (Sulfur Dioxide)
Weather Metrics
Temperature (°C and °F)
Feels Like Temperature
Humidity
Wind Speed & Direction
Visibility
UV Index
Cloud Cover
Atmospheric Pressure
Precipitation
Location Information
Station Name
City
State
Country
Latitude & Longitude
Time Zone
Last Updated Timestamp
Potential Use Cases
Air quality analysis across Indian cities
Pollution trend monitoring
Weather and AQI correlation studies
Environmental analytics projects
Power BI dashboards
Streamlit applications
Data visualization and storytelling
Machine Learning and forecasting experiments
Dataset Coverage

The dataset currently covers major cities across India, including:

-Ahmedabad
-Bangalore
-Chennai
-Hyderabad
-Kolkata
-Mumbai
-New Delhi
-Pune
-Lucknow
-Jaipur
-Kochi
-Bhubaneswar
-Guwahati
-Patna
-Dehradun
-Shimla
-Gangtok

and several other cities.

Notes
Data represents the latest available measurements at the time of collection.
Air quality values may vary throughout the day as monitoring stations are updated.
Missing pollutant values, when unavailable from the source, are recorded as 0 for consistency.
Project Background

This dataset was generated through a Python-based automated data pipeline using:

• Python
• Requests
• Pandas
• Google Sheets
• GitHub Actions

The goal of the project is to create a scalable environmental monitoring platform that can support dashboarding, analytics, and future forecasting applications.