Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· openaiHugging Face Suzhen/CodeChat

有4个文件:results-1-day.xlsx、results-1-hour.xlsx、results-4-hour.xlsx、results-30-minute.xlsx;它…

  1. User

    有4个文件:results-1-day.xlsx、results-1-hour.xlsx、results-4-hour.xlsx、results-30-minute.xlsx;它们都含有列标题且都只有8列M行。现要求用TK做一个窗口,上面有4个单选器,分别对应这4个文件,要求当按下“Read”按钮时,能将对应的文件内容显示在窗口上;要求显示出的文档内容能在点击列标题的情况下对数据进行排序;双击某一行时能弹窗显示当前行第二列的单元格内容;再额外添加一列,以显示排序时的序号;能单独定义每一列的显示宽度

  2. Assistant

    这是使用Tkinter库创建Python脚本的示例,以完成您提出的任务。您需要安装pandas和openpyxl库来运行此代码。

    import tkinter as tk
    from tkinter import ttk
    from tkinter import messagebox
    import pandas as pd
    from functools import partial
    
    FILE_MAP = {
        "results-1-day": "results-1-day.xlsx",
        "results-1-hour": "results-1-hour.xlsx",
        "results-4-hour": "results-4-hour.xlsx",
        "results-30-minute": "results-30-minute.xlsx",
    }
    
    class MainApplication(tk.Tk):
        def __init__(self):
            super().__init__()
            self.title("Excel Reader")
            self.geometry("800x600")
    
            self.column_widths = [50, 100, 100, 100, 100, 100, 100, 100, 50]
    
            self.var = tk.StringVar()
            self.var.set("results-1-day")
    
            for i, (text, _) in enumerate(FILE_MAP.items()):
                tk.Radiobutton(
                    self, text=text, variable=self.var, value=text, padx=20
                ).grid(row=0, column=i)
    
            self.tree = ttk.Treeview(self, columns=list(range(1, 9)), show="headings")
            self.tree.grid(row=1, column=0, columnspan=4, padx=20, pady=20)
    
            for col in self.tree["columns"]:
                self.tree.heading(col, text="Column " + str(col), command=partial(self.sort_by, col))
                self.tree.column(col, width=self.column_widths[int(col)], anchor="center")
    
            tk.Button(self, text="Read", command=self.read_file).grid(row=2, column=0)
            self.tree.bind("<Double-1>", self.show_details)
    
        def read_file(self):
            choice = self.var.get()
            file_name = FILE_MAP[choice]
            df = pd.read_excel(file_name)
            self.tree.delete(*self.tree.get_children())
            for index, row in df.iterrows():
                self.tree.insert("", "end", values=row.tolist() + [index+1])
    
        def sort_by(self, col_id):
            tree_data = list(self.tree.get_children())
            tree_data.sort(key=lambda x: self.tree.set(x, col_id), reverse=True)
            for index, item in enumerate(tree_data):
                self.tree.move(item, '', index)
                self.tree.set(item, len(self.tree["columns"]), index+1)
    
        def show_details(self, _):
            item_id = self.tree.focus()
            col2_value = self.tree.item(item_id)["values"][1]
            messagebox.showinfo("Detail", f"Column 2 value: {col2_value}")
    
    app = MainApplication()
    app.mainloop()
    

    请确保您将文件路径更新为本地计算机中这些文件的正确路径。运行此脚本将打开一个窗口,其中包含4个单选按钮、一个表和一个“Read”按钮。根据您的选择,这将读取所选文件并将其显示在表中。点击列标题可以对数据进行排序,并将在额外的一列中显示排序的序号。双击行会显示一个弹出窗口,其中包含行的第二列值。

  3. User

    是生成了一个窗口,但窗口没任何内容

  4. Assistant

    请确保您的文件名和路径正确,以及确保Python脚本位于与Excel文件相同的目录中。您可以尝试替换FILE_MAP字典中的文件名为完整的文件路径。例如: "results-1-day": "C:/path/to/your/results-1-day.xlsx"

    如果仍然无法显示内容,请确保您已经安装了必要的库,例如pandas和openpyxl。您可以使用以下命令安装它们:

    pip install pandas openpyxl
    

    还可以检查Python命令窗口是否有错误信息以进行调试。如果您仍然无法解决问题,请在此提供更多详细信息,以便我们可以更好地帮助您。

  5. User

    可以显示了,但存在两个问题:1.列标题不对,请用文档自带的列标题。2,排序有误,因表格某列内容是“50%”这样的带百分号的字符

  6. Assistant

    非常抱歉!下面是更新后的代码,它现在使用文件中的列名作为标题,同时对百分数列进行排序时,我也做了修改,以便正确处理带百分号的值。

    import tkinter as tk
    from tkinter import ttk
    from tkinter import messagebox
    import pandas as pd
    from functools import partial
    
    FILE_MAP = {
        "results-1-day": "results-1-day.xlsx",
        "results-1-hour": "results-1-hour.xlsx",
        "results-4-hour": "results-4-hour.xlsx",
        "results-30-minute": "results-30-minute.xlsx",
    }
    
    class MainApplication(tk.Tk):
        def __init__(self):
            super().__init__()
            self.title("Excel Reader")
            self.geometry("800x600")
    
            self.column_widths = [50, 100, 100, 100, 100, 100, 100, 100, 50]
    
            self.var = tk.StringVar()
            self.var.set("results-1-day")
    
            for i, (text, _) in enumerate(FILE_MAP.items()):
                tk.Radiobutton(
                    self, text=text, variable=self.var, value=text, padx=20
                ).grid(row=0, column=i)
    
            self.tree = ttk.Treeview(self, columns=list(range(1, 9)), show="headings")
            self.tree.grid(row=1, column=0, columnspan=4, padx=20, pady=20)
    
            self.headings = []
    
            tk.Button(self, text="Read", command=self.read_file).grid(row=2, column=0)
            self.tree.bind("<Double-1>", self.show_details)
    
        def read_file(self):
            choice = self.var.get()
            file_name = FILE_MAP[choice]
            df = pd.read_excel(file_name)
            self.tree.delete(*self.tree.get_children())
            if not self.headings:
                self.headings = df.columns
                for i, col_name in enumerate(df.columns, 1):
                    self.tree.heading(i, text=col_name, command=partial(self.sort_by, i))
                    self.tree.column(i, width=self.column_widths[i], anchor="center")
            for index, row in df.iterrows():
                self.tree.insert("", "end", values=row.tolist() + [index+1])
    
        def sort_by(self, col_id):
            tree_data = list(self.tree.get_children())
            tree_data.sort(
                key=lambda x: (float(self.tree.set(x, col_id).strip('%')) if '%' in self.tree.set(x, col_id) else self.tree.set(x, col_id)),
                reverse=True
            )
            
            for index, item in enumerate(tree_data):
                self.tree.move(item, '', index)
                self.tree.set(item, len(self.tree["columns"]), index+1)
    
        def show_details(self, _):
            item_id = self.tree.focus()
            col2_value = self.tree.item(item_id)["values"][1]
            messagebox.showinfo("Detail", f"Column 2 value: {col2_value}")
    
    app = MainApplication()
    app.mainloop()
    

    现在脚本会显示原始文件的列名,并处理正确地对带有百分号的数值进行排序。有关其他排序问题,请确保提供了有关如何更改排序规则的详细信息。这将有助于我们更好地为您提供帮助。

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.