One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
http https://data.giss.nasa.gov/gistemp/tabledata_v4/GLB.Ts+dSST.csv | sed 1d | | |
spyql " | |
SELECT Year, cols[1:13] AS temps | |
FROM csv | |
TO json" | | |
spyql " | |
SELECT json->Year + ((row_number-1)%12)/12 AS year, json->temps AS temp | |
FROM json | |
EXPLODE json->temps | |
WHERE json->temps is not Null |