Air Pollution data-Telangana, Sanathnagar, Hyderabad

by theDataTalks . 14 Mar 2020

Telangana has 6 stations for continuous monitoring of air pollution and
all are in Hyderabad. This document talks about PM2.5 (Particulate
matter (PM) that have a diameter of less than 2.5 micrometers) level for
one of the station named Sanathnagar, Hyderabad.

Conclusions from the below analysis:

The PM2.5 data has 3.3% outliers and the details of outliers are given
in the below analysis. After removing the outliers the PM2.5 level for
Sanathnagar falls under the category of “moderate” in monsoon season &
“unhealthy” in other seasons.

There is not much difference in PM2.5 level for weekend & weekday.

Data:

Data Source: https://app.cpcbccr.com/
Date downloaded: 07-Jan-2020
Hourly data taken for this analysis from 31-Mar-2015 to 30-Nov-2019
Total 40921 records & 13059 records are having “none” reading for PM2.5.
All “none” records removed for this analysis. The complete analysis was
done using R programming.

Below are the categories defined in 2012 EPA (United States
Environmental Protection Agency) PM2.5 standard

Good - 0.0 – 12.0 µg/m3, 24-hour average
Moderate - 12.1 – 35.4 µg/m3, 24-hour average
Unhealthy for Sensitive Groups - 35.5 – 55.4 µg/m3, 24-hour average
Unhealthy - 55.5 – 150.4 µg/m3, 24-hour average
Very Unhealthy - 150.5 – 250.4 µg/m3, 24-hour average
Hazardous - 250.5 – 350.4 µg/m3, 24-hour average
Hazardous - 350.5 – 500 µg/m3, 24-hour average

Details of Outliers:

An outlier is any datapoint that lies outside the 1.5 * inter quartile
range (IQR). IQR is calculated as the distance between the 25th
percentile and 75th percentile values for that variable. We have
identified the outliers using R-command “BoxPlot”.

Below are the details of minimum, maximum, mean & median of identified
outliers.

Min.	1st Qu.	Median	Mean	3rd Qu.	Max.
121.6	149.9	201.3	422.5	977.9	995

The below box plot & bar chart shows the difference in data with & with
out outliers.

Outliers identified: 880
Proportion of outliers: 3.3%
Mean of the outliers: 422.46
Mean without removing outliers: 57.26
Mean after we remove outliers: 45.34

Yearly Mean/Average of Hourly PM2.5 for different Seasons

All the below results were calculated after removing outliers from the
source data. The first table shows the monthly average of PM2.5 & the
second table shows the 24 hours average for each month.

	1	2	3	4	5	6	7
month name	“Jan”	“Feb”	“Mar”	“Apr”	“May”	“Jun”	“Jul”
monthly_mean	“69.22”	“56.09”	“56.6”	“44.59”	“42.53”	“29.21”	“22.07”

	8	9	10	11	12
month name	“Aug”	“Sep”	“Oct”	“Nov”	“Dec”
monthly_mean	“22.14”	“36.77”	“50.36”	“59.5”	“64.72”

	Day	1	2	3	4	5	6	7	8	9	10	11	12
1	1	63.3	63.36	53.34	45.13	46.55	40	23.26	15.07	29.96	52.88	40.03	61.3
2	2	71.79	64.72	49.87	48.56	43.39	45.05	27.73	15.48	34.34	33.52	40.38	60.18
3	3	73.95	57.48	48.81	54.36	37.59	40.38	29.16	14.12	27.9	37.53	38.09	67.03
4	4	79.06	50.08	58.49	49.07	37.62	37.24	26.28	16.33	35.67	42.85	47.72	70.44
5	5	79.08	59.57	59.1	43.69	39.36	39.89	22.41	15.86	29.59	46.7	45.72	67.03
6	6	79.42	64.83	54.19	50.64	43.28	38.87	24.77	17.79	33.01	51.08	51.74	69.16
7	7	73.35	64.93	55.94	41.51	40.68	36.75	25.82	17.6	28.68	57.06	56.43	76.79
8	8	75.8	64.07	58.33	35.46	43.26	32.56	22.93	18.82	26.53	58.9	56.75	76.15
9	9	73.75	62.78	59.68	42.6	51.1	29.12	21.78	19.06	31.22	60.66	60.19	68.2
10	10	72.5	58.9	60.54	39.05	44.42	27.69	20.56	17.24	33.52	53.93	60.57	59.42
11	11	74.67	63.1	55.97	39.7	51.78	24.71	21.74	19.68	34.32	50.67	54.57	56.39
12	12	78.62	64.67	51.67	39.78	43.78	24.23	23.36	16.42	35.2	53.37	64.88	65.11
13	13	75.29	60.55	51.29	40.24	44.58	25.96	20.22	23.12	32.97	51.31	64.16	62.06
14	14	70.76	60.27	55.55	45.67	40.34	25.97	25.56	24.06	33.85	55.89	63.95	57.3
15	15	68.16	44.68	51.33	43.7	36.97	28.32	23.76	23.12	39.9	58.83	64.65	60.81
16	16	65.39	47.27	53.2	43.69	41.88	30.86	25.31	21.4	41.04	56.05	61.18	65.17
17	17	65.19	48.91	47.9	45.23	40.19	29.87	23.28	24.04	29.66	44.88	44.68	59.63
18	18	63.64	56.83	46.14	53.34	41.92	24.92	21.37	27.57	33.05	44.45	42.68	51.29
19	19	64.35	52.52	49.27	44.88	47.71	26.2	19.45	23.25	36.48	44.93	51.03	45.62
20	20	72.81	47.4	59.65	42.8	44.16	24.25	18.39	25.44	41.96	53.96	57.39	48.39
21	21	66.9	49.69	55.28	43.27	48.1	26.83	21.34	20.62	41.13	46.55	60.84	57.9
22	22	57.76	54.56	55.66	42.18	43.77	27.21	18.09	22.2	39.47	63.84	66.58	65.19
23	23	66.91	60.8	58.19	45.21	44.67	23.57	17.06	30.08	37.04	57.78	68.8	64.94
24	24	69.8	48.31	65.25	41.32	40.07	22.67	16.75	31.61	36.39	51.83	70.56	73.5
25	25	58.93	51.28	68.16	42.58	41.89	22.65	18.91	30.6	36.67	50.74	77.5	76.71
26	26	49.72	54.04	60.56	49.9	38.34	25.13	19.28	22.33	44.8	49.05	81.05	80.31
27	27	47.95	50.93	63.19	49.14	40.78	25.64	16.85	30.25	42.07	53.49	80.2	74.77
28	28	75.26	50.91	61.78	45.71	39.38	25.95	22.94	29.74	49.29	53.74	81.91	69.78
29	29	65.93	37.64	66.85	47.18	43.19	25.88	22.23	25.9	50.81	45.61	70.01	68.36
30	30	60.8	NA	60.43	46.19	39.71	24.44	15.09	23.42	61.86	47.34	63.03	68.44
31	31	62.49	NA	52.81	NA	40.29	NA	15.79	27.97	NA	43.27	NA	64.86

Season classification:

Mar, Apr & May - Summer
Jun, Jul, Aug, Sep & Oct - Monsoon
Nov, Dec, Jan & Feb - Winter

The below plot gird shows the year-wise details of hourly PM2.5 levels
for different seasons.The blue line across each plot indicates Smoothed
conditional means.

From the below data, it is very clear that the pollution levels are less
in Monsoon compared to other seasons.

Mean/Average of Hourly PM2.5 for Weekdays & Weekends

The below plot grid shows the hourly PM2.5 levels for weekdays and
weekends. The blue line across each plot indicates Smoothed conditional
means.

The below plot shows that, there is not much difference in PM2.5 levels
for weekdays & weekends.

The data file in *.CSV format can be downloaded from Sanathnagar-Air Pollution Data