Introduction to `gt` Tables - 02

Making Beautiful Tables in R.

tables

tidyverse

Author

Horacio Lopez-Nicora

Published

April 15, 2025

1 Introduction

Overview

Welcome back to the second week of our gt table tutorial! Today, we’ll dive deeper into the advanced features of the gt package. We’ll start by exploring conditional formatting to highlight specific values in your tables, making important data points stand out. Next, we’ll learn how to group rows and columns to create more organized and intuitive tables. Finally, we’ll cover how to customize column labels to enhance the readability and user-friendliness of your tables. By the end of this session, you’ll have a solid understanding of these advanced techniques, enabling you to create sophisticated and professional tables for your data presentations. Let’s get started!

Recall the `gt` Tables Workflow

Please let’s go ahead and install the gt package first:

install.packages("gt")

2 Our data set

We will use the `palmerpenguins` data set

We are going to continue using our 🐧 data set from the package palmerpenguins. If you haven’t done so, please install that package first:

install.packages("palmerpenguins")

palmerpenguins is a package developed by Allison Horst, Alison Hill and Kristen Gorman, including a data set collected by Dr. Kristen Gorman at the Palmer Station Antarctica, as part of the Long Term Ecological Research Network. It is a nice, relatively simple data set to practice data exploration and visualization in R.

We’ll now load the package, along with the gt and tidyverse:

library(palmerpenguins)
library(tidyverse)

── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ readr     2.1.5
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.5.1     ✔ tibble    3.2.1
✔ lubridate 1.9.3     ✔ tidyr     1.3.1
✔ purrr     1.0.2     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

library(gt)

Warning: package 'gt' was built under R version 4.4.1

Once you’ve loaded that package you will have a data frame called penguins at your disposal — let’s take a look:

penguins

# A tibble: 344 × 8
   species island    bill_length_mm bill_depth_mm flipper_length_mm body_mass_g
   <fct>   <fct>              <dbl>         <dbl>             <int>       <int>
 1 Adelie  Torgersen           39.1          18.7               181        3750
 2 Adelie  Torgersen           39.5          17.4               186        3800
 3 Adelie  Torgersen           40.3          18                 195        3250
 4 Adelie  Torgersen           NA            NA                  NA          NA
 5 Adelie  Torgersen           36.7          19.3               193        3450
 6 Adelie  Torgersen           39.3          20.6               190        3650
 7 Adelie  Torgersen           38.9          17.8               181        3625
 8 Adelie  Torgersen           39.2          19.6               195        4675
 9 Adelie  Torgersen           34.1          18.1               193        3475
10 Adelie  Torgersen           42            20.2               190        4250
# ℹ 334 more rows
# ℹ 2 more variables: sex <fct>, year <int>

# Or glimpse() for a sort of transposed view, so we can see all columns:
glimpse(penguins)

Rows: 344
Columns: 8
$ species           <fct> Adelie, Adelie, Adelie, Adelie, Adelie, Adelie, Adel…
$ island            <fct> Torgersen, Torgersen, Torgersen, Torgersen, Torgerse…
$ bill_length_mm    <dbl> 39.1, 39.5, 40.3, NA, 36.7, 39.3, 38.9, 39.2, 34.1, …
$ bill_depth_mm     <dbl> 18.7, 17.4, 18.0, NA, 19.3, 20.6, 17.8, 19.6, 18.1, …
$ flipper_length_mm <int> 181, 186, 195, NA, 193, 190, 181, 195, 193, 190, 186…
$ body_mass_g       <int> 3750, 3800, 3250, NA, 3450, 3650, 3625, 4675, 3475, …
$ sex               <fct> male, female, female, NA, female, male, female, male…
$ year              <int> 2007, 2007, 2007, 2007, 2007, 2007, 2007, 2007, 2007…

3 Create table and label column names

For this session, we’ll be working with the Palmer Penguins data set. After loading the data set, you can create a basic table by passing the data frame to the gt() function. This function generates a table object that you can print and view.

Let’s apply what we learned last week and relabel the columns of the Palmer Penguins data set.

Exercise 1

Create a simple table using gt and the Palmer Penguins data set and relabel the columns. Please make the column names in bold.

Hint (click here)

For the label argument, you can either provide a character vector directly or wrap it in md() to enable Markdown syntax (such as bold text). Save and call this table: penguins_relabeled

Solutions (click here)

penguins_relabeled <-  penguins %>%  
  gt() %>% 
  cols_label(
    species = md('**Species**'),
    island = md('**Island**'),
    bill_length_mm = md('**Bill Length (mm)**'),
    bill_depth_mm = md('**Bill Depth (mm)**'),
    flipper_length_mm = md('**Flipper Length (mm)**'),
    body_mass_g = md('**Body Mass (g)**'),
    sex = md('**Sex**'),
    year = md('**Year**'),
  )

penguins_relabeled

Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009

4 Highlight Based on Multiple Conditions

Last week, we introduced conditional highlighting in gt. Today, we’ll further explore how to highlight cells based on multiple conditions.

# Apply conditional formatting to highlight bill lengths above 45 mm and body mass above 4000 grams
penguins_relabeled %>%
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(
      columns = c(bill_length_mm),
      rows = bill_length_mm > 45
    )
  ) %>%
  tab_style(
    style = cell_fill(color = "lightyellow"),
    locations = cells_body(
      columns = c(body_mass_g),
      rows = body_mass_g > 4000
    )
  )

Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009

The simplicity of this process allows you to quickly identify patterns in the raw data that may be worth further investigation.

Exercise 2

Highlight rows for Adelie Penguins and Biscoe Island.
What can you learn from this highlighted table?

Solutions (click here)

penguins_relabeled %>%
  tab_style(
    style = list(cell_fill(color = "lightcoral")),
    locations = cells_body(
      rows = species == "Adelie" & island == "Biscoe"
    )
  ) %>% 
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(
      columns = c(bill_length_mm),
      rows = bill_length_mm > 45
    )
  ) %>%
  tab_style(
    style = cell_fill(color = "lightyellow"),
    locations = cells_body(
      columns = c(body_mass_g),
      rows = body_mass_g > 4000
    )
  )

Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009

5 Group by Rows and Columns

Once you have created your table, gt offers several basic formatting options to enhance its appearance and readability. Let’s recall the anatomy of a gt table.

Last week we learned that you can add titles and subtitles to provide context and make the table more informative. The tab_header() function allows you to specify these elements. Additionally, you can format the columns to display numbers, dates, or currencies appropriately using functions like fmt_number(), fmt_date(), and fmt_currency(). These formatting options help ensure that the data is presented clearly and professionally. By applying these basic formatting techniques, you can significantly improve the visual appeal and utility of your tables.

Now let’s group rows and column by a specific classification, using the tab_row_group and tab_spanner functions to group the data by these categories.

Grouping Rows by Species

In this example, the tab_row_group function is used to group rows by the species column. Each species is given a label, making it easier to distinguish between the different groups of penguins.

# Group rows by species and island
penguins_relabeled %>%
  tab_row_group(
    label = md("***Adelie Penguins***"),
    rows = species == "Adelie"
  ) %>%
  tab_row_group(
    label = md("***Chinstrap Penguins***"),
    rows = species == "Chinstrap"
  ) %>%
  tab_row_group(
    label = md("***Gentoo Penguins***"),
    rows = species == "Gentoo"
  )

Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Gentoo Penguins
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap Penguins
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009
Adelie Penguins
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009

Grouping Columns by Measurements

In this example, the tab_spanner function is used to group columns related to measurements under a common label “Measurements”. This helps to categorize the columns and make the table more organized.

# Group columns by measurements
penguins_relabeled %>%
  tab_spanner(
    label = md("**Measurements**"),
    columns = c(bill_length_mm, bill_depth_mm, flipper_length_mm, body_mass_g)
  )

Species	Island	Measurements				Sex	Year
Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009

In the following exercise, both tab_row_group and tab_spanner functions can be used to group rows by island and columns by measurements. This will create a well-organized table that is easy to read and interpret.

Exercise 3

Grouping Rows by Island and Columns by Measurements

Solutions (click here)

# Group rows by species and columns by measurements
penguins_relabeled %>% 
  tab_row_group(
    label = md("***Adelie Penguins***"),
    rows = species == "Adelie"
  ) %>%
  tab_row_group(
    label = md("***Chinstrap Penguins***"),
    rows = species == "Chinstrap"
  ) %>%
  tab_row_group(
    label = md("***Gentoo Penguins***"),
    rows = species == "Gentoo"
  ) %>%
  tab_spanner(
    label = md("**Measurements**"),
    columns = c(bill_length_mm, bill_depth_mm, flipper_length_mm, body_mass_g)
  )

Species	Island	Measurements				Sex	Year
Species	Island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	Sex	Year
Gentoo Penguins
Gentoo	Biscoe	46.1	13.2	211	4500	female	2007
Gentoo	Biscoe	50.0	16.3	230	5700	male	2007
Gentoo	Biscoe	48.7	14.1	210	4450	female	2007
Gentoo	Biscoe	50.0	15.2	218	5700	male	2007
Gentoo	Biscoe	47.6	14.5	215	5400	male	2007
Gentoo	Biscoe	46.5	13.5	210	4550	female	2007
Gentoo	Biscoe	45.4	14.6	211	4800	female	2007
Gentoo	Biscoe	46.7	15.3	219	5200	male	2007
Gentoo	Biscoe	43.3	13.4	209	4400	female	2007
Gentoo	Biscoe	46.8	15.4	215	5150	male	2007
Gentoo	Biscoe	40.9	13.7	214	4650	female	2007
Gentoo	Biscoe	49.0	16.1	216	5550	male	2007
Gentoo	Biscoe	45.5	13.7	214	4650	female	2007
Gentoo	Biscoe	48.4	14.6	213	5850	male	2007
Gentoo	Biscoe	45.8	14.6	210	4200	female	2007
Gentoo	Biscoe	49.3	15.7	217	5850	male	2007
Gentoo	Biscoe	42.0	13.5	210	4150	female	2007
Gentoo	Biscoe	49.2	15.2	221	6300	male	2007
Gentoo	Biscoe	46.2	14.5	209	4800	female	2007
Gentoo	Biscoe	48.7	15.1	222	5350	male	2007
Gentoo	Biscoe	50.2	14.3	218	5700	male	2007
Gentoo	Biscoe	45.1	14.5	215	5000	female	2007
Gentoo	Biscoe	46.5	14.5	213	4400	female	2007
Gentoo	Biscoe	46.3	15.8	215	5050	male	2007
Gentoo	Biscoe	42.9	13.1	215	5000	female	2007
Gentoo	Biscoe	46.1	15.1	215	5100	male	2007
Gentoo	Biscoe	44.5	14.3	216	4100	NA	2007
Gentoo	Biscoe	47.8	15.0	215	5650	male	2007
Gentoo	Biscoe	48.2	14.3	210	4600	female	2007
Gentoo	Biscoe	50.0	15.3	220	5550	male	2007
Gentoo	Biscoe	47.3	15.3	222	5250	male	2007
Gentoo	Biscoe	42.8	14.2	209	4700	female	2007
Gentoo	Biscoe	45.1	14.5	207	5050	female	2007
Gentoo	Biscoe	59.6	17.0	230	6050	male	2007
Gentoo	Biscoe	49.1	14.8	220	5150	female	2008
Gentoo	Biscoe	48.4	16.3	220	5400	male	2008
Gentoo	Biscoe	42.6	13.7	213	4950	female	2008
Gentoo	Biscoe	44.4	17.3	219	5250	male	2008
Gentoo	Biscoe	44.0	13.6	208	4350	female	2008
Gentoo	Biscoe	48.7	15.7	208	5350	male	2008
Gentoo	Biscoe	42.7	13.7	208	3950	female	2008
Gentoo	Biscoe	49.6	16.0	225	5700	male	2008
Gentoo	Biscoe	45.3	13.7	210	4300	female	2008
Gentoo	Biscoe	49.6	15.0	216	4750	male	2008
Gentoo	Biscoe	50.5	15.9	222	5550	male	2008
Gentoo	Biscoe	43.6	13.9	217	4900	female	2008
Gentoo	Biscoe	45.5	13.9	210	4200	female	2008
Gentoo	Biscoe	50.5	15.9	225	5400	male	2008
Gentoo	Biscoe	44.9	13.3	213	5100	female	2008
Gentoo	Biscoe	45.2	15.8	215	5300	male	2008
Gentoo	Biscoe	46.6	14.2	210	4850	female	2008
Gentoo	Biscoe	48.5	14.1	220	5300	male	2008
Gentoo	Biscoe	45.1	14.4	210	4400	female	2008
Gentoo	Biscoe	50.1	15.0	225	5000	male	2008
Gentoo	Biscoe	46.5	14.4	217	4900	female	2008
Gentoo	Biscoe	45.0	15.4	220	5050	male	2008
Gentoo	Biscoe	43.8	13.9	208	4300	female	2008
Gentoo	Biscoe	45.5	15.0	220	5000	male	2008
Gentoo	Biscoe	43.2	14.5	208	4450	female	2008
Gentoo	Biscoe	50.4	15.3	224	5550	male	2008
Gentoo	Biscoe	45.3	13.8	208	4200	female	2008
Gentoo	Biscoe	46.2	14.9	221	5300	male	2008
Gentoo	Biscoe	45.7	13.9	214	4400	female	2008
Gentoo	Biscoe	54.3	15.7	231	5650	male	2008
Gentoo	Biscoe	45.8	14.2	219	4700	female	2008
Gentoo	Biscoe	49.8	16.8	230	5700	male	2008
Gentoo	Biscoe	46.2	14.4	214	4650	NA	2008
Gentoo	Biscoe	49.5	16.2	229	5800	male	2008
Gentoo	Biscoe	43.5	14.2	220	4700	female	2008
Gentoo	Biscoe	50.7	15.0	223	5550	male	2008
Gentoo	Biscoe	47.7	15.0	216	4750	female	2008
Gentoo	Biscoe	46.4	15.6	221	5000	male	2008
Gentoo	Biscoe	48.2	15.6	221	5100	male	2008
Gentoo	Biscoe	46.5	14.8	217	5200	female	2008
Gentoo	Biscoe	46.4	15.0	216	4700	female	2008
Gentoo	Biscoe	48.6	16.0	230	5800	male	2008
Gentoo	Biscoe	47.5	14.2	209	4600	female	2008
Gentoo	Biscoe	51.1	16.3	220	6000	male	2008
Gentoo	Biscoe	45.2	13.8	215	4750	female	2008
Gentoo	Biscoe	45.2	16.4	223	5950	male	2008
Gentoo	Biscoe	49.1	14.5	212	4625	female	2009
Gentoo	Biscoe	52.5	15.6	221	5450	male	2009
Gentoo	Biscoe	47.4	14.6	212	4725	female	2009
Gentoo	Biscoe	50.0	15.9	224	5350	male	2009
Gentoo	Biscoe	44.9	13.8	212	4750	female	2009
Gentoo	Biscoe	50.8	17.3	228	5600	male	2009
Gentoo	Biscoe	43.4	14.4	218	4600	female	2009
Gentoo	Biscoe	51.3	14.2	218	5300	male	2009
Gentoo	Biscoe	47.5	14.0	212	4875	female	2009
Gentoo	Biscoe	52.1	17.0	230	5550	male	2009
Gentoo	Biscoe	47.5	15.0	218	4950	female	2009
Gentoo	Biscoe	52.2	17.1	228	5400	male	2009
Gentoo	Biscoe	45.5	14.5	212	4750	female	2009
Gentoo	Biscoe	49.5	16.1	224	5650	male	2009
Gentoo	Biscoe	44.5	14.7	214	4850	female	2009
Gentoo	Biscoe	50.8	15.7	226	5200	male	2009
Gentoo	Biscoe	49.4	15.8	216	4925	male	2009
Gentoo	Biscoe	46.9	14.6	222	4875	female	2009
Gentoo	Biscoe	48.4	14.4	203	4625	female	2009
Gentoo	Biscoe	51.1	16.5	225	5250	male	2009
Gentoo	Biscoe	48.5	15.0	219	4850	female	2009
Gentoo	Biscoe	55.9	17.0	228	5600	male	2009
Gentoo	Biscoe	47.2	15.5	215	4975	female	2009
Gentoo	Biscoe	49.1	15.0	228	5500	male	2009
Gentoo	Biscoe	47.3	13.8	216	4725	NA	2009
Gentoo	Biscoe	46.8	16.1	215	5500	male	2009
Gentoo	Biscoe	41.7	14.7	210	4700	female	2009
Gentoo	Biscoe	53.4	15.8	219	5500	male	2009
Gentoo	Biscoe	43.3	14.0	208	4575	female	2009
Gentoo	Biscoe	48.1	15.1	209	5500	male	2009
Gentoo	Biscoe	50.5	15.2	216	5000	female	2009
Gentoo	Biscoe	49.8	15.9	229	5950	male	2009
Gentoo	Biscoe	43.5	15.2	213	4650	female	2009
Gentoo	Biscoe	51.5	16.3	230	5500	male	2009
Gentoo	Biscoe	46.2	14.1	217	4375	female	2009
Gentoo	Biscoe	55.1	16.0	230	5850	male	2009
Gentoo	Biscoe	44.5	15.7	217	4875	NA	2009
Gentoo	Biscoe	48.8	16.2	222	6000	male	2009
Gentoo	Biscoe	47.2	13.7	214	4925	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.8	14.3	215	4850	female	2009
Gentoo	Biscoe	50.4	15.7	222	5750	male	2009
Gentoo	Biscoe	45.2	14.8	212	5200	female	2009
Gentoo	Biscoe	49.9	16.1	213	5400	male	2009
Chinstrap Penguins
Chinstrap	Dream	46.5	17.9	192	3500	female	2007
Chinstrap	Dream	50.0	19.5	196	3900	male	2007
Chinstrap	Dream	51.3	19.2	193	3650	male	2007
Chinstrap	Dream	45.4	18.7	188	3525	female	2007
Chinstrap	Dream	52.7	19.8	197	3725	male	2007
Chinstrap	Dream	45.2	17.8	198	3950	female	2007
Chinstrap	Dream	46.1	18.2	178	3250	female	2007
Chinstrap	Dream	51.3	18.2	197	3750	male	2007
Chinstrap	Dream	46.0	18.9	195	4150	female	2007
Chinstrap	Dream	51.3	19.9	198	3700	male	2007
Chinstrap	Dream	46.6	17.8	193	3800	female	2007
Chinstrap	Dream	51.7	20.3	194	3775	male	2007
Chinstrap	Dream	47.0	17.3	185	3700	female	2007
Chinstrap	Dream	52.0	18.1	201	4050	male	2007
Chinstrap	Dream	45.9	17.1	190	3575	female	2007
Chinstrap	Dream	50.5	19.6	201	4050	male	2007
Chinstrap	Dream	50.3	20.0	197	3300	male	2007
Chinstrap	Dream	58.0	17.8	181	3700	female	2007
Chinstrap	Dream	46.4	18.6	190	3450	female	2007
Chinstrap	Dream	49.2	18.2	195	4400	male	2007
Chinstrap	Dream	42.4	17.3	181	3600	female	2007
Chinstrap	Dream	48.5	17.5	191	3400	male	2007
Chinstrap	Dream	43.2	16.6	187	2900	female	2007
Chinstrap	Dream	50.6	19.4	193	3800	male	2007
Chinstrap	Dream	46.7	17.9	195	3300	female	2007
Chinstrap	Dream	52.0	19.0	197	4150	male	2007
Chinstrap	Dream	50.5	18.4	200	3400	female	2008
Chinstrap	Dream	49.5	19.0	200	3800	male	2008
Chinstrap	Dream	46.4	17.8	191	3700	female	2008
Chinstrap	Dream	52.8	20.0	205	4550	male	2008
Chinstrap	Dream	40.9	16.6	187	3200	female	2008
Chinstrap	Dream	54.2	20.8	201	4300	male	2008
Chinstrap	Dream	42.5	16.7	187	3350	female	2008
Chinstrap	Dream	51.0	18.8	203	4100	male	2008
Chinstrap	Dream	49.7	18.6	195	3600	male	2008
Chinstrap	Dream	47.5	16.8	199	3900	female	2008
Chinstrap	Dream	47.6	18.3	195	3850	female	2008
Chinstrap	Dream	52.0	20.7	210	4800	male	2008
Chinstrap	Dream	46.9	16.6	192	2700	female	2008
Chinstrap	Dream	53.5	19.9	205	4500	male	2008
Chinstrap	Dream	49.0	19.5	210	3950	male	2008
Chinstrap	Dream	46.2	17.5	187	3650	female	2008
Chinstrap	Dream	50.9	19.1	196	3550	male	2008
Chinstrap	Dream	45.5	17.0	196	3500	female	2008
Chinstrap	Dream	50.9	17.9	196	3675	female	2009
Chinstrap	Dream	50.8	18.5	201	4450	male	2009
Chinstrap	Dream	50.1	17.9	190	3400	female	2009
Chinstrap	Dream	49.0	19.6	212	4300	male	2009
Chinstrap	Dream	51.5	18.7	187	3250	male	2009
Chinstrap	Dream	49.8	17.3	198	3675	female	2009
Chinstrap	Dream	48.1	16.4	199	3325	female	2009
Chinstrap	Dream	51.4	19.0	201	3950	male	2009
Chinstrap	Dream	45.7	17.3	193	3600	female	2009
Chinstrap	Dream	50.7	19.7	203	4050	male	2009
Chinstrap	Dream	42.5	17.3	187	3350	female	2009
Chinstrap	Dream	52.2	18.8	197	3450	male	2009
Chinstrap	Dream	45.2	16.6	191	3250	female	2009
Chinstrap	Dream	49.3	19.9	203	4050	male	2009
Chinstrap	Dream	50.2	18.8	202	3800	male	2009
Chinstrap	Dream	45.6	19.4	194	3525	female	2009
Chinstrap	Dream	51.9	19.5	206	3950	male	2009
Chinstrap	Dream	46.8	16.5	189	3650	female	2009
Chinstrap	Dream	45.7	17.0	195	3650	female	2009
Chinstrap	Dream	55.8	19.8	207	4000	male	2009
Chinstrap	Dream	43.5	18.1	202	3400	female	2009
Chinstrap	Dream	49.6	18.2	193	3775	male	2009
Chinstrap	Dream	50.8	19.0	210	4100	male	2009
Chinstrap	Dream	50.2	18.7	198	3775	female	2009
Adelie Penguins
Adelie	Torgersen	39.1	18.7	181	3750	male	2007
Adelie	Torgersen	39.5	17.4	186	3800	female	2007
Adelie	Torgersen	40.3	18.0	195	3250	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.7	19.3	193	3450	female	2007
Adelie	Torgersen	39.3	20.6	190	3650	male	2007
Adelie	Torgersen	38.9	17.8	181	3625	female	2007
Adelie	Torgersen	39.2	19.6	195	4675	male	2007
Adelie	Torgersen	34.1	18.1	193	3475	NA	2007
Adelie	Torgersen	42.0	20.2	190	4250	NA	2007
Adelie	Torgersen	37.8	17.1	186	3300	NA	2007
Adelie	Torgersen	37.8	17.3	180	3700	NA	2007
Adelie	Torgersen	41.1	17.6	182	3200	female	2007
Adelie	Torgersen	38.6	21.2	191	3800	male	2007
Adelie	Torgersen	34.6	21.1	198	4400	male	2007
Adelie	Torgersen	36.6	17.8	185	3700	female	2007
Adelie	Torgersen	38.7	19.0	195	3450	female	2007
Adelie	Torgersen	42.5	20.7	197	4500	male	2007
Adelie	Torgersen	34.4	18.4	184	3325	female	2007
Adelie	Torgersen	46.0	21.5	194	4200	male	2007
Adelie	Biscoe	37.8	18.3	174	3400	female	2007
Adelie	Biscoe	37.7	18.7	180	3600	male	2007
Adelie	Biscoe	35.9	19.2	189	3800	female	2007
Adelie	Biscoe	38.2	18.1	185	3950	male	2007
Adelie	Biscoe	38.8	17.2	180	3800	male	2007
Adelie	Biscoe	35.3	18.9	187	3800	female	2007
Adelie	Biscoe	40.6	18.6	183	3550	male	2007
Adelie	Biscoe	40.5	17.9	187	3200	female	2007
Adelie	Biscoe	37.9	18.6	172	3150	female	2007
Adelie	Biscoe	40.5	18.9	180	3950	male	2007
Adelie	Dream	39.5	16.7	178	3250	female	2007
Adelie	Dream	37.2	18.1	178	3900	male	2007
Adelie	Dream	39.5	17.8	188	3300	female	2007
Adelie	Dream	40.9	18.9	184	3900	male	2007
Adelie	Dream	36.4	17.0	195	3325	female	2007
Adelie	Dream	39.2	21.1	196	4150	male	2007
Adelie	Dream	38.8	20.0	190	3950	male	2007
Adelie	Dream	42.2	18.5	180	3550	female	2007
Adelie	Dream	37.6	19.3	181	3300	female	2007
Adelie	Dream	39.8	19.1	184	4650	male	2007
Adelie	Dream	36.5	18.0	182	3150	female	2007
Adelie	Dream	40.8	18.4	195	3900	male	2007
Adelie	Dream	36.0	18.5	186	3100	female	2007
Adelie	Dream	44.1	19.7	196	4400	male	2007
Adelie	Dream	37.0	16.9	185	3000	female	2007
Adelie	Dream	39.6	18.8	190	4600	male	2007
Adelie	Dream	41.1	19.0	182	3425	male	2007
Adelie	Dream	37.5	18.9	179	2975	NA	2007
Adelie	Dream	36.0	17.9	190	3450	female	2007
Adelie	Dream	42.3	21.2	191	4150	male	2007
Adelie	Biscoe	39.6	17.7	186	3500	female	2008
Adelie	Biscoe	40.1	18.9	188	4300	male	2008
Adelie	Biscoe	35.0	17.9	190	3450	female	2008
Adelie	Biscoe	42.0	19.5	200	4050	male	2008
Adelie	Biscoe	34.5	18.1	187	2900	female	2008
Adelie	Biscoe	41.4	18.6	191	3700	male	2008
Adelie	Biscoe	39.0	17.5	186	3550	female	2008
Adelie	Biscoe	40.6	18.8	193	3800	male	2008
Adelie	Biscoe	36.5	16.6	181	2850	female	2008
Adelie	Biscoe	37.6	19.1	194	3750	male	2008
Adelie	Biscoe	35.7	16.9	185	3150	female	2008
Adelie	Biscoe	41.3	21.1	195	4400	male	2008
Adelie	Biscoe	37.6	17.0	185	3600	female	2008
Adelie	Biscoe	41.1	18.2	192	4050	male	2008
Adelie	Biscoe	36.4	17.1	184	2850	female	2008
Adelie	Biscoe	41.6	18.0	192	3950	male	2008
Adelie	Biscoe	35.5	16.2	195	3350	female	2008
Adelie	Biscoe	41.1	19.1	188	4100	male	2008
Adelie	Torgersen	35.9	16.6	190	3050	female	2008
Adelie	Torgersen	41.8	19.4	198	4450	male	2008
Adelie	Torgersen	33.5	19.0	190	3600	female	2008
Adelie	Torgersen	39.7	18.4	190	3900	male	2008
Adelie	Torgersen	39.6	17.2	196	3550	female	2008
Adelie	Torgersen	45.8	18.9	197	4150	male	2008
Adelie	Torgersen	35.5	17.5	190	3700	female	2008
Adelie	Torgersen	42.8	18.5	195	4250	male	2008
Adelie	Torgersen	40.9	16.8	191	3700	female	2008
Adelie	Torgersen	37.2	19.4	184	3900	male	2008
Adelie	Torgersen	36.2	16.1	187	3550	female	2008
Adelie	Torgersen	42.1	19.1	195	4000	male	2008
Adelie	Torgersen	34.6	17.2	189	3200	female	2008
Adelie	Torgersen	42.9	17.6	196	4700	male	2008
Adelie	Torgersen	36.7	18.8	187	3800	female	2008
Adelie	Torgersen	35.1	19.4	193	4200	male	2008
Adelie	Dream	37.3	17.8	191	3350	female	2008
Adelie	Dream	41.3	20.3	194	3550	male	2008
Adelie	Dream	36.3	19.5	190	3800	male	2008
Adelie	Dream	36.9	18.6	189	3500	female	2008
Adelie	Dream	38.3	19.2	189	3950	male	2008
Adelie	Dream	38.9	18.8	190	3600	female	2008
Adelie	Dream	35.7	18.0	202	3550	female	2008
Adelie	Dream	41.1	18.1	205	4300	male	2008
Adelie	Dream	34.0	17.1	185	3400	female	2008
Adelie	Dream	39.6	18.1	186	4450	male	2008
Adelie	Dream	36.2	17.3	187	3300	female	2008
Adelie	Dream	40.8	18.9	208	4300	male	2008
Adelie	Dream	38.1	18.6	190	3700	female	2008
Adelie	Dream	40.3	18.5	196	4350	male	2008
Adelie	Dream	33.1	16.1	178	2900	female	2008
Adelie	Dream	43.2	18.5	192	4100	male	2008
Adelie	Biscoe	35.0	17.9	192	3725	female	2009
Adelie	Biscoe	41.0	20.0	203	4725	male	2009
Adelie	Biscoe	37.7	16.0	183	3075	female	2009
Adelie	Biscoe	37.8	20.0	190	4250	male	2009
Adelie	Biscoe	37.9	18.6	193	2925	female	2009
Adelie	Biscoe	39.7	18.9	184	3550	male	2009
Adelie	Biscoe	38.6	17.2	199	3750	female	2009
Adelie	Biscoe	38.2	20.0	190	3900	male	2009
Adelie	Biscoe	38.1	17.0	181	3175	female	2009
Adelie	Biscoe	43.2	19.0	197	4775	male	2009
Adelie	Biscoe	38.1	16.5	198	3825	female	2009
Adelie	Biscoe	45.6	20.3	191	4600	male	2009
Adelie	Biscoe	39.7	17.7	193	3200	female	2009
Adelie	Biscoe	42.2	19.5	197	4275	male	2009
Adelie	Biscoe	39.6	20.7	191	3900	female	2009
Adelie	Biscoe	42.7	18.3	196	4075	male	2009
Adelie	Torgersen	38.6	17.0	188	2900	female	2009
Adelie	Torgersen	37.3	20.5	199	3775	male	2009
Adelie	Torgersen	35.7	17.0	189	3350	female	2009
Adelie	Torgersen	41.1	18.6	189	3325	male	2009
Adelie	Torgersen	36.2	17.2	187	3150	female	2009
Adelie	Torgersen	37.7	19.8	198	3500	male	2009
Adelie	Torgersen	40.2	17.0	176	3450	female	2009
Adelie	Torgersen	41.4	18.5	202	3875	male	2009
Adelie	Torgersen	35.2	15.9	186	3050	female	2009
Adelie	Torgersen	40.6	19.0	199	4000	male	2009
Adelie	Torgersen	38.8	17.6	191	3275	female	2009
Adelie	Torgersen	41.5	18.3	195	4300	male	2009
Adelie	Torgersen	39.0	17.1	191	3050	female	2009
Adelie	Torgersen	44.1	18.0	210	4000	male	2009
Adelie	Torgersen	38.5	17.9	190	3325	female	2009
Adelie	Torgersen	43.1	19.2	197	3500	male	2009
Adelie	Dream	36.8	18.5	193	3500	female	2009
Adelie	Dream	37.5	18.5	199	4475	male	2009
Adelie	Dream	38.1	17.6	187	3425	female	2009
Adelie	Dream	41.1	17.5	190	3900	male	2009
Adelie	Dream	35.6	17.5	191	3175	female	2009
Adelie	Dream	40.2	20.1	200	3975	male	2009
Adelie	Dream	37.0	16.5	185	3400	female	2009
Adelie	Dream	39.7	17.9	193	4250	male	2009
Adelie	Dream	40.2	17.1	193	3400	female	2009
Adelie	Dream	40.6	17.2	187	3475	male	2009
Adelie	Dream	32.1	15.5	188	3050	female	2009
Adelie	Dream	40.7	17.0	190	3725	male	2009
Adelie	Dream	37.3	16.8	192	3000	female	2009
Adelie	Dream	39.0	18.7	185	3650	male	2009
Adelie	Dream	39.2	18.6	190	4250	male	2009
Adelie	Dream	36.6	18.4	184	3475	female	2009
Adelie	Dream	36.0	17.8	195	3450	female	2009
Adelie	Dream	37.8	18.1	193	3750	male	2009
Adelie	Dream	36.0	17.1	187	3700	female	2009
Adelie	Dream	41.5	18.5	201	4000	male	2009

6 Combining data wrangling with the `gt` package

Let’s combine skills we learned in previous sessions with gt.

Long to wide format

First, let’s use pivot_wider to format our original data set.

penguins <- palmerpenguins::penguins %>%  
  filter(!is.na(sex))

penguin_counts <- penguins %>%  
  mutate(year = as.character(year)) %>%  
  group_by(species, island, sex, year) %>%  
  summarise(n = n(), .groups = 'drop')

penguin_counts_wider <- penguin_counts %>%  
  pivot_wider(
    names_from = c(species, sex),
    values_from = n
  ) %>%  
  # Make missing numbers (NAs) into zero
  mutate(across(.cols = -(1:2), .fns = ~replace_na(., replace = 0))) %>%  
  arrange(island, year)

Now let’s format this table and make it look nice.

Exercise 4

Add labels such as a title, a subtitle and group the columns.

Solutions (click here)

penguin_counts_wider %>%  
  gt() %>%  
  cols_label(
    island = 'Island',
    year = 'Year',
    Adelie_female = 'Adelie (female)',
    Adelie_male = 'Adelie (male)',
    Chinstrap_female = 'Chinstrap (female)',
    Chinstrap_male = 'Chinstrap (male)',
    Gentoo_female = 'Gentoo (female)',
    Gentoo_male = 'Gentoo (male)',
  ) %>%  
  tab_spanner(
    label = md('**Adelie**'),
    columns = 3:4
  ) %>%  
  tab_spanner(
    label = md('**Chinstrap**'),
    columns = c('Chinstrap_female', 'Chinstrap_male')
  ) %>%  
  tab_spanner(
    label =  md('**Gentoo**'),
    columns = contains('Gentoo')
  ) %>%  
  tab_header(
    title = 'Penguins in the Palmer Archipelago',
    subtitle = 'Data is courtesy of the {palmerpenguins} R package'
  )

Island	Year	Adelie		Chinstrap		Gentoo
Penguins in the Palmer Archipelago
Data is courtesy of the {palmerpenguins} R package
Island	Year	Adelie (female)	Adelie (male)	Chinstrap (female)	Chinstrap (male)	Gentoo (female)	Gentoo (male)
Biscoe	2007	5	5	0	0	16	17
Biscoe	2008	9	9	0	0	22	23
Biscoe	2009	8	8	0	0	20	21
Dream	2007	9	10	13	13	0	0
Dream	2008	8	8	9	9	0	0
Dream	2009	10	10	12	12	0	0
Torgersen	2007	8	7	0	0	0	0
Torgersen	2008	8	8	0	0	0	0
Torgersen	2009	8	8	0	0	0	0

1 Introduction

Overview

Recall the gt Tables Workflow

2 Our data set

We will use the palmerpenguins data set

3 Create table and label column names

Exercise 1

4 Highlight Based on Multiple Conditions

Exercise 2

5 Group by Rows and Columns

Grouping Rows by Species

Grouping Columns by Measurements

Exercise 3

6 Combining data wrangling with the gt package

Long to wide format

Exercise 4

Recall the `gt` Tables Workflow

We will use the `palmerpenguins` data set

6 Combining data wrangling with the `gt` package