Unpivot Complex and Irregular Data Layouts
Tokenize data frames into a tidy 'melted' structure
Strip a level of headers from a pivot table
Directions from data cells to headers
Join data cells to headers
Move sentinel values into a separate column leaving NA behind
Align one set of cells with another set
Merge cell values into a single cell by rows or columns
Pack cell values from separate columns per data type into one list-col...
Divide a grid of cells into partitions containing individual tables
Display cells as though in a spreadsheet
Objects exported from other packages
Spread key-value pairs of mixed types across multiple columns
Tokenize data frames into a tidy 'melted' structure
Un-pivot complex and irregular data layouts.
Tools for converting data from complex or irregular layouts to a columnar structure. For example, tables with multilevel column or row headers, or spreadsheets. Header and data cells are selected by their contents and position, as well as formatting and comments where available, and are associated with one other by their proximity in given directions. Functions for data frames and HTML tables are provided.