Get started with APIs

TODO

• Skip tidyverse, re-integrate schemas?

️✅ Learning objectives

• Fetch json-formatted data from the web.
• Parse nested lists with the {tidyverse}.

library(dplyr)
library(jsonlite)
library(purrr)
library(tibble)
library(tidyr)

• Has anybody used:
  • nested lists (unnest)
  • tibble::enframe()

Where can I find APIs?

• I’m very likely going to build a replacement for APIs.guru.
  • Doesn’t update often enough.
  • Most recent merge: March 8, 2023
  • It should live up to its name, and be easier to update!
• But principles will still hold!

API Directories

• APIs.guru)
• publicapis.dev)
  • publicapis.dev GitHub

• Warning: No API database is complete! Just because it isn’t here doesn’t mean it doesn’t exist!
• Good if you know what you’re looking for
• Less good for exploration
• But we can grab the data from APIS.guru directly!

The APIs.guru API List

• (list.json result)

• JSON = JavaScript Object Notation
• By far most common format for API data
• I’m using JSONVue browser extension
• JSON: Great for nested data
• We aren’t going to dig into the format yet because we won’t use it directly

Fetch all APIs.guru APIs

all_apis <- jsonlite::fromJSON("https://api.apis.guru/v2/list.json")

length(all_apis)

#> [1] 2529

head(names(all_apis))

#> [1] "1forge.com"                    "1password.com:events"         
#> [3] "1password.local:connect"       "6-dot-authentiqio.appspot.com"
#> [5] "ably.io:platform"              "ably.net:control"

purrr::pluck_depth(all_apis)

#> [1] 10

str(head(all_apis, 2), max.level = 2)

#> List of 2
#>  $ 1forge.com          :List of 3
#>   ..$ added    : chr "2017-05-30T08:34:14.000Z"
#>   ..$ preferred: chr "0.0.1"
#>   ..$ versions :List of 1
#>  $ 1password.com:events:List of 3
#>   ..$ added    : chr "2021-07-19T10:17:09.188Z"
#>   ..$ preferred: chr "1.0.0"
#>   ..$ versions :List of 1

• jsonlite = one of several packages for parsing JSON
  • We’ll stick with it because it works & is used by higher-level packages
  • Used in {shiny}, {httr}, {httr2}, dozens of other packages
• fromJSON does some automatic guessing, we’ll come back to this in a later chapter
  • Alternatives: read_json() reads file, parse_json() reads string; don’t guess by default
• This result is a huge, nested list
• purrr::pluck_depth() tells you how nested a list is
• hard to see this. Let’s rectangle it!

Fetch JSON: Exercises

(not written yet, but general idea will be…)

• Provide URLs of JSON-formatted data
  • How many top-level items are described in this data?
  • How deeply is this data nested?
  • What is the X of the Yth item?

• This data will be on the book’s website to avoid changes.

Rectangling data

• “Rectangling” = converting hierarchical data to data frame
• Some background in R4DS Chapter 23: “Hierarchical data”
  • But we’ll use different methods
• Trial-and-error = ok

• Rectangular data is nice because then you can use normal tidyverse functions
• There’s a tidyverse function that I think handles returns from APIs better than what they show there.
• You might need to play around with unnest_wider vs unnest_longer (we’ll see examples in a sec). Don’t feel like you’re doing something wrong!
• In the next chapter (?), we’ll see how to use the API spec (when it’s available) to help us guess less.

Unnesting

• Is value a list of lists of observations?
  • tidyr::unnest_longer(value) separates into rows
• Is value a list of lists of variables?
  • tidyr::unnest_wider(value) separates into columns
• tidyr::unnest_auto() uses heuristic to choose between those

• Tidy data: Every row is a single observation, every column is a single variable.
• “Heuristic” is a fancy word for “set of rules.” I used it here specifically so I can define it and try to demystify it.
• unnest_auto() isn’t perfect.

How does unnest_auto() choose?

flowchart TD
    B{{"How many elements have names?"}}
        B -->|"none"| C["Unnest longer, drop indices"]
        B -->|"some"| C
        B -->|"all"| D{{"Are any names reused?"}}
            D -->|"yes"| E["Unnest wider"]
            D -->|"no"| F["Unnest longer, keep indices"]

Would it be helpful to see this as code?

What does unnest_auto() miss? (1)

Column is a named list (not a list of named lists).

• Error: Names are lost
• Check: rlang::is_named(df$col)
• Fix: dplyr::mutate(col_name = names(col)) before unnesting.

What does unnest_auto() miss? (2)

One or more elements of a list column are empty.

• Error: Assumes unnest_longer(), even if it’s just some missing values among a column that is obviously otherwise unnest_wider-worthy.
• Check: any(lengths(df$col) == 0)
• Fix: Do the unnest_auto() checks only on values of col that have lengths(col) > 0

• An empty item doesn’t have any names.
• Could be NULL or empty list()
• This is relatively common in JSON.

What does unnest_auto() miss? (3)

One or more elements of a list column lacks names, other elements have names.

• Error: Names are lost.
• Check: (flowchart already tests this, but makes the wrong decision)
• Fix: unnest_longer(col, indices_to = "descriptive_name") as fall-through

How should I choose unnest direction?

flowchart TD
    A{{"Is the overall column named?"}}
        A -->|"yes"| AA["Create a names column"]
            AA --> B
        A -->|"no"| B
    B{{"How many non-empty elements have names?"}}
        B -->|"none"| C["Unnest longer, drop indices"]
        B -->|"some"| F
        B -->|"all"| D{{"Are any names reused?"}}
            D -->|"yes"| E["Unnest wider"]
            D -->|"no"| F["Unnest longer, keep indices"]

• Does the overall column have names? Avoid losing the names
• For the name check, only use non-empty names.
• When all have names you should validate! Overlapping names could be coincidental (eg, first version is always “v1”, some have additional versions)
• When you keep indices, you should give them a descriptive name.
• We’ll see this in code as we go.

Rectangling APIs.guru’s list

enframe()

all_apis_df <- all_apis |>
  tibble::enframe(name = "api_name")

all_apis_df

#> # A tibble: 2,529 × 2
#>    api_name                      value           
#>    <chr>                         <list>          
#>  1 1forge.com                    <named list [3]>
#>  2 1password.com:events          <named list [3]>
#>  3 1password.local:connect       <named list [3]>
#>  4 6-dot-authentiqio.appspot.com <named list [3]>
#>  5 ably.io:platform              <named list [3]>
#>  6 ably.net:control              <named list [3]>
#>  7 abstractapi.com:geolocation   <named list [3]>
#>  8 adafruit.com                  <named list [3]>
#>  9 adobe.com:aem                 <named list [3]>
#> 10 adyen.com:AccountService      <named list [3]>
#> # ℹ 2,519 more rows

• tibble::enframe() is underused, imo!
• Best with named lists
• name arg is often useful (if input is named)
  • If it isn’t named, set to NULL
• value arg is available but we’re almost always going to destroy that column
• Need to figure out whether those values are blocks of results (rows) or separate pieces of information about a single result (columns)

value column: Unnest wider or longer?

(incorporate flowchart once it exists)

rlang::is_named(all_apis_df$value)

#> [1] FALSE

non_empties <- all_apis_df$value[lengths(all_apis_df$value) > 0]
element_names <- purrr::map(non_empties, names)
has_null <- unique(purrr::map_lgl(element_names, is.null))

has_null

#> [1] FALSE

common_names <- purrr::reduce(element_names, intersect)

common_names

#> [1] "added"     "preferred" "versions"

• Wider if multiple variables per value, longer if multiple observations per value.
• The purrr reduce thing checks for names that everything shares (inspired by unnest_auto).
• (make sure everyone groks why wider)

Unnest values

all_apis_versions <- all_apis_df |>
  tidyr::unnest_wider(value)

all_apis_versions

#> # A tibble: 2,529 × 4
#>    api_name                      added                    preferred versions    
#>    <chr>                         <chr>                    <chr>     <list>      
#>  1 1forge.com                    2017-05-30T08:34:14.000Z 0.0.1     <named list>
#>  2 1password.com:events          2021-07-19T10:17:09.188Z 1.0.0     <named list>
#>  3 1password.local:connect       2021-04-16T15:56:45.939Z 1.5.7     <named list>
#>  4 6-dot-authentiqio.appspot.com 2017-03-15T14:45:58.000Z 6         <named list>
#>  5 ably.io:platform              2019-07-13T11:28:07.000Z 1.1.0     <named list>
#>  6 ably.net:control              2021-07-26T09:45:31.536Z 1.0.14    <named list>
#>  7 abstractapi.com:geolocation   2021-04-14T17:12:40.648Z 1.0.0     <named list>
#>  8 adafruit.com                  2018-02-10T10:41:43.000Z 2.0.0     <named list>
#>  9 adobe.com:aem                 2019-01-03T07:01:34.000Z 3.7.1-pr… <named list>
#> 10 adyen.com:AccountService      2023-02-17T11:02:20.620Z 6         <named list>
#> # ℹ 2,519 more rows

What if we went longer?

all_apis_df |>
  tidyr::unnest_longer(value)

#> # A tibble: 7,587 × 3
#>    api_name                      value            value_id 
#>    <chr>                         <named list>     <chr>    
#>  1 1forge.com                    <chr [1]>        added    
#>  2 1forge.com                    <chr [1]>        preferred
#>  3 1forge.com                    <named list [1]> versions 
#>  4 1password.com:events          <chr [1]>        added    
#>  5 1password.com:events          <chr [1]>        preferred
#>  6 1password.com:events          <named list [1]> versions 
#>  7 1password.local:connect       <chr [1]>        added    
#>  8 1password.local:connect       <chr [1]>        preferred
#>  9 1password.local:connect       <named list [1]> versions 
#> 10 6-dot-authentiqio.appspot.com <chr [1]>        added    
#> # ℹ 7,577 more rows

• Thankfully going the wrong way is often obvious.
• tidyr::unnest() creates this same monstrosity

choose_unnest_direction()

# Based on `tidyr::unnest_auto` and `tidyr:::guess_dir`
choose_unnest_direction <- function(df, col) {
  col <- tidyselect::vars_pull(dplyr::tbl_vars(df), {{col}})
  col_contents <- df[[col]]
  code <- character()
  
  if (rlang::is_named(col_contents)) {
    code <- c(
      code,
      glue::glue(
        "dplyr::mutate(descriptive_name = names({col}), .before = {col})"
      )
    )
  }
  
  non_empties <- col_contents[lengths(col_contents) > 0]
  
  element_names <- purrr::map(non_empties, names)
  has_null <- unique(purrr::map_lgl(element_names, is.null))
  if (identical(has_null, TRUE)) {
    code <- c(
      code, 
      glue::glue("tidyr::unnest_longer({col}, indices_include = FALSE)")
    )
    return(glue::glue_collapse(code, sep = " |>\n  "))
  } else if (identical(has_null, FALSE)) {
    common_names <- purrr::reduce(element_names, intersect)
    n_common <- length(common_names)
    if (n_common > 0) {
      code <- c(
        code,
        glue::glue("tidyr::unnest_wider({col})")
      )
      return(glue::glue_collapse(code, sep = " |>\n  "))
    }
  }
  code <- c(
    code,
    glue::glue("tidyr::unnest_longer({col}, indices_to = \"descriptive_name\")")
  )
  return(glue::glue_collapse(code, sep = " |>\n  "))
}

This has some tidyeval, so I’ll probably move it to a package and talk about it or put it online to copy/paste, rather than showing the code here

Unnest versions: Wider or longer?

rlang::is_named(all_apis_versions$versions)

#> [1] FALSE

non_empties <- all_apis_versions$versions[lengths(all_apis_versions$versions) > 0]
element_names <- purrr::map(non_empties, names)
has_null <- unique(purrr::map_lgl(element_names, is.null))

has_null

#> [1] FALSE

common_names <- purrr::reduce(element_names, intersect)

common_names

#> character(0)

choose_unnest_direction(all_apis_versions, versions)

#> tidyr::unnest_longer(versions, indices_to = "descriptive_name")

Unnest versions

all_apis_longer <- all_apis_versions |>
  tidyr::unnest_longer(versions, indices_to = "version")

all_apis_longer

#> # A tibble: 3,992 × 5
#>    api_name                      added            preferred versions     version
#>    <chr>                         <chr>            <chr>     <named list> <chr>  
#>  1 1forge.com                    2017-05-30T08:3… 0.0.1     <named list> 0.0.1  
#>  2 1password.com:events          2021-07-19T10:1… 1.0.0     <named list> 1.0.0  
#>  3 1password.local:connect       2021-04-16T15:5… 1.5.7     <named list> 1.5.7  
#>  4 6-dot-authentiqio.appspot.com 2017-03-15T14:4… 6         <named list> 6      
#>  5 ably.io:platform              2019-07-13T11:2… 1.1.0     <named list> 1.1.0  
#>  6 ably.net:control              2021-07-26T09:4… 1.0.14    <named list> 1.0.14 
#>  7 abstractapi.com:geolocation   2021-04-14T17:1… 1.0.0     <named list> 1.0.0  
#>  8 adafruit.com                  2018-02-10T10:4… 2.0.0     <named list> 2.0.0  
#>  9 adobe.com:aem                 2019-01-03T07:0… 3.7.1-pr… <named list> 3.7.1-…
#> 10 adyen.com:AccountService      2023-02-17T11:0… 6         <named list> 3      
#> # ℹ 3,982 more rows

What if we went wider?

all_apis_versions |> head() |> tidyr::unnest_wider(versions)

#> # A tibble: 6 × 9
#>   api_name   added preferred `0.0.1`      `1.0.0`      `1.5.7`      `6`         
#>   <chr>      <chr> <chr>     <list>       <list>       <list>       <list>      
#> 1 1forge.com 2017… 0.0.1     <named list> <NULL>       <NULL>       <NULL>      
#> 2 1password… 2021… 1.0.0     <NULL>       <named list> <NULL>       <NULL>      
#> 3 1password… 2021… 1.5.7     <NULL>       <NULL>       <named list> <NULL>      
#> 4 6-dot-aut… 2017… 6         <NULL>       <NULL>       <NULL>       <named list>
#> 5 ably.io:p… 2019… 1.1.0     <NULL>       <NULL>       <NULL>       <NULL>      
#> 6 ably.net:… 2021… 1.0.14    <NULL>       <NULL>       <NULL>       <NULL>      
#> # ℹ 2 more variables: `1.1.0` <list>, `1.0.14` <list>

• head() because otherwise we have something like 800 new columns
• Note the NULLs

Preferred versions

all_apis_preferred <- all_apis_longer |>
  dplyr::filter(preferred == version) |>
  dplyr::select(api_name, version, versions)

all_apis_preferred

#> # A tibble: 2,529 × 3
#>    api_name                      version     versions        
#>    <chr>                         <chr>       <named list>    
#>  1 1forge.com                    0.0.1       <named list [7]>
#>  2 1password.com:events          1.0.0       <named list [7]>
#>  3 1password.local:connect       1.5.7       <named list [7]>
#>  4 6-dot-authentiqio.appspot.com 6           <named list [7]>
#>  5 ably.io:platform              1.1.0       <named list [7]>
#>  6 ably.net:control              1.0.14      <named list [7]>
#>  7 abstractapi.com:geolocation   1.0.0       <named list [8]>
#>  8 adafruit.com                  2.0.0       <named list [7]>
#>  9 adobe.com:aem                 3.7.1-pre.0 <named list [7]>
#> 10 adyen.com:AccountService      6           <named list [7]>
#> # ℹ 2,519 more rows

Preferred versions: Wider or longer?

choose_unnest_direction(all_apis_preferred, versions)

#> dplyr::mutate(descriptive_name = names(versions), .before = versions) |>
#>   tidyr::unnest_wider(versions)

head(names(all_apis_preferred$versions))

#> [1] "0.0.1"  "1.0.0"  "1.5.7"  "6"      "1.1.0"  "1.0.14"

all_apis_preferred_wide <- all_apis_preferred |>
  tidyr::unnest_wider(versions)

• We already dealt with these names, don’t need the mutate.

Preferred versions unnested

all_apis_preferred_wide

#> # A tibble: 2,529 × 10
#>    api_name         version added info         updated swaggerUrl swaggerYamlUrl
#>    <chr>            <chr>   <chr> <list>       <chr>   <chr>      <chr>         
#>  1 1forge.com       0.0.1   2017… <named list> 2017-0… https://a… https://api.a…
#>  2 1password.com:e… 1.0.0   2021… <named list> 2023-0… https://a… https://api.a…
#>  3 1password.local… 1.5.7   2021… <named list> 2023-0… https://a… https://api.a…
#>  4 6-dot-authentiq… 6       2017… <named list> 2021-0… https://a… https://api.a…
#>  5 ably.io:platform 1.1.0   2019… <named list> 2021-0… https://a… https://api.a…
#>  6 ably.net:control 1.0.14  2021… <named list> 2021-0… https://a… https://api.a…
#>  7 abstractapi.com… 1.0.0   2021… <named list> 2021-0… https://a… https://api.a…
#>  8 adafruit.com     2.0.0   2018… <named list> 2021-0… https://a… https://api.a…
#>  9 adobe.com:aem    3.7.1-… 2019… <named list> 2023-0… https://a… https://api.a…
#> 10 adyen.com:Accou… 6       2023… <named list> 2023-0… https://a… https://api.a…
#> # ℹ 2,519 more rows
#> # ℹ 3 more variables: openapiVer <chr>, link <chr>, externalDocs <list>

Preferred versions glimpse

dplyr::glimpse(all_apis_preferred_wide)

#> Rows: 2,529
#> Columns: 10
#> $ api_name       <chr> "1forge.com", "1password.com:events", "1password.local:…
#> $ version        <chr> "0.0.1", "1.0.0", "1.5.7", "6", "1.1.0", "1.0.14", "1.0…
#> $ added          <chr> "2017-05-30T08:34:14.000Z", "2021-07-19T10:17:09.188Z",…
#> $ info           <list> [["contact@1forge.com", "1Forge", "http://1forge.com"]…
#> $ updated        <chr> "2017-06-27T16:49:57.000Z", "2023-02-27T15:08:09.418Z",…
#> $ swaggerUrl     <chr> "https://api.apis.guru/v2/specs/1forge.com/0.0.1/swagge…
#> $ swaggerYamlUrl <chr> "https://api.apis.guru/v2/specs/1forge.com/0.0.1/swagge…
#> $ openapiVer     <chr> "2.0", "3.0.0", "3.0.2", "3.0.0", "3.0.1", "3.0.1", "3.…
#> $ link           <chr> "https://api.apis.guru/v2/specs/1forge.com/0.0.1.json",…
#> $ externalDocs   <list> <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, ["API …

info: wider or longer?

choose_unnest_direction(all_apis_preferred_wide, info)

#> tidyr::unnest_wider(info)

all_apis_preferred_wide |> 
  tidyr::unnest_wider(info, names_sep = "_")

#> # A tibble: 2,529 × 76
#>    api_name  version added info_contact info_description info_title info_version
#>    <chr>     <chr>   <chr> <list>       <chr>            <chr>      <chr>       
#>  1 1forge.c… 0.0.1   2017… <named list> "Stock and Fore… 1Forge Fi… 0.0.1       
#>  2 1passwor… 1.0.0   2021… <NULL>       "1Password Even… Events API 1.0.0       
#>  3 1passwor… 1.5.7   2021… <named list> "REST API inter… 1Password… 1.5.7       
#>  4 6-dot-au… 6       2017… <named list> "Strong authent… Authentiq… 6           
#>  5 ably.io:… 1.1.0   2019… <named list> "The [REST API … Platform … 1.1.0       
#>  6 ably.net… 1.0.14  2021… <named list> "Use the Contro… Control A… 1.0.14      
#>  7 abstract… 1.0.0   2021… <NULL>       "Abstract IP ge… IP geoloc… 1.0.0       
#>  8 adafruit… 2.0.0   2018… <NULL>       "### The Intern… Adafruit … 2.0.0       
#>  9 adobe.co… 3.7.1-… 2019… <named list> "Swagger AEM is… Adobe Exp… 3.7.1-pre.0 
#> 10 adyen.co… 6       2023… <named list> "This API is us… Account A… 6           
#> # ℹ 2,519 more rows
#> # ℹ 69 more variables: `info_x-apisguru-categories` <list>,
#> #   `info_x-logo` <list>, `info_x-origin` <list>, `info_x-providerName` <chr>,
#> #   `info_x-serviceName` <chr>, info_license <list>, info_termsOfService <chr>,
#> #   `info_x-unofficialSpec` <lgl>, `info_x-preferred` <lgl>,
#> #   `info_x-publicVersion` <lgl>, `info_x-timestamp` <chr>,
#> #   `info_x-description-language` <chr>, `info_x-release-note` <list>, …

• names_sep avoids name overlap & shows us all the things that came from info
• Notice that it went from 10 columns to 76.

info: hoist()

all_preferred_apis_with_categories <- all_apis_preferred_wide |>
  tidyr::hoist(info, categories = "x-apisguru-categories")

all_preferred_apis_with_categories

#> # A tibble: 2,529 × 11
#>    api_name             version added categories info         updated swaggerUrl
#>    <chr>                <chr>   <chr> <list>     <list>       <chr>   <chr>     
#>  1 1forge.com           0.0.1   2017… <chr [1]>  <named list> 2017-0… https://a…
#>  2 1password.com:events 1.0.0   2021… <chr [1]>  <named list> 2023-0… https://a…
#>  3 1password.local:con… 1.5.7   2021… <chr [1]>  <named list> 2023-0… https://a…
#>  4 6-dot-authentiqio.a… 6       2017… <chr [1]>  <named list> 2021-0… https://a…
#>  5 ably.io:platform     1.1.0   2019… <chr [1]>  <named list> 2021-0… https://a…
#>  6 ably.net:control     1.0.14  2021… <chr [1]>  <named list> 2021-0… https://a…
#>  7 abstractapi.com:geo… 1.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#>  8 adafruit.com         2.0.0   2018… <chr [1]>  <named list> 2021-0… https://a…
#>  9 adobe.com:aem        3.7.1-… 2019… <chr [1]>  <named list> 2023-0… https://a…
#> 10 adyen.com:AccountSe… 6       2023… <chr [1]>  <named list> 2023-0… https://a…
#> # ℹ 2,519 more rows
#> # ℹ 4 more variables: swaggerYamlUrl <chr>, openapiVer <chr>, link <chr>,
#> #   externalDocs <list>

Filter APIs

all_apis_preferred_wide |>
  tidyr::hoist(info, categories = "x-apisguru-categories") |>
  dplyr::rowwise() |>
  dplyr::filter("open_data" %in% categories) |>
  dplyr::ungroup()

#> # A tibble: 318 × 11
#>    api_name             version added categories info         updated swaggerUrl
#>    <chr>                <chr>   <chr> <list>     <list>       <chr>   <chr>     
#>  1 amentum.space:aviat… 1.5.0   2021… <chr [2]>  <named list> 2023-0… https://a…
#>  2 amentum.space:gravi… 1.1.1   2021… <chr [2]>  <named list> 2021-0… https://a…
#>  3 amentum.space:space… 1.1.2   2021… <chr [2]>  <named list> 2023-0… https://a…
#>  4 api.gov.uk:vehicle-… 1.1.0   2020… <chr [1]>  <named list> 2021-0… https://a…
#>  5 apis.guru            2.2.0   2015… <chr [2]>  <named list> 2023-0… https://a…
#>  6 apisetu.gov.in:aaha… 3.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#>  7 apisetu.gov.in:acko  3.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#>  8 apisetu.gov.in:agtr… 3.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#>  9 apisetu.gov.in:ahar… 3.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#> 10 apisetu.gov.in:aiim… 3.0.0   2021… <chr [1]>  <named list> 2021-0… https://a…
#> # ℹ 308 more rows
#> # ℹ 4 more variables: swaggerYamlUrl <chr>, openapiVer <chr>, link <chr>,
#> #   externalDocs <list>

• Point here is now we can work with this as data.
• Could also unnest_longer and filter for “open_data”
• swaggerUrl is JSON, swaggerYamlUrl is YAML version of the same thing
• YAML is another data format. Technically YAML is a superset of JSON, with added commenting capabilities.
• RMarkdown headers + package descriptions are YAML-related.
• We’ll see more about YAML and find out what “Swagger” means in the next chapter!

Rectangling: Exercises

• Provide sample (constructed) data, have you choose direction.
• To include:
  • Simple longer.
  • Simple wider.
  • Overall column is named, otherwise nothing to unnest.
  • Overall column is named, then there’s stuff to unnest.
  • Empty values, otherwise clearly wider.
  • unnest_auto() goes wider, but shared names are coincidental.
  • Some elements unnamed, but definitely longer.

Survey

Please let me know what you think about this chapter!

https://forms.gle/jiq4jsaXV6accnNS6