[R] filter and add a column

[Patrick (Malone Quantitative)]

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.anamarija using 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) <malone using 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.anamarija using 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 using 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.