{ "_id": "6a27c69324555f66ed53f9a7", "Package": "flattabler", "Title": "Obtaining a Flat Table from Pivot Tables", "Version": "2.1.2.9000", "Authors@R": "c(\nperson(\"Jose\", \"Samos\", , \"jsamos@ugr.es\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-4457-3439\")),\nperson(\"Universidad de Granada\", role = \"cph\")\n)", "Description": "Transformations that allow obtaining a flat table from\nreports in text or Excel format that contain data in the form\nof pivot tables. They can be defined for a single report and\napplied to a set of reports.", "License": "MIT + file LICENSE", "URL": "https://josesamos.github.io/flattabler/,\nhttps://github.com/josesamos/flattabler", "BugReports": "https://github.com/josesamos/flattabler/issues", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-GB", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.1", "Config/pak/sysreqs": "libicu-dev libx11-dev", "Repository": "https://josesamos.r-universe.dev", "Date/Publication": "2024-05-01 09:16:28 UTC", "RemoteUrl": "https://github.com/josesamos/flattabler", "RemoteRef": "HEAD", "RemoteSha": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-09 07:44:42 UTC", "User": "root" }, "Author": "Jose Samos [aut, cre] (ORCID: ),\nUniversidad de Granada [cph]", "Maintainer": "Jose Samos ", "MD5sum": "11bf1ae145f17c1f190735d7a075c307", "_user": "josesamos", "_type": "src", "_file": "flattabler_2.1.2.9000.tar.gz", "_fileid": "fc0830beaa8bec48165b41a2e171bc5a2527a905644d60b128d7bce048b216dc", "_filesize": 1476622, "_sha256": "fc0830beaa8bec48165b41a2e171bc5a2527a905644d60b128d7bce048b216dc", "_created": "2026-06-09T07:44:42.000Z", "_published": "2026-06-09T07:53:55.688Z", "_distro": "noble", "_jobs": [ { "job": 80272946493, "time": 161, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7501548365" }, { "job": 80272946448, "time": 152, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7501545645" }, { "job": 80272946594, "time": 103, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7501666329" }, { "job": 80272946526, "time": 73, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7501632105" }, { "job": 80272424567, "time": 201, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7501495324" }, { "job": 80272946456, "time": 144, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7501541991" }, { "job": 80272946525, "time": 140, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7501541477" }, { "job": 80272946524, "time": 83, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7501523272" }, { "job": 80272946480, "time": 86, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7501523774" } ], "_buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/josesamos/flattabler", "_commit": { "id": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "author": "José Samos ", "committer": "GitHub ", "message": "Merge pull request #7 from josesamos/copy01\n\nCopy01", "time": 1714554988 }, "_maintainer": { "name": "Jose Samos", "email": "jsamos@ugr.es", "login": "josesamos", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems", "uuid": 13182483, "orcid": "0000-0002-4457-3439" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "dplyr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "readxl", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "pander", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" } ], "_owner": "josesamos", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 2, "_contributors": [ { "user": "josesamos", "count": 90, "uuid": 13182483 } ], "_userbio": { "uuid": 13182483, "type": "user", "name": "JOSE SAMOS JIMENEZ", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems" }, "_downloads": { "count": 236, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/flattabler" }, "_devurl": "https://github.com/josesamos/flattabler", "_pkgdown": "https://josesamos.github.io/flattabler/", "_searchresults": 7, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/flattabler.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/josesamos/flattabler", "_realowner": "josesamos", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2020-06-29" }, { "version": "1.1.0", "date": "2020-08-10" }, { "version": "1.2.0", "date": "2020-11-15" }, { "version": "2.0.0", "date": "2023-08-09" }, { "version": "2.1.0", "date": "2023-09-14" }, { "version": "2.1.1", "date": "2024-01-08" }, { "version": "2.1.2", "date": "2024-05-01" } ], "_exports": [ "define_labels", "divide", "extract_labels", "fill_labels", "fill_values", "flatten_table_list", "get_col_values", "get_page", "pivot_table", "read_excel_file", "read_excel_folder", "read_excel_sheet", "read_text_file", "read_text_folder", "remove_agg", "remove_bottom", "remove_cols", "remove_empty", "remove_k", "remove_left", "remove_right", "remove_rows", "remove_top", "replace_dec", "set_page", "unpivot" ], "_datasets": [ { "name": "df_ex", "title": "Pivot table in data frame with with thousands indicator and decimal numbers", "object": "df_ex", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3", "V4", "V5", "V6", "V7" ], "rows": 26, "table": true, "tojson": true }, { "name": "df_ex_compact", "title": "Pivot table in data frame with a column with data from two label fields", "object": "df_ex_compact", "class": [ "data.frame" ], "fields": [ "V2", "V3", "V4", "V5", "V6", "V7" ], "rows": 26, "table": true, "tojson": true }, { "name": "df_pivottabler", "title": "Pivot table with basic and subtotal labels in the same column", "object": "df_pivottabler", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3", "V4", "V5", "V6", "V7", "V8", "V9", "V10" ], "rows": 12, "table": true, "tojson": true }, { "name": "df_set_h", "title": "Set of pivot tables placed horizontally on one sheet", "object": "df_set_h", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3", "V4", "V5", "V6", "V7", "V8", "V9", "V10", "V11", "V12", "V13", "V14", "V15", "V16", "V17", "V18", "V19", "V20", "V21", "V22", "V23", "V24", "V25", "V26", "V27", "V28", "V29", "V30", "V31", "V32", "V33", "V34", "V35", "V36", "V37", "V38" ], "rows": 29, "table": true, "tojson": true }, { "name": "df_set_h_v", "title": "Set of pivot tables on one sheet", "object": "df_set_h_v", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3", "V4", "V5", "V6", "V7", "V8", "V9", "V10", "V11", "V12", "V13", "V14", "V15", "V16", "V17", "V18", "V19", "V20", "V21" ], "rows": 58, "table": true, "tojson": true }, { "name": "df_set_v", "title": "Set of pivot tables placed vertically on one sheet", "object": "df_set_v", "class": [ "data.frame" ], "fields": [ "V1", "V2", "V3", "V4", "V5", "V6", "V7", "V8", "V9", "V10" ], "rows": 111, "table": true, "tojson": true }, { "name": "ft_ex", "title": "Flat table with page from a pivot table with with thousands indicator and decimal numbers", "object": "ft_ex", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "page", "col1", "col2", "row1", "row2", "value" ], "rows": 46, "table": true, "tojson": true }, { "name": "ft_ex_v2", "title": "Flat table without page from a pivot table with with thousands indicator and decimal numbers", "object": "ft_ex_v2", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "col1", "col2", "row1", "row2", "value" ], "rows": 54, "table": true, "tojson": true }, { "name": "ft_set", "title": "Flat table with page from a pivot table with with thousands indicator and decimal numbers", "object": "ft_set", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "page", "col1", "col2", "row1", "row2", "value" ], "rows": 201, "table": true, "tojson": true }, { "name": "pf_ex_compact", "title": "Pivot table result of transforming a data frame with a column with data from two label fields", "object": "pf_ex_compact", "class": [ "pivot_table" ], "fields": [], "table": false, "tojson": false }, { "name": "pt_ex", "title": "Pivot table with with thousands indicator and decimal numbers", "object": "pt_ex", "class": [ "pivot_table" ], "fields": [], "table": false, "tojson": false } ], "_help": [ { "page": "define_labels", "title": "Define the quantity of rows and columns that contain labels", "concept": [ "pivot table definition functions" ], "topics": [ "define_labels", "define_labels.pivot_table" ] }, { "page": "df_ex", "title": "Pivot table in data frame with with thousands indicator and decimal numbers", "concept": [ "pivot table in data frame" ], "topics": [ "df_ex" ] }, { "page": "df_ex_compact", "title": "Pivot table in data frame with a column with data from two label fields", "concept": [ "pivot table in data frame" ], "topics": [ "df_ex_compact" ] }, { "page": "df_pivottabler", "title": "Pivot table with basic and subtotal labels in the same column", "concept": [ "pivot table in data frame" ], "topics": [ "df_pivottabler" ] }, { "page": "df_set_h", "title": "Set of pivot tables placed horizontally on one sheet", "concept": [ "pivot table set in data frame" ], "topics": [ "df_set_h" ] }, { "page": "df_set_h_v", "title": "Set of pivot tables on one sheet", "concept": [ "pivot table set in data frame" ], "topics": [ "df_set_h_v" ] }, { "page": "df_set_v", "title": "Set of pivot tables placed vertically on one sheet", "concept": [ "pivot table set in data frame" ], "topics": [ "df_set_v" ] }, { "page": "divide", "title": "Divide table", "concept": [ "flat table list functions" ], "topics": [ "divide", "divide.pivot_table" ] }, { "page": "extract_labels", "title": "Extract labels", "concept": [ "pivot table transformation functions" ], "topics": [ "extract_labels", "extract_labels.pivot_table" ] }, { "page": "fill_labels", "title": "Fill in missing labels", "concept": [ "pivot table transformation functions" ], "topics": [ "fill_labels", "fill_labels.pivot_table" ] }, { "page": "fill_values", "title": "Fill in missing values", "concept": [ "pivot table transformation functions" ], "topics": [ "fill_values", "fill_values.pivot_table" ] }, { "page": "flatten_table_list", "title": "Transform a 'pivot_table' object list into a flat table", "concept": [ "flat table list functions" ], "topics": [ "flatten_table_list" ] }, { "page": "ft_ex", "title": "Flat table with page from a pivot table with with thousands indicator and decimal numbers", "concept": [ "flat table" ], "topics": [ "ft_ex" ] }, { "page": "ft_ex_v2", "title": "Flat table without page from a pivot table with with thousands indicator and decimal numbers", "concept": [ "flat table" ], "topics": [ "ft_ex_v2" ] }, { "page": "ft_set", "title": "Flat table with page from a pivot table with with thousands indicator and decimal numbers", "concept": [ "flat table" ], "topics": [ "ft_set" ] }, { "page": "get_col_values", "title": "Get column values", "concept": [ "flat table list functions" ], "topics": [ "get_col_values" ] }, { "page": "get_page", "title": "Get the page information of a pivot table", "concept": [ "pivot table definition functions" ], "topics": [ "get_page", "get_page.pivot_table" ] }, { "page": "pf_ex_compact", "title": "Pivot table result of transforming a data frame with a column with data from two label fields", "concept": [ "pivot table" ], "topics": [ "pf_ex_compact" ] }, { "page": "pivot_table", "title": "'pivot_table' S3 class", "concept": [ "pivot table definition functions" ], "topics": [ "pivot_table" ] }, { "page": "pt_ex", "title": "Pivot table with with thousands indicator and decimal numbers", "concept": [ "pivot table" ], "topics": [ "pt_ex" ] }, { "page": "read_excel_file", "title": "Import Excel file", "concept": [ "import functions" ], "topics": [ "read_excel_file" ] }, { "page": "read_excel_folder", "title": "Import one sheet from each Excel file in a folder", "concept": [ "import functions" ], "topics": [ "read_excel_folder" ] }, { "page": "read_excel_sheet", "title": "Import Excel file sheet", "concept": [ "import functions" ], "topics": [ "read_excel_sheet" ] }, { "page": "read_text_file", "title": "Import text file", "concept": [ "import functions" ], "topics": [ "read_text_file" ] }, { "page": "read_text_folder", "title": "Import all text files in a folder", "concept": [ "import functions" ], "topics": [ "read_text_folder" ] }, { "page": "remove_agg", "title": "Remove rows and columns with aggregated data", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_agg", "remove_agg.pivot_table" ] }, { "page": "remove_bottom", "title": "Remove bottom rows from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_bottom", "remove_bottom.pivot_table" ] }, { "page": "remove_cols", "title": "Remove columns from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_cols", "remove_cols.pivot_table" ] }, { "page": "remove_empty", "title": "Remove empty rows and columns from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_empty", "remove_empty.pivot_table" ] }, { "page": "remove_k", "title": "Remove thousands separator", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_k", "remove_k.pivot_table" ] }, { "page": "remove_left", "title": "Remove left columns from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_left", "remove_left.pivot_table" ] }, { "page": "remove_right", "title": "Remove right columns from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_right", "remove_right.pivot_table" ] }, { "page": "remove_rows", "title": "Remove rows from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_rows", "remove_rows.pivot_table" ] }, { "page": "remove_top", "title": "Remove top rows from a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "remove_top", "remove_top.pivot_table" ] }, { "page": "replace_dec", "title": "Replace decimal separator", "concept": [ "pivot table transformation functions" ], "topics": [ "replace_dec", "replace_dec.pivot_table" ] }, { "page": "set_page", "title": "Set page information to a pivot table", "concept": [ "pivot table definition functions" ], "topics": [ "set_page", "set_page.pivot_table" ] }, { "page": "unpivot", "title": "Unpivot a pivot table", "concept": [ "pivot table transformation functions" ], "topics": [ "unpivot", "unpivot.pivot_table" ] } ], "_pkglogo": "https://github.com/josesamos/flattabler/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/josesamos/flattabler/raw/HEAD/README.md", "_rundeps": [ "bit", "bit64", "cellranger", "cli", "clipr", "cpp11", "crayon", "dplyr", "generics", "glue", "hms", "lifecycle", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "R6", "readr", "readxl", "rematch", "rlang", "stringi", "stringr", "tibble", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr" ], "_vignettes": [ { "source": "flattabler.Rmd", "filename": "flattabler.html", "title": "Transforming a pivot table into a flat table with the flattabler package", "author": "Jose Samos (jsamos@ugr.es)", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "An illustrative example", "Pivot table", "Obtaining a flat table", "Transforming a set of pivot tables", "Pivot table operations", "Pivot table import", "Operations that return an object", "Operations that return a list of objects", "Pivot table definition", "Define pivot table characteristics", "Remove rows and columns", "Pivot table transformation", "Transform labels", "Transform values", "Flat table generation", "Generation from a pivot table", "Generation from a list of pivot tables", "Conclusions" ], "created": "2020-06-27 11:43:17", "modified": "2023-08-09 19:17:21", "commits": 5 } ], "_score": 4, "_indexed": true, "_nocasepkg": "flattabler", "_universes": [ "josesamos" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2.1.2.9000", "date": "2026-06-09T07:47:20.000Z", "distro": "noble", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "00613f7e7e270b486c6be17896ebf356aefcffa5301e9ad52e55cee63c3ef05e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.6.0", "os": "linux", "version": "2.1.2.9000", "date": "2026-06-09T07:47:15.000Z", "distro": "noble", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "3730a8511aa866be3e6d4f118c84dbe1c8e4317323b8572b457b3252b4f2d5d9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.5.3", "os": "mac", "version": "2.1.2.9000", "date": "2026-06-09T07:53:15.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "badae26d73aa46d81df9732f69f521955f608776ed6461e1de1be074ccb0f6cb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.6.0", "os": "mac", "version": "2.1.2.9000", "date": "2026-06-09T07:51:38.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "4d1955c118394254f143caacb9169da142f359fb72ff47f07a8faf8e5359181a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.6.0", "os": "wasm", "version": "2.1.2.9000", "date": "2026-06-09T07:47:21.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "f32d9924e67f5d71b1235b92d9fe15fa7ea112e9832975a304c98fbb4623842f", "status": "success", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.7.0", "os": "win", "version": "2.1.2.9000", "date": "2026-06-09T07:46:49.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "a36d1126c15358f8e470bf5c09bbff3631318173ba1316237ffa26d48f9298c4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.5.3", "os": "win", "version": "2.1.2.9000", "date": "2026-06-09T07:45:58.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "99e59547f71cd12464ae2fa543d27ad708dab6b21e29a9af7ad04aa0f67d7231", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" }, { "r": "4.6.0", "os": "win", "version": "2.1.2.9000", "date": "2026-06-09T07:45:59.000Z", "commit": "86db1393adcbef4a04c5a9ca5e01e1d05319347f", "fileid": "8095defa734e19f155ebdac228c7876babbd407543f72f92273a29f90f516529", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27191433863" } ] }