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
customertable with information about each customer - A
cust_tax_infotable with customers unique tax IDs - An
orderstable with information about each order - A
productstable with details about each unique product sold - An
inventorytable 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
Start Exercise