Data Analytics and Video Tutorials
Use a data frame to aid you in understanding your data better.
If you are working with files and trying to open them to read in their contents, sometimes errors will pop in that may not immediately be obvious how to resolve. In this blog post, we discuss a TypeError that is associated with opening a file in Python and reading in its contents. So how may…
Read More “TypeError: expected str, bytes or os.PathLike object, not DataFrame” »
So you are using Python and you have data stored in a data frame? You would like to present that on a webpage HTML table, but unsure how to achieve this. Well, read on to see two different methods that will help you. Pass the data to Javascript which then passes to the HTML the…
Read More “Create a HTML Table From Python Using Javascript” »
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” »
So you have an Excel file that has hundreds or maybe thousands of records, but you want to convert it to an XML file, and have each row as a separate file? This can be achieved very easily using Python, in three easy steps. First of all, what is XML? XML stands for “extensible markup…
Read More “How to Create Multiple XML Files From Excel With Python” »
Often a lot of data analytics projects involve comparisons, some of it could be to look at data quality problems, other times it could be to check that data you are loading has been saved to the database with no errors. As a result of this, there is a need to quickly check all your…
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” »
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…
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….
They say there is nowhere to hide, we disagree! As an addition to How to add a column to a dataframe would you like to learn to go and hide it?! This video has several steps in it; following each one will give you a good introduction. To start why you would like to hide a…
You have learnt addition, now learn how to add a column to a data frame! In our last post on what are Python data frames, we introduced the concept, but are you now searching how to add a column to a data frame? To start, I was working away and wondering how I…