Does anyone know of a way to specify the alignment of individual columns in a data frame so that after using write.table the columns are aligned in the file? -- View this message in context: http://r.789695.n4.nabble.com/Align-columns-in-data-frame-write-table-tp4640007.html Sent from the R help mailing list archive at Nabble.com.
Align columns in data frame write.table
4 messages · sharx, Joshua Wiley, David Winsemius +1 more
I do not know of any option in write.table() that would allow a variable spacer, such as padding with spaces to make columns centered or right aligned. Everything is just separated somehow. You could look at ?format or ?sprintf which have padding/alignment options. Once you had properly padded character data, you could just use writeLines() to push it to a file. Cheers, Josh
On Fri, Aug 10, 2012 at 6:39 PM, sharx <sxu12 at mtlakes.org> wrote:
Does anyone know of a way to specify the alignment of individual columns in a data frame so that after using write.table the columns are aligned in the file? -- View this message in context: http://r.789695.n4.nabble.com/Align-columns-in-data-frame-write-table-tp4640007.html Sent from the R help mailing list archive at Nabble.com.
______________________________________________ R-help at 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.
Joshua Wiley Ph.D. Student, Health Psychology Programmer Analyst II, Statistical Consulting Group University of California, Los Angeles https://joshuawiley.com/
On Aug 10, 2012, at 6:39 PM, sharx wrote:
Does anyone know of a way to specify the alignment of individual columns in a data frame so that after using write.table the columns are aligned in the file?
Do you mean by padding with spaces? set numzer.pad to the desired
width and then perhaps using
lapply(dfrm, function(x) sprintf(paste('%0', numzer.pad, 'i', sep=''),
x)
You might need to check for the class of the columns because the
letter in the format string for sprintf is different fo numbers and
characters.
David Winsemius, MD Alameda, CA, USA
HI, Not sure how you want to align the columns. If you want to write the columns in fixed width format, you can use, write.fwf() from library(gdata). A.K. ----- Original Message ----- From: sharx <sxu12 at mtlakes.org> To: r-help at r-project.org Cc: Sent: Friday, August 10, 2012 9:39 PM Subject: [R] Align columns in data frame write.table Does anyone know of a way to specify the alignment of individual columns in a data frame so that after using write.table the columns are aligned in the file? -- View this message in context: http://r.789695.n4.nabble.com/Align-columns-in-data-frame-write-table-tp4640007.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help at 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.