subseting data

Hi,



When I use your code i get this :

dat<-data.frame(test=c("abc","cdf","dabc"))

d<-subset(dat,grepl(test,"abc"))

d

Warning message:

In grepl(test, "abc") :

   argument 'pattern' has length>  1 and only the first element will be used

d

   test

1  abc

2  cdf

3 dabc



I can't seem to make it work. Also how would i use the grepl() to select only those that are not like i.e. ??GP???

Thanks, m





From: Steven Kennedy [mailto:stevenkennedy2263 at gmail.com]
Sent: Monday, May 02, 2011 11:30 AM
To: Matev?? Pavli??
Cc: r-help at r-project.org
Subject: Re: [R] subseting data



You can use grepl:

dat<-data.frame(test=c("abc","cdf","dabc"))
d<-subset(dat,grepl(test,"abc"))
d

   test
1  abc
3 dabc




On Mon, May 2, 2011 at 7:03 PM, Matev?? Pavli??<matevz.pavlic at gi-zrmk.si>  wrote:

Hi,



Is it possible (i am sure it is)  to subset data from a data.frame on the basis of SQL>LIKE<  operator. I.e., i would like to subset a data where only values which contains a string>GP<  would be used?



Example:



Gp<-subset(DF, DF$USCS like>GP<)



This like of course is not working,



Thanks, m


        [[alternative HTML version deleted]]