Python Matplotlib 按Category聚合QTY生成各分类对应柱状子图的实现
实现按分类拆分的柱状子图调整方案
现存代码的核心问题
- 误用
value_counts()方法:该方法用于统计列内值的出现频次,无法实现拆分每个Category组、展示组内Product对应QTY数值的目标 - 硬套用2*2布局:当前只有3个Category分组,强行生成4个子图位置自然会产生空白块
- 未做分组筛选:原代码直接对全列数据做统计,没有按Category维度拆分数据后绘图
具体调整逻辑
- 先提取所有唯一的Category值,明确需要绘制的子图数量
- 适配子图布局:如果保留22布局可直接隐藏多余的空轴,也可以直接调整为适配3个分类的13/3*1布局
- 按Category逐组筛选数据,在对应子图上以Product为横轴、QTY为纵轴绘制柱状图
- 统一调整子图标题、轴标签、间距,避免文字重叠
完整可运行代码
import pandas as pd import matplotlib.pyplot as plt # 载入测试数据 data = {'Category':["Toys","Toys","Toys","Toys","Food","Food","Food","Food","Food","Food","Food","Food","Furniture","Furniture","Furniture"], 'Product':["AA","BB","CC","DD","SSS","DDD","FFF","RRR","EEE","WWW","LLLLL","PPPPPP","LPO","NHY","MKO"], 'QTY':[100,200,300,50,20,800,300,450,150,320,400,1000,150,900,1150]} df = pd.DataFrame(data) # 获取所有唯一分类 category_list = df['Category'].unique() # 生成2*2布局的子图 fig, axarr = plt.subplots(2, 2, figsize=(12, 8)) # 将二维轴数组展平为一维,方便顺序遍历 axes = axarr.flatten() # 逐分类绘制柱状图 for plot_idx, current_category in enumerate(category_list): # 筛选当前分类下的所有数据 current_df = df[df['Category'] == current_category] # 绘制Product对应QTY的柱状图 current_df.plot.bar( x='Product', y='QTY', ax=axes[plot_idx], color=f'C{plot_idx}', legend=False ) # 设置子图属性 axes[plot_idx].set_title(current_category, fontsize=14) axes[plot_idx].set_xlabel('Product', fontsize=10) axes[plot_idx].set_ylabel('QTY', fontsize=10) # 隐藏无数据的第4个子图 axes[3].axis('off') # 自动调整子图间距,避免标签重叠 plt.tight_layout() plt.show()
可选优化:如果不需要保留空白子图占位,可直接将子图生成代码修改为
fig, axes = plt.subplots(1, 3, figsize=(15, 5)),完全适配3个分类的横向排列展示需求。
内容的提问来源于stack exchange,提问作者Galat
相关产品推荐
相关产品推荐

