If I have 2 csv files as follows:
I am looking for a Python way to compare the 2 CSV files (only Column 1), and if column1 is the same in both CSV files, then write the entire row from CSV1.csv to a new CSV file.
So in this example, the only time column 1 is the same is '189'. So the new output.csv file would just have 1 line, and be 189,Tom,Tom@gmail.com.football
I have tried import pandas, csv, and every time I attempt this I am hitting a roadblock.