How to get NaN if the data is not in proper input format or missing?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Walter Roberson
il 31 Mag 2022
Modificato: Walter Roberson
il 31 Mag 2022
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.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!