Plot of the global temperature trend using the command-line with SPyQL and rush

global_temperature_trend.sh

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 
  TO csv" |
rush plot --x year --y temp --xlab 'Year' --ylab 'Temperature anomaly w.r.t. 1951-80 (ºC)' --geom smooth --title 'Global surface temperature trend (land and ocean)' -o global_temperature_trend.png