www.eamoncaddigan.net

Content and configuration for https://www.eamoncaddigan.net
git clone https://git.eamoncaddigan.net/www.eamoncaddigan.net.git
Log | Files | Refs | Submodules | README

commit bb94e7334ef425a319be1e1c4e3fe6aeba505760
parent 1436af443e50eabaac95b1bf2b2c417b7ab3d1d3
Author: Eamon Caddigan <eamon.caddigan@gmail.com>
Date:   Tue, 23 Jan 2024 19:56:25 -0800

Update the list to include tinytable

And also talk about my recent work with huxtable (a little bit).

Diffstat:
Mcontent/posts/r-table-packages/index.md | 37++++++++++++++++++++-----------------
1 file changed, 20 insertions(+), 17 deletions(-)

diff --git a/content/posts/r-table-packages/index.md b/content/posts/r-table-packages/index.md @@ -1,6 +1,7 @@ --- title: "R packages for table layout" date: 2024-01-13T14:53:47-08:00 +lastmod: 2024-01-23T19:42:44-08:00 draft: false categories: - Data Science @@ -9,7 +10,7 @@ tags: --- The R package ecosystem has several packages[^list] that were created to -help with the design and layout of tables in documents. +help with the design and layout of tables in documents. <!--more--> @@ -31,39 +32,41 @@ help with the design and layout of tables in documents. - **pixiedust** ([Code forge](https://github.com/nutterb/pixiedust)) - **reactable** ([Code forge](https://github.com/glin/reactable), [Website](https://glin.github.io/reactable/)) - **stargazer** ([CRAN](https://CRAN.R-project.org/package=stargazer)) +- **tablaxlsx** ([CRAN](https://cran.r-project.org/web/packages/tablaxlsx/index.html)) - **tangram** ([Code forge](https://github.com/spgarbet/tangram)) +- **tinytable** ([Code forge](https://github.com/vincentarelbundock/tinytable/), [Website](https://vincentarelbundock.github.io/tinytable/)) - **xtable** ([CRAN](https://CRAN.R-project.org/package=xtable), [Website](http://xtable.r-forge.r-project.org/)) - **ztable** ([Code forge](https://github.com/cardiomoon/ztable)) -This was mostly cribbed from an earlier version of the gt package's website. -I found it to be a great resource and was disappointed when it was -removed[^removed], which is why I'm posting this here. +This list was mostly cribbed from an earlier version of the gt package’s +website. I found it to be a great resource and was disappointed when it was +removed[^removed], which is why I’ve posted it here. -Lately I've been programmatically formatting tables for Excel[^xl][^paper] -using [the openxlsx -package's](https://cran.r-project.org/web/packages/openxlsx/) interface -directly, but this is rather low-level. After digging around a bit, I plan -to look into -[tablaxlsx](https://cran.r-project.org/web/packages/tablaxlsx/index.html), -huxtable, and condformat to see how these might suit my needs. +Recently I had been programmatically formatting tables for +Excel[^xl][^paper] using [the openxlsx +package’s](https://cran.r-project.org/web/packages/openxlsx/) interface +directly, but this is rather low-level. After digging around a bit, I just +started using huxtable, and this week I developed a small R package that +extends it to simplify some repetitive tasks at my job. This may someday +mature enough for public release, but I can’t make any promises. [^list]: This is almost certainly incomplete, and I would be happy to add - anything that's either under active development or mature and stable. + anything that’s either under active development or mature and stable. [^removed]: Partially removed with [this commit](https://github.com/rstudio/gt/commit/c01aad5c5734e8a0767328471342a1170554d1ec), and mostly wiped away with [this one](https://github.com/rstudio/gt/commit/4ef570e855dcf81532a78a38869f676a7a82b008). - To be clear, this sentiment was strictly "I'm disappointed because I - found this useful and it's gone", and not, like, "I'm disappointed _in_ - Posit for removing it". + To be clear, this sentiment was strictly “I’m disappointed because + I found this useful and now it’s gone”, and not, like, “I’m disappointed + _in_ Posit for removing it”. [^xl]: My career has brought me into contact with a lot more people who want summary results delivered in a spreadsheet than collaborators who prefer - a nice reproducible report---as much as I'd rather focus on the latter. + a nice reproducible report---as much as I’d rather focus on the latter. Reproducible spreadsheets, that is, spreadsheets that are created by code, seem like the best compromise. [^paper]: See also: Karl W. Broman & Kara H. Woo (2018) Data Organization in Spreadsheets, The American Statistician, 72:1, 2-10, DOI: - 10.1080/00031305.2017.1375989 + [10.1080/00031305.2017.1375989](https://doi.org/10.1080/00031305.2017.1375989)