I tried the following but it does the opposite of what i want:
new_data5 <- subset(new_data4, date_abandoned > "01010000") I want to remove the rows with dates and leave just the rows without a date. This removes all the rows that dont have a date in the date_abandoned column ...on a positive note, as i did this next... dim(new_data5) [1] 263 80 ....i now know that i have 263 dates in that column :) I want to remove the 263 rows with dates and leave just the rows without a date. David Winsemius wrote: > > > On Nov 14, 2009, at 1:21 PM, frenchcr wrote: > >> >> >> I want to go through a column in data called > > Bad name for a data.frame. Fortunes, "dog" and all that. > >> date_abandoned....data["date_abandoned"]....and remove all the rows >> that >> have numbers greater than 1,010,000. > > Are you doing archeology? Given what you say next I wondered what > range you were really asking for. > >> >> The dates are in the format 20091114 so i'm just going to treat them >> as >> numbers for clean up purposes. >> >> >> I know that i use subset but not sure how to proceed from there. > > subdata <- subset(data, date_abandoned > "01010000"() > > > The problem with > "1010000" is that your specified minimum point had > an insufficient number of "places" to be in YYYYMMDD format. > > -- > > David Winsemius, MD > Heritage Laboratories > West Hartford, CT > > ______________________________________________ > R-help@r-project.org mailing list > 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. > > -- View this message in context: http://old.nabble.com/remove-row-if-the-column-%22date_abandoned%22-has-a-date-in-it-tp26352457p26354446.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list 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.