如何执行依赖于在另一个python gui脚本中提取文件名的python脚本？

Question

我创建了一个python脚本（NoShowCalc.py），它使用3个选定的excel文件（booked_file_path、arrived_file_path和vlookup_file_path）自动清理和分析数据。但是，我希望所有这些都通过GUI执行，因此我启动了一个单独的（GUI.py）脚本来创建一个带有浏览按钮的界面，该按钮将获得这些文件路径名，然后将获得执行NoShowCalc.py脚本所需的内容。一旦选择了这些excel文件，就会有另一个按钮来执行NoShowCalc.py脚本。然而，我做到了，而且成功了！但是我不知道我改变了什么，现在两个不同的py文件没有连接

以下是NoShowGUI.py脚本中的脚本：

def open_file():
browse_text.set('Loading...')
booked_file_path = askopenfile(parent=root, mode='rb', title='Choose a file', filetype=[('CSV file', '*.csv')])
if booked_file_path:
    read_csv = (booked_file_path)
    browse_text.set('Loaded')

def run():
    os.system('NoShow_Calc.py')
    calculate_text.set("Calculating...")
#Calculate button
calculate_text = tk.StringVar()
calculate_btn = tk.Button(root, textvariable=calculate_text, command=lambda:run(), font='Calibri', fg='black', height=1, width=15)
calculate_text.set("Calculate No Show")
calculate_btn.grid(column=2, row=9)

以下是NoShowCalc.py脚本中的第一行：

import pandas as pd 

booked = pd.read_csv(booked_file_path, parse_dates=['Appointment Date'])
arrived = pd.read_csv(arrived_file_path, parse_dates=['Appointment Date'])
vlookup = pd.read_excel(vlookup_file_path)

不断弹出的错误是NameError: name 'booked_file_path' is not defined。我不知道它以前是如何运行的，现在这个错误突然出现了，因为它不能再与另一个py文件通信了。我做错了什么

Answer 1

如果使用os.system()或使用模块subprocess运行脚本，则不能使用其他脚本中的变量。它们作为独立的进程运行，不能共享变量（或内存中的数据）

只能将一些文本值作为参数发送

 os.system('NoShow_Calc.py ' + booked_file_path)

然后您可以使用sys.argv在NoShow_Calc中获取它

import pandas as pd 
import sys

booked_file_path  = sys.argv[1]

booked = pd.read_csv(booked_file_path, parse_dates=['Appointment Date'])
arrived = pd.read_csv(arrived_file_path, parse_dates=['Appointment Date'])
vlookup = pd.read_excel(vlookup_file_path)

如果需要其他变量，则必须以相同的方式发送其他值

 os.system('NoShow_Calc.py ' + booked_file_path + ' ' + other_filename)

及

booked_file_path = sys.argv[1]
other_filename = sys.argv[2] 
# etc.

但是使用os.system()不能将结果booked, arrived, vlookup从NoShow_Calc发送到NoShowGUI

你可以用subprocess来做，但它只能以文本的形式发送，所以NoShow_Calc必须使用print()来显示所有结果，并且NoShowGUI必须将该文本解析为预期的结构-即列表、字典、DataFrame

---

最好使用import从NoShow_Calc.py加载代码，然后所有代码都在同一进程中运行，这样所有代码都可以访问相同的变量，而不需要转换为文本或从文本返回

为了更好，我在函数中添加了代码

import pandas as pd 

def my_function(booked_file_path, arrived_file_path, vlookup_file_path):
    booked = pd.read_csv(booked_file_path, parse_dates=['Appointment Date'])
    arrived = pd.read_csv(arrived_file_path, parse_dates=['Appointment Date'])
    vlookup = pd.read_excel(vlookup_file_path)

    return booked, arrived, vlookup

然后在NoShowGUI中，您可以导入它并像任何其他函数一样使用它

from NoShow_Calc import my_function

booked, arrived, vlookup = my_function(booked_file_path, arrived_file_path, vlookup_file_path)

---

编辑：

我制作了最小的工作代码。我把它减少到只有一个文件名

NoShow_Calc.py

import pandas as pd 

def calc(booked_file_path): #, arrived_file_path, vlookup_file_path):
    booked = pd.read_csv(booked_file_path, parse_dates=['Appointment Date'])
    #arrived = pd.read_csv(arrived_file_path, parse_dates=['Appointment Date'])
    #vlookup = pd.read_excel(vlookup_file_path)
    
    return booked #, arrived, vlookup

NoShowGUI.py

import tkinter as tk
from tkinter.filedialog import askopenfilename   # instead of `askopenfile`

# adding directory with this script to `sys.path` before `import NoShow_Calc`
# to make sure that `import` will search `NoShow_Calc.py` in correct folder even when GUI will be run from different folder

import os
import sys

HOME_DIR = os.path.dirname(os.path.abspath(__file__))
sys.path.append(HOME_DIR)

import NoShow_Calc

print('HOME_DIR:', HOME_DIR)

def select_filename():
    global booked_file_path  # inform function that it has to assign value to external/global variable 

    text_log.insert('end', 'Selecting ...\n')
    
    # use `askopenfilename` instead of `askopenfile` 
    # because I need only filename, not opened file (pandas will open it on its own)
    
    booked_file_path = askopenfilename(parent=root,                                        
                                       title='Choose a file', 
                                       #initialdir='/home/furas',
                                       filetypes=[('CSV file', '*.csv')])
    
    if booked_file_path:
        text_log.insert('end', f'Selected: {booked_file_path}\n')
    else:
        text_log.insert('end', f'Not selected\n')

def run():
    text_log.insert('end', "Calculating...\n")

    if booked_file_path is None:
        text_log.insert('end', "File booked_file_path not selected !!!")
        return
    #elif arrived_file_path is None:
    #    text_log.insert('end', "File arrived_file_path not selected !!!")
    #    return
    #elif vlookup_file_path is None:
    #    text_log.insert('end', "File vlookup_file_path not selected !!!")
    #    return
    else:        
        root.update()  # force tkinter to update text in text_log at once (not when it exits function `run`)
        result = NoShow_Calc.calc(booked_file_path)# , arrived_file_path, vlookup_file_path)

    text_log.insert('end', "Result:\n")
    text_log.insert('end', str(result.head()) + "\n")
    
#  - main  -    

booked_file_path = None  # default value at start (so in `run` I can check `None` to see if I selecte filename)
#arrived_file_path = None
#vlookup_file_path = None

root = tk.Tk()

text_log = tk.Text(root)
text_log.grid(column=0, row=0)

select_btn = tk.Button(root, text="Select File Name", command=select_filename)
select_btn.grid(column=0, row=1)

calculate_btn = tk.Button(root, text="Calculate", command=run)
calculate_btn.grid(column=0, row=2)

root.mainloop()