NaN values in timetable - how to calculate Nash–Sutcliffe model efficiency coefficient?

Question

Elizabeth Lees 2021-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/782633-nan-values-in-timetable-how-to-calculate-nash-sutcliffe-model-efficiency-coefficient

编辑： Elizabeth Lees 2021-3-27

I would like the calculate the Nash–Sutcliffe model efficiency coefficient between various variables in a dataset. However a number of rows do contain missing data so I would like to exclue them from the calculate too. Is there a function that will allow this in matlab?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2021-3-24

So the actual problem is how to remove rows with missing data? Then please post an example, which shows, how "missing" data are represented.

请先登录，再进行评论。

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

Answer 1

Star Strider 2021-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/782633-nan-values-in-timetable-how-to-calculate-nash-sutcliffe-model-efficiency-coefficient#answer_657298

在 MATLAB Online 中打开

If the ‘missing’ data are NaN entries, this works:

data = rand(10,3);                                  % Create Array
data(randi(30,1,5)) = NaN;                          % Create Missing Data
rowidx = ~any(isnan(data),2);                       % Rows Without ‘NaN’ Entries
data_new = data(rowidx,:);                          % Matrix With No ‘NaN’ Values

If the missing entries are in a cell array with empty cells, this works:

data = num2cell(rand(10,3));                        % Create Cell Array
data(randi(30,1,5)) = {[]};                         % Create Missing Data
rowidx = ~any(cellfun(@isempty,data),2);            % Rows Without Empty Cells
data_new = data(rowidx,:);                          % Matrix With No Empty Cells

.