wc-prod-ex-csv-reader.py

gistfile1.txt

import csv

with open('wc-product-export-10-5-2023-1683750652005 - wc-product-export-10-5-2023-1683750652005.csv') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    line_count = 0
    for row in csv_reader:
        if line_count == 0:
            line_count += 1
        else:
            col_count = 0
            for column in row:
                if column == 'Genus Species':
                    scientific_name = col_count + 1
                    print(row[0] + ',' + '"' + row[scientific_name] + '"')
                col_count += 1
            line_count += 1