Hi,
I?ve managed to sort out the problem. Yes you are correct, one of the coding method is using reshape2
The coding is as below:
library(tidyr)
comdrug2 <- gather(comdrug, key = DrugType, value = Reduction, DrugX, DrugY)
head(comdrug2)
ID DrugType Reduction
1 1 DrugX 0.10037492
2 2 DrugX 0.09631495
3 3 DrugX 0.07257339
4 4 DrugX 0.08801665
5 5 DrugX 0.10589090
6 6 DrugX 0.10779589
ID DrugType Reduction
95 45 DrugY 0.17670152
96 46 DrugY 0.13968377
97 47 DrugY 0.08439656
98 48 DrugY 0.17640175
99 49 DrugY 0.17171570
100 50 DrugY 0.15659558
Alternatively could be done as:
## option 2 to combine drug effects into single columnn (Drugtype)
## (will provide same result)
comdrug_long <- reshape2::melt(comdrug, id.vars = "ID",
value.name = "HbA1c Reduction",
variable.name = "Types of Drug?)
Regards,
Anaanthan
Begin forwarded message:
From: Sarah Goslee <sarah.goslee at gmail.com>
Subject: Re: [R] Coding help for data frame.
Date: 21 March 2019 at 11:20:59 PM MYT
To: Anaanthan Pillai <anaanthanpillai at gmail.com>, r-help <r-help at r-project.org>
Please also copy the R-help email list when you reply.
On Thu, Mar 21, 2019 at 10:05 AM Anaanthan Pillai
<anaanthanpillai at gmail.com> wrote:
The hypothetical data is about drug x and drug y both we assume as diabetic drug which can reduce hbaic level (sugar level)
Currently I have a data frame of 3X50, whereby the columns is (ID, drug x?s hba1c reduction, drug y?s hba1c reduction)
I want to reaarrange the data into ID, type of drugs (x or y) and their corresponding hba1c level.
Probably you need the reshape2 package. Can you provide an example of
what you expect the resulting data frame to look like? I'm assuming
that your sample data is the starting point.
Or do you simply need to rbind the two columns together?
Sarah
Anand
Begin forwarded message:
From: Sarah Goslee <sarah.goslee at gmail.com>
Subject: Re: [R] Coding help for data frame.
Date: 21 March 2019 at 9:56:43 PM MYT
To: Anaanthan Pillai <anaanthanpillai at gmail.com>
Cc: r-help <r-help at r-project.org>
I'm sorry, I don't understand what you're trying to do with your
hypothetical data.
Can you expand on what your question is?
Sarah
On Thu, Mar 21, 2019 at 9:54 AM Anaanthan Pillai
<anaanthanpillai at gmail.com> wrote:
Good day,
#I?ve created hypothetical data for drug X and drug Y whereby both drug have the ability to have HbA1c reduction.
set.seed(10)
drugx= rnorm(50, mean = 0.1, sd=0.02)
set.seed(11)
drugy= rnorm(50, mean=0.15, sd=0.03)
#And created a data frame, compare drugs (comdrug) of 50 patients for each drug.
comdrug= data.frame("ID"=c(1:50), "DrugX"=drugx, "DrugY"=drugy)
# whereby the data would look like this
head(comdrug)
head(comdrug)
ID DrugX DrugY
1 1 0.10037492 0.1322691
2 2 0.09631495 0.1507978
3 3 0.07257339 0.1045034
4 4 0.08801665 0.1091204
5 5 0.10589090 0.1853547
6 6 0.10779589 0.1219755
Is there anyway of coding if I could arrange like this?