1
Natural Language Query
2
Code Generation
3
Visualization
Plot the monthly average PM2.5 for the year 2023

Here's the monthly average PM2.5 plot for 2023:

Generated Python Code
Click to expand
import pandas as pd
import matplotlib.pyplot as plt

# Load and filter data for 2023
df_2023 = df[df['year'] == 2023]

# Calculate monthly averages
monthly_avg = df_2023.groupby('month')['pm25'].mean()

# Create the plot
plt.figure(figsize=(12, 6))
plt.plot(monthly_avg.index, monthly_avg.values, 
         marker='o', linewidth=3, markersize=8, 
         color='#3b82f6')

plt.title('Monthly Average PM2.5 - Gujarat 2023', fontsize=16, fontweight='bold')
plt.xlabel('Month', fontsize=12)
plt.ylabel('PM2.5 (ug/m3)', fontsize=12)
plt.grid(True, alpha=0.3)
plt.tight_layout()
plt.show()
Monthly Average PM2.5 - Gujarat 2023
WHO (15) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 0 40 80 100
Month
PM2.5 (ug/m3)
The chart shows highest PM2.5 levels in winter months with January at 95.2 and November at 91.7. Lowest levels occur during monsoon season with July at 25.1. All months exceed WHO annual guideline of 15.
Which month had the highest PM2.5 pollution in 2023?
January 2023 had the highest PM2.5 pollution with an average concentration of 95.2.
This value is 6.3 times higher than the WHO annual guideline of 15 and represents typical winter pollution patterns in Gujarat.
Which cities in Gujarat have the worst air quality?
1. Ahmedabad: 68.3
2. Surat: 61.7
3. Vadodara: 58.9
4. Rajkot: 52.4
5. Gandhinagar: 48.1
All cities exceed WHO guidelines by 3-4x. Industrial activity and vehicular emissions are primary contributors.