re move row if the column "date_abandoned" has a date in it
On Nov 14, 2009, at 5:24 PM, frenchcr wrote:
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.
Con=me on frenchcr. Stop making us guess. Give us enough information
to work with. You asked for something which I construed as saying you
wanted dates greater than the the first day of the year 101. You did
not address this question.
What do you get with str(new_data4) and
summary(new_data4$date_abandoned) ? In order to know what sort of
comparison to use we need to know what the data looks like.
Even better if you offered the output from:
small <- head(new_data4, 20)
dump("small", 20),
David > > > > > > > > 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. > > ______________________________________________ > 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. David Winsemius, MD Heritage Laboratories West Hartford, CT