开发者

Replacing NA's with asterisks (*)

开发者 https://www.devze.com 2023-03-01 06:33 出处:网络
I have a data set which I read from my a .csv file. After some editing work, I now need to write it as a .txt file with (i) all quotes removed (ii) every NA in the whole file to be replaced by an aste

I have a data set which I read from my a .csv file. After some editing work, I now need to write it as a .txt file with (i) all quotes removed (ii) every NA in the whole file to be replaced by an asterisk, *, and (iii) first row (variable names) excluded.

The following scripts, so far, remove quotes and am just wondering how can (ii) and (iii) can be added or may be done.

write.table(ped5, "ped5.txt" ,row.names=FALSE)
ped5 <- read.table("ped5.txt", header=TRUE)
write.table(ped5, "ped7.txt", row.names=FALSE, quote=FALSE)

Any help would be very much appr开发者_如何学Ceciated!


For (ii) use na = "*" and for (iii) col.names=FALSE.
So:

write.table(ped5,"ped7.txt",row.names=FALSE,quote=FALSE, na="*", col.names=FALSE)

It's all to find on help page to write.table (?write.table).

0

精彩评论

暂无评论...
验证码 换一张
取 消