Solar Radiation Prediction

Task from NASA Hackathon

@kaggle.dronio_solarenergy

Table List

1 table(650.29 KB)

Solarprediction

@kaggle.dronio_solarenergy.solarprediction

650.29 KB
32686 rows
11 columns

unixtime UNIXTime	data Data	time Time	radiation Radiation	temperature Temperature	pressure Pressure	humidity Humidity	winddirection_degrees WindDirection(Degrees)	speed Speed	timesunrise TimeSunRise	timesunset TimeSunSet
1475229326	9/29/2016 12:00:00 AM	23:55:26	1.21	48	30.46	59	177.39	5.62	06:13:00	18:13:00
1475229023	9/29/2016 12:00:00 AM	23:50:23	1.21	48	30.46	58	176.78	3.37	06:13:00	18:13:00
1475228726	9/29/2016 12:00:00 AM	23:45:26	1.23	48	30.46	57	158.75	3.37	06:13:00	18:13:00
1475228421	9/29/2016 12:00:00 AM	23:40:21	1.21	48	30.46	60	137.71	3.37	06:13:00	18:13:00
1475228124	9/29/2016 12:00:00 AM	23:35:24	1.17	48	30.46	62	104.95	5.62	06:13:00	18:13:00
1475227824	9/29/2016 12:00:00 AM	23:30:24	1.21	48	30.46	64	120.2	5.62	06:13:00	18:13:00
1475227519	9/29/2016 12:00:00 AM	23:25:19	1.2	49	30.46	72	112.45	6.75	06:13:00	18:13:00
1475227222	9/29/2016 12:00:00 AM	23:20:22	1.24	49	30.46	71	122.97	5.62	06:13:00	18:13:00
1475226922	9/29/2016 12:00:00 AM	23:15:22	1.23	49	30.46	80	101.18	4.5	06:13:00	18:13:00
1475226622	9/29/2016 12:00:00 AM	23:10:22	1.21	49	30.46	85	141.87	4.5	06:13:00	18:13:00


CREATE TABLE solarprediction (
  "unixtime" BIGINT,
  "data" VARCHAR,
  "time" VARCHAR,
  "radiation" DOUBLE,
  "temperature" BIGINT,
  "pressure" DOUBLE,
  "humidity" BIGINT,
  "winddirection_degrees" DOUBLE,
  "speed" DOUBLE,
  "timesunrise" VARCHAR,
  "timesunset" VARCHAR
);