Plot a Bar Chart for Sales by Region
Description:
This program generates a bar chart to visualize total sales across different regions using grouped sales data.
Code Explanation:
● Added a new column called 'Region' to the dataset to represent regions.
● Created a new 'Sales' column by multiplying Quantity and Price.
● Grouped the data by 'Region' and calculated total sales for each region.
● Used plt.bar() to create a bar chart of sales by region.
● Labeled the X-axis as Region and Y-axis as Total Sales for clarity.
● Applied tight_layout() to make the chart spacing neat.
Program:
import matplotlib.pyplot as plt
import pandas as pd
# Sample data with Region added
data = {
'OrderID': [101, 102, 103, 104],
'Product': ['Laptop', 'Tablet', 'Smartphone', 'Headphones'],
'Quantity': [2, 5, 3, 10],
'Price': [750, 300, 500, 50],
'Date': ['2025-01-01', '2025-01-01', '2025-01-02', '2025-01-02'],
'Region': ['North', 'East', 'North', 'West']
}
# Create DataFrame
df = pd.DataFrame(data)
# Calculate total sales per order
df['Sales'] = df['Quantity'] * df['Price']
# Group by region and sum sales
sales_by_region = df.groupby('Region')['Sales'].sum()
# Plotting the bar chart
plt.figure(figsize=(8, 5))
plt.bar(sales_by_region.index, sales_by_region.values, color='green')
plt.title('Sales by Region')
plt.xlabel('Region')
plt.ylabel('Total Sales')
plt.tight_layout()
plt.show()
Output:
