Market Trend Analysis

This is the content for the project's own page.

This is the main content for the project page itself. You can write a detailed case study here.

Here is the SQL query I used to aggregate the sales data:

SELECT
    product_category,
    SUM(sales_amount) AS total_sales,
    AVG(customer_rating) AS avg_rating
FROM
    sales_records
WHERE
    sale_date >= '2025-01-01'
GROUP BY
    product_category
ORDER BY
    total_sales DESC;

And here is a snippet of the Python code used for the analysis:

import pandas as pd

# Load the dataset
df = pd.read_csv('sales_data.csv')

# Display the first 5 rows
print(df.head())