r - return most common prefix in columns -


if columns in data frame share common prefix, how find out such common prefix?

note: prefix here means longest substring before number appears.

data set may like:

date,vix1,vix2,vix3,dosg124,dosg220

in case, want vix instead of dosg because more columns (3) have vix prefix.

you try table , which.max after removing 'suffix' part sub. here, assume suffix numeric part.

tbl <- table(sub('\\d+$', '', v1)) names(which.max(tbl)) #[1] "vix" 

by using sub, match numeric part (\\d+) end of string ($) , replace ''

data

 v1 <- c('date', 'vix1', 'vix2', 'vix3', 'dosg124', 'dosg220') 

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -