Python is a software tool widely used to process and manipulate data and is used for providing statistics. As a result, its adoption has been widely used in companies large and small, as it is easy to learn.
Let’s make the introductions 🙂Tkinter is a package that allows a programmer to build a GUI interface, which then can be opened on a computer screen by a user. There are many different types of GUI apps, but examples include a calculator or a text editor that opens when you click it. Tkinter would be…
In Data Analytics, that is a very relevant question, and something I look to implement in most projects, sometimes it is too easy to click the shortcut icon to your spreadsheet application! Here we are looking to bring a little automation into these videos. Building on How to import data from files and Removing characters from…
Do you want to validate with Tuples, that is easy, making changes not easy. In our recent video Python – how do I remove unwanted characters lists were used as a lookup to validate data that we need to be check for invalid data items. The most apparent difference between the two is that tuples are…
Read More “Python Tutorial: How to validate data using tuples” »
Taking it further with a python excel chart. We have created some video content here using Python with Excel that illustrates the different ways you can leverage Python to Data cleanse Find unwanted characters And see if the file is empty before import! What this video is giving as output Here we are looking to introduce…
Read More “Python Tutorial: How to create charts in Excel” »
Validating cells in Excel quickly – how to do it easily!Are you working with large spreadsheets and looking to quickly at data validation exercise to save you time? The aim would be to run your code and test it against some predefined rules you or your data analyst would have written to make sure it…
This import will not cost you anything except running some code!The need to productively have an all in one solution to manage your data as your code has become more critical as volumes of data become larger. Do you, as a data analyst, therefore, need to send your data into an excel file? Previously we…
Ever wondered how to go about checking if a file is empty? A problem you may come across in Data Analytics that when you are importing a file as outlined in this post Python – How to import data from files is how do we know if the files are empty or not before import? In…
Removal of unwanted errors in your data, the easy way.The process of importing data can take many formats, but have you been looking for a video on how you do this? Even better are you looking for a video that shows you how to import a CSV file and then data cleanse it, effectively removing…
Read More “How to remove characters from an imported CSV file” »
Have you ever wondered how to work with files and get access to them and look at their contents? In today’s environment, there is a frequent need to work with files, import do some work on them and then either save them somewhere or pass them onwards for further processing. Working with files can happen…
Read More “YouTube channel lists – Python working with files” »
Is there a need for you to be quickly open files, and import the data into a data frame? In this post and video on Python, we will look at several options for you to do this as well as some additional things to consider. The import of files covered here is as follows: Reading…
Read More “Python Tutorial: How to import data from files” »
