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

5 次查看（过去 30 天）
Karla Haiat
Karla Haiat 2018-1-15
评论： Srikanth Reddy Pyata 2023-6-12
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"

请先登录，再回答此问题。

采纳的回答

Emmanouil Tzorakoleftherakis
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by