Transposing a dataframe maintaining the first column as heading

r dataframe transpose
jon picture jon · Nov 1, 2011 · Viewed 43.6k times · Source

I have a big dataframe, but small example would be like this:

mydf <- data.frame(A = c(letters[1:10]), M1 = c(11:20), M2 = c(31:40), M3 = c(41:50))

I want to transpose the dataframe and maintain the column 1 (A) as column heading ( letter[1:10]) as variable names. The following are scratch trials of unsuccessful codes. 

tmydf = data.frame(t(mydf))
names(tmydf) <- tmydf[1,]

Thanks;

Answer

Ramnath picture Ramnath · Nov 1, 2011

Here is one way

tmydf = setNames(data.frame(t(mydf[,-1])), mydf[,1])

Related questions

What is the best way to transpose a data.frame in R and to set one of the columns to be the header for the new transposed table?

What is the best way to transpose a data.frame in R and to set one of the columns to be the header for the new transposed table? I have coded up a way to do this below. As I …

Read More
How to transpose a dataframe in tidyverse?

Using basic R, I can transpose a dataframe, say mtcars, which has all columns of the same class: as.data.frame(t(mtcars)) Or with pipes: library(magrittr) mtcars %>% t %>% as.data.frame How to accomplish the same …

Read More
How do I transpose a tibble() in R

In R the t() function is really meant for matrices. When I try to transpose my tibble with t() I end up with a matrix. A matrix can't be made into a tibble with tibble(). I end up spending time …

Read More