> 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
>> tail(comdrug2)
> 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.gos...@gmail.com>
> Subject: Re: [R] Coding help for data frame.
> Date: 21 March 2019 at 11:20:59 PM MYT
> To: Anaanthan Pillai <anaanthanpil...@gmail.com>, r-help
> <r-help@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
> <anaanthanpil...@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.gos...@gmail.com>
>> Subject: Re: [R] Coding help for data frame.
>> Date: 21 March 2019 at 9:56:43 PM MYT
>> To: Anaanthan Pillai <anaanthanpil...@gmail.com>
>> Cc: r-help <r-help@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
>> <anaanthanpil...@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?
>>
>>
>
> --
> Sarah Goslee (she/her)
> http://www.numberwright.com
[[alternative HTML version deleted]]
______________________________________________
R-help@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.
