We need a script to take two CSV files - the original CSV & the CSV with the rows that should be removed. The script should create a brand new CSV with the contents of the original CSV without the rows in the second CSV.

Mandatory Requirements

• Create a new CSV
• Remember big O notation because the input size can be really large
• Do error checking and return an error if the files do not exist

Some responses return {"detail": ...} while other return {"message": ...}

Make sure every response is the same

The barcode CSV could have duplicates due to user input errors. We need a script to parse through the CSV given to us and create a new CSV with just the duplicates.

Mandatory Requirements

• Accept a CSV file as an input
• Parse through CSV and return the rows of both duplicates (see below for example)
• After finding the duplicates, the rows should be written to a new CSV
• The input CSV should remain unchanged after the execution of the script
• Remember Big O Notation because the number of rows is in the 10,000's

If you have two duplicate barcodes like:
0002982, Water Bottle, Recycle
0002982, Chips, Landfill

Both "Water Bottle" and "Chips" should be recorded, so you should put barcodes that have been checked in like a dictionary, and when you find a duplicate, return both the barcode you just found and also the one in the dictionary.

Optional Requirements

• Rank the duplicate barcodes by the severity of the differences
• EX: (Tier 1: Barcodes with different disposal bin, Tier 2: Barcodes with different names with same disposal bin, Tier 3: Barcodes with very similar names and same disposal bin)
• Create a progress bar, so we know the script is still running and how many rows are left

Create unit tests to verify the specification of each endpoint