Merge orders with stalls on city, keeping only cities present in both

pandas · from merge and join

pd.mergehow=on=left_on/right_onsuffixesindicatorvalidate

Putting the kettle on…

Starting up…

Exercise 1

Merge orders with stalls on city, keeping only cities present in both.

your answer
stuck? the lesson behind it
merge and join
The named side is kept in full — and duplicate keys multiply your rows.