One-to-many classification
Understanding the difference between a one-to-one and one-to-many relationship is a useful skill. In this exercise, consider a set of tables from an e-commerce website. The hypothetical tables are the following:
- A
customer
table with information about each customer - A
cust_tax_info
table with customers unique tax IDs - An
orders
table with information about each order - A
products
table with details about each unique product sold - An
inventory
table with information on how much total inventory is available to sell for each product
This exercise is part of the course
Joining Data with pandas
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
