from matplotlib import pyplot as plt
import seaborn as sns
import pandas
dt = pandas.read_excel(r"C:\Users\KARA\Desktop\工作簿38.xlsx")
# print(dt)
value = list(dt['MeasuredValue'])
# print(value)
list_v = []
for i in value:
z = round(float(i), 1)
list_v.append(z)
# print(list_v)
# ------直方图(添加密度图)
def draw_distribution_histogram(nums, path, is_hist=True, is_kde=True,
is_rug=False, is_vertical=False,
is_norm_hist=False):
sns.set() # 切换到sns的默认运行配置
sns.distplot(nums, bins=20, hist=is_hist, kde=is_kde, rug=is_rug,
hist_kws={"color": "steelblue"}, kde_kws={"color": "purple"},
vertical=is_vertical, norm_hist=is_norm_hist)
plt.xlabel("Test Value")
plt.ylabel("Nuclear Density Value")
plt.title("Test Value Distribution Histogram")
plt.tight_layout() # 处理显示不完整的问题
plt.savefig(path, dpi=300)
path = "static/histogram.png"
draw_distribution_histogram(list_v, path, True, True)