MATLAB Answers

0

Can I extract data from excel filtering a specific search word and its associated value on the next column?

Hello. I have an excel sheet and there is a column with different names of data, for example my column can have O2, oxygen or iron. the next column has actual number values. I know on excel you can filter your column to only show "O2" for example. Is there a way to do this with Matlab? I want to extract all the values on the column next to the names but only the values that match "O2"

  0 Comments

Sign in to comment.

1 Answer

 Accepted Answer

Hi Karla,
You can do this by proper indexing of the columns. Please see code sample below:
data = {'O2', 5;'oxygen', 3;'iron', 2};
filtered = data(strcmp(data(:,1),'O2'), 2)
Note that in order to keep the data in the same array, you have to use cell arrays.

  0 Comments

Sign in to comment.