Re: [R] subtraction based on two groups in a dataframe

2010-10-20 Thread 1Rnwb
I want the reshaped data to look like this. plate.id HYBwell.id rlt1.control1 well.id rlt1.control1 well.idrlt1.disease1 well.id rlt1.disease2 1 P1 SKOV3hyb A10.190 A2 0.210 B10.217

Re: [R] subtraction based on two groups in a dataframe

2010-10-07 Thread 1Rnwb
Hi The reshape suggestions works great on my previous data, but I am unable to make is work on the new dataset. It actually works but only gives me the output of single row, instead of 96 rows. The dataset has two control groups control 1 and control 2, two disease groups viz disease 1 and

Re: [R] subtraction based on two groups in a dataframe

2010-10-07 Thread Dennis Murphy
Hi: Is this what you were looking for? plate.id well.id Group HYB rlt1 P1 A1 control1SKOV3hyb0.19 P1 A2 disease1SKOV3hyb0.21 P1 A3 control1SKOV3hyb0.205 P1 A4 disease1SKOV3hyb0.206 P1

Re: [R] subtraction based on two groups in a dataframe

2010-09-29 Thread 1Rnwb
Thanks for the help. Sharad On Mon, Sep 27, 2010 at 9:12 PM, Remko Duursma [via R] ml-node+2716469-935075351-6...@n4.nabble.comml-node%2b2716469-935075351-6...@n4.nabble.com wrote: Try something like this: dfr - read.table(textConnection(plate.id well.id Group HYB rlt1 1

Re: [R] subtraction based on two groups in a dataframe

2010-09-28 Thread Dennis Murphy
Hi: Perhaps this might be useful: tst - read.table(textConnection( +plate.id well.id Group HYB rlt1 + 1 P1 A1 Control SKOV3hyb 0.190 + 2 P1 A2 Control SKOV3hyb 0.210 + 3 P1 A3 Control SKOV3hyb 0.205 + 4 P1 A4 Control SKOV3hyb 0.206 +

[R] subtraction based on two groups in a dataframe

2010-09-27 Thread 1Rnwb
Hello I have a data set like below: plate.id well.id Group HYB rlt1 1 P1 A1 Control SKOV3hyb 0.190 2 P1 A2 Control SKOV3hyb 0.210 3 P1 A3 Control SKOV3hyb 0.205 4 P1 A4 Control SKOV3hyb 0.206 5 P1 A5 Control SKOV3hyb

Re: [R] subtraction based on two groups in a dataframe

2010-09-27 Thread Remko Duursma
Try something like this: dfr - read.table(textConnection(plate.id well.id Group HYB rlt1 1 P1 A1 Control SKOV3hyb 0.190 2 P1 A2 Control SKOV3hyb 0.210 3 P1 A3 Control SKOV3hyb 0.205 4 P1 A4 Control SKOV3hyb 0.206 5 P1