Prod_Trade.xlsx
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False
plt.style.use('ggplot')
trade = pd.read_excel(r'可视化\Prod_Trade.xlsx')
trade['year'] = trade.Date.dt.year
trade['month'] = trade.Date.dt.month
plt.figure(figsize=(12,6))
ax1 = plt.subplot2grid(shape=(2,3),loc=(0,0))
class_counts = trade.Order_Class[trade.year==2012].value_counts()
class_persent = class_counts / class_counts.sum()
ax1.set_aspect(aspect='equal')
ax1.pie(x=class_persent.values,
labels=class_persent.index,
autopct='%.1f%%')
ax1.set_title('等级订单比例',color='black')
ax2 = plt.subplot2grid(shape=