PyPath
Start learning

Unit 8 · Combining Tables

Joins, keys that do not match, and reshaping between wide and long.

  1. 1Stacking Tables with concatTwo tables of the same shape, one after the other.
  2. 2Merging on a KeyBringing two tables together on the column they share.
  3. 3When a Merge Goes WrongDuplicate keys multiply rows, and mismatched types match nothing.
  4. 4Wide to Long with meltTurning a column per month into a column that says which month.
  5. 5Long to Wide with pivotThe other direction, for when a person should be one row.
  6. 6Putting a Join to WorkTwo files, one question, and the checks that keep the answer honest.