Tag: validate CSV

How to show percentage differences between files in Python

Posted on By admin

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” »

CSV, numpy, Python, Python working with files, SequenceMatcher

How to Compare Column Headers in CSV to a List in Python

Posted on By admin

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” »

CSV, Python, Python Dataframe, Python Lists