dfdiff.py

#source: https://kanoki.org/2019/07/04/pandas-difference-between-two-dataframes/

import pandas as pd
import sys

def compare(csv1, csv2):
    #might need to modify this to drop certain columns or read csv a certain way
    dfcsv1 = pd.read_csv(csv1)
    dfcsv2 = pd.read_csv(csv2)

    dfrem = dfcsv1.merge(dfcsv2, how = 'outer' ,indicator=True).loc[lambda x : x['_merge']=='left_only']
    dfadd = dfcsv1.merge(dfcsv2, how = 'outer' ,indicator=True).loc[lambda x : x['_merge']=='right_only']

    return dfadd, dfrem

dfadd, dfrem = compare(sys.argv[1], sys.argv[2])

#might need to modify this to drop certain columns or write csv a certain way
dfadd.to_csv("added.csv")
dfrem.to_csv("removed.csv")

print("ADDED")
print(dfadd.to_string())

print("REMOVED")
print(dfrem.to_string())