dfe-analytical-services / analysts-guide

A static website to hold guidance, helpful links and code examples for analysts working in DfE.
https://dfe-analytical-services.github.io/analysts-guide/
MIT License
5 stars 3 forks source link

Add details and advice on what tables packages are best for different purposes #74

Open cjrace opened 3 months ago

cjrace commented 3 months ago

Is your feature request related to a problem? Please describe. A few of us have talked about this, as we've found through trial (and lots of error) that different packages in R work better for some purposes than others

Describe the solution you'd like Probably a new 'tables in R' section that then covers R Markdown into HTML, into Word docs / PDFs, embedding in quarto, and different shiny use cases too

Describe alternatives you've considered Could split up into separate sections, though not sure we have our own guides for markdown yet like we do shiny so probably better all as one on the R page

Additional context We might look at adding wrappers to some packages here in dfeshiny or even shinyGovstyle, so worth checking on the latest on those (currently I think reactable is looking the most promising for this in R Shiny).

There might be some things to steal from here - https://r-graph-gallery.com/table.html, they also have a diagram, which might be good for us to replicate that kind of visual with our own suggestions:

image

Though you should be warned, @jen-machin may not appreciate it if you copy the font too... image

jen-machin commented 3 months ago

Guidance from @rmbielby:

I also think we should include pros and cons for the interactive table packages specifically as they're all slightly different - there's a really nice blog post comparing the 3 packages here: https://clarewest.github.io/blog/post/making-tables-shiny/ (as an added bonus, it uses Animal Crossing villager data!) 😄