How to find and chart the frequency of a letter in column with histogram.
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Star Strider
am 28 Jul. 2021
Perhaps —
Col = {'HFHFHSHHAJHJA'; 'HSAJHFGFSAGJ'; 'HSGHSFFJHJ'};
T = cell2table(Col)
RowSum = cellfun(@(x)sum(x=='H',2),T{:,1})
ColSum = sum(RowSum)
.
4 Kommentare
Siehe auch
Kategorien
Mehr zu Histograms finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!