And I think this will do it too.
library(reshape2)
melt(ex, id.vars= c("gIN", "group"),
variable.name = "bc",
value.name = "value",
na.rm = FALSE)
John Kane
Kingston ON Canada
> -----Original Message-----
> From: jonsleepy at gmail.com
> Sent: Wed, 3 Jun 2015 18:25:02 -0400
> To: r-help at r-project.org
> Subject: Re: [R] reshape a data frame
>
> I found the gather function from the tidyr package, which worked nicely:
>
> gather(ex,bcX,value, bc1:bc2)
> gIN group bcX value
> 1 A_1 A bc1 1219.79
> 2 A_2 A bc1 1486.84
> 3 A_3 A bc1 1255.80
> 4 A_4 A bc1 941.87
> 5 B_1 B bc1 588.19
> 6 B_2 B bc1 304.02
> 7 A_1 A bc2 319.79
> 8 A_2 A bc2 186.84
> 9 A_3 A bc2 125.80
> 10 A_4 A bc2 94.87
> 11 B_1 B bc2 1008.19
> 12 B_2 B bc2 314.02
>
> Thanks.
>
>
>
>
>
> On Wed, Jun 3, 2015 at 5:44 PM, Jon BR <jonsleepy at gmail.com>
wrote:
>
>> Hello,
>>
>> I would like to ask for some advice in reformatting a data frame such
as
>> the following one:
>>
>>
>> gIN <-
c("A_1","A_2","A_3","A_4","B_1","B_2")
>> bc1 <- c(1219.79, 1486.84, 1255.80, 941.87, 588.19, 304.02)
>> bc2 <- c(319.79, 186.84, 125.80, 94.87, 1008.19, 314.02)
>> group <-
c("A","A","A","A","B","B")
>>
>> ex <- data.frame("gIN" = gIN, "bc1" = bc1,
"bc2"=bc2, "group" = group)
>>
>>> ex
>> gIN bc1 bc2 group
>> 1 A_1 1219.79 319.79 A
>> 2 A_2 1486.84 186.84 A
>> 3 A_3 1255.80 125.80 A
>> 4 A_4 941.87 94.87 A
>> 5 B_1 588.19 1008.19 B
>> 6 B_2 304.02 314.02 B
>>
>> I would like to reshape this data frame where all the columns that have
>> bc1, bc2,...etc are merged into a single column (call it bcX or
>> something)
>> and the other variables are kept apart, the example solution follows:
>>
>>
>>> ex_reshaped
>> gIN bcX group
>> 1 A_1 1219.79 A
>> 2 A_2 1486.84 A
>> 3 A_3 1255.80 A
>> 4 A_4 941.87 A
>> 5 B_1 588.19 B
>> 6 B_2 304.02 B
>> 7 A_1 319.79 A
>> 8 A_2 186.84 A
>> 9 A_3 125.80 A
>> 10 A_4 94.87 A
>> 11 B_1 1008.19 B
>> 12 B_2 314.02 B
>>
>> Does anyone know of a package, and/or command to accomplish this?
>>
>> Thank you
>>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
____________________________________________________________
Can't remember your password? Do you need a strong and secure password?
Use Password manager! It stores your passwords & protects your account.