How to find and chart the frequency of a letter in column with histogram.
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I am looking for a way to find the frequency of a letter appearing in each line of a column in an excel file. The only column I am looking at has data like this: HFHFHSHHAJHJA, HSAJHFGFSAGJ, HSGHSFFJHJ. All I have found online so far, specifically through the mathworks resources is
T = readtable('Data.xlsx');
Sets = T{:, 9};
histogram(Sets, 40, 'FaceAlpha',0.4);
Basically I am trying to find the frequency H appears in each line and then the total frequency of the column.
Thank you for your help.
0 commentaires
Réponses (1)
Star Strider
le 28 Juil 2021
Perhaps —
Col = {'HFHFHSHHAJHJA'; 'HSAJHFGFSAGJ'; 'HSGHSFFJHJ'};
T = cell2table(Col)
RowSum = cellfun(@(x)sum(x=='H',2),T{:,1})
ColSum = sum(RowSum)
.
4 commentaires
Voir également
Catégories
En savoir plus sur Histograms 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!