How to count the amount of excell row
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Putri Basenda Tarigan
il 13 Nov 2020
Modificato: Akira Agata
il 13 Nov 2020
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 Commenti
Risposta accettata
Akira Agata
il 13 Nov 2020
Modificato: Akira Agata
il 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!