Replace NaN’s in table with zero
Hello, I have a 1501×7 table called ‘x’ and there appears to be NaN’s in the fourth and sixth column called "Age" and "height". I would like a way to replace NaN’s with zeros. Take note, that I have already tried:
k = find(isnan(x))’;
x(k) = 0;
% and
x(isnan(x)) = 0;
Yet, neither work because I am using a table, not a matrix. I have also tried converting my table into a cell array, and using these same functions, but they still do not work. They return:"Undefined function ‘isnan’ for input arguments of type ‘cell’"
ALSO, please note that the table has columns full of text. So, cell2mat does not work.Hello, I have a 1501×7 table called ‘x’ and there appears to be NaN’s in the fourth and sixth column called "Age" and "height". I would like a way to replace NaN’s with zeros. Take note, that I have already tried:
k = find(isnan(x))’;
x(k) = 0;
% and
x(isnan(x)) = 0;
Yet, neither work because I am using a table, not a matrix. I have also tried converting my table into a cell array, and using these same functions, but they still do not work. They return:"Undefined function ‘isnan’ for input arguments of type ‘cell’"
ALSO, please note that the table has columns full of text. So, cell2mat does not work. Hello, I have a 1501×7 table called ‘x’ and there appears to be NaN’s in the fourth and sixth column called "Age" and "height". I would like a way to replace NaN’s with zeros. Take note, that I have already tried:
k = find(isnan(x))’;
x(k) = 0;
% and
x(isnan(x)) = 0;
Yet, neither work because I am using a table, not a matrix. I have also tried converting my table into a cell array, and using these same functions, but they still do not work. They return:"Undefined function ‘isnan’ for input arguments of type ‘cell’"
ALSO, please note that the table has columns full of text. So, cell2mat does not work. nan, zeros, replace, matrix, cell, basic, beginner, replacement, remove, tables, format MATLAB Answers — New Questions