Path: news.mathworks.com!not-for-mail
From: "John D'Errico" <woodchips@rochester.rr.com>
Newsgroups: comp.soft-sys.matlab
Subject: Remove NaN data
Date: Fri, 8 Aug 2008 13:24:01 +0000 (UTC)
Organization: John D'Errico (1-3LEW5R)
Lines: 31
Message-ID: <g7hhdh$4u4$1@fred.mathworks.com>
References: <g7hg9v$jv6$1@fred.mathworks.com>
Reply-To: "John D'Errico" <woodchips@rochester.rr.com>
NNTP-Posting-Host: webapp-03-blr.mathworks.com
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: fred.mathworks.com 1218201841 5060 172.30.248.38 (8 Aug 2008 13:24:01 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Fri, 8 Aug 2008 13:24:01 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 869215
Xref: news.mathworks.com comp.soft-sys.matlab:484478



"RT Trevino" <rosie_cc2000@yahoo.com> wrote in message 
<g7hg9v$jv6$1@fred.mathworks.com>...
> Hey all, I have data from excel and loaded into Matlab.  I 
> have a set of data (in columns) with values and some of 
> the values are NaN's.  How can I remove these NaN's and 
> replace them with previous values so as to keep the column 
> demensions the same?
> 
> Thanks

inpaint_nans will interpolate the nan elements,
based on the previous and forward values.
Use it on one column at a time if the columns
are independent of each other. It also works
in 2-dimensions, if you want it to interpolate
in both dimensions.

Find inpaint_nans on the FEX:

http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?
objectId=4551&objectType=file

If you just want to replace the nan elements
with the previous non-nan element, this is
not hard to do with a find, coupled with a
call to isnan.

HTH,
John