gt

Tables with summary rows in gt

This post focuses on ways to customize summary rows in gt tables, to create the summary table shown here (based on the Tidy Tuesday Taylor Swift and Beyoncé data).

Summary tables using gt

In this post, I walk through the various steps involved in creating the summary table shown here (based on the Tidy Tuesday Taylor Swift data), showcasing various capabilities of the gt package.

More experimenting with SQL in R Markdown: Pivoting data, outputting results to R, and creating a summary table using gt

Following on from my previous post, I use SELECT and JOIN statements to pivot the Taylor Swift and Beyoncé Tidy Tuesday data using RSQLite (after normalizing the underlying database), output the results to R, and create a relatively simple summary table using gt.