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

1 次查看(过去 30 天)
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 个评论
Atanu
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
Walter Roberson 2022-5-31
编辑: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.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by