How do i set empty matrix elements to zero?

7 visualizaciones (últimos 30 días)
joakim johansen
joakim johansen el 11 de Mzo. de 2019
Comentada: Rik el 20 de Jun. de 2019
How can i set the empty elements in the above picture to zero, i have tried T = cellfun('isempty', Z),
but it does not recognize the cells as empty.
Anyone got ideas of how to do this?
  2 comentarios
Guillaume
Guillaume el 11 de Mzo. de 2019
It's impossible for us to know from a screenshot what type of data you have. Assuming it's a cell array, it's also impossible for us to know if the cells are actually empty.
It's much better if you attach your data as a mat file. Screenshots are useless.
KALYAN ACHARJYA
KALYAN ACHARJYA el 11 de Mzo. de 2019
Editada: KALYAN ACHARJYA el 11 de Mzo. de 2019
Please attach the file, so that we can try on it.

Iniciar sesión para comentar.

Respuestas (1)

Navdha Agarwal
Navdha Agarwal el 20 de Jun. de 2019
Following assumptions are made for the solution stated below:
  1. The csv file is being read as a matrix and some cells are actually empty.
  2. The name of the file is 'file1.csv'
  3. When the file is read as the matrix, the empty cells are automatically recognized as 'NaN'.
The code for the question, keeping the above assumptions is:
A = readmatrix('file1.csv');
dim = size(A);
for i = 1:dim(1)
for j = 1:dim(2)
if isnan(A(i,j))
A(i,j) = 0;
end
end
end
disp(A)
  1 comentario
Rik
Rik el 20 de Jun. de 2019
The loops are not needed, you can simply use the line below:
A(isnan(A))=0;

Iniciar sesión para comentar.

Categorías

Más información sobre Multidimensional Arrays en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by