Top-Selling Products CSV Analysis

I’ve gathered a series of CSV files that record every sale we’ve made and now need a concise Python-driven study that pinpoints which products bring in the highest revenue. The data set is strictly sales data, and the key metric for ranking each item is revenue generated, not sheer volume or frequency.

You’ll write a clean, well-commented Python script (pandas / NumPy are fine; a Jupyter Notebook is equally acceptable) that:

• reads one or many CSVs,
• calculates total revenue for each SKU, and
• outputs a tidy summary—both as a CSV and a readable table or chart—listing products in descending order of revenue.

Acceptance criteria
• Script runs locally with a single command and works on standard Python 3.10+
• All file paths and parameters are configurable at the top of the script/notebook
• Output file contains product identifier, description (if present in source), total revenue, and rank
• Basic README explains how to reproduce the results

The raw files are available as soon as the project starts, and I’m happy to clarify field names or provide sample rows.