[R] reshape a data frame

[Jon BR]

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]]