数据可视化之利用Python从Excel导入数据绘图

有时候很多数据存放在Excel文档中，我们不可能慢慢地一个一个地在再打出来使用，所以用Python把Excel里面的数据导入就很方便了。

#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Date    : 2018-05-14 08:53:48
# @Arrogant  : ${Arrogant} ()
# @Link    : http://example.org
# @Version : $Id$

import matplotlib.pyplot as plt
import numpy as np
import xlrd
import seaborn as sns


NE_err = []
CE_err = []
AE_err = []
NE_diff = []
CE_diff = []
AE_diff = []
NE_max = []
NE_min = []
CE_max = []
CE_min = []
AE_max = []
AE_min = []
ExcelFile=xlrd.open_workbook(r'F:\工作\CE300_400_100.xlsx')     #选择导入的Excel表路径
ExcelFile1=xlrd.open_workbook(r'F:\工作\NE300.xlsx')
ExcelFile2=xlrd.open_workbook(r'F:\工作\AE300_400_100.xlsx')
sheet = ExcelFile.sheet_by_index(0)
sheet1 = ExcelFile1.sheet_by_index(0)
sheet2 = ExcelFile2.sheet_by_index(0)                            #选择该Excel表中的sheet
n03 = [[np.array(sheet1.col_values(0))],[np.array(sheet1.col_values(3))],[np.array(sheet1.col_values(6))],[np.array(sheet1.col_values(9))],[np.array(sheet1.col_values(12))]]
n04 = [[np.array(sheet1.col_values(1))],[np.array(sheet1.col_values(4))],[np.array(sheet1.col_values(7))],[np.array(sheet1.col_values(10))],[np.array(sheet1.col_values(13))]]
n01 = [[np.array(sheet1.col_values(2))],[np.array(sheet1.col_values(5))],[np.array(sheet1.col_values(8))],[np.array(sheet1.col_values(11))],[np.array(sheet1.col_values(14))]]
c03 = [[np.array(sheet.col_values(0))],[np.array(sheet.col_values(3))],[np.array(sheet.col_values(6))],[np.array(sheet.col_values(9))],[np.array(sheet.col_values(12))]]
c04 = [[np.array(sheet.col_values(1))],[np.array(sheet.col_values(4))],[np.array(sheet.col_values(7))],[np.array(sheet.col_values(10))],[np.array(sheet.col_values(13))]]      #把数据变成容易操作的array
c01 = [[np.array(sheet.col_values(2))],[np.array(sheet.col_values(5))],[np.array(sheet.col_values(8))],[np.array(sheet.col_values(11))],[np.array(sheet.col_values(14))]]
a03 = [[np.array(sheet2.col_values(0))],[np.array(sheet2.col_values(3))],[np.array(sheet2.col_values(6))],[np.array(sheet2.col_values(9))],[np.array(sheet2.col_values(12))]]
a04 = [[np.array(sheet2.col_values(1))],[np.array(sheet2.col_values(4))],[np.array(sheet2.col_values(7))],[np.array(sheet2.col_values(10))],[np.array(sheet2.col_values(13))]]
a01 = [[np.array(sheet2.col_values(2))],[np.array(sheet2.col_values(5))],[np.array(sheet2.col_values(8))],[np.array(sheet2.col_values(11))],[np.array(sheet2.col_values(14))]]