cols_hide() function allows us to hide one or more columns from
appearing in the final output table. While it's possible and often desirable
to omit columns from the input table data before introduction to the
function, there can be cases where the data in certain columns is useful (as
a column reference during formatting of other columns) but the final display
of those columns is not necessary.
A table object that is created using the
The column names to hide from the output display table. The order of the remaining columns will be preserved. Values provided that do not correspond to column names will be disregarded.
An object of class
The hiding of columns is internally a rendering directive, so, all columns
that are 'hidden' are still accessible and useful in any expression provided
rows argument. Furthermore, the
cols_hide() function (as with many
gt functions) can be placed anywhere in a pipeline of gt function
calls (acting as a promise to hide columns when the timing is right). However
there's perhaps greater readability when placing this call closer to the end
of such a pipeline.
# Use `countrypops` to create a gt table; # Hide the columns `country_code_2` and # `country_code_3` tab_1 <- countrypops %>% dplyr::filter(country_name == "Mongolia") %>% tail(5) %>% gt() %>% cols_hide( columns = vars( country_code_2, country_code_3) ) # Use `countrypops` to create a gt table; # Use the `population` column to provide # the conditional placement of footnotes, # then hide that column and one other tab_2 <- countrypops %>% dplyr::filter(country_name == "Mongolia") %>% tail(5) %>% gt() %>% cols_hide( columns = vars(country_code_3, population) ) %>% tab_footnote( footnote = "Population above 3,000,000.", locations = cells_body( columns = vars(year), rows = population > 3000000) )