how many times is a value repeated in a table

2 次查看（过去 30 天）
Fedi Chaarana
Fedi Chaarana 2021-7-14
回答： 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

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

采纳的回答

Sulaymon Eshkabilov
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

更多回答（1 个）

Ive J
Ive J 2021-7-14
Ran in:
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

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by