How to remove rows based on logical values in one column?

17 次查看（过去 30 天）
Mahyar Farahani
Mahyar Farahani 2020-10-3
回答： Image Analyst 2020-10-3
Hi
In my file I have 3 columns with many rows. One of the columns has 0/1 logical vlaues, I was wondering if there is command to remove all the rows associated with value 0 and keep all the one that are 1?

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

回答（2 个）

madhan ravi
madhan ravi 2020-10-3
T = table2array(readtable('73(4)_interval.xlsx'));
T(any(T==0, 2), : ) = []
Image Analyst
Image Analyst 2020-10-3
Let's say column 2 is the one you want to inspect, and data is your matrix. Then you can do
data = readmatrix(filename);
goodRows = logical(data(:, 2)); % Get column 2.
data = data(goodRows, :); % Take only rows where column 2 is 1.
Just basic MATLAB vectorization.
http://www.mathworks.com/matlabcentral/answers/8026-best-way-s-to-master-matlab
Free 2 hour training

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by