如何在Tkinter中显示数据框 [英] How to display a dataframe in tkinter

问题描述

我是Python的新手，甚至是tkinter的新手.

I am new to Python and even newer to tkinter.

我已经利用了stackoverflow中的代码(在tkinter中的两个帧之间切换)生成一个程序，在该程序中，将根据用户选择的选项来调用新框架并将其放置在另一个框架上.下面是我的代码的精简版.还有很多帧.

I've utilised code from stackoverflow (Switch between two frames in tkinter) to produce a program where new frames are called and placed on top of each other depending on what options the user selects. A stripped down version of my code is below. There are a lot more frames.

import tkinter as tk                
from tkinter import font  as tkfont 
import pandas as pd

class My_GUI(tk.Tk):

    def __init__(self, *args, **kwargs):
        tk.Tk.__init__(self, *args, **kwargs)

        self.title_font = tkfont.Font(family='Helvetica', size=18, weight="bold", slant="italic")


        container = tk.Frame(self)
        container.pack(side="top", fill="both", expand=True)
        container.grid_rowconfigure(0, weight=1)
        container.grid_columnconfigure(0, weight=1)

        self.frames = {}
        for F in (StartPage, Page_2):
            page_name = F.__name__
            frame = F(parent=container, controller=self)
            self.frames[page_name] = frame


            frame.grid(row=0, column=0, sticky="nsew")

        self.show_frame("StartPage")

    def show_frame(self, page_name):
        '''Show a frame for the given page name'''
        frame = self.frames[page_name]
        frame.tkraise()

class StartPage(tk.Frame):

    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        label = tk.Label(self, text="Welcome to....", font=controller.title_font)
        label.pack(side="top", fill="x", pady=10)

        button1 = tk.Button(self, text="Option selected",
                            command=lambda: controller.show_frame("Page_2"))
        button1.pack()



class Page_2(tk.Frame):

    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        label = tk.Label(self, text="The payment options are displayed below", font=controller.title_font)
        label.pack(side="top", fill="x", pady=10)

        #I want the able to be display the dataframe here

        button = tk.Button(self, text="Restart",
                           command=lambda: controller.show_frame("StartPage"))
        button.pack()

a = {'Option_1':[150,82.50,150,157.50,78.75],
     'Option2':[245,134.75,245,257.25,128.63]}
df = pd.DataFrame(a,index=['a',
                    'b',
                    'c',
                    'd',
                    'e']) 

print(df.iloc[:6,1:2])

if __name__ == "__main__":
    app = My_GUI()
    app.mainloop()

出现Page_2时，我希望它显示一个包含以下代码的数据框.

When Page_2 appears I want it to display a dataframe with the code below.

a = {'Option_1':[150,82.50,150,157.50,78.75],
     'Option2':[245,134.75,245,257.25,128.63]}
df = pd.DataFrame(a,index=['a',
                    'b',
                    'c',
                    'd',
                    'e']) 

print(df.iloc[:6,1:2])

例如，我搜索过如何在tkinter窗口(准确地说是tk框架)(未提供答案)和其他网站中显示熊猫数据框，以解决类似问题，但没有成功.

I've searched SO e.g. How to display a pandas dataframe in a tkinter window (tk frame to be precise) (no answer provided) and other websites for an answer to similar question but without success.

当我选择Page_2时，如何以及如何将数据框代码选择显示在我想要的区域中?

How and where would I place my dataframe code selection to appear in the area I want when I select Page_2?

推荐答案

首先，您可以查看通常使用的 Label 和 Text 小部件在您的GUI中显示文本.

As a start, you could have a look at Label and Text widgets, that usually are used to display text in your GUI.

您可能会尝试以下操作:

You could probably try something like:

class Page_2(tk.Frame):
    def __init__(self, parent, controller):
        # ... your code ...
        global df # quick and dirty way to access `df`, think about making it an attribute or creating a function that returns it
        text = tk.Text(self)
        text.insert(tk.END, str(df.iloc[:6,1:2]))
        text.pack()
        # lbl = tk.Label(self, text=str(df.iloc[:6,1:2])) # other option
        # lbl.pack()                                      #

最后，它实际上归结为您想要的花式:这些小部件是高度可定制的，因此您可以实现一些令人赏心悦目的东西，而不是此示例的基本外观.

In the end, it really boils down to how fancy you want to be: the widgets are highly customizable, so you could achieve something very pleasing to the eye instead of the basic look of this example.

我添加了 Combobox 小部件以选择要显示的选项，并添加了 Button 将其打印到您选择的"display"小部件中.

I added a Combobox widget to select the option to display and a Button that prints it to the "display" widget of your choice.

from tkinter import ttk # necessary for the Combobox widget

# ... your code ...

class Page_2(tk.Frame):

    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        self.controller = controller
        label = tk.Label(self, text="The payment options are displayed below", font=controller.title_font)
        label.pack(side="top", fill="x", pady=10)

        global df
        tk.Label(self, text='Select option:').pack()
        self.options = ttk.Combobox(self, values=list(df.columns))
        self.options.pack()
        tk.Button(self, text='Show option', command=self.show_option).pack()

        self.text = tk.Text(self)
        self.text.pack()

        tk.Button(self, text="Restart",
                  command=lambda: controller.show_frame("StartPage")).pack()

    def show_option(self):
        identifier = self.options.get() # get option
        self.text.delete(1.0, tk.END)   # empty widget to print new text
        self.text.insert(tk.END, str(df[identifier]))

显示的文本是数据框列的默认 str ing表示形式；保留自定义文本作为练习.

The text that is displayed is the default string representation of a data-frame's column; a custom text is left as an exercise.

这篇关于如何在Tkinter中显示数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！