r-help
Needing to transform some data for a time series (1930 - 2018). > tempDat # A tibble: 89 x 13 Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> 1 1930 52 60.3 60.6 72.2 71.7 86.8 91.3 89.7 82.3 70.4 60.2 52.2 2 1931 52.9 57.8 62.7 72.4 80.5 87 95.1 89.3 85.9 72.8 57.2 49.7 3 1932 47 56.8 61.9 69.3 77.2 84.7 91.9 92.1 87 71.5 62.9 49.3 If I use the gather function: tempDat.long <- gather(data=tempDat, key=month, value=temp, "Jan", "Feb", "Mar", "Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") > tempDat.long # A tibble: 1,068 x 3 Year month temp <dbl> <chr> <dbl> 1 1930 Jan 52 2 1931 Jan 52.9 3 1932 Jan 47 4 1933 Jan 48.8 5 1934 Jan 54.5 But I need it to be Year month temp <dbl> <chr> <dbl> 1 1930 Jan xx.x 2 1930 Feb xx.x 3 1930 Mar xx.x 4 1930 Apr xx.x 5 1930 May xx.x So would I need to use the lubridate package to rearrange my data or is there a more straight forward method? Jeff Reichman [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.