Climate Change Dataset2020–2024

Unveiling Earth's Symphony: Climate Change Insights from 2020 to 2024

@kaggle.atifmasih_climate_change_dataset2020_2024

Table List

1 table(25.33 KB)

Climate Change Dataset

@kaggle.atifmasih_climate_change_dataset2020_2024.climate_change_dataset

25.33 KB
53 rows
20 columns

year Year	month Month	avg_temp_c Avg Temp (°C)	max_temp_c Max Temp (°C)	min_temp_c Min Temp (°C)	precipitation_mm Precipitation (mm)	humidity Humidity (%)	wind_speed_m_s Wind Speed (m/s)	solar_irradiance_w_m Solar Irradiance (W/m²)	cloud_cover Cloud Cover (%)	co2_concentration_ppm CO2 Concentration (ppm)	latitude Latitude	longitude Longitude	altitude_m Altitude (m)	proximity_to_water_km Proximity To Water (km)	urbanization_index Urbanization Index	vegetation_index Vegetation Index	enso_index ENSO Index	particulate_matter_g_m Particulate Matter (µg/m³)	sea_surface_temp_c Sea Surface Temp (°C)
nan	1.0	-3.460515779331743	33.056918907353285	nan	184.89969755743786	89.62081302618182	9.742885739415993	nan	58.530797670209076		40.7128	nan	10.0	15.0		0.04423782887418304	0.6336943092843479	33.43707805480527	18.545360112309588
2020.0	2.0		25.901916083791665	3.1739745975583844	2.957244192049635	95.17102000342224	10.64824600272703	252.3136442294677	32.85666516634471	419.59592365802416	40.7128	-74.006	10.0	15.0	99999	0.6128400325468267	nan	24.504783135571934	15.909586979280654
2020.0	3.0	7.869842343867335	18.63424149980029	10.42485208665568	nan	nan	nan	247.39139984511084	29.380233637986674	416.6504582879432	40.7128	-74.006	10.0	15.0	0.3417315110218282	0.4665653848003175	-0.4280583600093959	32.3274997743319	21.281093622177334
nan	4.0	-0.0498626136153834	13.030562376875533	-9.196433418151315	102.4544605414934	Unknown	0.898697634212508	143.26161801322706	17.496855610388273	418.9228078130431	40.7128	-74.006	10.0	15.0	0.8963828325127179	0.030465932726280065	-0.5707078659552114	20.496275820817043	nan
2020.0	5.0	19.895067477882936	35.88212887551623	20.067999652410148	185.72922332959365	73.99994640624561	13.128301152215258	169.5494376964624	2.1937104861995405	401.89658759030175	40.7128	-74.006	10.0	99999.0	0.0761732035622401	nan	-0.2861494705734404	22.64905691725084	15.502968235198333
2020.0	6.0	2.1958863227793923	16.815980053623928	21.69339369094645	26.296148446729873	35.626443191624936	2.7860050941947905	158.7524359120713	96.05477049972627	400.35152991785486	nan	nan	10.0	15.0	0.731543715106451	0.04365568216176974	-0.23867083029214586	26.350879986637086	16.90621134574127
nan	7.0	-0.8315017708887984	nan	-9.098586846479657	22.98402037192848	nan	11.036926613168248	201.69895236814938	2.859401235842318	411.559105050758	nan	-74.006	10.0	15.0	0.1797197781852707	0.921412688375088	0.496792285006872	23.749488315782877	27.71362771832118
2020.0	8.0	5.241145172619772	23.018365507255687	-2.8241009285731744	100.23810532116136	75.36834893597688	12.462339982116639	89.70128267136548	92.01998586610826	423.2976034668884	40.7128	-74.006	10.0	15.0	0.4693462609656612	0.3578404397196293	0.5235609705809126	48.53486454396686	nan
2020.0	9.0	34.282302674973344	4.777629228981937	0.39121915565166177	199.45034189396836	96.81856590078783	8.00856854128788	227.88277854059066	98.88385241970374	432.83912572377307	40.7128	-74.006	10.0	15.0	0.3647412468996173	0.3564403191108527	nan	34.55780020584284	14.494095352151927
2020.0	10.0	25.979139842231827	11.02265627885938	-7.649405276953751	nan	86.06230719949002	99999.0	235.229354907283	51.5837019990618	444.483466470267	40.7128	-74.006	10.0	15.0		0.12975718070926812	-0.7530669500931289	15.21072251366412	17.138927964036846


CREATE TABLE climate_change_dataset (
  "year" VARCHAR,
  "month" VARCHAR,
  "avg_temp_c" DOUBLE,
  "max_temp_c" VARCHAR,
  "min_temp_c" VARCHAR,
  "precipitation_mm" VARCHAR,
  "humidity" VARCHAR,
  "wind_speed_m_s" VARCHAR,
  "solar_irradiance_w_m" VARCHAR,
  "cloud_cover" VARCHAR,
  "co2_concentration_ppm" DOUBLE,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "altitude_m" VARCHAR,
  "proximity_to_water_km" VARCHAR,
  "urbanization_index" DOUBLE,
  "vegetation_index" VARCHAR,
  "enso_index" VARCHAR,
  "particulate_matter_g_m" VARCHAR,
  "sea_surface_temp_c" VARCHAR
);