Write CSV

To write to a CSV file

import csv

header = ['name', 'area', 'country_code2', 'country_code3']
data = ['Afghanistan', 652090, 'AF', 'AFG']


with open("C:\\Users\\Nicholas Goh\\Desktop\\test.csv", 'w', encoding='UTF8', newline='') as f:
    writer = csv.writer(f)

    # write the header
    writer.writerow(header)

    # write the data
    writer.writerow(data)

Change 'w' to 'a' for Append instead of Overwrite

Change "C:\\Users\\Nicholas Goh\\Desktop\\test.csv" to your CSV output location