This function will split selected delimited column names such that the first components (LHS) are promoted to being spanner column labels, and the secondary components (RHS) will become the column labels. Please note that reference to individual columns must continue to be the column names from the input table data (which are unique by necessity).
cols_split_delim(data, delim, columns = NULL)
A table object that is created using the
The delimiter to use to split an input column name. The delimiter supplied will be autoescaped for the internal splitting procedure. The first component of the split will become the group name and the second component will be the column label.
An optional vector of column names that this operation should be limited to. The default is to consider all columns in the table.
An object of class
If we look to the column names in the
iris dataset as an example of how
cols_split_delim() might be useful, we find the names
Petal.Width. From this naming system, it's
easy to see that the
Petal can group together the repeated
Width values. In your own datasets, we can avoid a
lengthy relabeling with
cols_label() if column names can be fashioned
beforehand to contain both the spanner column label and the column label. An
additional advantage is that the column names in the input table data remain
unique even though there may eventually be repeated column labels in the
rendered output table).