[파이썬] 문제 : 엑셀(excel) 읽기, sheetname 읽기

 

 

from matplotlib.pylab import plt
import pandas as pd
import numpy as np

def ShowDataToPlot (a, b, title):
    plt.title(title)
    plt.plot(a,b)
    plt.xlabel("Sec")
    plt.ylabel("CPS")
    plt.grid(True)
    plt.show()

e_file = "TestCode.xlsx"

sh = pd.read_excel(e_file, None)       # sheet name을 확인하기 위한 read. None을 해야 함
sheet_names = list(sh.keys())           # sheet name들

data = pd.read_excel(e_file,sheet_name=0)
#print(readData)

ShowDataToPlot(data.index, data['2번'],'2번')
ShowDataToPlot(data.index, data['4번'],'4번')

TestCode.xlsx

0.01MB