import csv, sys

with open('Favret_aphid_list_mod.csv', 'r') as inny:
    reader1 = csv.DictReader(inny)

    with open ('output_al_vonDohlen.csv', 'r') as inny:
        reader2 = csv.DictReader(inny)

        with open('aphid_list_complete.csv', 'w') as outty:
            fieldnames = ['Genus', 'Species', 'Source']
            writer = csv.DictWriter(outty, fieldnames = fieldnames)
            writer.writeheader()

            for record in reader:
                writer.writerow(record)
            for record in reader1:
                writer.writerow(record)
            for record in reader2:
                writer.writerow(record)

            for record in reader:
                g = record['Genus']
                g = sorted(g)
                writer.writerow(record)