Could anyone help me out in finding frequency of data using excel file and later finding the row having maximum frequency?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Riya sharma
le 6 Nov 2022
Réponse apportée : Kevin Holly
le 6 Nov 2022
From the range column of excel file attatched, I need to sum up each row ( columns b to h) and store the sum value in a matrix.
After I get a matrix of sum values of each row. Further the max value of that matrix is needed to be found and corresponding range to which it belongs. Could anyone help me out how I can achieve this using matlab code. The excel file is attatched.
0 commentaires
Réponse acceptée
Kevin Holly
le 6 Nov 2022
t = readtable('frequency.xlsx')
t.Sum = sum(table2array(t(:,2:end)),2)
[maxvalue, Index] = max(t.Sum)
t(Index,[1 end])
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!