Below is a sample dataset:
data.frame(
Index = seq(1,5),
X_50 = sample(1:5, replace = TRUE),
X_90 = sample(1:5, replace = TRUE),
Y_50 = sample(1:5, replace = TRUE),
Y_90 = sample(1:5, replace = TRUE),
Z_50 = sample(1:5, replace = TRUE),
Z_90 = sample(1:5, replace = TRUE)
)
| Index | X_50 | X_90 | Y_50 | Y_90 | Z_50 | Z_90 |
|---|---|---|---|---|---|---|
| 1 | 3 | 5 | 1 | 10 | 3 | 4 |
| 2 | 8 | 8 | 6 | 6 | 9 | 7 |
| 3 | 9 | 3 | 3 | 7 | 7 | 4 |
| 4 | 3 | 10 | 8 | 10 | 6 | 1 |
| 5 | 7 | 2 | 3 | 5 | 10 | 8 |
I am trying to pivot the columns for the dataset to look like this:
|Index | percentile_value| X | Y |Z |
|—- |——| —–|—- |——|
|1|50|3|1|3|
|1|90|5|10|4|
|2|50|8|6|9|
|2|90|8|6|7|
|3|50|9|3|7|
|3|90|3|7|4|
and so forth…
I tried pivot_longer, but I am not getting the above result. Can someone please help me out here. Thank you.