Product Revenue Comparison by Month (New vs Old)

This project analyzes and visualizes the average revenue of new vs. old products across different months using Python and data visualization libraries.

📊 Description

The script performs the following:

• Reads product performance data from a CSV file.
• Checks for missing values and reports their percentage.
• Calculates the average revenue of new (Is_New = 1) vs old (Is_New = 0) products per month.
• Ensures all month/product-type combinations exist for consistent comparison.
• Generates a pivot table and heatmap comparing the average revenues.

📁 Input

A CSV file named product_performance_comparison.csv located at:

This project is licensed under the MIT License. See the LICENSE file for more details.

Make sure to adjust the path accordingly if running on another system.

📦 Requirements

• pandas
• matplotlib
• seaborn

Install with:

pip install pandas matplotlib seaborn

## 🔑 Keywords

("data analysis, pandas, product performance, revenue comparison, new vs old products, heatmap, data visualization, python project, matplotlib, seaborn")