how to delete NaN from a column of data

2 次查看（过去 30 天）
lowcalorie
lowcalorie 2012-5-8
评论： Image Analyst 2016-7-7
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

请先登录，再回答此问题。

采纳的回答

Geoff
Geoff 2012-5-8
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

更多回答（1 个）

James Tursa
James Tursa 2012-5-8
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:
http://www.mathworks.com/matlabcentral/fileexchange/6837-nan-suite

类别

在 Help Center 和 File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by