Learn how to efficiently concatenate multiple pandas DataFrames based on column values in Python. Complete guide with code examples for combining DataFrames that share the same fruit or category values.