how many times is a value repeated in a table

Question

Fedi Chaarana 2021-7-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878353-how-many-times-is-a-value-repeated-in-a-table

回答： Sulaymon Eshkabilov 2021-7-14

Hello

I have a mdf4 datei that i read with matlab and was converted into timetable. I converted this timetable to a normal table and i want to analyse the values of the first row. Each values was taken after 0,1s so and are one of these following possibilities{20,50,100} with some tolerance.

My question: how can i create a loop that tells me for how many times a values is repeated on the table ?

thanks in advance

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

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2021-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878353-how-many-times-is-a-value-repeated-in-a-table#answer_746793

在 MATLAB Online 中打开

N20=sum(tab.prob(:,1)==20); % Times of 20s
N50=sum(tab.prob(:,1)==50); % Times of 50s
N100=sum(tab.prob(:,1)==100); % Times of 100s

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

请先登录，再进行评论。

Answer 2

Ive J 2021-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/878353-how-many-times-is-a-value-repeated-in-a-table#answer_746773

在 MATLAB Online 中打开

You can play with groupSummary which offers lots of options:

tab = table(repmat([20; 50; 100], 20, 1), string((1:60).'), 'VariableNames', {'prob', 'id'});
head(tab)
ans = 8×2 table
    prob    id 
    ____    ___

     20     "1"
     50     "2"
    100     "3"
     20     "4"
     50     "5"
    100     "6"
     20     "7"
     50     "8"
tabSum = groupsummary(tab, 'prob')
tabSum = 3×2 table
    prob    GroupCount
    ____    __________

     20         20    
     50         20    
    100         20    