[R] re move row if the column "date_abandoned" has a date in it

frenchcr frenchcr at btinternet.com
Sat Nov 14 23:24:44 CET 2009



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.




More information about the R-help mailing list