search for: kwama

...in the raw dataset. @Eric<mailto:ericjberger at gmail.com>?s solution was able to achieve that. Nonetheless, we do appreciate your solution. Regards ------------------ Kevin Wamae From: William Dunlap <wdunlap at tibco.com> Date: Saturday, 14 October 2017 at 20:21 To: Kevin Wamae <KWamae at kemri-wellcome.org> Cc: Bert Gunter <bgunter.4567 at gmail.com>, Rui Barradas <ruipbarradas at sapo.pt>, R-help <R-help at r-project.org> Subject: Re: [R] Populate one data frame with values from another dataframe for rows that match Your example used one distinct studyno...

Dear @Bert Gunter<mailto:bgunter.4567 at gmail.com>, I tried merge and I faced many challenges. @Rui Barradas<mailto:ruipbarradas at sapo.pt> solution is working. From: Bert Gunter <bgunter.4567 at gmail.com> Date: Friday, 13 October 2017 at 22:44 To: Kevin Wamae <KWamae at kemri-wellcome.org> Cc: R-help <R-help at r-project.org> Subject: Re: [R] Populate one data frame with values from another dataframe for rows that match ?merge Bert On Oct 13, 2017 12:09 PM, "Kevin Wamae" <KWamae at kemri-wellcome.org<mailto:KWamae at kemri-wellcome....

...2016 103 6 J931/6 2016-11-30 3 2016 104 Now your problem is to combine the columns pf_mcl.raw and pf_mcl.curated in the way you want. ifelse() may be useful for that. Bill Dunlap TIBCO Software wdunlap tibco.com On Fri, Oct 13, 2017 at 10:48 PM, Kevin Wamae <KWamae at kemri-wellcome.org> wrote: > Dear @Bert Gunter<mailto:bgunter.4567 at gmail.com>, I tried merge and I > faced many challenges. @Rui Barradas<mailto:ruipbarradas at sapo.pt> > solution is working. > > From: Bert Gunter <bgunter.4567 at gmail.com> > Date: F...

?merge Bert On Oct 13, 2017 12:09 PM, "Kevin Wamae" <KWamae at kemri-wellcome.org> wrote: > I'm trying to populate the column ?pf_mcl? in myDF1 with values from > myDF2, where rows match based on column "studyno" but the solutions I have > found so far don't seem to be giving me the desired output. > > Below is a snapsh...

...irst element that appears, i.e. subscript[1], is "2013-04-04". In the filtered data set the first element that appears is "2013-04-05". I hope that is enough information for you to make further progress from here. Best, Eric On Thu, Feb 22, 2018 at 1:28 PM, Kevin Wamae <KWamae at kemri-wellcome.org> wrote: > Dear Eric, wow, this seems to do the trick. But I have encountered a > problem. > > > > I have tested it on the larger dataset and it seems to work on a filtered > dataset but not on the whole dataset (attached). See below script.. > >...

...5 # 2 J1000/6 2016-12-20 6 # 3 J1000/8 2016-11-18 1 # 4 J1000/9 2016-11-22 0 # 5 J1000/9 2016-11-30 0 # 6 J1000/9 2016-12-09 0 Comparing the two results you see that no rows have been dropped in my approach. HTH, Eric On Sat, Oct 14, 2017 at 8:49 AM, Kevin Wamae <KWamae at kemri-wellcome.org> wrote: > Dear @Rui Barradas, thank you for the solution. It works perfectly. > > > On 13/10/2017, 23:35, "Rui Barradas" <ruipbarradas at sapo.pt> wrote: > > Hello, > > Try the following. > > > myDF1$studyno &lt...

I'm trying to populate the column ?pf_mcl? in myDF1 with values from myDF2, where rows match based on column "studyno" but the solutions I have found so far don't seem to be giving me the desired output. Below is a snapshot of the data.frames. myDF1 <- structure(list(studyno = c("J1000/9", "J1000/9", "J1000/9", "J1000/9",

Dear @Rui Barradas, thank you for the solution. It works perfectly. On 13/10/2017, 23:35, "Rui Barradas" <ruipbarradas at sapo.pt> wrote: Hello, Try the following. myDF1$studyno <- as.character(myDF1$studyno) myDF2$studyno <- as.character(myDF2$studyno) i1 <- which(names(myDF1) == "pf_mcl") merge(myDF1[-i1], myDF2,

...quot;, "2014-04-01", "2015-04-01", "2016-03-01", "2017-01-01"))) might work. Best, Ista On Wed, Feb 21, 2018 at 3:33 PM, Kevin Wamae <KWamae at kemri-wellcome.org> wrote: > Hi, I am having trouble trying to figure out why if_else is behaving the way it is, it may be my code or the way the data is structured. > > Below is a snapshot of a database am working on and it represents a longitudinal survey of study participants in...

Hi, I am having trouble trying to figure out why if_else is behaving the way it is, it may be my code or the way the data is structured. Below is a snapshot of a database am working on and it represents a longitudinal survey of study participants in a trial with weekly follow up. The variable "survey_start" represents the start of the study-defined one year follow up (which we called