Question

How to create a spreadsheet file (CSV) with two columns in Python

Answer 1

import csv

data = {"alex(A2)": "alex@email.com(B2)", "alice(A3)": "alice@email.com(B3)"}

with open('d:\data.csv', 'w') as csv:
    columnsTitle = "name(A1), email(B1)\n"
    csv.write(columnsTitle)

    for key in data.keys():
        name = key
        email = data[key]
        row = name + "," + email + "\n"
        csv.write(row)


'''
run:

data.csv
--------
name(A1), email(B1)
alex(A2),alex@email.com(B2)
alice(A3),alice@email.com(B3)

'''

 

70+ SQL courses for beginners and professionals