I'm sure this is a simple question but I'm not sure where to find the answer. I want to remove some of the data. For example when my Location column is MW-09, MW-10, or MW-11. It works fine if I ONLY list ONE of the locations as in: SampledWells <- MyData[ MyData$Location != "MW-09", ] But if I try to do more than one (as shown below), I don't get an error but I also don't get my SampledWells SampledWells <- MyData[ MyData$Location != "MW-09", "MW-10", ] Thoughts?? Thank you for your time David [[alternative HTML version deleted]]
Hi David, I think you want this: SampledWells <- MyData[!( MyData$Location %in% c("MW-09", "MW-10")), ] Jim On Thu, Oct 4, 2018 at 9:02 AM David Doyle <kydaviddoyle at gmail.com> wrote:> > I'm sure this is a simple question but I'm not sure where to find the > answer. > > I want to remove some of the data. For example when my Location column is > MW-09, MW-10, or MW-11. > > It works fine if I ONLY list ONE of the locations as in: > > SampledWells <- MyData[ MyData$Location != "MW-09", ] > > But if I try to do more than one (as shown below), I don't get an error but > I also don't get my SampledWells > SampledWells <- MyData[ MyData$Location != "MW-09", "MW-10", ] > > Thoughts?? > > Thank you for your time > David > > [[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.
> On Oct 3, 2018, at 7:03 PM, David Doyle <kydaviddoyle at gmail.com> wrote: > > I'm sure this is a simple question but I'm not sure where to find the > answer. > > I want to remove some of the data. For example when my Location column is > MW-09, MW-10, or MW-11. > > It works fine if I ONLY list ONE of the locations as in: > > SampledWells <- MyData[ MyData$Location != "MW-09", ] > > But if I try to do more than one (as shown below), I don't get an error but > I also don't get my SampledWells > SampledWells <- MyData[ MyData$Location != "MW-09", "MW-10", ] > > Thoughts?? > > Thank you for your time > DavidHi, See ?"%in%" Then: SampledWells <- MyData[ !MyData$Location %in% c("MW-09", "MW-10"), ] Note the '!' operator that precedes the expression to negate the logical. Regards, Marc Schwartz [[alternative HTML version deleted]]
Inline. -- Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Wed, Oct 3, 2018 at 4:02 PM David Doyle <kydaviddoyle at gmail.com> wrote:> I'm sure this is a simple question but I'm not sure where to find the > answer. >Good R tutorials abound on the internet. One resource is: https://www.rstudio.com/online-learning/#r-programming but there are tons more if you search.> > I want to remove some of the data. For example when my Location column is > MW-09, MW-10, or MW-11. > > It works fine if I ONLY list ONE of the locations as in: > > SampledWells <- MyData[ MyData$Location != "MW-09", ] > > But if I try to do more than one (as shown below), I don't get an error but > I also don't get my SampledWells > SampledWells <- MyData[ MyData$Location != "MW-09", "MW-10", ] > > Thoughts?? >?"%in%" as in: SampledWells <- MyData[ MyData$Location %in% c( "MW-09", "MW-10", "MW-11"), ]> Thank you for your time > David > > [[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. >[[alternative HTML version deleted]]