Clear Filters
Clear Filters

how to delete NaN from a column of data

6 views (last 30 days)
I have a column of numbers that i called in from excel but some of my data comes up as NaN, which is fine but i need to do calculations on this data and matlab cant do calculations on NaN how can i get rid of the NaN from my data?
example
data=
45
23
NaN
78
mean(data) = NaN

Accepted Answer

Geoff
Geoff on 8 May 2012
If all you want is the mean, just use nanmean:
help nanmean
There are a bunch of functions that explicitly ignore NaN
nancov
nanmax
nanmean
nanmedian
nanmin
nanstd
nansum
nanvar
  2 Comments
Image Analyst
Image Analyst on 7 Jul 2016
Like James showed, find() is not needed, though it still works.
data(isnan(data)) = [];

Sign in to comment.

More Answers (1)

James Tursa
James Tursa on 8 May 2012
For your particular example:
mean(data(~isnan(data)))
For general nan handling, you might take a look at the FEX submissions such as this one:

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!