Obtaining a Flat Table from Pivot Tables


[Up] [Top]

Documentation for package ‘flattabler’ version 2.1.1

Help Pages

define_labels Define the quantity of rows and columns that contain labels
define_labels.pivot_table 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
divide.pivot_table Divide table
extract_labels Extract labels
extract_labels.pivot_table Extract labels
fill_labels Fill in missing labels
fill_labels.pivot_table Fill in missing labels
fill_values Fill in missing values
fill_values.pivot_table 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
get_page.pivot_table 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_agg.pivot_table Remove rows and columns with aggregated data
remove_bottom Remove bottom rows from a pivot table
remove_bottom.pivot_table Remove bottom rows from a pivot table
remove_cols Remove columns from a pivot table
remove_cols.pivot_table Remove columns from a pivot table
remove_empty Remove empty rows and columns from a pivot table
remove_empty.pivot_table Remove empty rows and columns from a pivot table
remove_k Remove thousands separator
remove_k.pivot_table Remove thousands separator
remove_left Remove left columns from a pivot table
remove_left.pivot_table Remove left columns from a pivot table
remove_right Remove right columns from a pivot table
remove_right.pivot_table Remove right columns from a pivot table
remove_rows Remove rows from a pivot table
remove_rows.pivot_table Remove rows from a pivot table
remove_top Remove top rows from a pivot table
remove_top.pivot_table Remove top rows from a pivot table
replace_dec Replace decimal separator
replace_dec.pivot_table Replace decimal separator
set_page Set page information to a pivot table
set_page.pivot_table Set page information to a pivot table
unpivot Unpivot a pivot table
unpivot.pivot_table Unpivot a pivot table