gpt-4-0314· OpenAI WildChat-4.8M (AI2)
写一段Python,用tkinter: 1,输入手机号,从后台Excel表格查找,实时显示用户所有信息
- User
写一段Python,用tkinter: 1,输入手机号,从后台Excel表格查找,实时显示用户所有信息
- Assistant
在当前目录中创建一个名为phonebook.xlsx文件,然后在文件中创建一个表格以存储数据。然后在Python文件中使用以下代码。确保安装了pandas & openpyxl模块。
pip install pandas openpyxl.from tkinter import * import pandas as pd def search(): try: df = pd.read_excel('phonebook.xlsx') phone = entry_phone.get() result = df.loc[df['phone'] == int(phone)].to_string(index=False) if not result: msg = f"No data found for phone number: {phone}." else: msg = f"Data for phone number: {phone}\n{result}" labelText.set(msg) entry_phone.delete(0, END) except: labelText.set("Error occurred!") root = Tk() root.title("Phonebook") frame = Frame(root) frame.pack() label = Label(frame, text="Enter Phone Number:") label.grid(row=0, column=0) entry_phone = Entry(frame) entry_phone.grid(row=0, column=1) button = Button(frame, text="Find", command=search) button.grid(row=1, columnspan=2) labelText = StringVar() resultsLabel = Label(frame, textvariable=labelText) resultsLabel.grid(row=2, columnspan=2) root.mainloop()这将在数据表格中查找您提供的手机号,并返回与该手机号码关联的所有信息。DataFrame中的数据按行查找,然后显示在GUI上。
- User
修改一下代码: 1,输入号码直接实时显示结果 2,结果以表格形式展现
- Assistant
为实现这些功能,我们可以使用以下代码。将创建名为"phonebook.xlsx"的Excel文件,同时在文件中创建一个名为"Data"的工作表来添加数据。然后在Python文件中使用以下代码。确保安装了pandas & openpyxl模块。
pip install pandas openpyxl.from tkinter import * import pandas as pd from tkinter import ttk def on_key_release(event): search() def search(): try: df = pd.read_excel('phonebook.xlsx', sheet_name='Data') phone = entry_phone.get() result = df.loc[df['phone'] == int(phone)] if phone else pd.DataFrame() # Show data only when the phone number is entered resultsTable.delete(*resultsTable.get_children()) for index, row in result.iterrows(): resultsTable.insert("", "end", values=(row['name'], row['phone'], row['email'])) if phone and not result.empty: resultsTable.grid(row=2, column=0, columnspan=2) else: resultsTable.grid_remove() except: resultsTable.grid_remove() def on_closing(): root.destroy() root = Tk() root.title("Phonebook") frame = Frame(root) frame.pack() label = Label(frame, text="Enter Phone Number:") label.grid(row=0, column=0) entry_phone = Entry(frame) entry_phone.grid(row=0, column=1) entry_phone.bind('<KeyRelease>', on_key_release) resultsTable = ttk.Treeview(frame, columns=('Name', 'Phone', 'Email'), show='headings') resultsTable.heading('Name', text='Name') resultsTable.heading('Phone', text='Phone') resultsTable.heading('Email', text='Email') scrollbar = ttk.Scrollbar(frame, orient='vertical', command=resultsTable.yview) scrollbar.grid(row=2, column=2, sticky='ns') resultsTable.configure(yscrollcommand=scrollbar.set) root.protocol("WM_DELETE_WINDOW", on_closing) root.mainloop()此代码会直接在输入手机号时实时显示搜索结果,而不需要点击按钮。结果也会以表格形式显示在窗口中。