Data Analytics and Video Tutorials
Automation is the process of removing manual steps and reduce the need for human intervention when data is been processed.
So you have numerous different automation projects in Python. In order to ensure a clean and smooth straight-through processing, checks need to be made to ensure what was received is in the right format. Most but not all files used in an automated process will be in the CSV format. It is important there that…
Read More “How to Compare Column Headers in CSV to a List in Python” »
In many of the SQL programming softwatre tools, there will most likely be an option for you to import your data torugh a screen they have provided. In SQL Server Management Studio the below screen is available to pick your file to import, and it quickly guides you through the steps. But what if you…
Problem statement You are working away on some data analytics projects and you receive files that have incorrect headings on them. The problem is without opening the file, how can you change the headers on the columns within it? To start off, lets look at file we want to change , below is a screen…