Thread Subject: Remove NaN data

Subject: Remove NaN data

From: RT Trevino

Date: 8 Aug, 2008 13:05:04

Message: 1 of 2

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

Subject: Remove NaN data

From: John D'Errico

Date: 8 Aug, 2008 13:24:01

Message: 2 of 2

"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

Tags for this Thread

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

rssFeed for this Thread

Contact us at files@mathworks.com