[R] How to output text to sink from data frame line by line without column names
Nevil Amos
nevil.amos at gmail.com
Sun Jun 13 08:41:13 CEST 2010
OK I see how to remove the line numbers[1] etc by using cat instead of
print, but cannot work out how to remove the column names from the data
frame output
On 13/06/2010 4:21 PM, Nevil Amos wrote:
> I want to output a text file assembeld from various soruces within r (
> actually as a genepop file)
>
> the output should be formatted line 1 "text comment"
> line 2:n selected
> column names from data frame
> line n+1on lines
> of selected columns from data frame one row at a time
>
>
> I have the following code, but cannot see how to remove the line
> numbers and omit column names form the line by line data frame output
>
> col1<-c(2,45,67)
> col2<-c("a","B","C")
> col3<-c(234,44,566)
> mydf<-as.data.frame(cbind(col1,col2,col3))
> n<-ncol(mydf)
> nr<-nrow(mydf)
> sink("test.txt")
>
> print("I will be including text of various sorts in this file so
> cannot use print table or similar command")
> for (i in 1:n){
> print(colnames(mydf[i]),quote=F) }
> for (j in 1:nr){
> print(mydf[j,c(2:n)],quote=F,row.names=F)}
> sink()
>
> The test.txt contains:
>
> [1] "I will be including text of various sorts in this file so cannot
> use print table or similar command"
> [1] col1
> [1] col2
> [1] col3
> col2 col3
> a 234
> col2 col3
> B 44
> col2 col3
> C 566
>
> what I would like in test.txt is:
>
> "I will be including text of various sorts in this file so cannot use
> print table or similar command"
> col1
> col2
> col3
> a 234
> B 44
> C 566
>
> Many thanks
>
> Nevil Amos
More information about the R-help
mailing list