Use python with pandas: I have two csv lists of differentsizes with slightly different information but some
Question:
Use python with pandas: I have two csv lists of differentsizes with slightly different information but some lines in eachcsv will have a matching name and address in the other csv. I wantto compare the data of each line in one csv to another line in theother csv using the name and address to match on. If they match, Iwant to print out another csv file (matched_merged.csv) that hasnew merged lines from all the unique information for each of thetwo lines sharing the address. After I print out the matched andmerged lines in the matched_merged.csv, I want to print out all thelines from each list that didn't match any thing in the other list.Attached are two of the csv files with some sample data.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill