使用Tkinter导入GUI的CSV文件无法更新值问题排查求助

我在使用Tkinter开发的GUI中，能够导入CSV文件并添加新列，但无法选中现有值修改为目标值；已设置更新行按钮，点击后无任何反应。以下是我的代码，请指出错误与遗漏之处。

import pandas as pd
import tkinter as tk
from tkinter import filedialog
from tkinter import *
from tkinter import ttk

csv_data = pd.DataFrame()
csv_text = None
entry_values = {}

def create_gui():
    global csv_data, csv_text, entry_values

    def open_csv():
        global csv_data
        csv_path = tk.filedialog.askopenfilename(title='Select CSV File', filetypes=[('CSV Files', '*.csv')])
        if csv_path:
            csv_data = pd.read_csv(csv_path)
            update_csv_display()
            create_entry_widgets()

    def display_csv():
        if csv_data is not None:
            for col in range(len(csv_data.columns)):
                label = tk.Label(csv_frame, text=csv_data.columns[col])
                label.pack()

                for row in range(len(csv_data)):
                    entry = tk.Entry(csv_frame)
                    entry.pack()
                    entry.insert(tk.END, str(csv_data.iloc[row, col]))

    def save_csv():
        global csv_data
        if csv_data is not None:
            csv_path = tk.filedialog.asksaveasfilename(title='Save CSV File', defaultextension='.csv', filetypes=[('CSV Files', '*.csv')])
            csv_data.to_csv(csv_path, index=False)
            print("CSV file saved successfully.")

    def add_column():
        global csv_data
        if csv_data is not None:
            column_name = entry_column.get()
            csv_data[column_name] = ''
            update_csv_display()
            create_entry_widgets()

    def update_csv_display():
        csv_text.delete(1.0, tk.END)
        csv_text.insert(tk.END, csv_data.to_string())

    def create_entry_widgets():
        global entry_values
        for col in csv_data.columns:
            entry_values[col] = StringVar()
            entry = Entry(csv_frame, textvariable=entry_values[col])
            entry.pack(padx=5, pady=5)


    def update_selected_row(event=None):
        print("selected row")
        global csv_data
        selected_items = my_tree.selection()
        print(selected_items)
        if selected_items:
            selected_row = selected_items[0]
            print(selected_row)
            for col, value in entry_values.items():
                print(f"{col}: {value.get()}")
                entry_values[col].set(csv_data.at[selected_row, col])

    def update_csv_data():
        global csv_data
        selected_items = my_tree.selection()
        if selected_items:
            selected_row = selected_items[0]
            for col in csv_data.columns:
                new_value = entry_values[col].get()
                csv_data.at[selected_row, col] = new_value
            update_csv_display()

    global csv_text
    root = Tk()
    root.geometry("1000x800")

    # Create a frame for the CSV data
    csv_frame = Frame(root)
    csv_frame.pack(side=tk.LEFT, padx=10, pady=10)

    csv_text = Text(csv_frame, width=120, height=50)
    csv_text.pack()

    # Create a button to open the CSV file
    csv_button = Button(csv_frame, text='Open CSV', command=open_csv)
    csv_button.pack(pady=10)

    # Create a button to save the CSV file
    save_csv_button = Button(csv_frame, text='Save CSV', command=save_csv)
    save_csv_button.pack(pady=10)

    # Add a column entry field and button for manual column addition
    add_column_frame = Frame(csv_frame)
    add_column_frame.pack(pady=10)

    entry_column = Entry(add_column_frame, width=20)
    entry_column.pack(side=LEFT, padx=5)

    add_column_button = Button(add_column_frame, text='Add Column', command=add_column)
    add_column_button.pack(side=LEFT)

    # Create a Treeview for displaying CSV data
    my_tree = ttk.Treeview(root)
    my_tree.pack(pady=20)

    my_tree.bind("<<TreeviewSelect>>", update_selected_row)

    update_row_button = Button(root, text='Update Row', command=update_selected_row)
    update_row_button.pack(padx=5, pady=5)

    save_changes_button = Button(root, text='Save Changes', command=update_csv_data)
    save_changes_button.pack(padx=5, pady=5)


    root.mainloop()

create_gui()

核心错误与遗漏点 #

1. Treeview未加载数据 #

打开CSV或添加列后，仅更新了csv_text文本框，未将数据同步到Treeview组件，导致Treeview为空，无法选中任何行，这是更新按钮无响应的根本原因。

2. Treeview行ID与DataFrame索引不匹配 #

Treeview返回的选中行ID是组件内部标识（如I001），不是DataFrame的整数索引，直接用csv_data.at[selected_row, col]会找不到对应行数据。

3. 输入框重复创建 #

每次打开CSV或添加列时，create_entry_widgets会在csv_frame中新增输入框，旧输入框未被清除，导致界面混乱，且新的StringVar会覆盖旧的，无法正确关联数据。

4. 按钮功能绑定错误 #

• update_row_button绑定的update_selected_row函数是将选中行数据填充到输入框，而非更新数据，按钮名称与功能不匹配。
• update_csv_data同样存在Treeview行ID转DataFrame索引的错误，无法修改数据。

关键修正代码示例 #

1. 新增Treeview数据加载函数 #

def load_treeview():
    # 清空Treeview现有内容
    my_tree.delete(*my_tree.get_children())
    # 设置列与表头
    my_tree["columns"] = list(csv_data.columns)
    my_tree["show"] = "headings"
    for col in csv_data.columns:
        my_tree.heading(col, text=col)
        my_tree.column(col, width=100)
    # 插入数据，将DataFrame索引设为Treeview的iid
    for index, row in csv_data.iterrows():
        my_tree.insert("", "end", iid=index, values=list(row))

在open_csv和add_column函数末尾添加load_treeview()，替换仅更新csv_text的逻辑。

2. 修正行索引获取逻辑 #

修改update_selected_row和update_csv_data：

def update_selected_row(event=None):
    selected_items = my_tree.selection()
    if selected_items:
        # 将Treeview的iid转换为DataFrame整数索引
        selected_row_idx = int(selected_items[0])
        for col, value_var in entry_values.items():
            value_var.set(csv_data.at[selected_row_idx, col])

def update_csv_data():
    selected_items = my_tree.selection()
    if selected_items:
        selected_row_idx = int(selected_items[0])
        for col in csv_data.columns:
            new_value = entry_values[col].get()
            csv_data.at[selected_row_idx, col] = new_value
        # 同步更新文本框与Treeview
        update_csv_display()
        load_treeview()

3. 修复输入框重复创建问题 #

def create_entry_widgets():
    global entry_values
    # 清除csv_frame中旧的输入框与标签
    for widget in csv_frame.winfo_children():
        if not isinstance(widget, (Text, Button, Frame)):
            widget.destroy()
    # 重新创建输入框
    entry_values.clear()
    for col in csv_data.columns:
        entry_values[col] = StringVar()
        tk.Label(csv_frame, text=col).pack(padx=5, pady=2)
        Entry(csv_frame, textvariable=entry_values[col]).pack(padx=5, pady=2)

4. 修正按钮功能绑定 #

# 按钮功能匹配：加载选中行数据到输入框
load_row_button = Button(root, text='Load Selected Row', command=update_selected_row)
load_row_button.pack(padx=5, pady=5)

# 更新选中行数据
update_row_button = Button(root, text='Update Selected Row', command=update_csv_data)
update_row_button.pack(padx=5, pady=5)

内容的提问来源于stack exchange，提问作者Kartikeya Kawadkar