could you please review my code? The first treeview is filled successfully, but I’m encountering an error when trying to fill the second treeview. Could you please help me identify any duplications and provide a solution for why the second treeview is not being filled with data from the CSV file? Thank you.
this is my code
import pandas as pd
from tkinter import *
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox, ttk
root = tk.Tk()
pw = ttk.PanedWindow(orient="horizontal")
sidebar = ttk.PanedWindow(pw, orient="vertical")
main = tk.Frame(pw, width=400, height=400, background="black")
sidebar_top = tk.Frame(sidebar, width=200, height=200, background="gray")
sidebar_bottom = tk.Frame(sidebar, width=200, height=200, background="white")
def show_selection2():
item = df_tree2.selection()[0]
cell = df_tree2.item(item)['values'][1]
def show_selection3():
print('tswting')
def show_selection5():
item = df_tree5.selection()[0]
pw.pack(fill="both", expand=True)
pw.add(sidebar)
pw.add(main)
sidebar.add(sidebar_top)
sidebar.add(sidebar_bottom)
df=pd.read_csv('c:/erp/book2.csv')
df_list=list(df.columns.values)
df_rset=df.to_numpy().tolist()
df_tree5=ttk.Treeview(sidebar_top,columns=df_list)
df_tree5.pack()
button5 = ttk.Button(sidebar_top,text="Mostrar selección", command=show_selection5)
button5.pack(side = BOTTOM)
for dt in df_rset:
v=[r for r in dt]
df_tree5.insert('','end',iid=v[0], values=v)
##================================
df=pd.read_csv('c:/erp/book1.csv')
df_list=list(df.columns.values)
df_rset=df.to_numpy().tolist()
df_tree2=ttk.Treeview(sidebar_bottom,columns=df_list)
df_tree2.pack()
button2 = ttk.Button(sidebar_bottom,text="Mostrar selección", command=show_selection2)
button2.pack()
for i in df_list:
df_tree2.column(i,width=100,anchor='c')
df_tree2.heading(i,text=i)
for dt in df_rset:
v=[r for r in dt]
df_tree2.insert('','end',iid=v[0], values=v)
root.mainloop()
this is error -================
Traceback (most recent call last):
File "c:mainfolmfattdftotreeviewtesting.py", line 62, in <module>
df_tree2.insert('','end',iid=v[0], values=v)
File "C:UsersAliAppDataLocalProgramsPythonPython312Libtkinterttk.py", line 1336, in insert
res = self.tk.call(self._w, "insert", parent, index,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
_tkinter.TclError: Item FINAMACE already exists
PS C:mainfolmfatt> ^C
2