🟡 PROJECT 2 (Medium): Sales Data Analysis

📌 Objective

Analyze monthly sales, find revenue, top product, and trends.

📌 Dataset (sample)

Month	Product	Sales
Jan	Mobile	25000
Jan	Laptop	40000
Feb	Laptop	38000
Feb	Mobile	30000

---

📌 Project Tasks

✔ 1. Load Data

df = pd.read_csv("sales.csv")

✔ 2. Clean Data

df.dropna(inplace=True)
df["Sales"] = df["Sales"].astype(int)

✔ 3. Total Sales

print("Total Revenue:", df["Sales"].sum())

✔ 4. Monthly Sales Summary

monthly = df.groupby("Month")["Sales"].sum()
print(monthly)

✔ 5. Best-Selling Product

best = df.groupby("Product")["Sales"].sum().idxmax()
print("Best Product:", best)

✔ 6. Plot Monthly Trend

monthly.plot(kind="line")