Ecommerce Data Exercise

Files

generate_csvs.py – Generates synthetic ecommerce CSV data using only Python standard library.
load_to_sqlite.py – Loads the CSV files into ecommerce.db (SQLite).
run_report.py – Runs a SQL join query and prints a combined ecommerce report.
report.sql – SQL version of the join query.

python generate_csvs.py

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
README.md		README.md
ecommerce.db		ecommerce.db
generate_csvs.py		generate_csvs.py
load_to_sqlite.py		load_to_sqlite.py
order_items.csv		order_items.csv
orders.csv		orders.csv
products.csv		products.csv
report.sql		report.sql
reviews.csv		reviews.csv
run_report.py		run_report.py
users.csv		users.csv