Re: [R] How do I subset a dataframe

2011-08-14 Thread Mikhail Titov
Eric: Create another column using grep and regular expression of your choice, then subset based on that column. Jorge: OP wants inexact match. P.S. I'd use RDBMS and SQL to pull data of interest Mikhail On 08/14/2011 02:20 AM, Jorge Ivan Velez wrote: > Hi eric, > > See > > R> ?"%in%" > > and

Re: [R] How do I subset a dataframe

2011-08-14 Thread Timothy Bates
Perhaps this: matches = grep("^ibm|sears|exxon", zeespan$customer, value=F) zee = zeespan[matches,] t On Aug 14, 2011, at 12:44 AM, eric wrote: > I have a dataframe zeespan. One of the columns has the name "customer". The > data in the customer column is text. I would like to return a subset of

Re: [R] How do I subset a dataframe

2011-08-14 Thread Jorge Ivan Velez
Hi eric, See R> ?"%in%" and try the following (untested): subset(zeespan, !customer %in% c("ibm" , "exxon" , "sears") ) HTH, Jorge On Sat, Aug 13, 2011 at 7:44 PM, eric <> wrote: > I have a dataframe zeespan. One of the columns has the name "customer". The > data in the customer column is

[R] How do I subset a dataframe

2011-08-14 Thread eric
I have a dataframe zeespan. One of the columns has the name "customer". The data in the customer column is text. I would like to return a subset of the dataframe with all rows that DON'T begin with either "ibm" or "exxon", or "sears" in the customer column. I tried subset(zeespan, customer !