Daily Climate Time Series Data

Daily climate data in the city of Delhi from 2013 to 2017

@kaggle.sumanthvrao_daily_climate_time_series_data

Table List

2 tables(44.91 KB)

Dailydelhiclimatetrain

@kaggle.sumanthvrao_daily_climate_time_series_data.dailydelhiclimatetrain

36.96 KB
1462 rows
5 columns

date Date	meantemp Meantemp	humidity Humidity	wind_speed Wind Speed	meanpressure Meanpressure
Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	10	84.5		1015.6666666666666
Wed Jan 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7.4	92	2.98	1017.8
Thu Jan 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7.166666666666667	87	4.633333333333334	1018.6666666666666
Fri Jan 04 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	8.666666666666666	71.33333333333333	1.2333333333333334	1017.1666666666666
Sat Jan 05 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	6	86.83333333333333	3.7	1016.5
Sun Jan 06 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7	82.8	1.48	1018
Mon Jan 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	7	78.6	6.3	1020
Tue Jan 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	8.857142857142858	63.71428571428572	7.142857142857143	1018.7142857142856
Wed Jan 09 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14	51.25	12.5	1017
Thu Jan 10 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	11	62	7.399999999999999	1015.6666666666666


CREATE TABLE dailydelhiclimatetrain (
  "date" TIMESTAMP,
  "meantemp" DOUBLE,
  "humidity" DOUBLE,
  "wind_speed" DOUBLE,
  "meanpressure" DOUBLE
);