Repository navigation
Expand file tree
/
Copy pathData Visualization.py
More file actions
61 lines (50 loc) · 1.69 KB
/
Copy pathData Visualization.py
File metadata and controls
61 lines (50 loc) · 1.69 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
import seaborn as sns
import matplotlib.pyplot as plt
import pandas as pd
# Load dataset
file_path = r"C:\Users\Kesar\Desktop\Sales_Data.csv"
data = pd.read_csv(file_path)
# Display the first few rows of the dataset
print("First 5 Rows of the Dataset:")
print(data.head())
# Dataset summary
print("\nDataset Summary:")
print(data.info())
# Check for missing values
print("\nMissing Values Count:")
print(data.isnull().sum())
# Check columns in the dataset to confirm their names
print("\nColumns in the Dataset:")
print(data.columns)
# Pie Chart for Category Distribution
category_sales = data.groupby('Category')['Sales'].sum()
plt.figure(figsize=(8, 8))
plt.pie(category_sales, labels=category_sales.index, autopct='%1.1f%%', startangle=140, colors=['#ff9999','#66b3ff','#99ff99', '#ffcc99'])
plt.title('Sales Distribution by Category')
plt.show()
# Histogram for Sales Frequency
plt.figure(figsize=(10, 6))
plt.hist(data['Sales'], bins=10, color='skyblue', edgecolor='black')
plt.title('Sales Frequency Distribution')
plt.xlabel('Sales')
plt.ylabel('Frequency')
plt.show()
# Bar Chart for Sales by Product
plt.figure(figsize=(10, 6))
plt.bar(data['Product'], data['Sales'], color='orange')
plt.title('Sales by Product')
plt.xlabel('Product')
plt.ylabel('Sales')
plt.xticks(rotation=45)
plt.show()
# Heatmap for Correlation between Variables
correlation_matrix = data[['Sales', 'Profit', 'Discount', 'Quantity']].corr()
plt.figure(figsize=(8, 6))
sns.heatmap(correlation_matrix, annot=True, cmap='coolwarm', fmt='.2f', linewidths=0.5)
plt.title('Correlation Matrix')
plt.show()
# Boxplot for Sales Distribution
plt.figure(figsize=(8, 6))
sns.boxplot(x=data['Sales'])
plt.title('Sales Distribution')
plt.show()