Thread Subject: Remove NaN data

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

"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