CS50P PSet 6 check50 problem for scourgify

Question

I managed to write the code to make the csv specific, yet the last two checks for check50 are still coming as errors. Here is my code:

import csv
import sys

students = []

if len(sys.argv) < 3:
    sys.exit("Too few command-line arguments")
elif len(sys.argv) > 3:
    sys.exit("Too many command-line arguments")

try:
    with open(sys.argv[1]) as file:
        reader = csv.DictReader(file)
        for row in reader:
            students.append(row)
except FileNotFoundError:
    sys.exit(f"Could not read {sys.argv[1]}")

for student in students:
    name = student["name"].split(",")
    first = name[1]
    last = name[0]

    student["name"] = first.strip()
    student["last"] = last

with open(sys.argv[2], "a") as file:
    writer = csv.DictWriter(file, fieldnames=["first", "last", "house"])
    writer.writeheader()
    for student in students:
        writer.writerow({"first": student["name"], "last": student["last"], "house": student["house"]})

Is there a problem that I am possibly overlooking?

Answer 1

lineterminator of csv module while writing to new csv file, 'lineterminator` defaulted to "\r\n", for test it should be "\r", csv module does it's own line handling