Table of contents 1. Create DataFrame to illustrate and apply join 2. Different ways to avoid duplicate columns after join 2.1 Rename Specifying column names to select before joining 2.2 Using alias 2.3 Dropping duplicate columns 2.4. Using coalesce to resolve column conflicts 3. Conclusion