How to get several values from a cell array through a loop?

Hi there,

I'm quite new to MATLAB and thats why I need some help.

I have got a cell array of size m x 3 and I want to extract the values in all 3 columns, by identifying the right rows with the value in column 1.

e.g.

A = {'company name', date, number

'company name 2', date, number}

I also wants to use a loop because the number of companies and thus the number of rows change.

Thanks in advance

Answer 1

[Jyotirmay Mishra]

For example you have a cell array a = {'abc', 1, 2; 'ba', 2, 4}

You can do the following steps to find all the column of row with company name 'abc'

t = string(a(:,1)) %%This gives first column of all rows in string form

Y = "abc" == t %% This in this case will give a 2X1 array with 1 in case the name matches and 0 if it doesn't

Result = a(Y, :) %% This will give all the columns of rows with matched condition

[madhan ravi]

@Jyotirmay Mishra didn’t know you could vote your own answer. By the way conversion of a cell array to a string array is not needed here.

[Jyotirmay Mishra]

That i just did to check if it was working from my personal id, because a lot of people are facing issues answering questions on matlab answer and i am also facing the same issue when trying from my personal id I unvoted the answer And thanks for the info

[Phil_911]

Thank, this worked for using one company name, but can I do it for severals as well?

I have got a cell array with 17 different company names and don't want to type in every single name.

Is it possible to use a loop, that takes the company from the string as a condition and finds all the rows from the company? Or is there maybe a easier way to do that?

[Jyotirmay Mishra]

Yes you can use a loop. For example- If you have a different cell array with company names and you want to check for each company name in that cell array you can do something like this

comp_name = {...} %%company name cell array

for i=1:length(comp_name)

t = string(a(:,1))

Y = string(comp_name(i)) == t

Result = a(Y, :) %% a is the name of original cell array with 3 columns

%%Result will give the required rows for each company name in comp_name cell array

end

You can also do it without converting the elements into a string

Look at this post for more insight

https://in.mathworks.com/matlabcentral/answers/307310-logical-indexing-in-cell-array

[Phil_911]

But if I use your equation the result only gives me back the rows of the one company. And I need the rows of each company seperated. With your code I only receive the rows of comapany a.

And Y only has the ones for one in, my case the last company. I am missing all other companies.

Could you please give me further info on that?

Thanks a lot.