折线图

###############    data:2021.4.12                           ###############################
###############    function:数据分布折线图                    ###############################

from openpyxl import load_workbook, Workbook
import matplotlib.pyplot as plt
import numpy as np

#文件路径
filepath = r'D:\work\python_work\eswin\song_1\statistic.xlsx'
#打开文件
wb = load_workbook(filepath)
#打开statistic
ws_stic = wb['statistic']

rows_stic = ws_stic.max_row
j = 2
x1 = [ws_stic.cell(row=2, column=1).value]
x2 = [ws_stic.cell(row=2, column=5).value] #差值
#x3 = [ws_stic.cell(row=2, column=6).value] #绝对值
y1 = [ws_stic.cell(row=2, column=2).value]
while j<rows_stic:
    j = j+1
    x1[len(x1):] = [ws_stic.cell(row=j, column=1).value]
    x2[len(x2):] = [ws_stic.cell(row=j, column=5).value]
    y1[len(y1):] = [ws_stic.cell(row=j, column=2).value]

j = -1
y_max = 0
while j<rows_stic-2:
    j = j+1
    if y_max <= y1[j]:
        y_max = y1[j]

x_mean = [ws_stic.cell(row=2, column=4).value, ws_stic.cell(row=2, column=4).value]
y_mean = [0, y_max+2]


print(x1)
print(y1)
print(x_mean, y_mean)
plt.plot(x1, y1, label='linear')
plt.plot(x_mean, y_mean, label='mean_line')

plt.xlabel('x label')
plt.ylabel('y label')

plt.legend

plt.show()