Is there a R function to transform the dataframe

Question

I have a data set below. I need to transform them so that variables names are now values

>(p2)
   B        D        F 
  36.0    38.93    36.06

I need to have like below

p2
Col1   COl2
 B      36.0
 D      38.93
 F      36.06

Hey, I think what you are asking is a simple transpose `t(p2)`. You can then make your rownames as a new column and name your columns as you wish. — Steve, Aug 19 '19 at 08:44
Could you add result of `dput(p2)` to your question? Is it vector, data.frame? — Marek, Aug 19 '19 at 08:52

score 0 · Answer 1 · answered Aug 19 '19 at 08:45

0

You can use the gather function from the Tidyverse :

library(tidyverse)
gather(p2, key = "Col1", value = "Col2")

answered Aug 19 '19 at 08:45

cyrilb38

this is not working – Rfer R Aug 19 '19 at 08:51
Could you provide the error that you get ? – cyrilb38 Aug 19 '19 at 08:52
Error in UseMethod("gather_") : no applicable method for 'gather_' applied to an object of class "c('double', 'numeric')" – Rfer R Aug 19 '19 at 08:54
Oh i guess you have a named vector. Could you provide the output of `class(p2)`. Maybe you just need to convert it to dataframe (if you need to) : `data.frame(p2)`. Or you could transpose it if you need a matrix, as @Steve suggest – cyrilb38 Aug 19 '19 at 09:03

score 0 · Answer 2 · answered Aug 19 '19 at 08:57

0

data.frame(Col1= names(p2), Col2 = p2, row.names = NULL)

Data :

p2 <- c(B =36.0, D=38.93, F= 36.06)

answered Aug 19 '19 at 08:57

Sang won kim

score 0 · Answer 3 · answered Aug 19 '19 at 08:59

If this is a vector:

p2 <- c(B = 36, D = 38.93, F = 36.06)

Then enframe from package tibble could help:

library(tibble)
enframe(p2)
# # A tibble: 3 x 2
# name  value
# <chr> <dbl>
# 1 B      36  
# 2 D      38.9
# 3 F      36.1

You could change names using

enframe(p2, "Col1", "Col2")

3 Answers3