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

淩亂°似流年 2022-05-19 06:54 446阅读 0赞

有时候很多数据存放在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))]]