i have successfully create the treeview by CSV but when i try to save treevew data to dataframe it give me the error please see my code and rectify and give me right code
import pandas as pd
from tkinter import ttk
import tkinter as tk
mywin=tk.Tk()
mywin.geometry('300x300')
df=pd.read_csv('c:/erp/book1.csv')
df_list=list(df.columns.values)
df_rset=df.to_numpy().tolist()
df_tree=ttk.Treeview(mywin,columns=df_list)
df_tree.pack()
for i in df_list:
df_tree.column(i,width=100,anchor='c')
df_tree.heading(i,text=i)
for dt in df_rset:
v=[r for r in dt]
df_tree.insert('','end',iid=v[0], values=v)
treeview_columns = [] # list of names here
treeview_df = pd.DataFrame(None, columns=treeview_columns)
for row in df_tree.get_children():
values = pd.DataFrame([df_tree.item(row)["values"]], columns=treeview_columns)
treeview_df = treeview_df.append(values)
mywin.mainloop()
this is error
in nested_data_to_arrays
arrays, columns = to_arrays(data, columns, dtype=dtype)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:UsersAliAppDataLocalProgramsPythonPython312Libsite-packagespandascoreinternalsconstruction.py", line 845, in to_arrays
content, columns = _finalize_columns_and_data(arr, columns, dtype)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:UsersAliAppDataLocalProgramsPythonPython312Libsite-packagespandascoreinternalsconstruction.py", line 942, in _finalize_columns_and_data
raise ValueError(err) from err
ValueError: 0 columns passed, passed data had 7 columns
PS C:mainfolmfatt>
waiting for your valuable reply