Python for Data · Unit 8
Unit 8: Combining Tables
Join two pandas tables on a shared column and reshape the result.
Lessons
- Stacking Tables with concatTwo tables of the same shape, one after the other.
- Merging on a KeyBringing two tables together on the column they share.
- When a Merge Goes WrongDuplicate keys multiply rows, and ids written two ways match nothing.
- Wide to Long with meltTurning a column per month into a column that says which month.
- Long to Wide with pivotThe other direction, for when a person should be one row.
- Putting a Join to WorkTwo files, one question, and the checks that keep the answer honest.
-
Take the Unit 8 test
End of unit test
Ten multiple choice questions and one free response problem. You need 70 to finish the unit. Retakes are unlimited and your best score is the one that counts.