对另一个数据帧文件调用另一个函数

Question

我有两个脚本： file1.py和file2.py

file1.py

## file1.py
from file2 import *

class df_read():

   def __init__(self):
       self.df1 = df1
       self.df2 = df2

   def df1_read(self,fileloc,sheet_NAME):
       self.df1 = pd.read_excel(file_loc,sheet_name=sheet_NAME)
       self.start_time1 = df1.iloc[0][1]
       return self.start_time1

   def df2_read(self,file loc,sheet_NAME):
       self.df2 = pd.read_excel(file_loc,sheet_name=sheet_NAME)
       self.start_time2 = df2.iloc[0][1]
       return self.start_time2

file2.py

##file2.py
from file1 import *

result1 = df_read.df1_read(C:\Users\exam1.xlsx,'01') - df_read.df2_read(C:\Users\exam1.xlsx,'02')
result2 = df_read.df1_read(C:\Users\exam2.xlsx,'01') - df_read.df2_read(C:\Users\exam2.xlsx,'02')

我想从另一个文件调用函数，但它不起作用。你能帮帮我吗

Answer 1

您没有在第二个代码段中实例化您的类：

df_obj = df_read()

result1 = df_obj .df1_read(C:\Users\exam1.xlsx,'01') - df_obj.df2_read(C:\Users\exam1.xlsx,'02')
result2 = df_obj.df1_read(C:\Users\exam2.xlsx,'01') - df_obj.df2_read(C:\Users\exam2.xlsx,'02')