How to delect the zero values in table

58 次查看（过去 30 天）
Chao Zhang
Chao Zhang 2021-5-24
评论： Chao Zhang 2021-5-24
There is a table in matlab, I want to know how to delete the entire row with zero values?
Many thanks in advance.

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2021-5-24
Ran in:
If all of the table entries are numeric, then this will work:
% Create an example input table
x = [0; 1; 0; 2];
y = [0; 1; 0; 2];
z = [0; 0; 0; 0];
tbl = table(x,y,z)
tbl = 4×3 table
x y z _ _ _ 0 0 0 1 1 0 0 0 0 2 2 0
% Identify rows with all zeros, by first converting to numeric
rowsToDelete = all(table2array(tbl)==0,2);
% Delete the rows
tbl(rowsToDelete,:) = []
tbl = 2×3 table
x y z _ _ _ 1 1 0 2 2 0

更多回答（1 个）

Fangjun Jiang
Fangjun Jiang 2021-5-24
编辑：Fangjun Jiang 2021-5-24
a=[1 2 3;0 0 0 ; 1 0 2];
index=all(a==0,2);
a(index,:)=[];

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by