flattabler (version 2.1.2)

fill_labels: Fill in missing labels

Description

Fills missing values in row and column labels for a pivot table. By default, columns are filled down and rows are filled right.

Usage

fill_labels(pt, down, right)
# S3 method for pivot_table
fill_labels(pt, down = TRUE, right = TRUE)

Value

A pivot_table object.

Arguments

pt

A pivot_table object.

down

A boolean, fill down.

right

A boolean, fill right.

Details

A pivot table should only contain label rows and columns, and an array of values, usually numeric data. The row and column closest to the data array are not filled (they must have data defined for each cell).

To correctly carry out this operation, the number of rows and columns that contain labels must be defined, and the table must only contain the pivot table rows and columns.

See Also

pivot_table

Other pivot table transformation functions: extract_labels(), fill_values(), remove_agg(), remove_bottom(), remove_cols(), remove_empty(), remove_k(), remove_left(), remove_right(), remove_rows(), remove_top(), replace_dec(), unpivot()

Examples

pt <-
  pt_ex |>
  remove_top(1) |>
  define_labels(n_col = 2, n_row = 2) |>
  fill_labels(down = TRUE, right = TRUE)