+---+-------------------+----+-----+----+----+------+------+-----------+-----------+-------------+-------+--------+---------+--------------------+-----+--------------------+
|loc| date| avg| min| max|rain|maxWin|avgWin|avgHumidity|sumSunshine|sumInsolation|sumSnow|avgCloud|avgGround| features|label| prediction|
+---+-------------------+----+-----+----+----+------+------+-----------+-----------+-------------+-------+--------+---------+--------------------+-----+--------------------+
| 93|2016-11-26 00:00:00|-1.6| -6.3| 0.8| 1.1| 1.9| 0.6| 83.0| 0.0| 2.53| 0.5| 8.1| -0.5|[93.0,-6.3,0.8,1....| -1.6| -2.496908458646051|
| 93|2016-12-08 00:00:00| 0.2| -6.3| 5.1| 1.8| 3.4| 0.5| 82.3| 2.7| 6.14| 0.5| 7.8| 0.5|[93.0,-6.3,5.1,1....| 0.2| -0.5542894685412494|
| 93|2017-01-21 00:00:00|-6.2|-13.0|-0.7| 1.1| 4.2| 1.1| 79.6| 6.7| 8.8| 1.3| 4.9| -3.4|[93.0,-13.0,-0.7,...| -6.2| -6.546222364120698|
| 93|2017-02-23 00:00:00| 0.8| -2.8| 4.4| 0.0| 4.1| 1.7| 56.1| 6.8| 12.17| 0.0| 4.4| 2.0|[93.0,-2.8,4.4,0....| 0.8| 0.4463458570826158|
| 93|2017-12-24 00:00:00| 0.9| -0.7| 2.4|10.4| 3.3| 0.7| 87.4| 0.0| 0.9| 1.8| 8.9| 0.2|[93.0,-0.7,2.4,10...| 0.9| 0.6885975508917763|
| 93|2018-01-08 00:00:00| 0.6| -2.1| 3.8| 1.1| 5.0| 1.4| 61.6| 0.8| 4.29| 2.0| 9.0| -0.4|[93.0,-2.1,3.8,1....| 0.6| 0.7107292458997987|
| 93|2018-01-22 00:00:00|-0.9| -3.8| 3.2| 3.7| 3.5| 0.7| 72.6| 1.1| 4.29| 5.0| 9.5| -0.7|[93.0,-3.8,3.2,3....| -0.9|-0.34255288616567536|
| 93|2018-02-23 00:00:00| 1.6| -3.4| 6.4| 4.4| 3.7| 0.9| 85.5| 4.8| 11.4| 7.6| 8.5| 1.9|[93.0,-3.4,6.4,4....| 1.6| 1.2598331080643832|
| 93|2018-11-24 00:00:00| 0.2| -1.7| 1.3| 4.4| 2.8| 0.5| 85.1| 0.0| 1.14| 8.5| 9.3| 0.9|[93.0,-1.7,1.3,4....| 0.2|-0.23102571771918803|
| 93|2019-02-19 00:00:00| 0.2| -1.3| 1.7| 5.7| 1.7| 0.2| 88.0| 0.0| 2.86| 4.0| 9.4| -0.2|[93.0,-1.3,1.7,5....| 0.2| 0.11007416263727621|
|100|2011-01-03 00:00:00|-7.8|-16.7|-2.8| 2.9| 4.1| 1.5| 83.0| 1.3| 6.67| 6.6| 7.9| -2.0|[100.0,-16.7,-2.8...| -7.8| -8.866293153141047|
|100|2011-01-14 00:00:00|-8.8|-15.8|-4.2| 0.3| 10.2| 5.6| 71.3| 6.3| 9.59| 0.4| 4.6| -6.9|[100.0,-15.8,-4.2...| -8.8| -9.537748097941778|
|100|2011-02-14 00:00:00|-8.0|-11.7|-4.3| 4.7| 4.5| 1.5| 85.0| 0.0| 3.06| 9.0| 8.8| -2.0|[100.0,-11.7,-4.3...| -8.0| -7.334369975934852|
|100|2011-02-28 00:00:00|-3.0| -3.8|-1.9| 1.4| 6.5| 2.5| 91.8| 0.0| 5.76| 2.2| 10.0| 0.0|[100.0,-3.8,-1.9,...| -3.0| -2.5884578762426624|
|100|2011-03-22 00:00:00|-1.5| -4.7| 2.6| 2.3| 8.0| 3.8| 52.4| 4.8| 15.27| 6.4| 5.0| 0.0|[100.0,-4.7,2.6,2...| -1.5| -1.2683076241902866|
|100|2011-03-25 00:00:00|-5.2|-12.7|-1.4| 4.8| 7.9| 3.2| 76.9| 4.5| 12.65| 8.5| 6.5| 0.0|[100.0,-12.7,-1.4...| -5.2| -6.562127722481371|
|100|2011-03-28 00:00:00|-0.2| -4.2| 4.0| 0.9| 6.4| 2.4| 79.0| 1.9| 9.63| 1.3| 8.4| 1.5|[100.0,-4.2,4.0,0...| -0.2|-0.07702383069997987|
|100|2011-12-02 00:00:00|-0.3| -1.9| 0.9| 3.0| 3.6| 1.9| 91.5| 0.0| 3.74| 3.4| 10.0| 0.6|[100.0,-1.9,0.9,3...| -0.3|-0.46808178532145883|
|100|2011-12-09 00:00:00|-6.3|-11.0|-2.7| 3.8| 4.7| 1.7| 85.9| 0.0| 1.27| 10.5| 8.5| 0.1|[100.0,-11.0,-2.7...| -6.3| -6.218081992323221|
|100|2012-01-01 00:00:00|-6.2|-10.4|-3.4| 0.3| 6.7| 4.5| 73.1| 5.9| 8.52| 0.4| 7.4| -4.0|[100.0,-10.4,-3.4...| -6.2| -6.621153351217983|
+---+-------------------+----+-----+----+----+------+------+-----------+-----------+-------------+-------+--------+---------+--------------------+-----+--------------------+
only showing top 20 rows