logical indexing into cell array to remove rows

Asked May 19 '14 at 12:52

Active Apr 18 '16 at 15:15

Viewed 103 times

I have a cell array and I am looking to remove some of the rows.

If a company in my cell array is not in companies_list I would like to remove the row from my cell array. I have tried the below however I get the error message:

Function 'subsindex' is not defined for values of class 'cell'.

Here is my code:

 indx = ismember(mycell.companies(:,1), companies_list(:,1));
 companies = mycell.companies(mycell.companies(indx == 1), :);

edited Apr 18 '16 at 15:15

Mikhail_Sam

10,602
11
66
102

asked May 19 '14 at 12:52

mHelpMe

6,336
24
75
150

Convert both of them to double arrays with `cell2mat` and then try `ismember` again? – Divakar May 19 '14 at 12:54
my cell array contains text and numbers in different fields - would cell2mat still work in that case? – mHelpMe May 19 '14 at 12:56
So, even the first columns have such mixed datatypes? I meant using `cell2mat` just on the first columns - `cell2mat(mycell.companies(:,1))` – Divakar May 19 '14 at 12:57
Sorry my mistake. mycell.companies is a 4500 x 2 cell. Both fields are text. – mHelpMe May 19 '14 at 13:00
Tried `cell2mat` just on the first columns of those two cell arrays? – Divakar May 19 '14 at 13:01
Its the 2nd line where the error happens. Why would I need to do cell2mat on companies_list? – mHelpMe May 19 '14 at 13:05
Isn't `companies_list` a cell array too? And what's the error? – Divakar May 19 '14 at 13:05
yes it is. However the ismember function give me the correct logical array. Its trying to use 'indx' where the error happens – mHelpMe May 19 '14 at 13:07
1

If you have the correct `indx`, after that just do this - `companies = mycell.companies(indx, :);` – Divakar May 19 '14 at 13:10
ah yep was being bit stupid there. thanks again – mHelpMe May 19 '14 at 13:12
Great! Problem solved and we move on :) – Divakar May 19 '14 at 13:13

logical indexing into cell array to remove rows

0 Answers0