How to extract table rows based on a column entry (string) which match a pattern?

44 次查看（过去 30 天）
Atanu
Atanu 2022-10-14
编辑： Cris LaPierre 2022-10-14
I have table where health column contains has similar values, like '1 Hour Saline', '2 Hour Saline', '2 hour Saline', '3 Hour Saline', '4 Hour Saline'. So far I'm fetching those rows with the following code
mergedTable(mergedTable.health == '1 Hour Saline' | ...
mergedTable.health == '2 Hour Saline' | mergedTable.health == '2 hour Saline' | ...
mergedTable.health == '3 Hours Saline' | mergedTable.health == '4 Hour Saline', :);
Is there an option to write the query using a pattern? I would also prefer the query to be case insensitive. I have attached the sample table for your reference.

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

采纳的回答

Cris LaPierre
Cris LaPierre 2022-10-14
编辑：Cris LaPierre 2022-10-14
You can use MATLAB's pattern matching functions (I like contains for this application). The table you shared does not contain any iteration of "Hour Saline" in it, but if it did, something like this should work.
ind = contains(mergedTable.health, "Hour Saline");
T2 = mergedTable(ind, :)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Oceanography and Hydrology 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by