Skip to contents

Simplify a Kolada values table, i.e as created by get_values, by removing columns that contain monotonous data, i.e. that contain only one value for all observations.

Usage

values_minimize(values_df)

Arguments

values_df

A Kolada value table, as created by get_values.

Value

A Kolada values table

Examples

# Download values for all available years of a given KPI for
# Malmö municipality (code 1280)
if (kolada_available()) {
vals <- get_values(kpi = "N45933", municipality = "1280", simplify = TRUE)
# (Returns a table with 5 rows and 8 columns)

# Remove columns with no information to differentiate between rows
values_minimize(vals)
# (Returns a table with 5 rows and 4 columns)
}
#> # A tibble: 7 × 4
#>   kpi     year value municipality
#>   <chr>  <int> <dbl> <chr>       
#> 1 N45933  2016  24.8 Malmö       
#> 2 N45933  2017  26.7 Malmö       
#> 3 N45933  2018  38.0 Malmö       
#> 4 N45933  2019  35.6 Malmö       
#> 5 N45933  2020  30.3 Malmö       
#> 6 N45933  2021  21.2 Malmö       
#> 7 N45933  2022  24.2 Malmö