读入excel文件并且绘出折线图

![图片是这样的格式](https://img-blog.csdnimg.cn/20190128151550308.png)
import pandas as pd
import matplotlib as mb
import matplotlib.pyplot as plt

xls = pd.read_excel('./a.xls',sheetname="Sheet1");

a=xls['iter'];
b=xls['ACDAE'];
c=xls['CDAAE'];
l_a=[];
l_b=[];
l_c=[];
for i in a:
	l_a.append(i);
for i in b:
	l_b.append(i);
for i in c:
	l_c.append(i);

plt.title('p2t Result')
plt.plot(l_a, l_b, color='green', label='Ours')
plt.plot(l_a, l_c, color='blue', label='CDAAE')
plt.legend(loc=7) 

plt.xlabel('iteration times')
plt.ylabel('acc')
plt.savefig('./p2t.png')
plt.show();