Sales Distribution by Item Type in Excel Using Python | Horizontal Bar Chart📊

🔥 In this video, we’ll analyze and visualize sales distribution by item type using Python's Pandas and Matplotlib libraries.

Here’s what you’ll learn:

📌 Group and Aggregate Sales by Item Type
📌 Calculate % of Total Sales using Pandas
📌 Sort Data for Effective Visualization
📌 Create a Clean Horizontal Bar Chart
📌 Add Percentage Labels to the Bars
📌 Make Your Charts Presentable with Titles & Axis Labels

💼 This is a real-world data visualization use-case ideal for:

Data Analysts

Python Learners

Dashboard Builders

Business Intelligence Enthusiasts

🛠️ Technologies Used:

Python

Pandas

Matplotlib

🎯 Key Code Snippet:
overall_sales = df.groupby('Item Type')['Sales'].sum()
sales_gt = ((overall_sales / overall_sales.sum()) * 100).sort_values(ascending=True)

plt.barh(sales_gt.index, sales_gt.values)
bar_lbl = plt.barh(sales_gt.index, sales_gt.values)
plt.bar_label(bar_lbl, labels=[f'{x/100:.2%}' for x in sales_gt.values])
plt.xlabel('% of Sales')
plt.ylabel('Item Type')
plt.title('Distribution of Sales at Item Level')
plt.show()
🔔 Like, Share & Subscribe to @DataWiz Vamshi for more projects in Python, Excel, SQL & Data Analysis.

#PythonProject #DataVisualization #Matplotlib #PandasTutorial #SalesAnalytics #DataWizVamshi #PythonForBeginners #KaggleProject

Видео Sales Distribution by Item Type in Excel Using Python | Horizontal Bar Chart📊 канала DataWiz Vamshi