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

106 Ansichten (letzte 30 Tage)
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.

Akzeptierte Antwort

Cris LaPierre
Cris LaPierre am 14 Okt. 2022
Bearbeitet: Cris LaPierre am 14 Okt. 2022
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, :)

Weitere Antworten (0)

Kategorien

Mehr zu MATLAB finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by