R data - Changing my data frame (converting columns into rows and vice versa)

Question

So I have created a data frame in R with this output called 'data'

But I want to convert my data frame to something like the one below

How would I go about doing this?

You can transpose using `t(data)`. But what is the reason for transposing? Because what you get back is matrix and not data frame. — Nishanth, Apr 08 '13 at 07:37

score 11 · Accepted Answer · edited May 22 '18 at 12:30

11

To transpose in R use the function t():

t(data)

edited May 22 '18 at 12:30

Majid

13,853
15
77
113

answered Apr 08 '13 at 06:59

jmanelsg

154
1
3

score 4 · Answer 2 · edited Jul 07 '16 at 22:34

4

t(data) returns a matrix.

To convert it to a data.frame from the matrix, wrap the output withas.data.frame()`.

edited Jul 07 '16 at 22:34

coatless

20,011
13
69
84

answered Jul 07 '16 at 15:57

Yap

41
3

strboul · Answer 3 · 2017-06-22T02:04:05.500

0

t(data) returns list. If you want to shape your data, you can turn into data frame by coercion: as.data.frame(data)

Better solution: use melt function from dplyr package. It can easily turn your data into tabular form, then you can "effectively" play with your data.

edited Jun 22 '17 at 02:04

answered Jun 21 '17 at 16:58

strboul

368
2
10

R data - Changing my data frame (converting columns into rows and vice versa)

3 Answers3