Read-in functions |
|
---|---|
List the names of all sheets within given files |
|
Read one excel sheet with read_excel |
|
Read headers that span over multiple rows |
|
Read multiple files (csv or excel) and/or multiple sheets (within an excel file) and handle headers that span multiple rows. |
|
A wrapper around read_ods to read multiple sheets in a .ods file |
|
Read in sheets |
|
Split tables functions |
|
Split a large table into smaller tables if there are blank columns or rows |
|
Split a large table in one direction if there are blank columns or rows |
|
Clean columns functions |
|
Rename columns with a data.frame containing old and new column names |
|
Remove duplicate columns that may have different column names |
|
Join functions |
|
Full join data.frames to compare columns add a suffix before the merge to track where the column originated |
|
Clean column contents |
|
Check field map layout for errors and duplicate range/row locations. |
|
Set -9 and 0s to NA for given columns |
|
Summarize column functions |
|
Find column information in a data.frame |
|
Select columns from data.frames stored within a list |
|
Create a list of column names that match a given regex for all data.frames in given list The function returns the proportion of the data.frames that contain the column name |
|
Summarise the number of columns per data.frame that match a given regex over a list of data.frames This function detects columns with similar names within a dataset |
|
Summarize information on variables that match a given regex |