from matplotlib import pyplot as plt
import matplotlib
import pandas as pd
import numpy as np
font = {'family': 'MicroSoft YaHei',
'weight': 'bold',
'size': '4'}
matplotlib.rc("font", **font)
dataM_pd = pd.read_excel(r'./data/每个男会员消费记录.xlsx', sheet_name=3)
# dataM = np.array(dataM_pd)
dataF_pd = pd.read_excel(r'./data/每个女会员消费记录.xlsx', sheet_name=3)
# # print(dataF_pd.head())
saleM_Num = len(dataM_pd.kh)
# print(saleM_Num)
saleM_payAll = sum(dataM_pd.pay)
saleM_payAvg = saleM_payAll / saleM_Num
saleM_payCount = sum(dataM_pd.zsl.values)
saleM_countAvg = saleM_payCount / saleM_Num
# print(saleM_Num)
# print(saleM_payAll)
# print(saleM_payAvg)
print(saleM_payCount)
print(saleM_countAvg)
saleF_Num = len(dataF_pd.kh)
# print(saleM_Num)
saleF_payAll = sum(dataF_pd.pay)
saleF_payAvg = saleF_payAll / saleM_Num
saleF_payCount = sum(dataF_pd.zsl)
saleF_countAvg = saleF_payCount / saleM_Num
# plt.figure(figsize=(8, 20), dpi=80)
fig, ax = plt.subplots(2, 2, figsize=(8, 20))
bar_width = 0.2
x_1 = [0]
x_2 = [i + bar_width for i in x_1]
ax[0, 0].bar(x_1, saleM_payAll, bar_width, color="#87CEFA", label='男会员总消费')
ax[0, 0].bar(x_2, saleF_payAll, bar_width, color="#FFC0CB", label='女会员总消费')
ax[0, 0].legend()
ax[0, 0].set_ylabel('费用(元)')
ax[0, 0].set_xlabel('性别')
ax[0, 0].set_xticks([])
x_3 = [i + 2 * bar_width for i in x_2]
x_4 = [i + bar_width for i in x_3]
ax[0, 1].bar(x_3, saleM_payAvg, bar_width, color="#87CEFA", label='男会员平均消费')
ax[0, 1].bar(x_4, saleF_payAvg, bar_width, color="#FFC0CB", label='女会员平均消费')
ax[0, 1].legend()
ax[0, 1].set_ylabel('费用(元)')
ax[0, 1].set_xlabel('性别')
ax[0, 1].set_xticks([])
x_5 = [i + 2 * bar_width for i in x_4]
x_6 = [i + bar_width for i in x_5]
ax[1, 0].bar(x_5, saleM_payCount, bar_width, color="#87CEFA", label='男会员中消费次数')
ax[1, 0].bar(x_6, saleF_payCount, bar_width, color="#FFC0CB", label='女会员中消费次数')
ax[1, 0].legend()
ax[1, 0].set_ylabel('次数(次)')
ax[1, 0].set_xlabel('性别')
ax[1, 0].set_xticks([])
# x_5=[i + 2 * bar_width for i in x_4]
# x_6=[i + bar_width for i in x_5]
ax[1, 1].bar(x_5, saleM_countAvg, bar_width, color="#87CEFA", label='男会员平均消费次数')
ax[1, 1].bar(x_6, saleF_countAvg, bar_width, color="#FFC0CB", label='女会员平均消费次数')
ax[1, 1].legend()
ax[1, 1].set_ylabel('次数(次)')
ax[1, 1].set_xlabel('性别')
ax[1, 1].set_xticks([])
# plt.legend()
plt.show()
# plt.savefig('./Images/草图.png',dpi=80)
fig.savefig('./Images/草图.png', dpi=80)
设置多个子图的label
最新推荐文章于 2022-09-16 16:54:30 发布