[R] Removing Bad Data

From: Rahul Kaura <rahulkaura61_at_yahoo.com>
Date: Tue, 15 Mar 2011 22:45:49 -0700 (PDT)


 
 

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]]



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. Received on Wed 16 Mar 2011 - 08:48:31 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Mar 2011 - 09:50:21 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive