Azzera filtri
Azzera filtri

How to delect the zero values in table

34 visualizzazioni (ultimi 30 giorni)
There is a table in matlab, I want to know how to delete the entire row with zero values?
Many thanks in advance.

Risposta accettata

the cyclist
the cyclist il 24 Mag 2021
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

Più risposte (1)

Fangjun Jiang
Fangjun Jiang il 24 Mag 2021
Modificato: Fangjun Jiang il 24 Mag 2021
a=[1 2 3;0 0 0 ; 1 0 2];
index=all(a==0,2);
a(index,:)=[];

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by