pengchy
我在用R读入一个表格的时候,其中有一些是空值,读入后就变成""了,如果我想把这样的值全部转换成NA不知该如何操作? 我用grep("",matrix[,1])返回的是所有的值,包括""。
if(i=="") {
loc <- grep(tf[i,1],anno[,2])
print(tf[i,2])
} else{a
loc <- grep(tf[i,2],anno[,1])
#print(tf[i,2])
}
结果发现if(i=="")根本没有执行,难道i==""也不行?
谢谢!
pengchy
> tf[1:20,]
symbol refseq locuslink
[1,] "AA125825" "AA125825" ""
[2,] "AA634818" "AA634818" ""
[3,] "AATF" "NM_012138" "26574"
[4,] "AB002296" "AB002296" ""
[5,] "AB058701" "AB058701" ""
[6,] "AB075831" "AB075831" ""
[7,] "ABT1" "NM_013375" "29777"
[8,] "ADNP" "NM_015339" "23394"
[9,] "AEBP2" "NM_153207" "121536"
[10,] "AF020591" "NM_014480" "27300"
[11,] "AF093680" "NM_013242" "29105"
[12,] "AF5Q31" "NM_014423" "27125"
[13,] "AHR" "NM_001621" "196"
[14,] "AHRR" "NM_020731" "57491"
[15,] "AI022870" "AI022870" ""
[16,] "AI352508" "AI352508" ""
[17,] "AI569906" "AI569906" ""
[18,] "AI808690" "AI808690" ""
[19,] "AIRE" "NM_000383" "326"
[20,] "AK024238" "AK024238" ""
>tf2 <- tf[,2]
>tf2[tf2==""]=NA
>tf[,2] <- tf2
搞定!
谢谢版主!