Function reference

All functions

define_labels()

Define the quantity of rows and columns that contain labels

df_ex

Pivot table in data frame with with thousands indicator and decimal numbers

df_ex_compact

Pivot table in data frame with a column with data from two label fields

df_pivottabler

Pivot table with basic and subtotal labels in the same column

df_set_h

Set of pivot tables placed horizontally on one sheet

df_set_h_v

Set of pivot tables on one sheet

df_set_v

Set of pivot tables placed vertically on one sheet

divide()

Divide table

extract_labels()

Extract labels

fill_labels()

Fill in missing labels

fill_values()

Fill in missing values

flatten_table_list()

Transform a pivot_table object list into a flat table

ft_ex

Flat table with page from a pivot table with with thousands indicator and decimal numbers

ft_ex_v2

Flat table without page from a pivot table with with thousands indicator and decimal numbers

ft_set

Flat table with page from a pivot table with with thousands indicator and decimal numbers

get_col_values()

Get column values

get_page()

Get the page information of a pivot table

pf_ex_compact

Pivot table result of transforming a data frame with a column with data from two label fields

pivot_table()

pivot_table S3 class

pt_ex

Pivot table with with thousands indicator and decimal numbers

read_excel_file()

Import Excel file

read_excel_folder()

Import one sheet from each Excel file in a folder

read_excel_sheet()

Import Excel file sheet

read_text_file()

Import text file

read_text_folder()

Import all text files in a folder

remove_agg()

Remove rows and columns with aggregated data

remove_bottom()

Remove bottom rows from a pivot table

remove_cols()

Remove columns from a pivot table

remove_empty()

Remove empty rows and columns from a pivot table

remove_k()

Remove thousands separator

remove_left()

Remove left columns from a pivot table

remove_right()

Remove right columns from a pivot table

remove_rows()

Remove rows from a pivot table

remove_top()

Remove top rows from a pivot table

replace_dec()

Replace decimal separator

set_page()

Set page information to a pivot table

unpivot()

Unpivot a pivot table