我正在尝试根据输入使用 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
提交
取消