remove_empty: Remove empty rows and columns from a pivot table

In flattabler: Obtaining a Flat Table from Pivot Tables

Remove empty rows and columns from a pivot table

Description

Remove rows and columns without data from the pivot table represented by the object.

Usage

remove_empty(pt)

## S3 method for class 'pivot_table'
remove_empty(pt)

Arguments

pt	A pivot_table object.

Details

A pivot table should only contain label rows and columns, and an array of values, usually numeric data.

All rows and columns not belonging to the pivot table must be removed, including those without data.

Value

A pivot_table object.

See Also

pivot_table

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

Examples

df <- df_ex
df[seq(from = 1, to = 25, by = 2), ] <- " "
df[, seq(from = 1, to = 7, by = 2)] <- " "
pt <- pivot_table(df)
pt <- pt |> remove_empty()

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