Putting datasets together
Joining, stacking, summarising down to one row per group, reshaping.
What we have
- Joins another file onto this one side by side, matching on a shared key.
- Stacks another file underneath this one.
- Pairs up every matching row on both sides — a many-to-many join.
- Pairs every row here with every row in the other file.
- Replaces the data with one row per group, holding summaries.
- Replaces the data with one row per combination, and a count.
- Swaps the data between wide and long shape.
Coming later
m:m, which is refused on purpose —joinbyis the honest way to do itreshape error, which shows why a reshape will not go- percentile statistics such as
(p25)
mergeJoins another file onto this one side by side, matching on a shared key.
appendStacks another file underneath this one.
joinbyPairs up every matching row on both sides — a many-to-many join.
crossPairs every row here with every row in the other file.
collapseReplaces the data with one row per group, holding summaries.
contractReplaces the data with one row per combination, and a count.
reshapeSwaps the data between wide and long shape.