Skip to content

how do I separete coloumns by comma?

1 message · arun

#
Hi,
Try:
mydata <- read.table("data.txt") #or read.table("data.txt",sep="")
?str(mydata)
#'data.frame':??? 6 obs. of? 6 variables:
# $ V1: int? 1 1 1 1 1 1
# $ V2: int? 4 4 4 2 2 2
# $ V3: int? 4 2 5 3 3 3
# $ V4: int? 1 2 1 1 1 1
# $ V5: int? 6 3 2 1 2 4
# $ V6: int? 23 28 24 24 40 22


?write.table(mydata,"dataNew.txt",sep=",",row.names=FALSE,quote=FALSE)
##dataNew.txt
V1,V2,V3,V4,V5,V6
1,4,4,1,6,23
1,4,2,2,3,28
1,4,5,1,2,24
1,2,3,1,1,24
1,2,3,1,2,40
1,2,3,1,4,22
#or

?Lines1 <- readLines("data.txt")
?gsub(" +",",",Lines1)
#[1] "1,4,4,1,6,23" "1,4,2,2,3,28" "1,4,5,1,2,24" "1,2,3,1,1,24" "1,2,3,1,2,40"
#[6] "1,2,3,1,4,22"

A.K.




Hi every one, 


I have a text file like this: 
1??? 4?? 4??? 1??? 6 ?? 23 
1?? 4??? 2??? 2??? 3??? 28 
1??? 4??? 5??? 1??? 2??? 24 
1??? 2??? 3??? 1??? 1??? 24 
1?? 2??? 3??? 1??? 2?? ? 40 
1?? 2?? 3??? 1??? 4? ? ? 22 

I want to separate columns by comma, like this: 
1,4,4,1,6,23 
1,4,2,2,3,28 
1,4,5,1,2,24 
1,2,3,1,1,24 
1,2,3,1,2,40 
1,2,3,1,4,22?? 

I used this code: 
mydata=read.table("data.txt",sep=",") 
but I see this output: 
1\t4\t4\t1\t6\t231\t4\t2\t2\t3\t28 
...? 
please correct my code 
Thanks in advance 
Elham