Have a global df in tkinter-CodePudding

Hello I am on a project for my school and I have to code a stock manager.

import tkinter as tk
from tkinter import filedialog, messagebox, ttk, simpledialog
from PIL import Image,ImageTk
import pandas as pd

# initalise the tkinter GUI
window = tk.Tk()

window.geometry("1280x720") # set the root dimensions
window.pack_propagate(False) # tells the root to not let the widgets inside it determine its size.
window.resizable(0, 0) # makes the root window fixed in size.
window.title('e-Zone Manager')


bg=tk.PhotoImage(file='image2.png')
canva=tk.Canvas(window)
canva.pack(fill="both",expand=True)
canva.create_image(0,0,image=bg,anchor="nw")

logo=tk.PhotoImage(file="logo.png")
window.iconphoto(False,logo)

# Frame for TreeView
frame = tk.LabelFrame(window,)
frame.place(height=300, width=750, rely=0.2, relx=0.21)

# Frame for open file dialog
data_frame = tk.LabelFrame(window, text="Open File")
data_frame.place(height=100, width=400, rely=0.75, relx=0.05)

#Frame pour les outils
tool_frame=tk.LabelFrame(window)
tool_frame.place(height=100,width=600,rely=0.75,relx=0.45)

# Buttons
button1 = tk.Button(data_frame, text="Browse A File", command=lambda: File_dialog())
button1.place(rely=0.65, relx=0.50)

button2 = tk.Button(data_frame, text="Load File", command=lambda: Load_excel_data())
button2.place(rely=0.65, relx=0.30)


button3 = tk.Button(tool_frame, text="Ajout", command=lambda: ajout())
button3.place(rely=0.65,relx=0.30)

button4=tk.Button(tool_frame,text="Supprimer",command=lambda: supp())
button4.place(rely=0.75,relx=0.40)

# The file/file path text
label_file = ttk.Label(data_frame, text="No File Selected")
label_file.place(rely=0, relx=0)


## Treeview Widget
tv1 = ttk.Treeview(frame)
tv1.place(relheight=1, relwidth=1) # set the height and width of the widget to 100% of its container (frame1).

treescrolly = tk.Scrollbar(frame, orient="vertical", command=tv1.yview) # command means update the yaxis view of the widget
treescrollx = tk.Scrollbar(frame, orient="horizontal", command=tv1.xview) # command means update the xaxis view of the widget
tv1.configure(xscrollcommand=treescrollx.set, yscrollcommand=treescrolly.set) # assign the scrollbars to the Treeview Widget
treescrollx.pack(side="bottom", fill="x") # make the scrollbar fill the x axis of the Treeview widget
treescrolly.pack(side="right", fill="y") # make the scrollbar fill the y axis of the Treeview widget




def File_dialog():
    """This Function will open the file explorer and assign the chosen file path to label_file"""
    filename = filedialog.askopenfilename(initialdir="/",
                                          title="Select A File",
                                          filetype=(("xlsx files", "*.xlsx"),("All Files", "*.*")))
    label_file["text"] = filename
    return None


def refresh_df():
    file_path = label_file["text"]
    excel_filename = r"{}".format(file_path)
    df = pd.read_excel(excel_filename)
    clear_data()
    tv1["column"] = list(df.columns)
    tv1["show"] = "headings"
    for column in tv1["columns"]:
        tv1.heading(column, text=column) # let the column heading = column name
        
    df_rows = df.to_numpy().tolist() # turns the dataframe into a list of lists
    for row in df_rows:
        tv1.insert("", "end", values=row) # inserts each list into the treeview. For parameters see https://docs.python.org/3/library/tkinter.ttk.html#tkinter.ttk.Treeview.insert

def Load_excel_data():
    """If the file selected is valid this will load the file into the Treeview"""
    file_path = label_file["text"]
    try:
        excel_filename = r"{}".format(file_path)
        if excel_filename[-4:] == ".csv":
            df = pd.read_csv(excel_filename)
        else:
            df = pd.read_excel(excel_filename)

    except ValueError:
        tk.messagebox.showerror("Information", "The file you have chosen is invalid")
        return None
    except FileNotFoundError:
        tk.messagebox.showerror("Information", f"No such file as {file_path}")
        return None
    clear_data()
    tv1["column"] = list(df.columns)
    tv1["show"] = "headings"
    for column in tv1["columns"]:
        tv1.heading(column, text=column) # let the column heading = column name
        
    df_rows = df.to_numpy().tolist() # turns the dataframe into a list of lists
    for row in df_rows:
        tv1.insert("", "end", values=row)
    return None
    

def clear_data():
    tv1.delete(*tv1.get_children())
    return None


def supp(df):
    ligne_supp=simpledialog.askinteger("Input","Quel ligne voulez vous supprimer ?")
    df=df.drop(ligne_supp)
    #df.reset_index(inplace=True)
    clear_data()
    tv1["column"] = list(df.columns)
    tv1["show"] = "headings"
    for column in tv1["columns"]:
        tv1.heading(column, text=column) # let the column heading = column name
        
    df_rows = df.to_numpy().tolist() # turns the dataframe into a list of lists
    for row in df_rows:
        tv1.insert("", "end", values=row)

window.mainloop()

My problem is I want to have a global dataframe i can use in my differents functions, because now in each function i write on a new df and this don't update my df in my GUI. But the fact that I ask for the path of my excel file, make that I can't declare my df in my main().

If you have hints or solutions I will be grateful !

I've tried to upload my df in each function but this wrote on my excel file ands create a new column, so I can't use my function two time.

CodePudding user response：

Global objects (not recommended)

You need to create global object global variable_name

And in every function or method u need to mark that u want to use this object by at the beginning of the function/method global variable_name