Reading

Background

You are at a family gathering at Niagara Falls and your grandfather, who lives nearby, claims that summer temperatures are colder now than they were when he was a kid in the 1920s. Your inner data scientist thinks this is unlikely but you decide to look into it.

You will use the NASA GISS temperature record for the Buffalo Niagara Airport available from this website. Later we’ll learn how to use APIs to interact with online databases, but for now we’ll work with a simple csv file.

Instructions

Download the temperature data

library(tidyverse)

# define the link to the data - you can try this in your browser too
dataurl="https://raw.githubusercontent.com/AdamWilsonLab/SpatialDataScience/master/docs/02_assets/buffaloweather.csv"

This url points to a CSV file with monthly mean temperatures from the GISS dataset. You can check out the file here. Now use read_csv() to download and import the CSV file directly from the website (cool, huh!?).

temp=read_csv(dataurl,
              skip=1, #skip the first line which has column names
              na="999.90", # tell R that 999.90 means missing in this dataset
              col_names = c("YEAR","JAN","FEB","MAR", # define column names 
                            "APR","MAY","JUN","JUL",  
                            "AUG","SEP","OCT","NOV",  
                            "DEC","DJF","MAM","JJA",  
                            "SON","metANN"))
# renaming is necessary becuase they used dashes ("-")
# in the column names and R doesn't like that.

Explore the data

Now use your tools to explore the dataset. You can try View(temp) to open the table in a browsable ‘excel-like’ window. Or summary(temp) to get summaries of each column.

Develop the graphic

You want to make a nice graphic to show your grandfather at your next family gathering. Be sure to include informative axis labels, a graph title, a graph subtitle describing the source of the data, the raw data, and a smoothed line showing the overal trend through time.

Specific Tasks

  • Create a new R script in RStudio
  • Load data from a comma-separated-values formatted text file hosted on a website
  • Graph the annual mean temperature in June, July and August (JJA) using ggplot
  • Add a smooth line with geom_smooth()
  • Add informative axis labels using xlab() and ylab() including units
  • Add a graph title with ggtitle()
  • Save a graphic to a png file using png() and dev.off() OR ggsave
  • Save the script
  • Click ‘Source’ in RStudio to run the script from beginning to end to re-run the entire process

What do you tell your grandfather?

Extra time?

If you have extra time, use the station selector to find the links to download additional stations and make additional plots. You could even merge different stations into the same table and plot them together.