How to transform a data frame to a row?

Question

I have a very basic question about reshaping a table:

       pval     Quality
High  0.782        0.62
 Low  0.782        1.58

I would like to change it to

   pval     High     Low
  0.782     0.62    1.58

I am relatively new to R. Could someone help? Thanks!

`reshape` `melt` and drop duplicate then `t()` – BENY Sep 11 '17 at 18:13 — BENY, Sep 11 '17 at 18:13
`t(unlist(df)[-2])` works. Thanks so much guys! – kin182 Sep 11 '17 at 18:20 — kin182, Sep 11 '17 at 18:20

score 1 · Answer 1 · edited Sep 11 '17 at 18:46

1

You can use the function spread in tidyverse package

 library(tidyverse)
 df1 %>% 
     rownames_to_column() %>% 
     spread(rowname, Quality)

Result

    pval High  Low
 1 0.782 0.62 1.58

edited Sep 11 '17 at 18:46

David Arenburg

89,637
17
130
188

answered Sep 11 '17 at 18:17

onyambu

49,350
3
19
45

score 1 · Accepted Answer · answered Sep 11 '17 at 18:20

You could do a straight reshape() if you bind the row names to the data first.

reshape(cbind(df, rn=rownames(df), row.names=NULL), 
    direction="wide", timevar="rn", idvar="pval")
#    pval Quality.High Quality.Low
# 1 0.782         0.62        1.58

Data:

df <- structure(list(pval = c(0.782, 0.782), Quality = c(0.62, 1.58
)), .Names = c("pval", "Quality"), class = "data.frame", row.names = c("High", 
"Low"))

How to transform a data frame to a row?

2 Answers2