Tkinter interface to search and filter Pandas DataFrame and display rows in Treeview

00:00 Introduction to applications
00:43 Layout and importing libraries
01:34 Creating Pandas DataFrame using Excel file by read_excel()
02:20 Adding components to Tkinter GUI window
06:18 my_search() function to filter dataframe
10:00 Adding treeview to show the filtered dataframe
12:18 Adding headers to Treeview based on result
14:23 Inserting rows of data to Treeview



Download Source code from here

#FilterDataFrame #Pandas #SearchData #SearchExcel #Treeview #showFilteredData #queryDataFRame #plus2net #python

[philmillington]

Hi Works great, put the extra line of code in and change the 'def search' function to (*args) and bingo works great. Just what I have been looking. Thanks very much for your help. Kind Regards Phil

[raymundofelipeolvera]

Great vide, helped me a lot, only one question, how would you get mixed values as object type ( int and str (100054, 01-0157-52-1) ?

[philmillington]

Hi Thanks for the reply, I will give a try later and let you know how I get on, Regards Phil

[philmillington]

Thanks for your help, all working great now, ps... is there a way so when you type in the query it will automaticaly update the grid while you type? Regards Phil

[breadesal]

is there a video tutorial you made that includes the explore file explorer and select a csv file to read and write with the search filter. I need to include both import csv file, search filter and export the displayed filtered data

[philmillington]

Hi, Can we click the Treeview and put the item click in the search tk.Entry box>

[philmillington]

Hi There thanks for the reply, it does work when i have the column called 'name' but I want the column to be called 'Description' can I make the change to the code to make this work? Reagards Phil

[philmillington]

when I enter a string for my search I get the error message... AttributeError: 'DataFrame' object has no attribute 'name' whats do you think went wrong Regards Phil

[alicfpamohamed]

hi, thanks for the lessons, i'm new here and in programming world, i typed as your video step by step, when i excute the file i have no error but the Terminal shows only the directory where my files and nothing ....

[SwatcomComputers]

Sir one video on chatgpt should be in the pipeline...

[AhmedHassan]

How i can put vedio in tkinter
i want to put url and vedio append in window how can i do that