gpt-4-0314· OpenAI
WildChat-4.8M (AI2)
写一段Python,用tkinter: 1,输入手机号,选择指定文件夹,从文件夹下的EXcel文件查找信息并输出
- User
写一段Python,用tkinter: 1,输入手机号,选择指定文件夹,从文件夹下的EXcel文件查找信息并输出
- Assistant
import tkinter as tk from tkinter import ttk from tkinter import filedialog import os import pandas as pd def browse_folder(): folder = filedialog.askdirectory() folder_path.set(folder) def find_info(): folder = folder_path.get() phone_number = entry_phone.get() for file in os.listdir(folder): if file.endswith('.xlsx') or file.endswith('.xls'): file_path = os.path.join(folder, file) df = pd.read_excel(file_path) if phone_number in df['Phone'].values: output.set(f"Found in {file}: {df.loc[df['Phone'] == phone_number].to_string()}") return output.set("Not found") app = tk.Tk() app.title('Phone Number Finder') label_phone = ttk.Label(app, text="Phone Number:") label_phone.grid(column=0, row=0) entry_phone = ttk.Entry(app) entry_phone.grid(column=1, row=0) label_folder = ttk.Label(app, text="Folder:") label_folder.grid(column=0, row=1) folder_path = tk.StringVar() entry_folder = ttk.Entry(app, textvariable=folder_path) entry_folder.grid(column=1, row=1) button_browse = ttk.Button(app, text="Browse", command=browse_folder) button_browse.grid(column=2, row=1) label_output = ttk.Label(app, text="Output:") label_output.grid(column=0, row=3) output = tk.StringVar() output.set("Phone number information will be displayed here.") label_output = ttk.Label(app, textvariable=output) label_output.grid(column=1, row=3, columnspan=2) button_find = ttk.Button(app, text="Find Info", command=find_info) button_find.grid(column=0, row=2, columnspan=3) app.mainloop()这段Python代码使用tkinter库创建了一个简单的界面,用户可以输入手机号、选择指定的文件夹,并从文件夹中的Excel文件中查找信息并输出。用户需要确保Excel文件中的手机号码列名为'Phone'。如果找到匹配项,程序会输出该项所在的文件以及条目的详细信息。