extract_labels: Extract labels

In flattabler: Obtaining a Flat Table from Pivot Tables

Extract labels

Description

Extract the given set of labels from a table column in compact format to generate a new column in the table.

Usage

extract_labels(pt, col, labels)

## S3 method for class 'pivot_table'
extract_labels(pt, col = 1, labels = c())

Arguments

pt	A pivot_table object.
col	A number, column from which labels are extracted.
labels	A vector of strings, set of labels to extract.

Details

Sometimes a table column includes values of multiple label fields, this is generally known as compact table format. Given a column number and a set of labels, it generates a new column with the labels located at the positions they occupied in the original column and removes them from it.

Value

A pivot_table object.

See Also

pivot_table

Other pivot table transformation functions: fill_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 <- pivot_table(df_ex_compact) |>
  extract_labels(col = 1, labels = c("b1", "b2", "b3", "b4", "Total general"))

flattabler documentation built on Sept. 15, 2023, 1:06 a.m.