How to tidy data with R

weather_data2.csv

library(tidyverse)

2.0s

weather <- read_csv2(weather_data2.csv
)
str(weather)

0.8s

The weather dataset suffers from one of the five most common symptoms of messy data: column names are values. In particular, the column names X1 and X2 represent days of the month, which should really be values of a new variable called day.

weather2 <- gather(weather, day, value, X1:X2, na.rm = TRUE)

0.7s

# First remove column of row names
weather2 <- weather2[, -1]

0.6s