我正在嘗試根據輸入使用 if-elif-else 語句從 Excel 中讀取不同的工作表,并編寫了以下代碼import numpy as np import pandas as pddef ABSMATDATA(a,b,c,d,Material,Tmpref): if Material == 2.016: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='H2') elif Material == 28.016: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='N2') elif Material == 32.000: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='O2') elif Material == 32.065: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='S') elif Material == 18.016: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='H2O') elif Material == 64.065: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='SO2') elif Material == 12.001: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='C Graphite') elif Material == 28.011: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='CO') elif Material == 44.011: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='CO2') elif Material == 16.043: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='CH4') elif Material == 30.070: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='C2H6') elif Material == 44.097: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='C3H8') elif Material == 58.124: df = pd.read_excel('F:\MAschinenbau\Bachelorarbeit\ABSMAT.xlsx',sheet_name='C4H10') else: print('No data for this material available') df =[list(np.arange(0,1100,100)),list(np.arange(0,11,1)),list(np.arange(0,11,1)),list(np.arange(0,11,1)),list(np.arange(0,11,1))] return df我正在嘗試ABSMATDATA(1,2,3,4,28.011,100)在 IPython 控制臺中運行代碼調用,但它沒有給出任何輸出。我希望df在我的變量資源管理器中看到2 維數組。
添加回答
舉報
0/150
提交
取消