How to get NaN if the data is not in proper input format or missing?

4 次查看（过去 30 天）

显示更早的评论

Atanu 2022-5-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1731015-how-to-get-nan-if-the-data-is-not-in-proper-input-format-or-missing

评论： Atanu 2022-6-1

采纳的回答： Walter Roberson

all_data.mat

在 MATLAB Online 中打开

I am running a function over each table rows. It is a big table and some of the entries are 'NaN' (class: 'double') or 'none' (class: 'char'). There may some missing entries too. I want to get 'NaN' as output if any of the table entries is not a valid entry. How should I approach it? I have uploaded the table in attachment. My function is as follows.

function [logical_out, reaction_time, average_position] = new_table2(name,date,Trial)

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

Atanu 2022-6-1

Thank you. Let me try.

Atanu 2022-6-1

You are right. All the NaN entries for 'playstarttrialtone' and 'presentcost' gave me NaN as output without doing anything.

By the way, I have converted all the columns from cellstring to double (e.g., playstarttrialtone and presentcost) or string ('subjectid') as I thought would be appropriate. But the bad entries in the subjectid column is specified as 'none' in the table. So they are still giving me outputs.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2022-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1731015-how-to-get-nan-if-the-data-is-not-in-proper-input-format-or-missing#answer_975310

编辑：Walter Roberson 2022-5-31

https://www.mathworks.com/help/matlab/ref/standardizemissing.html

standardize missing. Then rmmissing https://www.mathworks.com/help/matlab/ref/rmmissing.html with the second output to show which rows were removed. Run the function on the reduced data, and then inject the results into a larger vector of nan values to match up to the original rows.