user@devops:~$ cat README.md
Merge & Join — Combining Datasets
# Description
Dataset combination project with pandas simulating a real e-commerce environment where data comes from multiple sources: CRM customer data, sales system, product catalog, and reviews. Learn the 4 join types (INNER, LEFT, RIGHT, OUTER), chained joins to combine 3+ tables, CONCAT for stacking data vertically, and using the indicator parameter for debugging. Includes conceptual diagrams and business analysis.
# Key features
$ INNER JOIN: only records that exist in both tables
$ LEFT JOIN: all records from the main table enriched
$ OUTER JOIN with indicator to see missing data in each table
$ Multiple chained joins: 4+ table combination like real ML
$ CONCAT for vertical data stacking
$ Cardinality detection and duplicate key verification
# Gallery
# Technologies used
