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]]
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 at 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 at 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.
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 at 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 at 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 at 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. >