Country <- c('Angola', 'Angola','Botswana',
'Botswana','Zimbabwe','Zimbabwe')
year <- c('2006', '2007', '2008', '2009', '2010', '2006')
bank_ratio <- c(24,25,38,34,42,49)
Reserve_ratio <- c(77,59,64,65,57,86)
broad_money <- c(163,188,317,361,150,288)
id <- (c(1,1,2,2,3,3))df <- data.frame(Country, year, bank_ratio, Reserve_ratio,broad_money, id) library(dplyr) df1<- df %>% filter(id%in% c(1,2)) On Mon, May 17, 2021 at 5:13 PM Eric Berger <ericjber...@gmail.com> wrote: > If your data frame is named x then > > y <- x[ x$id %in% c(1,2), ] > > would create a new data frame y that has what you want. > > > On Mon, May 17, 2021 at 5:33 PM Admire Tarisirayi Chirume < > atchir...@gmail.com> wrote: > > > Can someone help on how to filter my data frame below such that it > retains > > a country if a given id (last column) is satisfied eg filtering a data > > frame that has countries with id 1 and 2 only > > > > Country year bank_ratio Reserve_ratio broad_money id > > Angola 2006 24 77 163 1 > > Angola 2007 25 59 188 1 > > Botswana 2008 38 64 317 2 > > Botswana 2009 34 65 361 2 > > Zimbabwe 2010 42 57 150 3 > > Zimbabwe 2006 49 86 288 3 > > > > > > > > Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw > > Skype: admirechirume > > Call: +263773369884 > > whatsapp: +818099861504 > > > > [[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. > > > > [[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. > [[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.
