# How to remove cells in cell matrix that are a certain value?

2 ビュー (過去 30 日間)
Dc215905 2021 年 6 月 18 日

Hello,
I have a 8x4 cell matrix that looks like:
1x761200 double 1x121400 double 1x299600 double 1x555000 double
1x761200 double 1x121400 double 1x299600 double 1x555000 double
1x761200 double 1x121400 double 1x299600 double 1x555000 double
1x761200 double 1x121400 double 1x299600 double 1x555000 double
-1 -1 -1 -1
-1 -1 -1 -1
1x761200 double 1x121400 double 1x299600 double 1x555000 double
1x761200 double 1x121400 double 1x299600 double 1x555000 double
I would like to find which rows contain '-1' and then remove those rows from the matrix.
Any suggestions?

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

### 採用された回答

Rik 2021 年 6 月 18 日

data(all(cellfun('prodofsize',data)==1),:)=[];
You might need to specify the dimension for the all function (writing of mobile, so no testing). You might also mean the any function instead of all.
Edit:
This does indeed require a modification:
L=all(cellfun('prodofsize',data)==1,2)
% ^^
data(L,:)=[]
##### 3 件のコメント1 件の古いコメントを表示1 件の古いコメントを非表示
Rik 2021 年 6 月 18 日
Let's try with a simple example (and the dimension changed, I really should learn the syntax some day..).
data={...
[1 2],[1 2],[1 2];...
-1 ,-1 ,1 ;...
[1 2],[1 2],[1 2]};
L=all(cellfun('prodofsize',data)==1,2)
L = 3×1 logical array
0 1 0
data(L,:)=[]
data = 2×3 cell array
{[1 2]} {[1 2]} {[1 2]} {[1 2]} {[1 2]} {[1 2]}
Dc215905 2021 年 6 月 19 日
Thank you! That works great!

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

### カテゴリ

Help Center および File ExchangeStartup and Shutdown についてさらに検索

### Community Treasure Hunt

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

Start Hunting!

Translated by