Remove monotonous columns from a table tibble

Usage

table_minimize(table_df, remove_monotonous_data = TRUE)

Arguments

table_df: A tibble returned by get_tables().
remove_monotonous_data: Remove columns where all values are identical.

Value

A tibble.

Examples

# \donttest{
scb <- px_api("scb", lang = "en")
if (px_available(scb)) {
  get_tables(scb, query = "population") |> table_minimize()
}# }
#> # A tibble: 613 × 10
#>    id    title updated first_period last_period time_unit variables subject_code
#>    <chr> <chr> <chr>   <chr>        <chr>       <chr>     <list>    <chr>       
#>  1 TAB6… Popu… 2026-1… 2025M01      2026M08     Monthly   <list>    BE          
#>  2 TAB1… Popu… 2025-0… 2000M01      2024M12     Monthly   <list>    BE          
#>  3 TAB6… Popu… 2026-0… 2025         2026        Annual    <list>    BE          
#>  4 TAB5… Popu… 2025-0… 2000         2024        Annual    <list>    BE          
#>  5 TAB4… Popu… 2026-0… 1960         2024        Annual    <list>    MI          
#>  6 TAB4… Popu… 2026-0… 2000         2024        Annual    <list>    MI          
#>  7 TAB4… Popu… 2026-0… 2013         2025        Annual    <list>    MI          
#>  8 TAB4… Gain… 2022-0… 2015         2020        Annual    <list>    MI          
#>  9 TAB4… Popu… 2026-0… 2000         2024        Annual    <list>    MI          
#> 10 TAB4… Popu… 2022-1… 2000         2020        Annual    <list>    MI          
#> # ℹ 603 more rows
#> # ℹ 2 more variables: subject_path <chr>, source <chr>