I am using r to read and reformat data that is then saved to a text file using sink(), the file has a number of initial lines of comments and summary data followed by print of a data.frame with no row names.
for example

a<-c(100:120)
b<-c(rnorm(100:120))
c<-c(rnorm(200:220))
mydata<-data.frame(rbind(a,b,c))
sink("datafile.txt")

cat("comments about my data \n")
cat("other calculations returned as separate text comments on a line \n")
print(mydata,row.names=F)
sink()


I need the content of the text file to keep each row of the data frame on a single line thus (with intervening columns present of course)

"datafile.txt"

comments about my data
other calculations returned as separate text comments on a line
X1 X2 X3 X4 X5 X6 ..................................................................... X19 X20 X21


100.0000000 101.000000 102.0000000 103.0000000 104.0000000 105.0000000 ......................118.0000000 119.0000000 120.0000000 -0.3380570 -1.400905 1.0396499 -0.5802181 -0.2340614 0.6044928 ...................................-0.4854702 -0.3677461 -1.2033173 -0.9002824 1.544242 -0.8668653 0.3066256 0.2490254 -1.6429223 ..................................... 0.0861146 0.4276929 -0.3408604

How doI change setting for print() or use another function to keep each row of the data frame as a single line ( of greater length up to approx 300 characters) instead of wrapping the data frame into multiple lines of text?

The problem : I end up with the data frame split into several sections one under another thus

"datafile.txt"

comments about my data
other calculations returned as separate text comments on a line
          X1         X2          X3          X4          X5          X6
 100.0000000 101.000000 102.0000000 103.0000000 104.0000000 105.0000000
  -0.3380570  -1.400905   1.0396499  -0.5802181  -0.2340614   0.6044928
  -0.9002824   1.544242  -0.8668653   0.3066256   0.2490254  -1.6429223
          X7           X8          X9         X10         X11         X12
 106.0000000 107.00000000 108.0000000 109.0000000 110.0000000 111.0000000
   0.3152427   0.15093494  -0.3316172  -0.3603724  -2.0516402  -0.4556241
  -0.6502265  -0.08842649  -0.3775335  -0.4942572  -0.0976565  -0.7716651
         X13         X14         X15         X16          X17        X18
 112.0000000 113.0000000 114.0000000 115.0000000 116.00000000 117.000000
   0.8829135   0.8851043  -0.7687383  -0.9573476  -0.03041968   1.425754
   0.2666777   0.6405255   0.2342905  -0.7705545  -1.18028004   1.303601
         X19         X20         X21
 118.0000000 119.0000000 120.0000000
  -0.4854702  -0.3677461  -1.2033173
   0.0861146   0.4276929  -0.3408604

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to