[R] Removing Bad Data

Mario Valle mvalle at cscs.ch
Wed Mar 16 10:15:30 CET 2011


To recover also the date:

x<- read.table('d.dat', na.strings='-')
x$V1<- as.Date(x$V1, "%m/%d/%Y")


Hope it helps
                             mario

On 16-Mar-11 06:45, Rahul Kaura wrote:
>   
>   
> I created a couple of timeSeries objects - when I was merging them , I got an
> error.
> Looking at the data , I see that one of the time series has
>   
> 06/30/2007  0.0028       0.0183  0.0122      0.0042  0.0095    -        
>   07/31/2007 -0.0111       0.0255  0.0096     -0.0069 -0.0024  0.0043     
>   08/31/2007 -0.0108      -0.0237 -0.0062     -0.0138 -0.0173 -0.0065     
>   09/30/2007  0.0197       0.0477  0.0410      0.0331  0.0114  0.0322     
>
>   
> The "-" (first row, last column) is getting picked up from excel and is not a
> number
>   
> How do I check for this and replace with zero
>
>
> 	[[alternative HTML version deleted]]
>

-- 
Ing. Mario Valle
Data Analysis and Visualization Group            | http://www.cscs.ch/~mvalle
Swiss National Supercomputing Centre (CSCS)      | Tel:  +41 (91) 610.82.60
v. Cantonale Galleria 2, 6928 Manno, Switzerland | Fax:  +41 (91) 610.82.82



More information about the R-help mailing list