This task involves using Python and SQL to analyze a small SQLite database of cosmetic product sales. The goal is to:
- Connect to a SQLite database using Python
- Execute basic SQL queries
- Summarize total quantity sold and total revenue for each product
- Visualize the results using a bar chart
- Python 3
- SQLite (via sqlite3)
- Pandas
- Matplotlib
| File | Description |
|---|---|
| cosmetic_sales_data.db | SQLite database with cosmetic product sales |
| cosmetic_sales_script.ipynb | Python script to analyze and visualize data |
| cosmetic_sales_chart.png | Bar chart showing revenue by product |
| README.md | This file |