Filter contents of a table
조회 수: 5 (최근 30일)
이전 댓글 표시
I've the following table
tbl = table(['1'; '2'; '3'; '4'; '5'; '6'],['1'; '3'; '2'; '2'; '4'; '1'],'VariableNames', {'name', 'value'})
I would like to filter rows that don't have 'value' 3 and 4.
Expected result:
tbl = table(['1'; '3'; '4'; '6'],['1'; '2'; '2';'1'],'VariableNames', {'name', 'value'})
Any suggestions on how this can be done?
댓글 수: 0
채택된 답변
dpb
2019년 12월 7일
Why are numeric values entered as text/characters?
ix=~ismember(str2num(tbl.value),[3 4]);
tbl=tbl(ix,:);
If the real question is for table that is using nonnumeric character data, then use one of the string search functions instead. For the actual question, I'd strongly suggest either build the table as numeric to begin with or immediately convert to double.
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Identification에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!