In R studio have you been searching high and low on how to open a file?! Well, search no more as we have a video that will answer your questions. Today we are going to cover off the following ways in which you can access files: read.table read_excel read.csv readLines Whether you have a txt,…
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…
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” »
