R: Error in !row.names :无效参数类型

Question

我的k桌看起来：

rsID  
rs6786  
rs798  
rs56,COSM787,COSM687  
rs097,COSM96,COSM90,COSM76

我想有以下几个字(我需要第一个逗号之前的单词)：

rsID  
rs6786  
rs798  
rs56   
rs097

我试着运行这段代码，但是我有一个错误："Error in !row.names :无效参数类型“：

UPDATE k  
SET rsID = SUBSTRING(rsID, 1, CHARINDEX(',', rsID) - 1)  
WHERE CHARINDEX(',', rsID) > 0

Answer 1

我们可以用sub

df1$rsID <- sub(',.*', '', df1$rsID)
df1
#   rsID
#1 rs6786
#2  rs798
#3   rs56
#4  rs097

数据

df1 <- structure(list(rsID = c("rs6786", "rs798",
  "rs56,COSM787,COSM687", 
 "rs097,COSM96,COSM90,COSM76")), .Names = "rsID", 
 class =    "data.frame", row.names = c(NA, -4L))