How can I delete/extract rows from a table with cell columns consisting of str and numeric values

1 次查看（过去 30 天）
Peter Jaenicke
Peter Jaenicke 2017-7-14
评论： Peter Perkins 2017-7-18
I have a table comprising of number and cell columns:
From this table I would like to extract all rows which have "pits" in a cell in column 3 / Type.
My approaches so far:
1. Extract it via "strfind"
Ppits=P(cellfun(@isempty, strfind(P.Type, 'pits')), :);
Error:
Error using strfind
Cell must be a cell array of character vectors.
2. Delete rows with "0" or []. All attempts like logical indexing didn't work due to the fact that it's a table or the column has numerical and str values.
e.g.
>> toDelete = P < 6;
P(toDelete,:) = [];
Undefined operator '<' for input arguments of type 'table'.

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

回答（1 个）

dbmn
dbmn 2017-7-14
The easiest way to extract the "pits" is to do the following
% Convert your column type to a format called categorical
% This format is supported by the table format
P.Type = categorical(P.Type)
% Then you can compare it like you would with numbers
P(P.Type == 'pits', :)
if you want to do the same with f.ex PH value just use
P(P.pH < 7, :)
and combine the two as you like
  1 个评论
Peter Jaenicke
Peter Jaenicke 2017-7-14
First of all, thank you for your answer. Using
P.Type = categorical(P.Type)
results into
Error using categorical (line 347)
Could not find unique values in DATA using the UNIQUE function.
Caused by:
Error using cell/unique (line 85)
Input A must be a cell array of character vectors.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Categorical Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by