pandas可视化叠加柱状图---excel

rsj0315

1. import pandas as pd
   
2. import matplotlib.pyplot as plt
   
3. 
   
4. #函数
   
5. def to_time(x):
   
6.     return int(x[0])+round(int(x[1])/60,2)
   
7. data = pd.read_excel(r'performance.xlsx')
   
8. 
   
9. data['up_time']=data['up_time'].astype('str').str.split(':')
   
10. data['down_time']=data['down_time'].astype('str').str.split(':')
    
11. 
    
12. # 计算开车时间和停车时间
    
13. data['up_time']=data['up_time'].apply(to_time)
    
14. data['down_time']=data['down_time'].apply(to_time)
    
15. 
    
16. #绘制叠加柱状图
    
17. data.plot.bar(x='date',y=['up_time','down_time'],stacked=True)
    
18. 
    
19. #绘制横向的叠加柱状图
    
20. # data.plot.barh(x='date',y=['up_time','down_time'],stacked=True)
    
21. 
    
22. #设置标题
    
23. plt.xlabel('hour',fontsize=12,fontweight='bold')
    
24. plt.ylabel('date_shift',fontsize=12,fontweight='bold')
    
25. plt.xticks(rotation='45',ha='right')
    
26. plt.title ('C line up_time vs dow_time per shift',fontsize=16,fontweight='bold')
    
27. #紧凑型标签
    
28. plt.tight_layout()
    
29. 
    
30. plt.show()

复制代码

Twilight6

不错 帮你顶下