Tkinter GUI tutorial python – how to clean excel data

Estimated reading time: 2 minutes

Tkinter is an application within Python that allows users to create GUI or graphical user interfaces to manage data in a more user-friendly way.

We are building our data analytics capability here, and looking to provide the user with the functionality they use in their work or college projects.

We have tested this code over 100,000 records sitting on the Microsoft OneDrive network so in a way, for this reason, its speeds were quite good.

As a result over five tests, they all were under 100s from start to finish.

data cleansing data cleansing fixed

In this Tkinter GUI tutorial python, you will be shown how to find the data errors, clean them and then export the final result to excel.

We will take you through the following:

  • Creation of the Tkinter interface.
  • Methods/ functions to find errors.
  • Methods/functions to clean the data.
  • Exporting the clean data to an excel file.

 

To sum up:

The video walks through the creation of a Tkinter window using a canvas and a frame to store the data frame.

Then it looks at importing the data through pd.read_excel, to load the data into a pandas data frame.

Next, there is a function and or method that will extract the errors through str.extract , which is loaded into separate columns

Finally, I have exported the clean dataset using rawdata.to_excel , and saved the file as a separate new spreadsheet.

how to create charts in Tkinter

Estimated reading time: 1 minute

In how to create charts in Tkinter, it is one of many libraries that can be used to create different chart types and graphical user interfaces

With python programming, as a result of its ease of use and ability to quickly roll out GUI applications, it makes it one of the most popular in use today.

Because the application allows the creation of interfaces that users will be familiar with, its roll out across an organization will make adoption a lot easier.

In fact, the applications created can also have the ability to create an executable file that can be placed on users’ desktops.

In the below video, after importing Tkinter we use many of its built-in functions to create:

  • Pie chart, a bar chart, and a line chart.
  • We also use functions and classes to help manage the creation of the charts.
  • It is recommended you follow the video to the end as it will give you a great insight into how these can be used.

❤Subscribe for more free YouTube tips: Subscribe to Data analytics Ireland

❤Share this video with a YouTuber friend: How to create Tkinter charts


Notice: ob_end_flush(): failed to send buffer of zlib output compression (0) in /home/dataana1/public_html/wp-includes/functions.php on line 4979