Possible improvements to the tableinfo dataset

[tylerlittlefield]

The tableinfo dataset is pretty much a raw representation of the tables found at each individual link shown here: https://exoplanetarchive.ipac.caltech.edu/docs/TAP/usingTAP.html

There could be some possible areas of improvement such as replacing "X" with TRUE, i.e. something more familiar to R users. Below are some ideas:

library(dplyr)

tableinfo %>% 
  # remove all trailing/leading whitespace
  mutate(across(
    .cols = where(is.character), 
    .fns = stringr::str_squish
  )) %>% 
  # replace all empty character values with NA
  mutate(across(
    .cols = where(is.character), 
    .fns = dplyr::na_if, 
    ""
  )) %>% 
  # if "X" return TRUE
  mutate(across(
    .cols = where(is.character), 
    .fns = ~ ifelse(
      test = .x == "X", 
      yes = TRUE, 
      no = .x
    )
  ))