sorry David,
im really new to R (my first week) and appreciate your help. Also I dont
always know what info to give people on the forum (although im starting to
catch the drift).
heres what i get...
summary(new_data4$date_abandoned)
Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
16010000 19980000 20010000 19930000 20040000 20090000 315732
> ls()
[1] "data" "new_data" "new_data2" "new_data3" "new_data4"
> small <- head(new_data4, 20)
> dump("small", 20)
Error in dump("small", 20) : cannot write to this connection
>
frenchcr
David Winsemius wrote:
>
>
> 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@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.
>
> 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-tp26352457p26355689.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.
