pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue

By the end of this page you can attach columns from one DataFrame to another on a shared key, choose the right how for the question, see at a glance which rows failed to match, and catch the failure t