Data Analytics and Video Tutorials
Learn how to work with files and get data out of them.
In our previous post on how to compare CSV files for differences we showed how you could see the differences, but what if you wanted to see if a record was 100% matched or not? Here we are going to use SequenceMatcher which is a python class that allows you to compare files and return…
Read More “How to show percentage differences between files in Python” »
Are you working on a data analytics project where you need to feed your data to a location that is able to process an XML file? The ability to get your data into a structured format like XML has many benefits: (A) You can transfer the data to a web service for processing. (B) Multiple…
Read More “How to Create an XML file from Excel using Python” »
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” »
Have you ever wondered how to work with files and get access to them and look at their contents? In today’s environment, there is a frequent need to work with files, import do some work on them and then either save them somewhere or pass them onwards for further processing. Working with files can happen…
Read More “YouTube channel lists – Python working with files” »
Is there a need for you to be quickly open files, and import the data into a data frame? In this post and video on Python, we will look at several options for you to do this as well as some additional things to consider. The import of files covered here is as follows: Reading…
Read More “Python Tutorial: How to import data from files” »