Data is information an organization captures as part of its business that they store on databases. It is then used to serve their customers and help them make better decisions.
The R Project for Statistical Computing is beneficial to anyone who needs a statistical analysis performed on a dataset. The language is Open source so that anyone can use it. And can work cross-platform for any operating system in use. R can work with other similar packages; an example been Python, which can execute within…
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…
Changing a file is the natural step; tracking those changes are just as important. Change is part and parcel of life, but in the technology world with the complexity and interdependency of systems, not effectively been able to track what goes on leads to: Countless hours are trying to figure out where it went wrong….
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…
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…
