Which cities does an inner join lose

pandas · from Capstone: an analysis, end to end

mergegroupbyaggpivot_tablesort_valuesvalidate=

Putting the kettle on…

Starting up…

Exercise 2

Which cities does an inner join lose? Return them as a sorted list, comparing the cities in orders with those in the inner result.

your answer
stuck? the lesson behind it
Capstone: an analysis, end to end
From a messy table to a ranked report — and the two joins that could ruin it.