How do i set empty matrix elements to zero?
11 次查看(过去 30 天)
显示 更早的评论
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/207846/image.png)
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 个评论
Guillaume
2019-3-11
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
2019-3-11
编辑:KALYAN ACHARJYA
2019-3-11
Please attach the file, so that we can try on it.
回答(1 个)
Navdha Agarwal
2019-6-20
Following assumptions are made for the solution stated below:
- The csv file is being read as a matrix and some cells are actually empty.
- The name of the file is 'file1.csv'
- 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 个评论
Rik
2019-6-20
The loops are not needed, you can simply use the line below:
A(isnan(A))=0;
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!