How to count number of letters (including some with special symbols)
9 views (last 30 days)
Show older comments
Hi,
I have an Excel file from which I want to read the entire first column into Matlab and have as an output how many times given letters occur.
However, the problem is that some of the letters have an apostrophe attached to them, for example:
m'
s
a
s'
In the string above, s should be treated as a separate thing which has nothing in common with s'. So the frequency should show 1 for each of the letters, i.e.:
m' 1
s 1
a 1
s' 1
I have tried many things which I found of this forum but none of them has worked so far. One of the basic problems I encountered was loading in the file into Matlab due to the apostrophe, not to mention creating a proper table with frequency.
I would be very grateful for some help!
4 Comments
Accepted Answer
Cris LaPierre
on 18 Nov 2019
Edited: Cris LaPierre
on 18 Nov 2019
Ok, so if each entry is on its own row, then I'd do the following.
vals=readtable('ediD_count.xlsx','ReadVariableNames',false);
cnts=groupsummary(vals,"Var1")
I've attached what I'm using as a data set. It looks like this:
vals =
Var1
____
'm''
's'
'a'
's''
'f1'
'k'
's'
'a'
's''
'a'
...
The result is a table of unique values found in the first variable, and the number of times it was found in the second.
cnts =
Var1 GroupCount
____ __________
'a' 4
'f1' 2
'k' 2
'm'' 1
's' 3
's'' 4
More Answers (0)
See Also
Categories
Find more on Variables in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!