I need a python script to do the following:
I have 2 csv files
File 1 contains a list of IDs
File 2 contains a list of IDs with other data appended.
I want to read the list of IDs in file 1 and find the matching ID in file 2. Then I want to add the ID from file 1 and the matched row from file 2 into a 3rd file.
File 1 has 8000 rows
File 2 has 12m rows
Examples of file 1 and file 2 attached
Location: Anywhere
Posted: Aug. 20, 2024, 8:29 a.m.
Apply Now Company Website