Air Quality And Pollution Assessment

Environmental Metrics and Demographic Insights for Predicting Air Quality

@kaggle.mujtabamatin_air_quality_and_pollution_assessment

Table List

1 table(79.07 KB)

Updated Pollution Dataset

@kaggle.mujtabamatin_air_quality_and_pollution_assessment.updated_pollution_dataset

79.07 KB
5000 rows
10 columns

temperature Temperature	humidity Humidity	pm2_5 PM2.5	pm10 PM10	no2 NO2	so2 SO2	co CO	proximity_to_industrial_areas Proximity To Industrial Areas	population_density Population Density	air_quality Air Quality
29.8	59.1	5.2	17.9	18.9	9.2	1.72	6.3	319	Moderate
28.3	75.6	2.3	12.2	30.8	9.7	1.64	6	611	Moderate
23.1	74.7	26.7	33.8	24.4	12.6	1.63	5.2	619	Moderate
27.1	39.1	6.1	6.3	13.5	5.3	1.15	11.1	551	Good
26.5	70.7	6.9	16	21.9	5.6	1.01	12.7	303	Good
39.4	96.6	14.6	35.5	42.9	17.9	1.82	3.1	674	Hazardous
41.7	82.5	1.7	15.8	31.1	12.7	1.8	4.6	735	Poor
31	59.6	5	16.8	24.2	13.6	1.38	6.3	443	Moderate
29.4	93.8	10.3	22.7	45.1	11.8	2.03	5.4	486	Poor
33.2	80.5	11.1	24.4	32	15.3	1.69	4.9	535	Poor


CREATE TABLE updated_pollution_dataset (
  "temperature" DOUBLE,
  "humidity" DOUBLE,
  "pm2_5" DOUBLE,
  "pm10" DOUBLE,
  "no2" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "proximity_to_industrial_areas" DOUBLE,
  "population_density" BIGINT,
  "air_quality" VARCHAR
);