Air Quality In Hyderabad: Pollution Analysis.

Explore pollution data to predict AQI in Hyderabad for environmental analysis.

@kaggle.manavgupta92_airqualityindexdata

Table List

1 table(11.11 KB)

Aqi Data Set

@kaggle.manavgupta92_airqualityindexdata.aqi_data_set

11.11 KB
72 rows
11 columns

id Id	mounths Mounths	pm10_in_g_m3 PM10 In Æg/m3	so2_in_g_m3 SO2 In Æg/m3	nox_in_g_m3 NOx In Æg/m3	n__pm2_5_in_g_m3 PM2.5 In Æg/m3	ammonia_nh3_in_g_m3 Ammonia - NH3 In Æg/m3	o3_in_g_m3 O3 In Æg/m3	co_in_mg_m3 CO In Mg/m3	n__benzene_in_g_m3 Benzene In Æg/m3	aqi AQI
1	Jan-17	174	26.4	35	79	25	107.6	0.9	0.7	149
2	Feb-17	143	35.1	40.3	75	31	103	0.9	0.9	129
3	Mar-17	142	32.1	30.9	59	26	80.7	0.8	0.5	128
4	Apr-17	117	50.9	36.3	75	36	79.5	0.9	0.7	111
5	May-17		41.6	25.2	53	28	70	0.5	0.5
6	Jun-17		35.5	21.2	25	26	38.8	0.3	0.6
7	Jul-17	111	38.9	21.5	29	30	24.4	0.3	0.7	106.7
8	Aug-17	78	36	18.4	35	23	22.5	0.4	0.5	78.3
9	Sep-17	86	30	22.3	39	20	35.2	0.4	0.4	86
10	Oct-17	146	37.1	32.6	63	23	52.8	0.6	0.5	130


CREATE TABLE aqi_data_set (
  "id" BIGINT,
  "mounths" VARCHAR,
  "pm10_in_g_m3" DOUBLE,
  "so2_in_g_m3" DOUBLE,
  "nox_in_g_m3" DOUBLE,
  "n__pm2_5_in_g_m3" BIGINT,
  "ammonia_nh3_in_g_m3" DOUBLE,
  "o3_in_g_m3" DOUBLE,
  "co_in_mg_m3" DOUBLE,
  "n__benzene_in_g_m3" DOUBLE,
  "aqi" DOUBLE
);