بايثون

import pandas as pd

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

df.dropna(inplace=True)

df['Date'] = pd.to_datetime(df['Date'])

df['Month'] = df['Date'].dt.to_period('M').astype(str)

df['Year'] = df['Date'].dt.year

total_sales = df['Sales'].sum()

total_orders = df['OrderID'].nunique()

avg_order_value = total_sales / total_orders

monthly_sales = df.groupby('Month')['Sales'].sum().reset_index()

department_sales = df.groupby('Department')['Sales'].sum().reset_index()

print("Total Sales:", total_sales)

print("Total Orders:", total_orders)

print("Average Order Value:", round(avg_order_value, 2))

print("\nMonthly Sales:")

print(monthly_sales)

print("\nDepartment Sales:")

print(department_sales)