Efficiently Join Relation Tables in Pandas DataFrame Using Categories

Understanding Single Table vs Two One-to-One Related Tables Performance: Which Approach Wins?