Trying to cross reference one CSV to another

user_19651853 0
Viewed 47

So I have two CSV files, one with a list of names that might be a match or might not match the list of names in another file. But if it does find a match I want it to go back to the original csv1 and a different column value from csv2 from the same row as the match to the second row in csv1.

with open('/Users/{}/Desktop/{}.csv'.format(os.getlogin(), mainFile), mode='r') as csv_file:
csv_reader = csv.DictReader(csv_file)
for i in csv_reader:
    with open('/Users/{}/Desktop/{}.csv'.format(os.getlogin(), projects), mode='r') as new_csv:
        csv_reader = csv.DictReader(new_csv)
        for x in csv_reader:
            if i['Owner'] == x['Project Owner']:
                with open('/Users/{}/Desktop/{}.csv'.format(os.getlogin(), mainFile), mode='r') as csv_writing:
                    writer = csv.writer(csv_writing)
                    writer.writerow([x['Project Owner'], x['Project Name']])

this is what I have so far but I'm worried that it won't know what to do with the rows in csv1 that don't match and since I can loop a writer the best option would be to delete the row from csv1 that doesn't match right? So how would I delete that said row? Or a better solution if you have one.

csv python
1 Answers

There's a Table helper in convtools library (github). The helper simplifies basic operations for stream processing table-like data.

from convtools.contrib.tables import Table
from convtools import conversion as c

Table.from_csv("tmp/main.csv", header=True).join(
    Table.from_csv("tmp/projects.csv", header=True),
    on=c.LEFT.col("Owner") == c.RIGHT.col("Project Owner"),
    how="inner",
).take("Project Owner", "Project Name").into_csv("tmp/results.csv")
user_53877380
Related