フィルターのクリア

How do I extract a row of data from a cell array?

62 ビュー (過去 30 日間)
Brad
Brad 2014 年 5 月 7 日
コメント済み: Bryan 2018 年 10 月 2 日
I have a 3 x 4 cell array, (a), that looks like this;
'Due' 55000 1 100
'WFR' 55100 2 200
'Due' 55200 20 300
where column 1 is of char, and the others are doubles.
I'm attempting to extract the rows of data based on the values in the 3rd column being greater than 2 (20 in this case).
Desired output is cell b = 'Due' 55200 20 300
I'm using the following code;
b=a(~ismember(a(:, 3), [1 2]), :);
I keep getting the following error message;
"Input A of class cell and input B of class double must be cell arrays of strings, unless one is a string"
This is the first time I've attempted to extract rows of data from cell arrays. Am I doing something wrong? If so, how do I approach this problem in order to get b?

採用された回答

Andrei Bobrov
Andrei Bobrov 2014 年 5 月 7 日
b = a(cat(1,a{:,3}) > 2,:)
  3 件のコメント
fei peng
fei peng 2016 年 10 月 19 日
GOOD
Bryan
Bryan 2018 年 10 月 2 日
Excellent! Thanks

サインインしてコメントする。

その他の回答 (1 件)

Sara
Sara 2014 年 5 月 7 日
If you know which row you want to extract, you can do:
b = a(row,:);
  1 件のコメント
Brad
Brad 2014 年 5 月 7 日
Sara, I'm looking to extract the row based on a specific value in the 3rd column (which varies). I did try your approach and it works. But I need some ideas on how to approach this when the values in the 3rd column are not equal to 1 or 2. Thanks.

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeWhos についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by