remove_rows: Remove rows from a pivot table

In flattabler: Obtaining a Flat Table from Pivot Tables

Remove rows from a pivot table

Description

Remove the rows whose numbers are indicated from the pivot table represented by the object.

Usage

remove_rows(pt, r)

## S3 method for class 'pivot_table'
remove_rows(pt, r)

Arguments

pt	A pivot_table object.
r	A vector of numbers, row numbers.

Details

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

All rows not belonging to the pivot table must be removed. It is common to find rows with header or footer information, which must be removed.

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_empty(), remove_k(), remove_left(), remove_right(), remove_top(), replace_dec(), unpivot()

Examples

pt <- pt_ex |> remove_rows(1)

pt <- pt_ex |> remove_rows(c(1, 8, 14, 19, 25, 26))

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