How to find and chart the frequency of a letter in column with histogram.

조회 수: 2 (최근 30일)
N/A
N/A 2021년 7월 28일
댓글: Star Strider 2021년 7월 29일
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.

답변 (1개)

Star Strider
Star Strider 2021년 7월 28일
Perhaps —
Col = {'HFHFHSHHAJHJA'; 'HSAJHFGFSAGJ'; 'HSGHSFFJHJ'};
T = cell2table(Col)
T = 3×1 table
Col _________________ {'HFHFHSHHAJHJA'} {'HSAJHFGFSAGJ' } {'HSGHSFFJHJ' }
RowSum = cellfun(@(x)sum(x=='H',2),T{:,1})
RowSum = 3×1
6 2 3
ColSum = sum(RowSum)
ColSum = 11
.
  댓글 수: 4
N/A
N/A 2021년 7월 29일
So basically it would be a histogram showing the percentage of H in the data set. Sorry for not being clear enough.
Star Strider
Star Strider 2021년 7월 29일
In that event, just use bar with ‘H_Pct_Row’.

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Histograms에 대해 자세히 알아보기

태그

제품


릴리스

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by