如何使用%、-和+作为可能的分隔符将字符列拆分为3列,并将分隔符保留在新列中?
示例数据:
data <- data.table(x=c("92.1%+100-200","90.4%-1000+200", "92.8%-200+100", "99.2%-500-200","90.1%+500-200"))
所需数据示例:
data.desired <- data.table(x1=c("92.1%", "90.4%", "92.8%","99.2%","90.1%")
, x2=c("+100","-1000","-200","-500","+500")
, x3=c("-200","+200","+100","-200","-200"))
很高兴在这个问题上得到一个好的答案和一些帮助!
https://stackoverflow.com/questions/53715609
复制相似问题