Introduction to `gt` Tables - 01

Making Beautiful Tables in R.

tables

tidyverse

Author

Horacio Lopez-Nicora

Published

April 8, 2025

1 Introduction

Overview

Welcome to this session on the gt package in R! The gt package is a powerful tool designed to help you create and customize tables with ease. Whether you’re preparing data for a report, presentation, or publication, gt offers a range of features to make your tables both informative and visually appealing. In this session, we’ll explore the capabilities of the gt package, guiding you through its basic and advanced functionalities.

The purpose of this session is to provide you with a comprehensive understanding of how to use the gt package effectively. We’ll start with the basics, such as installing the package and creating simple tables, and gradually move on to more advanced features like conditional formatting and grouping rows and columns. By the end of this session, you’ll be equipped with the skills to create professional-quality tables that can improve your data presentations.

Session key topics

Installation and Setup: Install the gt package and set up your environment.
Creating Your First Table: Get hands-on experience with creating a basic table from a data frame.
Customizing Tables: Discover how to add titles, subtitles, footnotes, and format columns.
Advanced Table Features: Explore grouping, conditional formatting, and applying themes.
Practical Example: Build a comprehensive table using multiple features.
Q&A and Wrap-Up: Address any questions and recap the key points.

Let’s get started and unlock the potential of the gt package for your data visualization needs!

The `gt` Tables Workflow

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

install.packages("gt")

2 Our data set

Creating our Data.Frame

We are going to create a simple data frame using information from the gapminder package.

simple_table <- data.frame(
  Country = c("Brazil", "Italy", "Paraguay", "USA"),
  Capital = c("Brasília", "Roma", "Asunción", "Washington D.C."),
  Continent = c("Americas", "Europe", "Americas", "Americas"),
  LifeExp = c(72.4, 80.5, 71.8, 78.2)
)

Recall that `as_tibble()` turns an existing object, such as a data frame or matrix, into a so-called tibble.

We will also 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)

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 Creating a Simple Table from a Data Frame

Creating a table with the gt package is remarkably simple. You begin by selecting a data frame that you want to display. For this session, we’ll use a data.frame we created and the Palmer Penguins dataset.

After loading the dataset, 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.

# Create a simple table
simple_table %>% gt()

Country	Capital	Continent	LifeExp
Brazil	Brasília	Americas	72.4
Italy	Roma	Europe	80.5
Paraguay	Asunción	Americas	71.8
USA	Washington D.C.	Americas	78.2

The simplicity of this process allows you to quickly transform raw data into a structured table format, making it easier to analyze and present.

3.1 Basic Formatting Options

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

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.

Let’s go ahead and add a title and subtitle to our basic simple table.

# Add titles and subtitles
simple_table %>% gt() %>% 
  tab_header(
    title = "Life Expectation in 2007",
    subtitle = "Data retrieved from the `gapminder` package"
  )

Country	Capital	Continent	LifeExp
Life Expectation in 2007
Data retrieved from the `gapminder` package
Brazil	Brasília	Americas	72.4
Italy	Roma	Europe	80.5
Paraguay	Asunción	Americas	71.8
USA	Washington D.C.	Americas	78.2

Let’s say we want, for some reason to express LifeExp with two decimal. We can do this using the function fmt_number.

# Format columns with numbers
simple_table %>% gt() %>%
  fmt_number(decimals = 2)

Country	Capital	Continent	LifeExp
Brazil	Brasília	Americas	72.40
Italy	Roma	Europe	80.50
Paraguay	Asunción	Americas	71.80
USA	Washington D.C.	Americas	78.20

If there are several columns we would like to apply fmt_number, then we can use the following statement: fmt_number(columns = vars(column_1, column_2, column_3, column_4), decimals = 2)

Footnotes are also an essential part of data presentation, providing additional context, explanations, or references that enhance the understanding of the data. Using footnotes can help clarify complex information, cite sources, or highlight important details that might not be immediately apparent from the table itself.

In the gtpackage, the tab_footnote function allows you to add these valuable annotations directly to your tables, making them more informative and professional.

Using our previous example, let’s add a footnote to our simple table.

# Add titles and subtitles and footnote
simple_table %>% gt() %>% 
  tab_header(
    title = "Life Expectation in 2007",
    subtitle = "Data retrieved from the `gapminder` package"
  ) %>% 
  tab_footnote(
    footnote = "Data retreived from `gapminder`",
    locations = cells_title(groups = "title")
  )

Country	Capital	Continent	LifeExp
Life Expectation in 2007¹
Data retrieved from the `gapminder` package
Brazil	Brasília	Americas	72.4
Italy	Roma	Europe	80.5
Paraguay	Asunción	Americas	71.8
USA	Washington D.C.	Americas	78.2
¹ Data retreived from `gapminder`

Now let’s put in practice what we learn with the Palmer Penguin data set.

Exercise 1

Create a simple table using gt and the Palmer Penguins data set.

Solutions (click here)

penguins %>% gt()

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

Exercise 2

Create a simple table and add titles and subtitles using gt and the Palmer Penguins data set.

Solutions (click here)

# Create a table with titles and subtitles
penguins %>% gt() %>%
  tab_header(
    title = "Palmer Penguins Data",
    subtitle = "Species, Island, and Measurements"
  )

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex	year
Palmer Penguins Data
Species, Island, and Measurements
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

Create a simple table and add titles, subtitles, and a footnote using gt and the Palmer Penguins data set. The location of the footnote should be in the subtitle.

Solutions (click here)

# Create a table with titles, subtitles, and footnote
penguins %>% gt() %>%
  tab_header(
    title = "Palmer Penguins Data",
    subtitle = "Species, Island, and Measurements"
  ) %>% 
  tab_footnote(
    footnote = "Data collected by Dr. Kristen Gorman",
    locations = cells_title(groups = "subtitle")
  )

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex	year
Palmer Penguins Data
Species, Island, and Measurements¹
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
¹ Data collected by Dr. Kristen Gorman

Exercise 3

Create a simple table and add titles, subtitles, and a footnote using gt and the Palmer Penguins data set. The location of the footnote should be in the subtitle.
Additionally, make sure that all numerical variables are presented with two decimal places.

Solutions (click here)

# Create a table with titles, subtitles, and footnote
penguins %>% gt() %>%
  tab_header(
    title = "Palmer Penguins Data",
    subtitle = "Species, Island, and Measurements"
  ) %>% 
  tab_footnote(
    footnote = "Data collected by Dr. Kristen Gorman",
    locations = cells_title(groups = "subtitle")
  ) %>% 
  fmt_number(
    columns = vars(bill_length_mm, bill_depth_mm, flipper_length_mm, body_mass_g),
    decimals = 2
  )

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex	year
Palmer Penguins Data
Species, Island, and Measurements¹
Adelie	Torgersen	39.10	18.70	181.00	3,750.00	male	2007
Adelie	Torgersen	39.50	17.40	186.00	3,800.00	female	2007
Adelie	Torgersen	40.30	18.00	195.00	3,250.00	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.70	19.30	193.00	3,450.00	female	2007
Adelie	Torgersen	39.30	20.60	190.00	3,650.00	male	2007
Adelie	Torgersen	38.90	17.80	181.00	3,625.00	female	2007
Adelie	Torgersen	39.20	19.60	195.00	4,675.00	male	2007
Adelie	Torgersen	34.10	18.10	193.00	3,475.00	NA	2007
Adelie	Torgersen	42.00	20.20	190.00	4,250.00	NA	2007
Adelie	Torgersen	37.80	17.10	186.00	3,300.00	NA	2007
Adelie	Torgersen	37.80	17.30	180.00	3,700.00	NA	2007
Adelie	Torgersen	41.10	17.60	182.00	3,200.00	female	2007
Adelie	Torgersen	38.60	21.20	191.00	3,800.00	male	2007
Adelie	Torgersen	34.60	21.10	198.00	4,400.00	male	2007
Adelie	Torgersen	36.60	17.80	185.00	3,700.00	female	2007
Adelie	Torgersen	38.70	19.00	195.00	3,450.00	female	2007
Adelie	Torgersen	42.50	20.70	197.00	4,500.00	male	2007
Adelie	Torgersen	34.40	18.40	184.00	3,325.00	female	2007
Adelie	Torgersen	46.00	21.50	194.00	4,200.00	male	2007
Adelie	Biscoe	37.80	18.30	174.00	3,400.00	female	2007
Adelie	Biscoe	37.70	18.70	180.00	3,600.00	male	2007
Adelie	Biscoe	35.90	19.20	189.00	3,800.00	female	2007
Adelie	Biscoe	38.20	18.10	185.00	3,950.00	male	2007
Adelie	Biscoe	38.80	17.20	180.00	3,800.00	male	2007
Adelie	Biscoe	35.30	18.90	187.00	3,800.00	female	2007
Adelie	Biscoe	40.60	18.60	183.00	3,550.00	male	2007
Adelie	Biscoe	40.50	17.90	187.00	3,200.00	female	2007
Adelie	Biscoe	37.90	18.60	172.00	3,150.00	female	2007
Adelie	Biscoe	40.50	18.90	180.00	3,950.00	male	2007
Adelie	Dream	39.50	16.70	178.00	3,250.00	female	2007
Adelie	Dream	37.20	18.10	178.00	3,900.00	male	2007
Adelie	Dream	39.50	17.80	188.00	3,300.00	female	2007
Adelie	Dream	40.90	18.90	184.00	3,900.00	male	2007
Adelie	Dream	36.40	17.00	195.00	3,325.00	female	2007
Adelie	Dream	39.20	21.10	196.00	4,150.00	male	2007
Adelie	Dream	38.80	20.00	190.00	3,950.00	male	2007
Adelie	Dream	42.20	18.50	180.00	3,550.00	female	2007
Adelie	Dream	37.60	19.30	181.00	3,300.00	female	2007
Adelie	Dream	39.80	19.10	184.00	4,650.00	male	2007
Adelie	Dream	36.50	18.00	182.00	3,150.00	female	2007
Adelie	Dream	40.80	18.40	195.00	3,900.00	male	2007
Adelie	Dream	36.00	18.50	186.00	3,100.00	female	2007
Adelie	Dream	44.10	19.70	196.00	4,400.00	male	2007
Adelie	Dream	37.00	16.90	185.00	3,000.00	female	2007
Adelie	Dream	39.60	18.80	190.00	4,600.00	male	2007
Adelie	Dream	41.10	19.00	182.00	3,425.00	male	2007
Adelie	Dream	37.50	18.90	179.00	2,975.00	NA	2007
Adelie	Dream	36.00	17.90	190.00	3,450.00	female	2007
Adelie	Dream	42.30	21.20	191.00	4,150.00	male	2007
Adelie	Biscoe	39.60	17.70	186.00	3,500.00	female	2008
Adelie	Biscoe	40.10	18.90	188.00	4,300.00	male	2008
Adelie	Biscoe	35.00	17.90	190.00	3,450.00	female	2008
Adelie	Biscoe	42.00	19.50	200.00	4,050.00	male	2008
Adelie	Biscoe	34.50	18.10	187.00	2,900.00	female	2008
Adelie	Biscoe	41.40	18.60	191.00	3,700.00	male	2008
Adelie	Biscoe	39.00	17.50	186.00	3,550.00	female	2008
Adelie	Biscoe	40.60	18.80	193.00	3,800.00	male	2008
Adelie	Biscoe	36.50	16.60	181.00	2,850.00	female	2008
Adelie	Biscoe	37.60	19.10	194.00	3,750.00	male	2008
Adelie	Biscoe	35.70	16.90	185.00	3,150.00	female	2008
Adelie	Biscoe	41.30	21.10	195.00	4,400.00	male	2008
Adelie	Biscoe	37.60	17.00	185.00	3,600.00	female	2008
Adelie	Biscoe	41.10	18.20	192.00	4,050.00	male	2008
Adelie	Biscoe	36.40	17.10	184.00	2,850.00	female	2008
Adelie	Biscoe	41.60	18.00	192.00	3,950.00	male	2008
Adelie	Biscoe	35.50	16.20	195.00	3,350.00	female	2008
Adelie	Biscoe	41.10	19.10	188.00	4,100.00	male	2008
Adelie	Torgersen	35.90	16.60	190.00	3,050.00	female	2008
Adelie	Torgersen	41.80	19.40	198.00	4,450.00	male	2008
Adelie	Torgersen	33.50	19.00	190.00	3,600.00	female	2008
Adelie	Torgersen	39.70	18.40	190.00	3,900.00	male	2008
Adelie	Torgersen	39.60	17.20	196.00	3,550.00	female	2008
Adelie	Torgersen	45.80	18.90	197.00	4,150.00	male	2008
Adelie	Torgersen	35.50	17.50	190.00	3,700.00	female	2008
Adelie	Torgersen	42.80	18.50	195.00	4,250.00	male	2008
Adelie	Torgersen	40.90	16.80	191.00	3,700.00	female	2008
Adelie	Torgersen	37.20	19.40	184.00	3,900.00	male	2008
Adelie	Torgersen	36.20	16.10	187.00	3,550.00	female	2008
Adelie	Torgersen	42.10	19.10	195.00	4,000.00	male	2008
Adelie	Torgersen	34.60	17.20	189.00	3,200.00	female	2008
Adelie	Torgersen	42.90	17.60	196.00	4,700.00	male	2008
Adelie	Torgersen	36.70	18.80	187.00	3,800.00	female	2008
Adelie	Torgersen	35.10	19.40	193.00	4,200.00	male	2008
Adelie	Dream	37.30	17.80	191.00	3,350.00	female	2008
Adelie	Dream	41.30	20.30	194.00	3,550.00	male	2008
Adelie	Dream	36.30	19.50	190.00	3,800.00	male	2008
Adelie	Dream	36.90	18.60	189.00	3,500.00	female	2008
Adelie	Dream	38.30	19.20	189.00	3,950.00	male	2008
Adelie	Dream	38.90	18.80	190.00	3,600.00	female	2008
Adelie	Dream	35.70	18.00	202.00	3,550.00	female	2008
Adelie	Dream	41.10	18.10	205.00	4,300.00	male	2008
Adelie	Dream	34.00	17.10	185.00	3,400.00	female	2008
Adelie	Dream	39.60	18.10	186.00	4,450.00	male	2008
Adelie	Dream	36.20	17.30	187.00	3,300.00	female	2008
Adelie	Dream	40.80	18.90	208.00	4,300.00	male	2008
Adelie	Dream	38.10	18.60	190.00	3,700.00	female	2008
Adelie	Dream	40.30	18.50	196.00	4,350.00	male	2008
Adelie	Dream	33.10	16.10	178.00	2,900.00	female	2008
Adelie	Dream	43.20	18.50	192.00	4,100.00	male	2008
Adelie	Biscoe	35.00	17.90	192.00	3,725.00	female	2009
Adelie	Biscoe	41.00	20.00	203.00	4,725.00	male	2009
Adelie	Biscoe	37.70	16.00	183.00	3,075.00	female	2009
Adelie	Biscoe	37.80	20.00	190.00	4,250.00	male	2009
Adelie	Biscoe	37.90	18.60	193.00	2,925.00	female	2009
Adelie	Biscoe	39.70	18.90	184.00	3,550.00	male	2009
Adelie	Biscoe	38.60	17.20	199.00	3,750.00	female	2009
Adelie	Biscoe	38.20	20.00	190.00	3,900.00	male	2009
Adelie	Biscoe	38.10	17.00	181.00	3,175.00	female	2009
Adelie	Biscoe	43.20	19.00	197.00	4,775.00	male	2009
Adelie	Biscoe	38.10	16.50	198.00	3,825.00	female	2009
Adelie	Biscoe	45.60	20.30	191.00	4,600.00	male	2009
Adelie	Biscoe	39.70	17.70	193.00	3,200.00	female	2009
Adelie	Biscoe	42.20	19.50	197.00	4,275.00	male	2009
Adelie	Biscoe	39.60	20.70	191.00	3,900.00	female	2009
Adelie	Biscoe	42.70	18.30	196.00	4,075.00	male	2009
Adelie	Torgersen	38.60	17.00	188.00	2,900.00	female	2009
Adelie	Torgersen	37.30	20.50	199.00	3,775.00	male	2009
Adelie	Torgersen	35.70	17.00	189.00	3,350.00	female	2009
Adelie	Torgersen	41.10	18.60	189.00	3,325.00	male	2009
Adelie	Torgersen	36.20	17.20	187.00	3,150.00	female	2009
Adelie	Torgersen	37.70	19.80	198.00	3,500.00	male	2009
Adelie	Torgersen	40.20	17.00	176.00	3,450.00	female	2009
Adelie	Torgersen	41.40	18.50	202.00	3,875.00	male	2009
Adelie	Torgersen	35.20	15.90	186.00	3,050.00	female	2009
Adelie	Torgersen	40.60	19.00	199.00	4,000.00	male	2009
Adelie	Torgersen	38.80	17.60	191.00	3,275.00	female	2009
Adelie	Torgersen	41.50	18.30	195.00	4,300.00	male	2009
Adelie	Torgersen	39.00	17.10	191.00	3,050.00	female	2009
Adelie	Torgersen	44.10	18.00	210.00	4,000.00	male	2009
Adelie	Torgersen	38.50	17.90	190.00	3,325.00	female	2009
Adelie	Torgersen	43.10	19.20	197.00	3,500.00	male	2009
Adelie	Dream	36.80	18.50	193.00	3,500.00	female	2009
Adelie	Dream	37.50	18.50	199.00	4,475.00	male	2009
Adelie	Dream	38.10	17.60	187.00	3,425.00	female	2009
Adelie	Dream	41.10	17.50	190.00	3,900.00	male	2009
Adelie	Dream	35.60	17.50	191.00	3,175.00	female	2009
Adelie	Dream	40.20	20.10	200.00	3,975.00	male	2009
Adelie	Dream	37.00	16.50	185.00	3,400.00	female	2009
Adelie	Dream	39.70	17.90	193.00	4,250.00	male	2009
Adelie	Dream	40.20	17.10	193.00	3,400.00	female	2009
Adelie	Dream	40.60	17.20	187.00	3,475.00	male	2009
Adelie	Dream	32.10	15.50	188.00	3,050.00	female	2009
Adelie	Dream	40.70	17.00	190.00	3,725.00	male	2009
Adelie	Dream	37.30	16.80	192.00	3,000.00	female	2009
Adelie	Dream	39.00	18.70	185.00	3,650.00	male	2009
Adelie	Dream	39.20	18.60	190.00	4,250.00	male	2009
Adelie	Dream	36.60	18.40	184.00	3,475.00	female	2009
Adelie	Dream	36.00	17.80	195.00	3,450.00	female	2009
Adelie	Dream	37.80	18.10	193.00	3,750.00	male	2009
Adelie	Dream	36.00	17.10	187.00	3,700.00	female	2009
Adelie	Dream	41.50	18.50	201.00	4,000.00	male	2009
Gentoo	Biscoe	46.10	13.20	211.00	4,500.00	female	2007
Gentoo	Biscoe	50.00	16.30	230.00	5,700.00	male	2007
Gentoo	Biscoe	48.70	14.10	210.00	4,450.00	female	2007
Gentoo	Biscoe	50.00	15.20	218.00	5,700.00	male	2007
Gentoo	Biscoe	47.60	14.50	215.00	5,400.00	male	2007
Gentoo	Biscoe	46.50	13.50	210.00	4,550.00	female	2007
Gentoo	Biscoe	45.40	14.60	211.00	4,800.00	female	2007
Gentoo	Biscoe	46.70	15.30	219.00	5,200.00	male	2007
Gentoo	Biscoe	43.30	13.40	209.00	4,400.00	female	2007
Gentoo	Biscoe	46.80	15.40	215.00	5,150.00	male	2007
Gentoo	Biscoe	40.90	13.70	214.00	4,650.00	female	2007
Gentoo	Biscoe	49.00	16.10	216.00	5,550.00	male	2007
Gentoo	Biscoe	45.50	13.70	214.00	4,650.00	female	2007
Gentoo	Biscoe	48.40	14.60	213.00	5,850.00	male	2007
Gentoo	Biscoe	45.80	14.60	210.00	4,200.00	female	2007
Gentoo	Biscoe	49.30	15.70	217.00	5,850.00	male	2007
Gentoo	Biscoe	42.00	13.50	210.00	4,150.00	female	2007
Gentoo	Biscoe	49.20	15.20	221.00	6,300.00	male	2007
Gentoo	Biscoe	46.20	14.50	209.00	4,800.00	female	2007
Gentoo	Biscoe	48.70	15.10	222.00	5,350.00	male	2007
Gentoo	Biscoe	50.20	14.30	218.00	5,700.00	male	2007
Gentoo	Biscoe	45.10	14.50	215.00	5,000.00	female	2007
Gentoo	Biscoe	46.50	14.50	213.00	4,400.00	female	2007
Gentoo	Biscoe	46.30	15.80	215.00	5,050.00	male	2007
Gentoo	Biscoe	42.90	13.10	215.00	5,000.00	female	2007
Gentoo	Biscoe	46.10	15.10	215.00	5,100.00	male	2007
Gentoo	Biscoe	44.50	14.30	216.00	4,100.00	NA	2007
Gentoo	Biscoe	47.80	15.00	215.00	5,650.00	male	2007
Gentoo	Biscoe	48.20	14.30	210.00	4,600.00	female	2007
Gentoo	Biscoe	50.00	15.30	220.00	5,550.00	male	2007
Gentoo	Biscoe	47.30	15.30	222.00	5,250.00	male	2007
Gentoo	Biscoe	42.80	14.20	209.00	4,700.00	female	2007
Gentoo	Biscoe	45.10	14.50	207.00	5,050.00	female	2007
Gentoo	Biscoe	59.60	17.00	230.00	6,050.00	male	2007
Gentoo	Biscoe	49.10	14.80	220.00	5,150.00	female	2008
Gentoo	Biscoe	48.40	16.30	220.00	5,400.00	male	2008
Gentoo	Biscoe	42.60	13.70	213.00	4,950.00	female	2008
Gentoo	Biscoe	44.40	17.30	219.00	5,250.00	male	2008
Gentoo	Biscoe	44.00	13.60	208.00	4,350.00	female	2008
Gentoo	Biscoe	48.70	15.70	208.00	5,350.00	male	2008
Gentoo	Biscoe	42.70	13.70	208.00	3,950.00	female	2008
Gentoo	Biscoe	49.60	16.00	225.00	5,700.00	male	2008
Gentoo	Biscoe	45.30	13.70	210.00	4,300.00	female	2008
Gentoo	Biscoe	49.60	15.00	216.00	4,750.00	male	2008
Gentoo	Biscoe	50.50	15.90	222.00	5,550.00	male	2008
Gentoo	Biscoe	43.60	13.90	217.00	4,900.00	female	2008
Gentoo	Biscoe	45.50	13.90	210.00	4,200.00	female	2008
Gentoo	Biscoe	50.50	15.90	225.00	5,400.00	male	2008
Gentoo	Biscoe	44.90	13.30	213.00	5,100.00	female	2008
Gentoo	Biscoe	45.20	15.80	215.00	5,300.00	male	2008
Gentoo	Biscoe	46.60	14.20	210.00	4,850.00	female	2008
Gentoo	Biscoe	48.50	14.10	220.00	5,300.00	male	2008
Gentoo	Biscoe	45.10	14.40	210.00	4,400.00	female	2008
Gentoo	Biscoe	50.10	15.00	225.00	5,000.00	male	2008
Gentoo	Biscoe	46.50	14.40	217.00	4,900.00	female	2008
Gentoo	Biscoe	45.00	15.40	220.00	5,050.00	male	2008
Gentoo	Biscoe	43.80	13.90	208.00	4,300.00	female	2008
Gentoo	Biscoe	45.50	15.00	220.00	5,000.00	male	2008
Gentoo	Biscoe	43.20	14.50	208.00	4,450.00	female	2008
Gentoo	Biscoe	50.40	15.30	224.00	5,550.00	male	2008
Gentoo	Biscoe	45.30	13.80	208.00	4,200.00	female	2008
Gentoo	Biscoe	46.20	14.90	221.00	5,300.00	male	2008
Gentoo	Biscoe	45.70	13.90	214.00	4,400.00	female	2008
Gentoo	Biscoe	54.30	15.70	231.00	5,650.00	male	2008
Gentoo	Biscoe	45.80	14.20	219.00	4,700.00	female	2008
Gentoo	Biscoe	49.80	16.80	230.00	5,700.00	male	2008
Gentoo	Biscoe	46.20	14.40	214.00	4,650.00	NA	2008
Gentoo	Biscoe	49.50	16.20	229.00	5,800.00	male	2008
Gentoo	Biscoe	43.50	14.20	220.00	4,700.00	female	2008
Gentoo	Biscoe	50.70	15.00	223.00	5,550.00	male	2008
Gentoo	Biscoe	47.70	15.00	216.00	4,750.00	female	2008
Gentoo	Biscoe	46.40	15.60	221.00	5,000.00	male	2008
Gentoo	Biscoe	48.20	15.60	221.00	5,100.00	male	2008
Gentoo	Biscoe	46.50	14.80	217.00	5,200.00	female	2008
Gentoo	Biscoe	46.40	15.00	216.00	4,700.00	female	2008
Gentoo	Biscoe	48.60	16.00	230.00	5,800.00	male	2008
Gentoo	Biscoe	47.50	14.20	209.00	4,600.00	female	2008
Gentoo	Biscoe	51.10	16.30	220.00	6,000.00	male	2008
Gentoo	Biscoe	45.20	13.80	215.00	4,750.00	female	2008
Gentoo	Biscoe	45.20	16.40	223.00	5,950.00	male	2008
Gentoo	Biscoe	49.10	14.50	212.00	4,625.00	female	2009
Gentoo	Biscoe	52.50	15.60	221.00	5,450.00	male	2009
Gentoo	Biscoe	47.40	14.60	212.00	4,725.00	female	2009
Gentoo	Biscoe	50.00	15.90	224.00	5,350.00	male	2009
Gentoo	Biscoe	44.90	13.80	212.00	4,750.00	female	2009
Gentoo	Biscoe	50.80	17.30	228.00	5,600.00	male	2009
Gentoo	Biscoe	43.40	14.40	218.00	4,600.00	female	2009
Gentoo	Biscoe	51.30	14.20	218.00	5,300.00	male	2009
Gentoo	Biscoe	47.50	14.00	212.00	4,875.00	female	2009
Gentoo	Biscoe	52.10	17.00	230.00	5,550.00	male	2009
Gentoo	Biscoe	47.50	15.00	218.00	4,950.00	female	2009
Gentoo	Biscoe	52.20	17.10	228.00	5,400.00	male	2009
Gentoo	Biscoe	45.50	14.50	212.00	4,750.00	female	2009
Gentoo	Biscoe	49.50	16.10	224.00	5,650.00	male	2009
Gentoo	Biscoe	44.50	14.70	214.00	4,850.00	female	2009
Gentoo	Biscoe	50.80	15.70	226.00	5,200.00	male	2009
Gentoo	Biscoe	49.40	15.80	216.00	4,925.00	male	2009
Gentoo	Biscoe	46.90	14.60	222.00	4,875.00	female	2009
Gentoo	Biscoe	48.40	14.40	203.00	4,625.00	female	2009
Gentoo	Biscoe	51.10	16.50	225.00	5,250.00	male	2009
Gentoo	Biscoe	48.50	15.00	219.00	4,850.00	female	2009
Gentoo	Biscoe	55.90	17.00	228.00	5,600.00	male	2009
Gentoo	Biscoe	47.20	15.50	215.00	4,975.00	female	2009
Gentoo	Biscoe	49.10	15.00	228.00	5,500.00	male	2009
Gentoo	Biscoe	47.30	13.80	216.00	4,725.00	NA	2009
Gentoo	Biscoe	46.80	16.10	215.00	5,500.00	male	2009
Gentoo	Biscoe	41.70	14.70	210.00	4,700.00	female	2009
Gentoo	Biscoe	53.40	15.80	219.00	5,500.00	male	2009
Gentoo	Biscoe	43.30	14.00	208.00	4,575.00	female	2009
Gentoo	Biscoe	48.10	15.10	209.00	5,500.00	male	2009
Gentoo	Biscoe	50.50	15.20	216.00	5,000.00	female	2009
Gentoo	Biscoe	49.80	15.90	229.00	5,950.00	male	2009
Gentoo	Biscoe	43.50	15.20	213.00	4,650.00	female	2009
Gentoo	Biscoe	51.50	16.30	230.00	5,500.00	male	2009
Gentoo	Biscoe	46.20	14.10	217.00	4,375.00	female	2009
Gentoo	Biscoe	55.10	16.00	230.00	5,850.00	male	2009
Gentoo	Biscoe	44.50	15.70	217.00	4,875.00	NA	2009
Gentoo	Biscoe	48.80	16.20	222.00	6,000.00	male	2009
Gentoo	Biscoe	47.20	13.70	214.00	4,925.00	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.80	14.30	215.00	4,850.00	female	2009
Gentoo	Biscoe	50.40	15.70	222.00	5,750.00	male	2009
Gentoo	Biscoe	45.20	14.80	212.00	5,200.00	female	2009
Gentoo	Biscoe	49.90	16.10	213.00	5,400.00	male	2009
Chinstrap	Dream	46.50	17.90	192.00	3,500.00	female	2007
Chinstrap	Dream	50.00	19.50	196.00	3,900.00	male	2007
Chinstrap	Dream	51.30	19.20	193.00	3,650.00	male	2007
Chinstrap	Dream	45.40	18.70	188.00	3,525.00	female	2007
Chinstrap	Dream	52.70	19.80	197.00	3,725.00	male	2007
Chinstrap	Dream	45.20	17.80	198.00	3,950.00	female	2007
Chinstrap	Dream	46.10	18.20	178.00	3,250.00	female	2007
Chinstrap	Dream	51.30	18.20	197.00	3,750.00	male	2007
Chinstrap	Dream	46.00	18.90	195.00	4,150.00	female	2007
Chinstrap	Dream	51.30	19.90	198.00	3,700.00	male	2007
Chinstrap	Dream	46.60	17.80	193.00	3,800.00	female	2007
Chinstrap	Dream	51.70	20.30	194.00	3,775.00	male	2007
Chinstrap	Dream	47.00	17.30	185.00	3,700.00	female	2007
Chinstrap	Dream	52.00	18.10	201.00	4,050.00	male	2007
Chinstrap	Dream	45.90	17.10	190.00	3,575.00	female	2007
Chinstrap	Dream	50.50	19.60	201.00	4,050.00	male	2007
Chinstrap	Dream	50.30	20.00	197.00	3,300.00	male	2007
Chinstrap	Dream	58.00	17.80	181.00	3,700.00	female	2007
Chinstrap	Dream	46.40	18.60	190.00	3,450.00	female	2007
Chinstrap	Dream	49.20	18.20	195.00	4,400.00	male	2007
Chinstrap	Dream	42.40	17.30	181.00	3,600.00	female	2007
Chinstrap	Dream	48.50	17.50	191.00	3,400.00	male	2007
Chinstrap	Dream	43.20	16.60	187.00	2,900.00	female	2007
Chinstrap	Dream	50.60	19.40	193.00	3,800.00	male	2007
Chinstrap	Dream	46.70	17.90	195.00	3,300.00	female	2007
Chinstrap	Dream	52.00	19.00	197.00	4,150.00	male	2007
Chinstrap	Dream	50.50	18.40	200.00	3,400.00	female	2008
Chinstrap	Dream	49.50	19.00	200.00	3,800.00	male	2008
Chinstrap	Dream	46.40	17.80	191.00	3,700.00	female	2008
Chinstrap	Dream	52.80	20.00	205.00	4,550.00	male	2008
Chinstrap	Dream	40.90	16.60	187.00	3,200.00	female	2008
Chinstrap	Dream	54.20	20.80	201.00	4,300.00	male	2008
Chinstrap	Dream	42.50	16.70	187.00	3,350.00	female	2008
Chinstrap	Dream	51.00	18.80	203.00	4,100.00	male	2008
Chinstrap	Dream	49.70	18.60	195.00	3,600.00	male	2008
Chinstrap	Dream	47.50	16.80	199.00	3,900.00	female	2008
Chinstrap	Dream	47.60	18.30	195.00	3,850.00	female	2008
Chinstrap	Dream	52.00	20.70	210.00	4,800.00	male	2008
Chinstrap	Dream	46.90	16.60	192.00	2,700.00	female	2008
Chinstrap	Dream	53.50	19.90	205.00	4,500.00	male	2008
Chinstrap	Dream	49.00	19.50	210.00	3,950.00	male	2008
Chinstrap	Dream	46.20	17.50	187.00	3,650.00	female	2008
Chinstrap	Dream	50.90	19.10	196.00	3,550.00	male	2008
Chinstrap	Dream	45.50	17.00	196.00	3,500.00	female	2008
Chinstrap	Dream	50.90	17.90	196.00	3,675.00	female	2009
Chinstrap	Dream	50.80	18.50	201.00	4,450.00	male	2009
Chinstrap	Dream	50.10	17.90	190.00	3,400.00	female	2009
Chinstrap	Dream	49.00	19.60	212.00	4,300.00	male	2009
Chinstrap	Dream	51.50	18.70	187.00	3,250.00	male	2009
Chinstrap	Dream	49.80	17.30	198.00	3,675.00	female	2009
Chinstrap	Dream	48.10	16.40	199.00	3,325.00	female	2009
Chinstrap	Dream	51.40	19.00	201.00	3,950.00	male	2009
Chinstrap	Dream	45.70	17.30	193.00	3,600.00	female	2009
Chinstrap	Dream	50.70	19.70	203.00	4,050.00	male	2009
Chinstrap	Dream	42.50	17.30	187.00	3,350.00	female	2009
Chinstrap	Dream	52.20	18.80	197.00	3,450.00	male	2009
Chinstrap	Dream	45.20	16.60	191.00	3,250.00	female	2009
Chinstrap	Dream	49.30	19.90	203.00	4,050.00	male	2009
Chinstrap	Dream	50.20	18.80	202.00	3,800.00	male	2009
Chinstrap	Dream	45.60	19.40	194.00	3,525.00	female	2009
Chinstrap	Dream	51.90	19.50	206.00	3,950.00	male	2009
Chinstrap	Dream	46.80	16.50	189.00	3,650.00	female	2009
Chinstrap	Dream	45.70	17.00	195.00	3,650.00	female	2009
Chinstrap	Dream	55.80	19.80	207.00	4,000.00	male	2009
Chinstrap	Dream	43.50	18.10	202.00	3,400.00	female	2009
Chinstrap	Dream	49.60	18.20	193.00	3,775.00	male	2009
Chinstrap	Dream	50.80	19.00	210.00	4,100.00	male	2009
Chinstrap	Dream	50.20	18.70	198.00	3,775.00	female	2009
¹ Data collected by Dr. Kristen Gorman

3.2 How can we customize our tables to include more advanced features?

Apply Conditional Formatting

In this section, we’ll explore advanced features of the gt package to enhance your tables’ functionality and visual appeal. We’ll focus on conditional formatting and labeling columns, essential for creating informative and organized tables.

Conditional formatting highlights specific values based on criteria, drawing attention to crucial data points and enhancing readability. The tab_style function in the gt package allows you to apply styles to cells that meet certain conditions.

For example, you might want to highlight cells in the LifeExp column with a light blue background to emphasize these values:

# Apply conditional formatting to highlight specific values
simple_table %>% gt() %>%
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(columns = vars(LifeExp))
  )

Country	Capital	Continent	LifeExp
Brazil	Brasília	Americas	72.4
Italy	Roma	Europe	80.5
Paraguay	Asunción	Americas	71.8
USA	Washington D.C.	Americas	78.2

In this example, the tab_style function is used to apply a light blue fill to the cells in the LifeExp column. This visual cue helps to make the LifeExp stand out, making it easier for viewers to identify and compare these values.

Customize the column labels in your table

The cols_label function in the gt package allows you to customize the column labels in your table. This is particularly useful when you want to make your table more readable and user-friendly by providing descriptive names for your columns. Instead of using the default column names from your data frame, you can specify more meaningful labels that better convey the content of each column.

For example, you can rename columns in our simple_table data set to provide clearer descriptions:

# Group rows by species
simple_table %>%  gt() %>%
  cols_label(
    LifeExp = "Life Expectation"
  )

Country	Capital	Continent	Life Expectation
Brazil	Brasília	Americas	72.4
Italy	Roma	Europe	80.5
Paraguay	Asunción	Americas	71.8
USA	Washington D.C.	Americas	78.2

In this example, the cols_label function is used to change the column names to more descriptive labels. This helps viewers understand the measurements more easily, enhancing the overall clarity and effectiveness of the table.

Let’s put into practice these new skills!

Exercise 4

In this exercise, use the Penguins Palmer dataset and use the the tab_style function to apply a color fill to the cells in the bill_length_mm column.

Solutions (click here)

# Apply conditional formatting to highlight specific values
penguins %>% gt() %>%
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(columns = vars(bill_length_mm))
  )

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

Additionally, re-label all columns with numeric values.

Solutions (click here)

# Apply conditional formatting to highlight specific values
penguins %>% gt() %>%
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(columns = vars(bill_length_mm))
  ) %>% 
  cols_label(
    bill_length_mm = "Bill Length (mm)",
    bill_depth_mm = "Bill Depth (mm)",
    flipper_length_mm = "Flipper Length (mm)",
    body_mass_g = "Body Mass (g)"
  )

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

Exercise 5

Combine everything we learn today and create a complete and customized table using the Penguins Palmer data set.

Solutions (click here)

# Create a table with titles, subtitles, and footnote
penguins %>% gt() %>%
  tab_header(
    title = "Palmer Penguins Data",
    subtitle = "Species, Island, and Measurements"
  ) %>% 
  tab_footnote(
    footnote = "Data collected by Dr. Kristen Gorman",
    locations = cells_title(groups = "title")
  ) %>% 
  fmt_number(
    columns = vars(bill_length_mm, bill_depth_mm, flipper_length_mm, body_mass_g),
    decimals = 2
  ) %>% 
  tab_style(
    style = cell_fill(color = "lightblue"),
    locations = cells_body(columns = vars(bill_length_mm))
  ) %>% 
  cols_label(
    bill_length_mm = "Bill Length (mm)",
    bill_depth_mm = "Bill Depth (mm)",
    flipper_length_mm = "Flipper Length (mm)",
    body_mass_g = "Body Mass (g)"
  )

species	island	Bill Length (mm)	Bill Depth (mm)	Flipper Length (mm)	Body Mass (g)	sex	year
Palmer Penguins Data¹
Species, Island, and Measurements
Adelie	Torgersen	39.10	18.70	181.00	3,750.00	male	2007
Adelie	Torgersen	39.50	17.40	186.00	3,800.00	female	2007
Adelie	Torgersen	40.30	18.00	195.00	3,250.00	female	2007
Adelie	Torgersen	NA	NA	NA	NA	NA	2007
Adelie	Torgersen	36.70	19.30	193.00	3,450.00	female	2007
Adelie	Torgersen	39.30	20.60	190.00	3,650.00	male	2007
Adelie	Torgersen	38.90	17.80	181.00	3,625.00	female	2007
Adelie	Torgersen	39.20	19.60	195.00	4,675.00	male	2007
Adelie	Torgersen	34.10	18.10	193.00	3,475.00	NA	2007
Adelie	Torgersen	42.00	20.20	190.00	4,250.00	NA	2007
Adelie	Torgersen	37.80	17.10	186.00	3,300.00	NA	2007
Adelie	Torgersen	37.80	17.30	180.00	3,700.00	NA	2007
Adelie	Torgersen	41.10	17.60	182.00	3,200.00	female	2007
Adelie	Torgersen	38.60	21.20	191.00	3,800.00	male	2007
Adelie	Torgersen	34.60	21.10	198.00	4,400.00	male	2007
Adelie	Torgersen	36.60	17.80	185.00	3,700.00	female	2007
Adelie	Torgersen	38.70	19.00	195.00	3,450.00	female	2007
Adelie	Torgersen	42.50	20.70	197.00	4,500.00	male	2007
Adelie	Torgersen	34.40	18.40	184.00	3,325.00	female	2007
Adelie	Torgersen	46.00	21.50	194.00	4,200.00	male	2007
Adelie	Biscoe	37.80	18.30	174.00	3,400.00	female	2007
Adelie	Biscoe	37.70	18.70	180.00	3,600.00	male	2007
Adelie	Biscoe	35.90	19.20	189.00	3,800.00	female	2007
Adelie	Biscoe	38.20	18.10	185.00	3,950.00	male	2007
Adelie	Biscoe	38.80	17.20	180.00	3,800.00	male	2007
Adelie	Biscoe	35.30	18.90	187.00	3,800.00	female	2007
Adelie	Biscoe	40.60	18.60	183.00	3,550.00	male	2007
Adelie	Biscoe	40.50	17.90	187.00	3,200.00	female	2007
Adelie	Biscoe	37.90	18.60	172.00	3,150.00	female	2007
Adelie	Biscoe	40.50	18.90	180.00	3,950.00	male	2007
Adelie	Dream	39.50	16.70	178.00	3,250.00	female	2007
Adelie	Dream	37.20	18.10	178.00	3,900.00	male	2007
Adelie	Dream	39.50	17.80	188.00	3,300.00	female	2007
Adelie	Dream	40.90	18.90	184.00	3,900.00	male	2007
Adelie	Dream	36.40	17.00	195.00	3,325.00	female	2007
Adelie	Dream	39.20	21.10	196.00	4,150.00	male	2007
Adelie	Dream	38.80	20.00	190.00	3,950.00	male	2007
Adelie	Dream	42.20	18.50	180.00	3,550.00	female	2007
Adelie	Dream	37.60	19.30	181.00	3,300.00	female	2007
Adelie	Dream	39.80	19.10	184.00	4,650.00	male	2007
Adelie	Dream	36.50	18.00	182.00	3,150.00	female	2007
Adelie	Dream	40.80	18.40	195.00	3,900.00	male	2007
Adelie	Dream	36.00	18.50	186.00	3,100.00	female	2007
Adelie	Dream	44.10	19.70	196.00	4,400.00	male	2007
Adelie	Dream	37.00	16.90	185.00	3,000.00	female	2007
Adelie	Dream	39.60	18.80	190.00	4,600.00	male	2007
Adelie	Dream	41.10	19.00	182.00	3,425.00	male	2007
Adelie	Dream	37.50	18.90	179.00	2,975.00	NA	2007
Adelie	Dream	36.00	17.90	190.00	3,450.00	female	2007
Adelie	Dream	42.30	21.20	191.00	4,150.00	male	2007
Adelie	Biscoe	39.60	17.70	186.00	3,500.00	female	2008
Adelie	Biscoe	40.10	18.90	188.00	4,300.00	male	2008
Adelie	Biscoe	35.00	17.90	190.00	3,450.00	female	2008
Adelie	Biscoe	42.00	19.50	200.00	4,050.00	male	2008
Adelie	Biscoe	34.50	18.10	187.00	2,900.00	female	2008
Adelie	Biscoe	41.40	18.60	191.00	3,700.00	male	2008
Adelie	Biscoe	39.00	17.50	186.00	3,550.00	female	2008
Adelie	Biscoe	40.60	18.80	193.00	3,800.00	male	2008
Adelie	Biscoe	36.50	16.60	181.00	2,850.00	female	2008
Adelie	Biscoe	37.60	19.10	194.00	3,750.00	male	2008
Adelie	Biscoe	35.70	16.90	185.00	3,150.00	female	2008
Adelie	Biscoe	41.30	21.10	195.00	4,400.00	male	2008
Adelie	Biscoe	37.60	17.00	185.00	3,600.00	female	2008
Adelie	Biscoe	41.10	18.20	192.00	4,050.00	male	2008
Adelie	Biscoe	36.40	17.10	184.00	2,850.00	female	2008
Adelie	Biscoe	41.60	18.00	192.00	3,950.00	male	2008
Adelie	Biscoe	35.50	16.20	195.00	3,350.00	female	2008
Adelie	Biscoe	41.10	19.10	188.00	4,100.00	male	2008
Adelie	Torgersen	35.90	16.60	190.00	3,050.00	female	2008
Adelie	Torgersen	41.80	19.40	198.00	4,450.00	male	2008
Adelie	Torgersen	33.50	19.00	190.00	3,600.00	female	2008
Adelie	Torgersen	39.70	18.40	190.00	3,900.00	male	2008
Adelie	Torgersen	39.60	17.20	196.00	3,550.00	female	2008
Adelie	Torgersen	45.80	18.90	197.00	4,150.00	male	2008
Adelie	Torgersen	35.50	17.50	190.00	3,700.00	female	2008
Adelie	Torgersen	42.80	18.50	195.00	4,250.00	male	2008
Adelie	Torgersen	40.90	16.80	191.00	3,700.00	female	2008
Adelie	Torgersen	37.20	19.40	184.00	3,900.00	male	2008
Adelie	Torgersen	36.20	16.10	187.00	3,550.00	female	2008
Adelie	Torgersen	42.10	19.10	195.00	4,000.00	male	2008
Adelie	Torgersen	34.60	17.20	189.00	3,200.00	female	2008
Adelie	Torgersen	42.90	17.60	196.00	4,700.00	male	2008
Adelie	Torgersen	36.70	18.80	187.00	3,800.00	female	2008
Adelie	Torgersen	35.10	19.40	193.00	4,200.00	male	2008
Adelie	Dream	37.30	17.80	191.00	3,350.00	female	2008
Adelie	Dream	41.30	20.30	194.00	3,550.00	male	2008
Adelie	Dream	36.30	19.50	190.00	3,800.00	male	2008
Adelie	Dream	36.90	18.60	189.00	3,500.00	female	2008
Adelie	Dream	38.30	19.20	189.00	3,950.00	male	2008
Adelie	Dream	38.90	18.80	190.00	3,600.00	female	2008
Adelie	Dream	35.70	18.00	202.00	3,550.00	female	2008
Adelie	Dream	41.10	18.10	205.00	4,300.00	male	2008
Adelie	Dream	34.00	17.10	185.00	3,400.00	female	2008
Adelie	Dream	39.60	18.10	186.00	4,450.00	male	2008
Adelie	Dream	36.20	17.30	187.00	3,300.00	female	2008
Adelie	Dream	40.80	18.90	208.00	4,300.00	male	2008
Adelie	Dream	38.10	18.60	190.00	3,700.00	female	2008
Adelie	Dream	40.30	18.50	196.00	4,350.00	male	2008
Adelie	Dream	33.10	16.10	178.00	2,900.00	female	2008
Adelie	Dream	43.20	18.50	192.00	4,100.00	male	2008
Adelie	Biscoe	35.00	17.90	192.00	3,725.00	female	2009
Adelie	Biscoe	41.00	20.00	203.00	4,725.00	male	2009
Adelie	Biscoe	37.70	16.00	183.00	3,075.00	female	2009
Adelie	Biscoe	37.80	20.00	190.00	4,250.00	male	2009
Adelie	Biscoe	37.90	18.60	193.00	2,925.00	female	2009
Adelie	Biscoe	39.70	18.90	184.00	3,550.00	male	2009
Adelie	Biscoe	38.60	17.20	199.00	3,750.00	female	2009
Adelie	Biscoe	38.20	20.00	190.00	3,900.00	male	2009
Adelie	Biscoe	38.10	17.00	181.00	3,175.00	female	2009
Adelie	Biscoe	43.20	19.00	197.00	4,775.00	male	2009
Adelie	Biscoe	38.10	16.50	198.00	3,825.00	female	2009
Adelie	Biscoe	45.60	20.30	191.00	4,600.00	male	2009
Adelie	Biscoe	39.70	17.70	193.00	3,200.00	female	2009
Adelie	Biscoe	42.20	19.50	197.00	4,275.00	male	2009
Adelie	Biscoe	39.60	20.70	191.00	3,900.00	female	2009
Adelie	Biscoe	42.70	18.30	196.00	4,075.00	male	2009
Adelie	Torgersen	38.60	17.00	188.00	2,900.00	female	2009
Adelie	Torgersen	37.30	20.50	199.00	3,775.00	male	2009
Adelie	Torgersen	35.70	17.00	189.00	3,350.00	female	2009
Adelie	Torgersen	41.10	18.60	189.00	3,325.00	male	2009
Adelie	Torgersen	36.20	17.20	187.00	3,150.00	female	2009
Adelie	Torgersen	37.70	19.80	198.00	3,500.00	male	2009
Adelie	Torgersen	40.20	17.00	176.00	3,450.00	female	2009
Adelie	Torgersen	41.40	18.50	202.00	3,875.00	male	2009
Adelie	Torgersen	35.20	15.90	186.00	3,050.00	female	2009
Adelie	Torgersen	40.60	19.00	199.00	4,000.00	male	2009
Adelie	Torgersen	38.80	17.60	191.00	3,275.00	female	2009
Adelie	Torgersen	41.50	18.30	195.00	4,300.00	male	2009
Adelie	Torgersen	39.00	17.10	191.00	3,050.00	female	2009
Adelie	Torgersen	44.10	18.00	210.00	4,000.00	male	2009
Adelie	Torgersen	38.50	17.90	190.00	3,325.00	female	2009
Adelie	Torgersen	43.10	19.20	197.00	3,500.00	male	2009
Adelie	Dream	36.80	18.50	193.00	3,500.00	female	2009
Adelie	Dream	37.50	18.50	199.00	4,475.00	male	2009
Adelie	Dream	38.10	17.60	187.00	3,425.00	female	2009
Adelie	Dream	41.10	17.50	190.00	3,900.00	male	2009
Adelie	Dream	35.60	17.50	191.00	3,175.00	female	2009
Adelie	Dream	40.20	20.10	200.00	3,975.00	male	2009
Adelie	Dream	37.00	16.50	185.00	3,400.00	female	2009
Adelie	Dream	39.70	17.90	193.00	4,250.00	male	2009
Adelie	Dream	40.20	17.10	193.00	3,400.00	female	2009
Adelie	Dream	40.60	17.20	187.00	3,475.00	male	2009
Adelie	Dream	32.10	15.50	188.00	3,050.00	female	2009
Adelie	Dream	40.70	17.00	190.00	3,725.00	male	2009
Adelie	Dream	37.30	16.80	192.00	3,000.00	female	2009
Adelie	Dream	39.00	18.70	185.00	3,650.00	male	2009
Adelie	Dream	39.20	18.60	190.00	4,250.00	male	2009
Adelie	Dream	36.60	18.40	184.00	3,475.00	female	2009
Adelie	Dream	36.00	17.80	195.00	3,450.00	female	2009
Adelie	Dream	37.80	18.10	193.00	3,750.00	male	2009
Adelie	Dream	36.00	17.10	187.00	3,700.00	female	2009
Adelie	Dream	41.50	18.50	201.00	4,000.00	male	2009
Gentoo	Biscoe	46.10	13.20	211.00	4,500.00	female	2007
Gentoo	Biscoe	50.00	16.30	230.00	5,700.00	male	2007
Gentoo	Biscoe	48.70	14.10	210.00	4,450.00	female	2007
Gentoo	Biscoe	50.00	15.20	218.00	5,700.00	male	2007
Gentoo	Biscoe	47.60	14.50	215.00	5,400.00	male	2007
Gentoo	Biscoe	46.50	13.50	210.00	4,550.00	female	2007
Gentoo	Biscoe	45.40	14.60	211.00	4,800.00	female	2007
Gentoo	Biscoe	46.70	15.30	219.00	5,200.00	male	2007
Gentoo	Biscoe	43.30	13.40	209.00	4,400.00	female	2007
Gentoo	Biscoe	46.80	15.40	215.00	5,150.00	male	2007
Gentoo	Biscoe	40.90	13.70	214.00	4,650.00	female	2007
Gentoo	Biscoe	49.00	16.10	216.00	5,550.00	male	2007
Gentoo	Biscoe	45.50	13.70	214.00	4,650.00	female	2007
Gentoo	Biscoe	48.40	14.60	213.00	5,850.00	male	2007
Gentoo	Biscoe	45.80	14.60	210.00	4,200.00	female	2007
Gentoo	Biscoe	49.30	15.70	217.00	5,850.00	male	2007
Gentoo	Biscoe	42.00	13.50	210.00	4,150.00	female	2007
Gentoo	Biscoe	49.20	15.20	221.00	6,300.00	male	2007
Gentoo	Biscoe	46.20	14.50	209.00	4,800.00	female	2007
Gentoo	Biscoe	48.70	15.10	222.00	5,350.00	male	2007
Gentoo	Biscoe	50.20	14.30	218.00	5,700.00	male	2007
Gentoo	Biscoe	45.10	14.50	215.00	5,000.00	female	2007
Gentoo	Biscoe	46.50	14.50	213.00	4,400.00	female	2007
Gentoo	Biscoe	46.30	15.80	215.00	5,050.00	male	2007
Gentoo	Biscoe	42.90	13.10	215.00	5,000.00	female	2007
Gentoo	Biscoe	46.10	15.10	215.00	5,100.00	male	2007
Gentoo	Biscoe	44.50	14.30	216.00	4,100.00	NA	2007
Gentoo	Biscoe	47.80	15.00	215.00	5,650.00	male	2007
Gentoo	Biscoe	48.20	14.30	210.00	4,600.00	female	2007
Gentoo	Biscoe	50.00	15.30	220.00	5,550.00	male	2007
Gentoo	Biscoe	47.30	15.30	222.00	5,250.00	male	2007
Gentoo	Biscoe	42.80	14.20	209.00	4,700.00	female	2007
Gentoo	Biscoe	45.10	14.50	207.00	5,050.00	female	2007
Gentoo	Biscoe	59.60	17.00	230.00	6,050.00	male	2007
Gentoo	Biscoe	49.10	14.80	220.00	5,150.00	female	2008
Gentoo	Biscoe	48.40	16.30	220.00	5,400.00	male	2008
Gentoo	Biscoe	42.60	13.70	213.00	4,950.00	female	2008
Gentoo	Biscoe	44.40	17.30	219.00	5,250.00	male	2008
Gentoo	Biscoe	44.00	13.60	208.00	4,350.00	female	2008
Gentoo	Biscoe	48.70	15.70	208.00	5,350.00	male	2008
Gentoo	Biscoe	42.70	13.70	208.00	3,950.00	female	2008
Gentoo	Biscoe	49.60	16.00	225.00	5,700.00	male	2008
Gentoo	Biscoe	45.30	13.70	210.00	4,300.00	female	2008
Gentoo	Biscoe	49.60	15.00	216.00	4,750.00	male	2008
Gentoo	Biscoe	50.50	15.90	222.00	5,550.00	male	2008
Gentoo	Biscoe	43.60	13.90	217.00	4,900.00	female	2008
Gentoo	Biscoe	45.50	13.90	210.00	4,200.00	female	2008
Gentoo	Biscoe	50.50	15.90	225.00	5,400.00	male	2008
Gentoo	Biscoe	44.90	13.30	213.00	5,100.00	female	2008
Gentoo	Biscoe	45.20	15.80	215.00	5,300.00	male	2008
Gentoo	Biscoe	46.60	14.20	210.00	4,850.00	female	2008
Gentoo	Biscoe	48.50	14.10	220.00	5,300.00	male	2008
Gentoo	Biscoe	45.10	14.40	210.00	4,400.00	female	2008
Gentoo	Biscoe	50.10	15.00	225.00	5,000.00	male	2008
Gentoo	Biscoe	46.50	14.40	217.00	4,900.00	female	2008
Gentoo	Biscoe	45.00	15.40	220.00	5,050.00	male	2008
Gentoo	Biscoe	43.80	13.90	208.00	4,300.00	female	2008
Gentoo	Biscoe	45.50	15.00	220.00	5,000.00	male	2008
Gentoo	Biscoe	43.20	14.50	208.00	4,450.00	female	2008
Gentoo	Biscoe	50.40	15.30	224.00	5,550.00	male	2008
Gentoo	Biscoe	45.30	13.80	208.00	4,200.00	female	2008
Gentoo	Biscoe	46.20	14.90	221.00	5,300.00	male	2008
Gentoo	Biscoe	45.70	13.90	214.00	4,400.00	female	2008
Gentoo	Biscoe	54.30	15.70	231.00	5,650.00	male	2008
Gentoo	Biscoe	45.80	14.20	219.00	4,700.00	female	2008
Gentoo	Biscoe	49.80	16.80	230.00	5,700.00	male	2008
Gentoo	Biscoe	46.20	14.40	214.00	4,650.00	NA	2008
Gentoo	Biscoe	49.50	16.20	229.00	5,800.00	male	2008
Gentoo	Biscoe	43.50	14.20	220.00	4,700.00	female	2008
Gentoo	Biscoe	50.70	15.00	223.00	5,550.00	male	2008
Gentoo	Biscoe	47.70	15.00	216.00	4,750.00	female	2008
Gentoo	Biscoe	46.40	15.60	221.00	5,000.00	male	2008
Gentoo	Biscoe	48.20	15.60	221.00	5,100.00	male	2008
Gentoo	Biscoe	46.50	14.80	217.00	5,200.00	female	2008
Gentoo	Biscoe	46.40	15.00	216.00	4,700.00	female	2008
Gentoo	Biscoe	48.60	16.00	230.00	5,800.00	male	2008
Gentoo	Biscoe	47.50	14.20	209.00	4,600.00	female	2008
Gentoo	Biscoe	51.10	16.30	220.00	6,000.00	male	2008
Gentoo	Biscoe	45.20	13.80	215.00	4,750.00	female	2008
Gentoo	Biscoe	45.20	16.40	223.00	5,950.00	male	2008
Gentoo	Biscoe	49.10	14.50	212.00	4,625.00	female	2009
Gentoo	Biscoe	52.50	15.60	221.00	5,450.00	male	2009
Gentoo	Biscoe	47.40	14.60	212.00	4,725.00	female	2009
Gentoo	Biscoe	50.00	15.90	224.00	5,350.00	male	2009
Gentoo	Biscoe	44.90	13.80	212.00	4,750.00	female	2009
Gentoo	Biscoe	50.80	17.30	228.00	5,600.00	male	2009
Gentoo	Biscoe	43.40	14.40	218.00	4,600.00	female	2009
Gentoo	Biscoe	51.30	14.20	218.00	5,300.00	male	2009
Gentoo	Biscoe	47.50	14.00	212.00	4,875.00	female	2009
Gentoo	Biscoe	52.10	17.00	230.00	5,550.00	male	2009
Gentoo	Biscoe	47.50	15.00	218.00	4,950.00	female	2009
Gentoo	Biscoe	52.20	17.10	228.00	5,400.00	male	2009
Gentoo	Biscoe	45.50	14.50	212.00	4,750.00	female	2009
Gentoo	Biscoe	49.50	16.10	224.00	5,650.00	male	2009
Gentoo	Biscoe	44.50	14.70	214.00	4,850.00	female	2009
Gentoo	Biscoe	50.80	15.70	226.00	5,200.00	male	2009
Gentoo	Biscoe	49.40	15.80	216.00	4,925.00	male	2009
Gentoo	Biscoe	46.90	14.60	222.00	4,875.00	female	2009
Gentoo	Biscoe	48.40	14.40	203.00	4,625.00	female	2009
Gentoo	Biscoe	51.10	16.50	225.00	5,250.00	male	2009
Gentoo	Biscoe	48.50	15.00	219.00	4,850.00	female	2009
Gentoo	Biscoe	55.90	17.00	228.00	5,600.00	male	2009
Gentoo	Biscoe	47.20	15.50	215.00	4,975.00	female	2009
Gentoo	Biscoe	49.10	15.00	228.00	5,500.00	male	2009
Gentoo	Biscoe	47.30	13.80	216.00	4,725.00	NA	2009
Gentoo	Biscoe	46.80	16.10	215.00	5,500.00	male	2009
Gentoo	Biscoe	41.70	14.70	210.00	4,700.00	female	2009
Gentoo	Biscoe	53.40	15.80	219.00	5,500.00	male	2009
Gentoo	Biscoe	43.30	14.00	208.00	4,575.00	female	2009
Gentoo	Biscoe	48.10	15.10	209.00	5,500.00	male	2009
Gentoo	Biscoe	50.50	15.20	216.00	5,000.00	female	2009
Gentoo	Biscoe	49.80	15.90	229.00	5,950.00	male	2009
Gentoo	Biscoe	43.50	15.20	213.00	4,650.00	female	2009
Gentoo	Biscoe	51.50	16.30	230.00	5,500.00	male	2009
Gentoo	Biscoe	46.20	14.10	217.00	4,375.00	female	2009
Gentoo	Biscoe	55.10	16.00	230.00	5,850.00	male	2009
Gentoo	Biscoe	44.50	15.70	217.00	4,875.00	NA	2009
Gentoo	Biscoe	48.80	16.20	222.00	6,000.00	male	2009
Gentoo	Biscoe	47.20	13.70	214.00	4,925.00	female	2009
Gentoo	Biscoe	NA	NA	NA	NA	NA	2009
Gentoo	Biscoe	46.80	14.30	215.00	4,850.00	female	2009
Gentoo	Biscoe	50.40	15.70	222.00	5,750.00	male	2009
Gentoo	Biscoe	45.20	14.80	212.00	5,200.00	female	2009
Gentoo	Biscoe	49.90	16.10	213.00	5,400.00	male	2009
Chinstrap	Dream	46.50	17.90	192.00	3,500.00	female	2007
Chinstrap	Dream	50.00	19.50	196.00	3,900.00	male	2007
Chinstrap	Dream	51.30	19.20	193.00	3,650.00	male	2007
Chinstrap	Dream	45.40	18.70	188.00	3,525.00	female	2007
Chinstrap	Dream	52.70	19.80	197.00	3,725.00	male	2007
Chinstrap	Dream	45.20	17.80	198.00	3,950.00	female	2007
Chinstrap	Dream	46.10	18.20	178.00	3,250.00	female	2007
Chinstrap	Dream	51.30	18.20	197.00	3,750.00	male	2007
Chinstrap	Dream	46.00	18.90	195.00	4,150.00	female	2007
Chinstrap	Dream	51.30	19.90	198.00	3,700.00	male	2007
Chinstrap	Dream	46.60	17.80	193.00	3,800.00	female	2007
Chinstrap	Dream	51.70	20.30	194.00	3,775.00	male	2007
Chinstrap	Dream	47.00	17.30	185.00	3,700.00	female	2007
Chinstrap	Dream	52.00	18.10	201.00	4,050.00	male	2007
Chinstrap	Dream	45.90	17.10	190.00	3,575.00	female	2007
Chinstrap	Dream	50.50	19.60	201.00	4,050.00	male	2007
Chinstrap	Dream	50.30	20.00	197.00	3,300.00	male	2007
Chinstrap	Dream	58.00	17.80	181.00	3,700.00	female	2007
Chinstrap	Dream	46.40	18.60	190.00	3,450.00	female	2007
Chinstrap	Dream	49.20	18.20	195.00	4,400.00	male	2007
Chinstrap	Dream	42.40	17.30	181.00	3,600.00	female	2007
Chinstrap	Dream	48.50	17.50	191.00	3,400.00	male	2007
Chinstrap	Dream	43.20	16.60	187.00	2,900.00	female	2007
Chinstrap	Dream	50.60	19.40	193.00	3,800.00	male	2007
Chinstrap	Dream	46.70	17.90	195.00	3,300.00	female	2007
Chinstrap	Dream	52.00	19.00	197.00	4,150.00	male	2007
Chinstrap	Dream	50.50	18.40	200.00	3,400.00	female	2008
Chinstrap	Dream	49.50	19.00	200.00	3,800.00	male	2008
Chinstrap	Dream	46.40	17.80	191.00	3,700.00	female	2008
Chinstrap	Dream	52.80	20.00	205.00	4,550.00	male	2008
Chinstrap	Dream	40.90	16.60	187.00	3,200.00	female	2008
Chinstrap	Dream	54.20	20.80	201.00	4,300.00	male	2008
Chinstrap	Dream	42.50	16.70	187.00	3,350.00	female	2008
Chinstrap	Dream	51.00	18.80	203.00	4,100.00	male	2008
Chinstrap	Dream	49.70	18.60	195.00	3,600.00	male	2008
Chinstrap	Dream	47.50	16.80	199.00	3,900.00	female	2008
Chinstrap	Dream	47.60	18.30	195.00	3,850.00	female	2008
Chinstrap	Dream	52.00	20.70	210.00	4,800.00	male	2008
Chinstrap	Dream	46.90	16.60	192.00	2,700.00	female	2008
Chinstrap	Dream	53.50	19.90	205.00	4,500.00	male	2008
Chinstrap	Dream	49.00	19.50	210.00	3,950.00	male	2008
Chinstrap	Dream	46.20	17.50	187.00	3,650.00	female	2008
Chinstrap	Dream	50.90	19.10	196.00	3,550.00	male	2008
Chinstrap	Dream	45.50	17.00	196.00	3,500.00	female	2008
Chinstrap	Dream	50.90	17.90	196.00	3,675.00	female	2009
Chinstrap	Dream	50.80	18.50	201.00	4,450.00	male	2009
Chinstrap	Dream	50.10	17.90	190.00	3,400.00	female	2009
Chinstrap	Dream	49.00	19.60	212.00	4,300.00	male	2009
Chinstrap	Dream	51.50	18.70	187.00	3,250.00	male	2009
Chinstrap	Dream	49.80	17.30	198.00	3,675.00	female	2009
Chinstrap	Dream	48.10	16.40	199.00	3,325.00	female	2009
Chinstrap	Dream	51.40	19.00	201.00	3,950.00	male	2009
Chinstrap	Dream	45.70	17.30	193.00	3,600.00	female	2009
Chinstrap	Dream	50.70	19.70	203.00	4,050.00	male	2009
Chinstrap	Dream	42.50	17.30	187.00	3,350.00	female	2009
Chinstrap	Dream	52.20	18.80	197.00	3,450.00	male	2009
Chinstrap	Dream	45.20	16.60	191.00	3,250.00	female	2009
Chinstrap	Dream	49.30	19.90	203.00	4,050.00	male	2009
Chinstrap	Dream	50.20	18.80	202.00	3,800.00	male	2009
Chinstrap	Dream	45.60	19.40	194.00	3,525.00	female	2009
Chinstrap	Dream	51.90	19.50	206.00	3,950.00	male	2009
Chinstrap	Dream	46.80	16.50	189.00	3,650.00	female	2009
Chinstrap	Dream	45.70	17.00	195.00	3,650.00	female	2009
Chinstrap	Dream	55.80	19.80	207.00	4,000.00	male	2009
Chinstrap	Dream	43.50	18.10	202.00	3,400.00	female	2009
Chinstrap	Dream	49.60	18.20	193.00	3,775.00	male	2009
Chinstrap	Dream	50.80	19.00	210.00	4,100.00	male	2009
Chinstrap	Dream	50.20	18.70	198.00	3,775.00	female	2009
¹ Data collected by Dr. Kristen Gorman

1 Introduction

Overview

Session key topics

The gt Tables Workflow

2 Our data set

Creating our Data.Frame

We will also use the palmerpenguins data set

3 Creating a Simple Table from a Data Frame

3.1 Basic Formatting Options

Exercise 1

Exercise 2

Exercise 3

3.2 How can we customize our tables to include more advanced features?

Apply Conditional Formatting

Customize the column labels in your table

Exercise 4

Exercise 5

The `gt` Tables Workflow

We will also use the `palmerpenguins` data set