[R] Fwd: Coding help for data frame.

[Anaanthan Pillai]

> 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.goslee using gmail.com>
> Subject: Re: [R] Coding help for data frame.
> Date: 21 March 2019 at 11:20:59 PM MYT
> To: Anaanthan Pillai <anaanthanpillai using gmail.com>, r-help <r-help using 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 using 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 using gmail.com>
>> Subject: Re: [R] Coding help for data frame.
>> Date: 21 March 2019 at 9:56:43 PM MYT
>> To: Anaanthan Pillai <anaanthanpillai using gmail.com>
>> Cc: r-help <r-help using 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 using 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]]