Tag: validate CSV

How to show percentage differences between files in Python

January 16, 2022June 14, 2022 admin No Comments

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…

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

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

May 27, 2021October 5, 2021 admin No Comments

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…

CSV, Python, Python Dataframe, Python Lists