Remove cell array rows based on logical condition?
16 次查看(过去 30 天)
显示 更早的评论
Howdy,
I have a 2267x23 cell array (raw). I would like to remove rows based on the condition of a logical.
Here is what I've done:
I = num(:,20) == 1 | num(:,20) == 7; % Makes logical index for weekend (1 = weekend, 0 = weekday)
E = [num, I];
E(E(:,22) == 0, :) = []; % Weekend bin, site 0
Y = [num, I];
Y(Y(:,22) == 1, :) = []; % Weekday bin, site 0
but I realized that that didn't help me with the raw data. So I want to do something similar to the raw data so I can then have two subsets of cell arrays (Weekend and weekday) but I can't figure it out.
I tried:
E = [raw, I];
E(E(:,24) == 0, :) = [];
.
.
.
but it does not like the concatenating attempt. So I tried making the logical a cell but it does not like that either.
Any help would be stellar, thank you!
0 个评论
采纳的回答
OCDER
2018-7-18
[Num, ~, Raw] = xlsread('yourdata.xlsx');
I = Num(:,20) == 1 | Num(:,20) == 7; %Your logical index of weekends
Weekend = Raw( I, :);
Weekday = Raw(~I, :);
更多回答(1 个)
dpb
2018-7-18
With what you've got, you're just looking for
raw(I,:)=[];
to leave week weekday rows of all the data.
Knowing the actual data format in the raw array it might be possible to simplify the machinations done to have gotten to your I
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!