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.
