[R] Non date value
Ashta
sewashm at gmail.com
Sat Apr 15 06:39:30 CEST 2017
DF1 is a data frame. I am suspecting there might be non date value
in that column. My question is how to remove a non date values from
that field.
example if Alex152 has 12253,. This value is not a date format.
On Fri, Apr 14, 2017 at 11:24 PM, Bert Gunter <bgunter.4567 at gmail.com> wrote:
> Show us str(DF1) . It is not a data frame.
>
> -- Bert
>
>
>
>
> On Fri, Apr 14, 2017 at 9:02 PM, Ashta <sewashm at gmail.com> wrote:
>> Hi all,
>> I am reading a field data that contains several variables. The sample
>> of the data with the first two variables is shown below. I wanted to
>> know the minimum and maximum recording date However, I have some
>> problem.
>>
>>
>> Name Rdate V1 to V20
>> Alex1 01/03/2015
>> Alex2 01/03/2014
>> Alex3 31/12/2012
>> Alex4 15/01/2011
>> Alex150 22/01/2010
>> Alex151 15/02/2011
>>
>>
>>
>> DF1=DF1[!is.na(DF1$Rdate),]
>> range(DF1$Rdate, na.rm=TRUE)
>>
>> Warning message:
>> In is.na(DF1$Rdate) :
>> is.na() applied to non-(list or vector) of type 'NULL'
>> Error in DF1$Rdate : $ operator is invalid for atomic vectors
>> Execution halted
>>
>> I am expecting the Rdate field should contain recording dates. I am
>> suspecting there might be a non date value in that columns. How do I
>> remove that row if it is not a date format?
>>
>>
>> Thank you.
>>
>> ______________________________________________
>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> 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.
More information about the R-help
mailing list