This should get you going:
Add a vector of 1s to controls before joining the datasets.
On Tue, Aug 6, 2019 at 3:01 PM Ana Marija <sokovic.anamar...@gmail.com> wrote:
>
> I really don't know how I would implement this
>
> On Tue, Aug 6, 2019 at 1:42 PM Patrick (Malone Quantitative)
> <mal...@malonequantitative.com> wrote:
>>
>> See the posting guide for this list about plain text.
>>
>> Again, what have you tried? This is also mentioned in the posting guide.
>>
>>
>> On Tue, Aug 6, 2019 at 2:38 PM Ana Marija <sokovic.anamar...@gmail.com>
>> wrote:
>> >
>> > Hi Patrick,
>> >
>> > yes both controls and tot have "eid" column, please see attached
>> >
>> > Can you please tell em what means to post in "plain text" ?
>> >
>> > Thanks
>> > Ana
>> >
>> > On Tue, Aug 6, 2019 at 1:33 PM Patrick (Malone Quantitative)
>> > <mal...@malonequantitative.com> wrote:
>> >>
>> >> Do you have some kind of ID variable? If so, it should be
>> >> straightforward with the appropriate joining function.
>> >>
>> >> What have you tried?
>> >>
>> >> Also, please post in plain text.
>> >>
>> >>
>> >> On Tue, Aug 6, 2019 at 2:16 PM Ana Marija <sokovic.anamar...@gmail.com>
>> >> wrote:
>> >> >
>> >> > Hello,
>> >> >
>> >> > I am filtering my data frame "tot" via:
>> >> >
>> >> > controls=tot %>% filter_all(any_vars(. %in% c("E109", "E119","E149")))
>> >> > %>%
>> >> > filter_all(any_vars(. %in% c("Caucasian"))) %>% filter_all(any_vars(.
>> >> > %in%
>> >> > c("No kinship found","Ten or more third-degree relatives identified")))
>> >> >
>> >> > > dim(controls)
>> >> > [1] 15381 1093
>> >> > > dim(tot)
>> >> > [1] 502536 1093
>> >> >
>> >> > how do I add in my data frame "tot" a new column called "controls" where
>> >> > every of those filtered 15381 rows would have the value 1 and the rest
>> >> > which can be found in tot have the value -9?
>> >> >
>> >> > Thanks
>> >> > Ana
>> >> >
>> >> > [[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.
______________________________________________
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.
