我有一个
data.frame
ID由字母数字字符序列组成(例如。,
id = c(A001, A002, B013)
).我在寻找一个简单的函数
stringr
或
stirngi
c(A002, A003, B014)
).
str_add_n <- function(df, string, n, width=3){
string <- enquo(string)
## split the string using pattern
df <- df %>%
separate(!!string,
into = c("text", "num"),
sep = "(?<=[A-Za-z])(?=[0-9])",
remove=FALSE
) %>%
mutate(num = as.numeric(num),
num = num + n,
num = stringr::str_pad(as.character(num),
width = width,
side = "left",
pad = 0
)
) %>%
unite(next_string, text:num, sep = "")
return(df)
}
让我们做一个玩具
df
df <- data.frame(id = c("A001", "A002", "B013"))
str_add_n(df, id, 1)
id next_string
1 A001 A002
2 A002 A003
3 B013 B014
同样,这是有效的,我想知道是否有更好的方法来做到这一点,欢迎所有的调整!
更新
根据建议的答案,我进行了一些基准测试,似乎两者都非常接近,我倾向于
str_add_n_2
(我改了名字,可以同时运行这两个程序,并采纳了
x<-as.character(x)
)
microbenchmark::microbenchmark(question = str_add_n(df, id, 1),
answer = df %>% mutate_at(vars(id), funs(str_add_n_2(., 1))),
string_add = df %>% mutate_at(vars(id), funs(string_add(as.character(.)))))
产生
Unit: milliseconds
expr min lq mean median uq
question 4.312094 4.448391 4.695276 4.570860 4.755748
answer 2.932146 3.017874 3.191262 3.117627 3.240688
string_add 3.388442 3.466466 3.699363 3.534416 3.682762
max neval cld
10.29253 100 c
8.24967 100 a
9.05441 100 b
欢迎更多的调整!