MATLAB Answers

How to count the amount of excell row

1 view (last 30 days)
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

  0 Comments

Sign in to comment.

Accepted Answer

Akira Agata
Akira Agata on 13 Nov 2020
Edited: Akira Agata on 13 Nov 2020
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 Comments

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by