Data Analytics and Video Tutorials
Making sure that your data has no errors contained within it.
On this website, we have posted about how to remove unwanted characters from your data and How to remove characters from an imported CSV file both will show you different approaches. In this blog posting, we are going to approach the process by using loops within a function. Essentially we are going to pass a…
Read More “How To Check For Unwanted Characters Using Loops With Python” »
Livestream #2 – What does a data analyst do? You are probably sitting there hearing about big data and databases, data analytics and machine learning and wonder where a data analyst fits in? Here we will look to break it down step by step. Sometimes a data analyst can be confused with a business analyst;…
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…
Read More “Tkinter GUI tutorial python – how to clean excel data” »
Using r programming functions to cleanse data In our recent post Python Tutorial: How do I remove unwanted characters we walked through the concepts behind data cleansing. We demonstrated several different approaches to data cleansing, and the use of regular expressions was also shown. Here we look at that approach using rstudio and the following…
Read More “how to remove unwanted characters from your data” »
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…
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” »
Removing the unwanted, that is holding you up.A situation has arisen of you having information, which has erroneous data inside it, what do you do? Data issues are a common scenario faced by many data analytics professionals and the industry as a whole. Data quality now has become more critical, especially as we move more…
Ever had a process where you received a set of data, and it took a bit of effort to cleanse the data, so it looks the way you want it? The world of data processing and data exchanged between servers and organisations needs careful attention, one person’s idea of clean data might not be other…
I was on LinkedIn recently, and looking at my profile, saw a post I had posted about six years ago around Data Cleansing. One thing that struck me was that the topics I brought up then are as relevant then as they are now, and with Big Data now mainstream many companies are wondering how to manage…