Efficiently Join Relation Tables in Pandas DataFrame Using Categories

Optimizing Database Design: Multiple Tables vs One Table with More Columns