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;
To interchange rows with columns, you can use the t() function. For example, if you have the matrix (or dataframe) mat you can transpose it by typing t(mat) . This will, as previously hinted, result in a new matrix that is obtained by exchanging the rows and columns.
Rotating or transposing R objects You can rotate the data. frame so that the rows become the columns and the columns become the rows. That is, you transpose the rows and columns. You simply use the t() command.
Here is one way
tmydf = setNames(data.frame(t(mydf[,-1])), mydf[,1])
Something like this perhaps:
tmp <- as.data.frame(t(mydf[,-1])) > colnames(tmp) <- mydf$A > tmp a b c d e f g h i j M1 11 12 13 14 15 16 17 18 19 20 M2 31 32 33 34 35 36 37 38 39 40 M3 41 42 43 44 45 46 47 48 49 50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With