Sighh... Questions on "non-standard" packages such as the TidyVerse universe are off topic here: per the posting guide:
"If the question relates to a contributed package , e.g., one downloaded from CRAN, try contacting the package maintainer first. You can also use find("functionname") and packageDescription("packagename") to find this information. Only send such questions to R-help or R-devel if you get no reply or need further assistance. This applies to both requests for help and to bug reports." More to the point, RStudio has its own Help site for these questions: https://www.tidyverse.org/help/ ## and, in particular, https://community.rstudio.com/ Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Sun, Nov 28, 2021 at 5:57 AM Philip Monk <prm...@gmail.com> wrote: > > Hello, > > I have a wide table that I transform to a long table for analysis. > The wide table has 25 columns - the first is labels, then columns 2:25 > are monthly data of LST which is in 19 rows. > > I mutate this with : > > data_long <- data %>% pivot_longer(cols = 2:25, names_to = > "Date", values_to = "LST") > > I've decided to add some weather data which might be relevant, > inputting this as an additional 7 rows of data in the wide format (see > example below of the first 5 months of data). > > I have belatedly realised that I cannot work out how to pivot this > into the long format I need - the documentation doesn't provide enough > syntax examples for me to work it out (I've not long been using 'R'). > > How do I mutate this to provide the additional columns in the long > table for the weather variables? > > Thanks for your time, > > Philip > > Part-time PhD Student (Environmental Science) > Lancaster University, UK. > > > > Wide data > ------------------ > > Buffer 15/01/2010 16/02/2010 20/03/2010 > 24/04/2011 07/05/2010 > > 100 6.091741043 6.405879111 8.925945159 > 6.278147269 6.133940129 > > 200 5.271975614 5.994054977 7.375445078 > 5.805619599 5.537759202 > > 300 4.451891901 5.61142085 6.120095292 > 5.149985946 5.353001442 > > 400 3.385694303 4.77953426 5.608927408 > 4.542354226 4.824773827 > > 500 2.900508112 4.305900444 5.61367474 > 4.320657374 4.520022189 > > 600 3.110238149 3.616699448 4.800003992 > 4.006103489 4.188421662 > > 700 3.150580922 2.848148846 4.216782177 > 3.642003696 3.725611032 > > 800 3.079728958 2.016807672 4.05288041 > 3.315992643 3.278124347 > > 900 2.327902499 1.452876728 3.779922823 > 3.181741995 3.29577819 > > 1000 1.641887823 2.120099832 4.267840277 > 3.321634055 3.551965361 > > 1100 1.63370882 1.661317381 3.747342619 > 2.814670223 2.807355369 > > 1200 0.986559368 1.133219897 2.414025636 > 2.180686348 2.166547946 > > 1300 0.920601397 1.237239562 2.647100163 > 2.253223258 2.411947081 > > 1400 0.571882394 0.93675648 2.272566024 > 2.07198929 1.954723088 > > 1500 0.340505009 0.7379146 2.526476424 > 1.912840489 2.003872651 > > 1600 0.813480877 1.026085605 2.643863876 > 1.825988411 2.278799668 > > 1700 0.471988882 0.566766122 1.290173713 > 1.360936689 1.45967449 > > 1800 0.269067515 0.13349775 0.612263766 > 0.666152106 0.680354177 > > 1900 0.303179244 0.082892149 0.465457136 > 0.537232782 0.287185161 > > Temperautre 12 15 16 > 23 21.5 > > Wind speed 10 9 10.5 > 9.5 9.5 > > Wind trend 1 1 1 > 0 1 > > Wind direction 22.5 45 67.5 > 191.25 56.25 > > Humidity 40 44.5 22 > 24.5 7 > > Pressure 1024 1018.5 1025 > 1005.5 1015.5 > > Pressure trend 1 1 1 > 1 1 > > > > > long data > ----------------- > Buffer Date LST Temperature Wind > speed ...... > 1 01.01.21 4 5 10 > 2 01.02.21 5 2 11 > 3 01.03.21 7 5 15 > 4 01.04.21 9 6 7 > 5 01.05.21 7 5 10 > > ______________________________________________ > 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. ______________________________________________ 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.