python读取excel数据并制图

最新推荐文章于 2026-05-09 07:26:07 发布

原创

最新推荐文章于 2026-05-09 07:26:07 发布 · 1.3w 阅读

收录于

import xlrd
import matplotlib.pyplot as plt

 from pylab import mpl 
 mpl.rcParams['font.sans-serif'] = ['FangSong'] # 指定默认字体 
 mpl.rcParams['axes.unicode_minus'] = False # 解决保存图像是负号'-'显示为方块的问题

#读取excel数据
# 打开文件
data = xlrd.open_workbook('E:\桌面\demo.xlsx')
table = data.sheet_by_index(0)
# 获取总行数
nrows = table.nrows
# 获取总列数
ncols = table.ncols
# 获取一列的数值，例如第4列
four = table.col_values(3)
# 获取一列的数值，例如第8列
six = table.col_values(7)

j=0
h=0
k=0
p=0
q=0
for j in range(nrows):
    a = four[j]
    b = six[j]
    if a == "待修复" and b =="细微":
        h += 1
    elif a == "待修复" and b =="一般":
        k += 1
    elif a == "待修复" and b =="严重":
        p += 1
    elif a == "待修复" and b =="致命":
        q += 1
print(h,k,p,q)

#待修复缺陷严重性分布
P=["细微","一般","严重","致命"]
Q=[0,0,0,0]
Q[0]=h
Q[1]=k
Q[2]=p
Q[3]=q
fig = plt.figure()
plt.bar(P,Q,0.4,color="red")
for x, y in zip(P, Q):
    # ha: