Package: flattabler 2.1.2.9000

flattabler: Obtaining a Flat Table from Pivot Tables

Transformations that allow obtaining a flat table from reports in text or Excel format that contain data in the form of pivot tables. They can be defined for a single report and applied to a set of reports.

Authors:Jose Samos [aut, cre], Universidad de Granada [cph]

flattabler_2.1.2.9000.tar.gz
flattabler_2.1.2.9000.zip(r-4.5)flattabler_2.1.2.9000.zip(r-4.4)flattabler_2.1.2.9000.zip(r-4.3)
flattabler_2.1.2.9000.tgz(r-4.4-any)flattabler_2.1.2.9000.tgz(r-4.3-any)
flattabler_2.1.2.9000.tar.gz(r-4.5-noble)flattabler_2.1.2.9000.tar.gz(r-4.4-noble)
flattabler_2.1.2.9000.tgz(r-4.4-emscripten)flattabler_2.1.2.9000.tgz(r-4.3-emscripten)
flattabler.pdf |flattabler.html✨
flattabler/json (API)
NEWS

# Install 'flattabler' in R:
install.packages('flattabler', repos = c('https://josesamos.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/josesamos/flattabler/issues

Datasets:
  • 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
  • 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
  • pf_ex_compact - Pivot table result of transforming a data frame with a column with data from two label fields
  • pt_ex - Pivot table with with thousands indicator and decimal numbers

On CRAN:

26 exports 2 stars 1.53 score 32 dependencies 7 scripts 321 downloads

Last updated 5 months agofrom:86db1393ad. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 29 2024
R-4.5-winOKAug 29 2024
R-4.5-linuxOKAug 29 2024
R-4.4-winOKAug 29 2024
R-4.4-macOKAug 29 2024
R-4.3-winOKAug 29 2024
R-4.3-macOKAug 29 2024

Exports:define_labelsdivideextract_labelsfill_labelsfill_valuesflatten_table_listget_col_valuesget_pagepivot_tableread_excel_fileread_excel_folderread_excel_sheetread_text_fileread_text_folderremove_aggremove_bottomremove_colsremove_emptyremove_kremove_leftremove_rightremove_rowsremove_topreplace_decset_pageunpivot

Dependencies:bitbit64cellrangerclicliprcpp11crayondplyrfansigenericsgluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogressR6readrreadxlrematchrlangstringistringrtibbletidyselecttzdbutf8vctrsvroomwithr

Transforming a pivot table into a flat table with the flattabler package

Jose Samos ([email protected])

Rendered fromflattabler.Rmdusingknitr::rmarkdownon Aug 29 2024.

Last update: 2023-08-09
Started: 2020-06-27

Readme and manuals

Help Manual

Help pageTopics
Define the quantity of rows and columns that contain labelsdefine_labels define_labels.pivot_table
Pivot table in data frame with with thousands indicator and decimal numbersdf_ex
Pivot table in data frame with a column with data from two label fieldsdf_ex_compact
Pivot table with basic and subtotal labels in the same columndf_pivottabler
Set of pivot tables placed horizontally on one sheetdf_set_h
Set of pivot tables on one sheetdf_set_h_v
Set of pivot tables placed vertically on one sheetdf_set_v
Divide tabledivide divide.pivot_table
Extract labelsextract_labels extract_labels.pivot_table
Fill in missing labelsfill_labels fill_labels.pivot_table
Fill in missing valuesfill_values fill_values.pivot_table
Transform a 'pivot_table' object list into a flat tableflatten_table_list
Flat table with page from a pivot table with with thousands indicator and decimal numbersft_ex
Flat table without page from a pivot table with with thousands indicator and decimal numbersft_ex_v2
Flat table with page from a pivot table with with thousands indicator and decimal numbersft_set
Get column valuesget_col_values
Get the page information of a pivot tableget_page get_page.pivot_table
Pivot table result of transforming a data frame with a column with data from two label fieldspf_ex_compact
'pivot_table' S3 classpivot_table
Pivot table with with thousands indicator and decimal numberspt_ex
Import Excel fileread_excel_file
Import one sheet from each Excel file in a folderread_excel_folder
Import Excel file sheetread_excel_sheet
Import text fileread_text_file
Import all text files in a folderread_text_folder
Remove rows and columns with aggregated dataremove_agg remove_agg.pivot_table
Remove bottom rows from a pivot tableremove_bottom remove_bottom.pivot_table
Remove columns from a pivot tableremove_cols remove_cols.pivot_table
Remove empty rows and columns from a pivot tableremove_empty remove_empty.pivot_table
Remove thousands separatorremove_k remove_k.pivot_table
Remove left columns from a pivot tableremove_left remove_left.pivot_table
Remove right columns from a pivot tableremove_right remove_right.pivot_table
Remove rows from a pivot tableremove_rows remove_rows.pivot_table
Remove top rows from a pivot tableremove_top remove_top.pivot_table
Replace decimal separatorreplace_dec replace_dec.pivot_table
Set page information to a pivot tableset_page set_page.pivot_table
Unpivot a pivot tableunpivot unpivot.pivot_table