Dataset Description
dataset Structure
'data.frame': 3317 obs. of 11 variables:
$ country : chr "India" "India" "India" "India" ...
$ state : chr "Andhra_Pradesh" "Andhra_Pradesh" "Andhra_Pradesh" "Andhra_Pradesh" ...
$ city : chr "Amaravati" "Anantapur" "Kadapa" "Tirupati" ...
$ station : chr "Secretariat, Amaravati - APPCB" "Gulzarpet, Anantapur - APPCB" "Yerramukkapalli, Kadapa - APPCB" "Tirumala, Tirupati - APPCB" ...
$ last_update : chr "17-09-2024 08:00:00" "17-09-2024 08:00:00" "17-09-2024 08:00:00" "17-09-2024 08:00:00" ...
$ latitude : num 16.5 14.7 14.5 13.7 13.7 ...
$ longitude : num 80.5 77.6 78.8 79.3 79.3 ...
$ pollutant_id : chr "CO" "PM2.5" "CO" "PM10" ...
$ pollutant_min: int 30 27 NA 16 1 NA NA NA NA 64 ...
$ pollutant_max: int 100 73 NA 60 2 NA NA NA NA 123 ...
$ pollutant_avg: int 46 49 NA 39 1 NA NA NA NA 86 ...summary statistics
carat cut color clarity depth
Min. :0.2000 Fair : 1610 D: 6775 SI1 :13065 Min. :43.00
1st Qu.:0.4000 Good : 4906 E: 9797 VS2 :12258 1st Qu.:61.00
Median :0.7000 Very Good:12082 F: 9542 SI2 : 9194 Median :61.80
Mean :0.7979 Premium :13791 G:11292 VS1 : 8171 Mean :61.75
3rd Qu.:1.0400 Ideal :21551 H: 8304 VVS2 : 5066 3rd Qu.:62.50
Max. :5.0100 I: 5422 VVS1 : 3655 Max. :79.00
J: 2808 (Other): 2531
table price x y
Min. :43.00 Min. : 326 Min. : 0.000 Min. : 0.000
1st Qu.:56.00 1st Qu.: 950 1st Qu.: 4.710 1st Qu.: 4.720
Median :57.00 Median : 2401 Median : 5.700 Median : 5.710
Mean :57.46 Mean : 3933 Mean : 5.731 Mean : 5.735
3rd Qu.:59.00 3rd Qu.: 5324 3rd Qu.: 6.540 3rd Qu.: 6.540
Max. :95.00 Max. :18823 Max. :10.740 Max. :58.900
z
Min. : 0.000
1st Qu.: 2.910
Median : 3.530
Mean : 3.539
3rd Qu.: 4.040
Max. :31.800
Check for missing values
country state city station last_update
0 0 0 0 0
latitude longitude pollutant_id pollutant_min pollutant_max
0 0 0 270 270
pollutant_avg
270 country state city station
1 India Andhra_Pradesh Amaravati Secretariat, Amaravati - APPCB
2 India Andhra_Pradesh Anantapur Gulzarpet, Anantapur - APPCB
4 India Andhra_Pradesh Tirupati Tirumala, Tirupati - APPCB
5 India Andhra_Pradesh Tirupati Tirumala, Tirupati - APPCB
10 India Andhra_Pradesh Visakhapatnam GVM Corporation, Visakhapatnam - APPCB
11 India Andhra_Pradesh Visakhapatnam GVM Corporation, Visakhapatnam - APPCB
last_update latitude longitude pollutant_id pollutant_min
1 17-09-2024 08:00:00 16.51508 80.51817 CO 30
2 17-09-2024 08:00:00 14.67589 77.59303 PM2.5 27
4 17-09-2024 08:00:00 13.67000 79.35000 PM10 16
5 17-09-2024 08:00:00 13.67000 79.35000 NH3 1
10 17-09-2024 08:00:00 17.72000 83.30000 PM2.5 64
11 17-09-2024 08:00:00 17.72000 83.30000 NO2 32
pollutant_max pollutant_avg
1 100 46
2 73 49
4 60 39
5 2 1
10 123 86
11 58 39Filter data for CO pollutant
country state city station
1 India Andhra_Pradesh Amaravati Secretariat, Amaravati - APPCB
3 India Andhra_Pradesh Kadapa Yerramukkapalli, Kadapa - APPCB
9 India Andhra_Pradesh Vijayawada Rajiv Gandhi Park, Vijayawada - APPCB
30 India Bihar Bettiah Kamalnath Nagar, Bettiah - BSPCB
33 India Bihar Bihar Sharif D M Colony, Bihar Sharif - BSPCB
36 India Bihar Chhapra Darshan Nagar, Chhapra - BSPCB
last_update latitude longitude pollutant_id pollutant_min
1 17-09-2024 08:00:00 16.51508 80.51817 CO 30
3 17-09-2024 08:00:00 14.46505 78.82419 CO NA
9 17-09-2024 08:00:00 16.50972 80.61222 CO NA
30 17-09-2024 08:00:00 26.80365 84.51954 CO 30
33 17-09-2024 08:00:00 25.20476 85.51496 CO 3
36 17-09-2024 08:00:00 25.78083 84.74468 CO 14
pollutant_max pollutant_avg
1 100 46
3 NA NA
9 NA NA
30 103 101
33 28 15
36 32 28Analysis
Histogram for CO levels
Boxplot for CO levels
Column {data-width=200}
Scatter plot for CO levels (avg vs max)
