How to reshape a wider data.frame to longer data.frame in R?

Question

I was playing with pivot_longer and pivot_wider but probably am missing something. I have a data.frame like D_Wider and would like to convert it to something like D_longer. any way forward?

library(tidyverse)
D_Wider <- data.frame(A = 15, S = 10, D = 25, Z = 16)

Desired Output

D_Longer <- data.frame(Stations = c("A","S","D","Z"), Value = c(15,10,25,16))

`tidyr::pivot_longer(D_Wider, cols = everything())` – Ronak Shah Jul 22 '20 at 00:24 — Ronak Shah, Jul 22 '20 at 00:24

score 0 · Accepted Answer · answered Jul 22 '20 at 00:24

0

Easiest would be stack from base R

stack(D_Wider)[2:1]

Or using pivot_longer

library(tidyr)
pivot_longer(D_Wider, cols = everything(), 
     names_to = 'Stations', values_to = 'Value')

answered Jul 22 '20 at 00:24

akrun

874,273
37
540
662

Why it returns values in scientific notations? like using 5.23 to the power +3 – Hydro Jul 22 '20 at 00:30
1

@Hydro You can do `options(scipen = 999)` – akrun Jul 22 '20 at 00:31

How to reshape a wider data.frame to longer data.frame in R?

1 Answers1

Linked