Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

counting occurrence of particular letter in vector of words in r

Tags:

string

r

count

I am trying to count number of particular letter in long vector of words.

for example:

I would like to count number of letter "A" in the following vector.

myvec <- c("A", "KILLS", "PASS", "JUMP", "BANANA", "AALU", "KPAL")

So intended output would be:

c(1,0,1,0, 3,2,1)

Any idea ?

like image 395
SHRram Avatar asked Oct 31 '14 18:10

SHRram


3 Answers

Another posibility:

myvec <- c("A", "KILLS", "PASS", "JUMP", "BANANA", "AALU", "KPAL")

sapply(gregexpr("A", myvec, fixed = TRUE), function(x) sum(x > -1))

## [1] 1 0 1 0 3 2 1

EDIT This was begging for a benchmark:

library(stringr); library(stringi); library(microbenchmark); library(qdapDictionaries)

myvec <- toupper(GradyAugmented)

GREGEXPR <- function() sapply(gregexpr("A", myvec, fixed = TRUE), function(x) sum(x > -1))
GSUB <- function() nchar(gsub("[^A]", "", myvec))
STRSPLIT <- function() sapply(strsplit(myvec,""), function(x) sum(x=='A'))
STRINGR <- function() str_count(myvec, "A")
STRINGI <- function()  stri_count(myvec, fixed="A")
VAPPLY_STRSPLIT <- function() vapply(strsplit(myvec,""), function(x) sum(x=='A'), integer(1))


(op <- microbenchmark( 
    GREGEXPR(),
    GSUB(),
    STRINGI(),
    STRINGR(),
    STRSPLIT(),
    VAPPLY_STRSPLIT(),    
times=50L))

## Unit: milliseconds
##               expr        min         lq       mean     median        uq        max neval
##         GREGEXPR() 477.278895 631.009023 688.845407 705.878827 745.73596  906.83006    50
##             GSUB() 197.127403 202.313022 209.485179 205.538073 208.90271  270.19368    50
##          STRINGI()   7.854174   8.354631   8.944488   8.663362   9.32927   11.19397    50
##          STRINGR() 618.161777 679.103777 797.905086 787.554886 906.48192 1115.59032    50
##         STRSPLIT() 244.721701 273.979330 331.281478 294.944321 348.07895  516.47833    50
##  VAPPLY_STRSPLIT() 184.042451 206.049820 253.430502 219.107882 251.80117  595.02417    50

boxplot(op)

And stringi whooping some major tail. The vapply + strsplit was a nice approach as was the simple gsub approach. Interesting results for sure.

enter image description here

like image 147
Tyler Rinker Avatar answered Oct 27 '22 01:10

Tyler Rinker


For a succinct base R solution, try this:

nchar(gsub("[^A]", "", myvec))
# [1] 1 0 1 0 3 2 1
like image 43
Josh O'Brien Avatar answered Oct 27 '22 01:10

Josh O'Brien


library(stringr)
str_count(myvec, "A")
#[1] 1 0 1 0 3 2 1

or

 library(stringi)
 stri_count(myvec, fixed="A")
 #[1] 1 0 1 0 3 2 1

or

 vapply(strsplit(myvec,""), function(x) sum(x=='A'), integer(1))
 #[1] 1 0 1 0 3 2 1
like image 45
akrun Avatar answered Oct 27 '22 00:10

akrun