re move row if the column "date_abandoned" has a date in it
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 at 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.