Virata manual

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 — joinby is the honest way to do it
  • reshape error, which shows why a reshape will not go
  • percentile statistics such as (p25)