Find specific range in a table

Question

Pouyan Sadeghian 2021-6-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/846545-find-specific-range-in-a-table

评论： Star Strider 2021-6-3

采纳的回答： Star Strider

在 MATLAB Online 中打开

Hi,

I want to find a specific range in my table.

For example I have a table like this called table:

 Var1          Label          MaxPosition    MinValue
    ____    _________________    ___________    ________
   {'Image0029.bmp'}         38            0   
   {'Image0029.bmp'}         51            0   
   {'Image0030.bmp'}         40            0   
   {'Image0030.bmp'}         47            0   
   {'Image0030.bmp'}         51            0   
   {'Image0030.bmp'}         54            0   
   {'Image0031.bmp'}         42            0   
   {'Image0031.bmp'}         53            0   
   {'Image0031.bmp'}         57            0   
   {'Image0032.bmp'}         44            0   
   {'Image0032.bmp'}         55            0   
   {'Image0032.bmp'}         59            0   
   {'Image0033.bmp'}         45            0 
    

I want to display just the values greater than 40 and less than 50 of the column MaxPosition. I tried the code but it doesnt work and I dont know why. I searched in the forums and help and dont find a solution for my problem.

This is the code I use:

NewTable = varfun(@(x)(x>40) & (x<50),table,'GroupingVariables','MaxPosition')

If it is uesfull the error:

Error using tabular/varfun>dfltErrHandler (line 434)
Applying the function '@(x)(x>40)&(x<50)' to the 1st group in the variable 'Label' generated the following error:
Undefined function 'gt' for input arguments of type 'cell'.
Error in tabular/varfun>@(s,varargin)dfltErrHandler(grouped,funName,s,varargin{:}) (line 183)
    errHandler = @(s,varargin) dfltErrHandler(grouped,funName,s,varargin{:});
Error in tabular/varfun (line 230)
                outVals{igrp} = errHandler(s,inArg);
Error in calculation (line 27)
MaxV = varfun(@(x)(x>40) & (x<50),sortedTablelup,'GroupingVariables','MaxPosition')

I would be happy if someone could help me.

Best

Pouyan

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2021-6-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/846545-find-specific-range-in-a-table#answer_715570

在 MATLAB Online 中打开

Try this —

T1 = cell2table({678.     {'Image0029.bmp'},         38            0   
   {'Image0029.bmp'}         51            0   
   {'Image0030.bmp'}         40            0   
   {'Image0030.bmp'}         47            0   
   {'Image0030.bmp'}         51            0   
   {'Image0030.bmp'}         54            0   
   {'Image0031.bmp'}         42            0   
   {'Image0031.bmp'}         53            0   
   {'Image0031.bmp'}         57            0   
   {'Image0032.bmp'}         44            0   
   {'Image0032.bmp'}         55            0   
   {'Image0032.bmp'}         59            0   
   {'Image0033.bmp'}         45            0}, 'VariableNames',{'Var1','Label','MaxPosition','MinValue'})
T1 = 13×4 table
    Var1          Label          MaxPosition    MinValue
    ____    _________________    ___________    ________

   {'Image0029.bmp'}        38            0    
   {'Image0029.bmp'}        51            0    
   {'Image0030.bmp'}        40            0    
   {'Image0030.bmp'}        47            0    
   {'Image0030.bmp'}        51            0    
   {'Image0030.bmp'}        54            0    
   {'Image0031.bmp'}        42            0    
   {'Image0031.bmp'}        53            0    
   {'Image0031.bmp'}        57            0    
   {'Image0032.bmp'}        44            0    
   {'Image0032.bmp'}        55            0    
   {'Image0032.bmp'}        59            0    
   {'Image0033.bmp'}        45            0    
T2 = T1((T1.MaxPosition>40) & (T1.MaxPosition<50),:) 
T2 = 4×4 table
    Var1          Label          MaxPosition    MinValue
    ____    _________________    ___________    ________

   {'Image0030.bmp'}        47            0    
   {'Image0031.bmp'}        42            0    
   {'Image0032.bmp'}        44            0    
   {'Image0033.bmp'}        45            0    