How transform all ‘NaN’ string in double NaN for each rows

Hi guys,

I have this table:

Date A B C D

'03-Jan-2005' 'NaN' 583 'NaN' 217

'04-Jan-2005' 872 586 'NaN' 219

'05-Jan-2005' 873 578 'NaN' 221

'06-Jan-2005' 888 572 'NaN' 222

'07-Jan-2005' 881 'NaN' 'NaN' 223

'10-Jan-2005' 879 564 'NaN' 222

My question is:

how to transform all 'NaN' value that I find in my table rows in a numeric(double) format?

Thank you very much for your answers.

Answer 1

[KSSV]

Let T be your table.

T.C = str2double(T.C) ; 

[gcicceri]

Thanks for the answer, but mine is just an example and my request is in case the 'NaN' values appear in several rows and columns.

Answer 2

[Ameer Hamza]

Try str2num() for this case: https://www.mathworks.com/help/releases/R2020a/matlab/ref/str2num.html

T.C = str2num(T.C);

[gcicceri]

Thanks for the answer, but mine is just an example and my request is in case the 'NaN' values appear in several rows and columns.

[Ameer Hamza]

Can you attach the actual table in a .mat file? In your question, Column A and B contain 'NaN' and double values. However, such mixing of data types is not possible in Matlab (unless it is a column of cells). Attaching the file will be helpful in this case.