THIS SHOULD BE SUPER EASY IF YOU KNOW HOW TO USE R STUDIO!!!

*so here are all of the commands that i used to tidy the data shown below*

library(rvest) library(httr) library(XML) library(plyr)

#Generation of list of dates Date <- seq(as.Date("2017/01/01"),by='day',as.Date("2018/03/18")) Date <- as.character(Date) Date <- gsub("-","/",Date)

#Programme Weather <- data.frame() for ( i in 1:length(Date)) { Webpage <- read_html(paste0('https://www.wunderground.com/history/airport/KMIC/',Date[1],'/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo=')) Values <- html_nodes(Webpage,'.indent+ td') Values <- html_text(Values) Dummy <- c(1:length(Values)) Dummy1 <- data.frame(rbind(Values,Dummy)) Parameters <- html_nodes(Webpage,'.indent') Parameters <- html_text(Parameters) colnames(Dummy1) <- Parameters Data <- Dummy1[1,1:length(Values)] Weather <- rbind.fill(Weather,Data) }

##Cleaning the data table ##Required Function for extratcting numbers library(stringr) numextract <- function(string){ str_extract(string, "\\-*\\d+\\.*\\d*") }

##Extracting the numbers from the table Weather[,1:14] <- sapply(Weather[,1:14],numextract)

##Providing dates and city names Weather$Date <- cbind(Date,Weather) Weather$City <- 'Minneapolis Crystal'

AFTER YOU HAVE PUT THIS INTO R

I have to come up with any question that addresses anything from this data that I have tidy and make any meaningful graphic that could explain this question. the data verbs we have learned are group_by, summarize, filter, select, arrange, mutate

10 points: use of piping and data verbs

10 points: meaningful data graphic that addresses question.

5 points: plots are annotated uniquely (titles, axes labeled, meaningful scales, etc)

10 points: narrative description of your data graphic