Skip to content

Instantly share code, notes, and snippets.

@ikatsov
Last active March 15, 2020 17:35
Show Gist options
  • Save ikatsov/8fc93cdf0d0497b89b580ab8b446fcd3 to your computer and use it in GitHub Desktop.
Save ikatsov/8fc93cdf0d0497b89b580ab8b446fcd3 to your computer and use it in GitHub Desktop.
products.csv
| product_id | product_name | aisle_id | department_id |
| 1 | Chocolate Sandwich Cookies | 61 | 19 |
| 2 | All-Seasons Salt | 104 | 13 |
| 3 | Robust Golden Oolong Tea | 94 | 7 |
...
departments.csv # coarse categorization
| department_id | department |
| 1 | frozen |
| 2 | other |
| 3 | bakery |
...
aisles.csv # fine-grained categorization
| aisle_id | aisle |
| 1 | prepared soups salads |
| 2 | specialty cheeses |
| 3 | energy granola bars |
...
order_products__prior.csv
| order_id | product_id | add_to_cart_order * | ...
| 1 | 49302 | 1 |
| 1 | 11109 | 2 |
| 110246 | 3 | 0 |
...
orders.csv
| order_id | user_id | ...
| 2539329 | 1 |
| 2398795 | 1 |
| 473747 | 1 |
...
* in what order products were added to the cart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment