[R] Syntax help for 'Pivot_longer'

Philip Monk prmonk @end|ng |rom gm@||@com
Sun Nov 28 14:57:07 CET 2021


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



More information about the R-help mailing list