Stacks value columns of a summary table (one row per patient, say) into
one row per identifier and column, the form used by the plot builders.
The columns are given by name (values), by a regular expression
(pattern), or default to all columns other than id and exclude.
Usage
PlotDataLonger(
data,
id,
values = NULL,
conditions = NULL,
pattern = NULL,
exclude = NULL,
names_to = "condition",
values_to = "value",
drop_na = FALSE
)Arguments
- data
A data frame.
- id
Identifier columns kept on every row.
- values
Value columns to stack, in condition order.
- conditions
Condition names for the stacked columns; default the column names (or the pattern groups).
- pattern
Regular expression selecting the value columns when
valuesisNULL.- exclude
Columns never stacked when
valuesisNULL.- names_to, values_to
Names of the new condition and value columns.
- drop_na
Drop rows whose value is missing.
Details
With pattern, the first capture group of the pattern becomes the
condition name ("^log2\\|(.*)$" turns log2|p1 into p1); a pattern
without a group keeps the column names.
See also
Other plot-data builders:
PlotDataBindRows(),
PlotDataConstant(),
PlotDataCount(),
PlotDataCrossShares(),
PlotDataDirection(),
PlotDataDominant(),
PlotDataFromArrays(),
PlotDataJoin(),
PlotDataKeyColours(),
PlotDataLabels(),
PlotDataMembership(),
PlotDataPairRatio(),
PlotDataProduct(),
PlotDataQuantiles(),
PlotDataRankRows(),
PlotDataRatio(),
PlotDataRecode(),
PlotDataRelative(),
PlotDataSelect(),
PlotDataShares(),
PlotDataSummarise(),
PlotDataUnite()
Examples
d <- data.frame(patient = c("p1", "p2"), a = 1:2, b = 3:4)
PlotDataLonger(d, "patient", c("a", "b"), conditions = c("A", "B"))
#> patient condition value
#> 1 p1 A 1
#> 2 p2 A 2
#> 3 p1 B 3
#> 4 p2 B 4
w <- data.frame(type = c("a", "b"), `v|p1` = 1:2, `v|p2` = c(3, NA), check.names = FALSE)
PlotDataLonger(w, "type", pattern = "^v\\|(.*)$", names_to = "patient", drop_na = TRUE)
#> type patient value
#> 1 a p1 1
#> 2 b p1 2
#> 3 a p2 3