图像融合评价指标作图，表格导图

import matplotlib.pyplot as plt

import numpy as np
import xlrd

import pandas as pd

from openpyxl import load_workbook


#存放测试结果的excel文件
workbook_ALL = load_workbook(filename='D:\downloads/fusion_ssim\Metric\metric_2M3DFfinal_M3DF.xlsx')
sheet1_ALL = workbook_ALL["EN"]#度量指标
#需要对比的算法
CBF=[]
DCHWT=[]
FusionGAN=[]
DenseFuse=[]
U2fusion=[]
RFN_Nest=[]
IFT=[]
Ours=[]
#确定每种算法所在的行与列
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=2,max_col=2):
    for j in i:
        print(j.value)
        CBF.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=3,max_col=3):
    for j in i:
        print(j.value)
        DCHWT.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=4,max_col=4):
    for j in i:
        print(j.value)
        FusionGAN.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=5,max_col=5):
    for j in i:
        print(j.value)
        DenseFuse.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=6,max_col=6):
    for j in i:
        print(j.value)
        U2fusion.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=12,max_col=12):
    for j in i:
        print(j.value)
        RFN_Nest.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=8,max_col=8):
    for j in i:
        print(j.value)
        IFT.append(j.value)
for i in sheet1_ALL.iter_cols(min_row=2, max_row=21, min_col=9,max_col=9):
    for j in i:
        print(j.value)
        Ours.append(j.value)

print(CBF)
print(Ours)



x_axis_data = np.arange(1,21).astype(dtype=np.str)
# y_axis_data = [68, 69, 79, 71, 80, 70, 66]  # y
#
plt.plot(x_axis_data, CBF, '*:g', alpha=1, linewidth=1,ms = 5, label='CBF')  # 'bo-'表示蓝色实线，数据点实心原点标注
plt.plot(x_axis_data, DCHWT, '^:b', alpha=1, linewidth=1,ms = 5, label='DCHWT')
plt.plot(x_axis_data, DenseFuse, '1:c', alpha=1, linewidth=1,ms = 6, label='DenseFuse')
plt.plot(x_axis_data, IFT, '.:m', alpha=1, linewidth=1,ms = 5, label='IFT')
plt.plot(x_axis_data, FusionGAN, 'p:y', alpha=1, linewidth=1,ms =5, label='FusionGAN')
plt.plot(x_axis_data, U2fusion, 'X:k', alpha=1, linewidth=1,ms = 5, label='U2fusion')
plt.plot(x_axis_data, RFN_Nest, 'd:g', alpha=1, linewidth=1,ms = 5, label='RFN_Nest')
plt.plot(x_axis_data, Ours, 's-r', alpha=1, linewidth=1,ms = 4, label='Ours')
plt.legend()  # 显示上面的label
plt.xlabel('Image pairs')  # x_label
plt.ylabel('Values of the metric')  # y_label
# num1 =1.05
# num2 = 1
# num3 = 3
# num4 = 0
# plt.legend(bbox_to_anchor=(num1, num2), loc=num3, borderaxespad=num4)
#plt.legend(bbox_to_anchor=(0.5, -0.2),loc=8,ncol=8, borderaxespad=0) # , borderaxespad=0

plt.legend(bbox_to_anchor=(0.5, 1.05), loc=10,ncol=4, borderaxespad=0)
#plt.legend(scatterpoints=1,labels = 'CBF', labelspacing=0.4,columnspacing=0.4,markerscale=2,bbox_to_anchor=(0.9, 0),ncol=12,prop='font1',handletextpad=0.1)
#plt.legend(scatterpoints=2,labels = 'DCHWT', labelspacing=0.4,columnspacing=0.4,markerscale=2,bbox_to_anchor=(0.9, 0),ncol=12,prop='font1',handletextpad=0.1)

# plt.ylim(-1,1)#仅设置y轴坐标范围
#保存位置
plt.savefig('D:/downloads/img2/picture/EN.svg',dpi=300,format='svg')
plt.show()