Examples

• Filter rows and add columns

  Keep the penguins with a recorded body mass, and add the mass in kilograms and a size label.

• Summarize groups

  Count the penguins and find the mean and largest body mass for each species, with some masses missing.

• Join two tables

  Add airport names and altitudes to hourly weather readings from the nycflights13 tables.

• Pivot between wide and long

  Count penguins per species with one column per study year, then stack the years into rows.

• Query a database table · from phibble

  Summarize nycflights13 weather by airport in SQLite, inspect the query, and collect the result.