How to view Excel File or Pandas DataFrame in Tkinter (Python GUI)

#Tkinter #PythonExcel #PythonTutorial #Pandas #DataScience
This video will show you step by step on how to place a Pandas DataFrame or Excel File into a Tkinter GUI.
Programming Language: Python 3.7
Text Editor: Atom (The linter used is Flake8)
Libraries: Pandas, TKinter
The code can be found in the github gist below:
gist.github.com/RamonWill/068...

[@RamonWilliams]

Timestamps 0:00 Intro 1:00 Creating the Root, Frames, Label and Buttons 10:00 Creating the Treeview Widget and scrollbars 14:44 Creating the button commands 16:53 Creating the File Dialog Function (opens file explorer) 19:40 Load Excel File into Treeview (what you most likely came for) 25:54 Testing the code It's probably evident but i didn't check beforehand if it works for csv files. Nevertheless for the code please see the description, the code in the description also works for csv files!

[@logicalprogression9995]

Works for csv's too, just need to swap out some of the File_dialogue filetype params or can feed it a list of pandas acceptable types to make it more generic.

[@johndavies729]

'You're waking up in 7 hours' lmaooo that hit different 😂😂

[@ian3018]

This was unbelievably helpful

[@jgp6711]

A great video illustrating a practical implementation around a Treeview. 👍

[@dipitjaywant8044]

This was extremely helpful. Thanks for this video.

[@VonSchelzen]

Congratulations, you are the best!

[@logicalprogression9995]

Don't leave comments very often but just saying nice one bro, exactly what I was looking for anyway! Nice to have actual explanations behind some of the functionality and parameter sets for a change.

[@RamonWilliams]

much appreciated, just trying to help educate and save people some time :)

[@tedtoad2471]

Excellent tutorial, thanks much. Still trying to figure out how to control the column widths otherwise it is all working great. Got it, in the column loop add tv1.column(column, width= 350)

[@slickwillie3376]

Very educational. I modified it for accepting csv and txt files as well.

[@coupdur7899]

how did you do ? can i get the code please

[@jeremyham764]

Nice, clear and simple thx

[@tomaszkubczyk2551]

You're a life saver. Cheers.

[@RamonWilliams]

no problem

[@ghaliahmed]

I want to thanks for this clean explanation ... 🇩🇿👍

[@martin-xq7te]

Great tutorial. Thank you for keeping it simple. How about showing how to alter the df frame and return as excel file

[@lapasta9925]

thanks helped me much!

[@sreerampillai1339]

Awesome , really well explained!

[@RamonWilliams]

Glad it was helpful!

[@canerucal]

you saved my life. thank you very much !

[@RamonWilliams]

You're welcome!

[@aminegatou4492]

and now do a video about how to edit those values or add new values or delete values and automatically save it. It will help a lot

[@ajayiomofayowa2258]

You are a life saver Jezz

[@RamonWilliams]

no problem

[@tribaldcon]

Big thanks to you

[@digitalmachine0101]

Good information

[@vishnuvijay2959]

very nice!

[@temitopecomfort2636]

Thank you for the tutorials. Please how do i create a filter dataframe from the load excel data and have it displayed on another window

[@dwithidaya4168]

Thank you so much..You saved me

[@RamonWilliams]

Happy to help

[@alan6031]

Thanks a lot for this! Very helpful. I have one question, how can I work with loaded excel/csv file, for example if I want to get the values from it and use them for any calculations? Even a little hint will help, thank you!

[@TheSenseii915]

This was great, thank you. I was actually looking for a video that would show me how to allow a user to select an excel file and then have my program run pandas stuff on it and then return a new dataframe (that was modified as per the pandas stuff) and then save it wherever the user wanted to save it as an excel file. Do you have any content like that? Thank you.

[@carlosngaba5721]

Hi. Thanks for the tutorial. I got a problem with the attribute yview and xview for treescrolly and treescrollx.

[@majidzinkoohi330]

Hi Ramon Williams, Thanks a lot for this! Very helpful. I want to open multiple excel files and plot them. Tried to add some code but it didn't work. Can you help me please ?

[@kiefah15]

This code helped me a lot. I just wanted to ask, how do I get rid of an additional "unnamed" column without hard coding it?

[@idonotcomplyrevolution]

hi Ramon, im using gspread/pandas/numpy module and want to load a specific google sheet into a tkinter window, ive got it all working fine without tkinter/gui, any help would be dearly appreciated as ive been struggling on this for some weeks now as im a newbie python coder. best regards simon. also really enjoyed your tut and subbed.

[@charlesdixon1950]

I am getting some errors. No such file as (file_path) when i click load, so the try/except isnt working and the browse does not work probablt because of the initialdir. i didnt see this on yout github but ill look again

[@alphinkj8351]

Thanks Ramson....I like your explanations also but i think if can reduce video length less than 7:59 minutes it will help you to increase your subscribers. Try to create tutorial videos. All the best for your KZbin journey.

[@RamonWilliams]

Thanks, looking back on this video i could've easily reduced it.

[@Braha_19]

Great Explanation. But, when i try the treeview widget i receive an error stating "NULL main window". Copied your code from "Github". Can you help on this. TIA

[@sirfsimran482]

Thanks Buddy for this awesome script :) Can you please add functionality in which user can select some format or style from drop down & fetch an excel report. But Nice Script Awesome :) :) :)

[@RamonWilliams]

Thanks Abhishek, I've created a tutorial recently that kind of extends on this script. It allows you to drag and drop csv files directly into the GUI. Which works better than a drop down in my option because a drop down would have to be hard coded i believe.

[@graythistle]

nice! ... now how do you move items up, delete them, and insert new ones somewhere between two rows...

[@gemorn]

how to perform search opration on selected excel file plz make video on this topic

[@RamonWilliams]

I will try to create a tutorial for that next week

[@MrDogbural]

If excel data cells have hyperlink, can we bring them into listbox and they can be clickable?

[@RamonWilliams]

Hi Minki, Yes this can definitely be done. I have only done this for a Treeview though. In my latest video "How to Bind to Widgets in Tkinter (Python GUI)" I show exactly how you can go about achieving this

[@alwaaffa]

how I can create GUI for search box or search engine to the dataset by using python?

[@RamonWilliams]

I know this request is old but i will try to create a tutorial this week showing this

[@user-hl9kq2tw7o]

help somebody please, i got an error: 'Index' object is not callable

[@dwithidaya4168]

Can you please extend this program to plot a graph using the loaded excel file

[@RamonWilliams]

This is actually quite easy to do. You can store the dataframe in memory each time is it loaded and have a button that plots the data based on an x and y variable you set

[@keresnerezza23]

👍👍👍 Jesus christ u r awesome.thanks.

[@RamonWilliams]

Thank you

[@gy9gy8]

Hi，Could I just use tkinter load file data to python?

[@PhoebeAshmore13]

Hi - just seen no one has replied! I've just done a project that required data to be loaded in by the user. I used the filedialog module tkinter to get the file paths and then stored those in a variable. I then read the file in through pandas and stored it within the program as a dataframe. Hope that helps - I'm afraid I can't give exact code snippets because they're for a university assignment.

[@johnjohnson4887]

Thank you so much. But whenever I load the excel / csv file it shows me "The file you selected is not valid." Why is that. How can I fix it?

[@RamonWilliams]

Quick questions are you using the code in the video or the code in the github gist in the description? are you trying to load an excel file? if you are trying to load an excel file the code in the github gist should work. I missed out a few lines in this video that would enable it to work on excel files. therefore the code on this video only works on csv

[@NeroNero-zo8gr]

​@@RamonWilliams 😢

[@yannickbass5102]

I have copied the source code on github and ran it. I have a problem with tv.configure line it brings the following : invalid command name ".!labelframe.!treeview". Can you tell me what to do, please? Thanks for this video?

[@RamonWilliams]

did you change the source in any way?

[@RamonWilliams]

No problem Yannick, a few questions i have. What version of python are you using? Python 3 right? Are you getting the error as soon as you run the script or is it occuring when an excel file has already been loaded? I copied and pasted the source code myself and it worked fine. The error you have seems to occur when a widget is called after it has been destroyed and the only thing that destroyed here is the children of the treeview

[@enosjonathanraharja5133]

can this works with csv files?

[@slickwillie3376]

You'll need to do some modification. Took me about an hour to figure it out, but works great now with csv, txt, and xlsx file extensions. Use the If file_path.split(".")[-1] == "csv": statement (same for .txt extension) and make the assignments in the load_file function conditional. Good luck!

[@naxishah7493]

how can I solve error like "unsupported format : Expected BOF record"

[@RamonWilliams]

If you tried to read in a csv file you would've got that error as i forgot to account for csv files in this videos code. However the code in the GitHub Gist in the description works for csv files.

[@plaine3308]

How can I edit the code so that it always opens a specific file of my choice

[@RamonWilliams]

Hi Plaine, You could remove the file dialog function and the "Browse a file" button. and then you could either make label or filepath variable (inside the load excel data function) equal to the path of your specific file

[@plaine3308]

@@RamonWilliams Thank you