Table Editor in Python with pandastable

Key Takeaways

what is going on guys welcome back in this video today we're going to learn how to easily build a simple table editor in Python with a graphical user interface almost like a minimalistic Excel clone using a package called Panda table so let us get right into [Music] it all right so this is really going to be a super simple tutorial in this video today we're going to work with an external python package called Panda tape and it's going to allow us to easily build a simple table editor with a graphical user interface in Python now the idea is we're going to build our graphical user interface with TK inter the core python package and then this pandas table package introduces a new component or a new widget you could say to the GUI called the table and it works basically like a very very minimalistic version of excel so we have the ability to add rows to change the content of files to Import and Export uh to filter to Aggregate and to sort and so on so it's a very minimalistic version of a uh sheet application you could say even though it doesn't have nearly as much functionality but it's a very easy way to do that and you don't really have to do much coding you just have to add the component to your application which is why I say it's going to be a very simple video so what we're going to do is we're going to open up our command line and we're going to install the packages that we need uh so we're going to use pip or pip 3 and install and then obviously pandas if you don't have it on your system yet and second pandas table the package that is going to give us this uh widget now what we're going to do in our code is we're going to say import TK inter s TK this is core python then import pandas aspd and from pandas table we want to import the table now we're going to model our application as a class I'm going to call this your table editor and we're going to provide a simple init method here we're going to define a root element so the root is going to be a TK instance we're going to set a title let's call this just table editor and now what we need to do is we need to add to this root window a frame and into this Frame we need to add the table we cannot add the table directly into the window we need to First create a frame so we're going to say self. frame is equal to TK frame part of self. root then self. frame is going to be packed and then we're going to say self. table is equal to table and here now we can provide a couple of things now first of all of course it's part of the frame but then we can also provide a default um a default data frame so we can say that the data frame is some data frame or we can just leave it as none so this is also possible we can just create the table I can say self table show and then self. root main Loop to run the application then I can go down here and say if uncore name uncore uncore equals then main if that's the case create an instance of table editor and this will already result in our application uh showing this table editor tool here however you can see we cannot really do a lot we don't have any data in here we don't have any buttons that we can work with so what we can do right away is we can go ahead and we can say that we want to enable two things we want to show the status bar so show status bar true and we want to show the toolbar which has all the functionality so I can run this and now you can see we don't have any data yet but we still have or we already have uh buttons here load a table we can save we can import CSV we can load an Excel file we can copy the table to clipboard we can paste the table we can do um operations like transposing aggregating and so on we can merge concatenate join we can filter we can do calculations we can fit models uh we can do a lot of things visually here just by adding the pandis table component now what we can do is we can define a sample data frame up here let's call this sample DF it's going to be a PD data frame uh let's just add some data here column one we'll have the values 1 2 3 then [Music] maybe column 2 column 3 let's use here A B C and then down here maybe something like four five six so now I can set this as the default data frame I can say data frame equals and then sample DF and then you can see we have the data here and now of course I can change it I can change this to six for example probably I have to press enter uh and then I can save this for example I can say save I can navigate to my documents directory where is it I have a lot of hidden directories here documents programming neural 9 python current and here of course I can save it as a pickle file but I can also go to all files and I can say data. CSV and this will automatically SA sa it as a CSV file as you can see here and um it will also save the six not the five so it saved the edited version and this is just a simple example right I can do a lot of more things I can add rows um I can I can change values I can uh transpose there you go I can transpose the whole uh data frame I can aggregate uh on different columns with different functions here uh I don't want to go through all the features but basically you you have this sort of minimalistic I don't like to call it actually Excel clone because you don't have these uh operations I think you cannot do stuff like equals and then some formula but you do have basic table editing and basic sheet manipulation functionality here uh let me see where where was the possibility to plot I can oh actually opened it on my second screen so I plotted 466 and you can see now here column 3 and then it plotted this um maybe I can also do it like this plot select it opens it up here again no actually now it doesn't show it on the x-axis uh but we have a bunch of different uh options here for styling and animation this is basically pandas in a graphical user interface and you can just add it to your application easily and build a simple table editor for yourself using this Panda table package so that's it for today's video I hope you enjoyed it and hope you learned something if so let me know by hitting a like button and leaving a comment in the comment section down below and of course don't forget subscribe to this Channel and hit the notification Bell to not miss a single future video for free other than that thank you much for watching see you in the next video and bye