How to count the amount of excell row

5 次查看(过去 30 天)
Hello.
I have an excel file with 80x10. for the first column, it has number from 1 to 10 but appear in many rows. for example number 1 appear in row 1,2,3. number 2 appear in row 4,5,6, etc. I want to calculate how many rows having the same number in that column. How to code this in Matlab?
Please help me.
Thank you

采纳的回答

Akira Agata
Akira Agata 2020-11-13
编辑:Akira Agata 2020-11-13
How about using accumarray function? The following is an example:
% Sample data (column vector containing 1~10 randomly)
data = randi(10,80,1);
% Count how many times 1~10 appears
count = accumarray(data,1);
% Arrange the result
number = (1:10)';
T = table(number,count);
>> T
T =
10×2 table
number count
______ _____
1 7
2 10
3 4
4 3
5 8
6 11
7 9
8 7
9 13
10 8

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by