Extracting rows from table with specific digits

Question

Nadeau Hahne 2021-4-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/795847-extracting-rows-from-table-with-specific-digits

回答： Stephen23 2021-4-8

Hello,

I have the following table below. I want pull the rows where the second digit is 2. So I am looking to pull all the rows that have the code '*2****.*' and making a new table from that.

x =

5×2 table

code description

____________ _________________

{'116004.5'} {'description 1'}

{'116006.6'} {'description 2'}

{'120099.9'} {'description 3'}

{'120199.3'} {'description 4'}

{'120202.5'} {'description 5'}

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2021-4-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/795847-extracting-rows-from-table-with-specific-digits#answer_669907

    code = [{'116004.5'}
    {'116006.6'}        
    {'120099.9'}        
    {'120199.3'}    
    {'120202.5'}] ; 
description = [ {'description 1'}
        {'description 2'}
        {'description 3'}
        {'description 4'}
        {'description 5'}] ; 
    
    T = table(code,description) ;
    
    idx = contains(T.(2),'2') ;
    
    T = T(idx,:)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Stephen23 2021-4-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/795847-extracting-rows-from-table-with-specific-digits#answer_669967

I changed your example data so that the first code string contains '2' but not in the 2nd position, to make a more thorough test case.

code = {'116204.5';'116006.6';'120099.9';'120199.3';'120202.5'};
desc = {'description 1';'description 2';'description 3';'description 4';'description 5'};
T = table(code,desc)
T = 5×2 table
        code              desc       
    ____________    _________________

    {'116204.5'}    {'description 1'}
    {'116006.6'}    {'description 2'}
    {'120099.9'}    {'description 3'}
    {'120199.3'}    {'description 4'}
    {'120202.5'}    {'description 5'}
X = cellfun(@isempty,regexp(T.code,'^.2'));
out = T(~X,:)
out = 3×2 table
        code              desc       
    ____________    _________________

    {'120099.9'}    {'description 3'}
    {'120199.3'}    {'description 4'}
    {'120202.5'}    {'description 5'}