Question

How to read spreadsheet file (CSV) row by row in Python

Answer 1

import csv

with open('d:\data.csv', 'rt') as f:
    reader = csv.reader(f)

    for row in reader:
        print(row)


'''
run:

['name(A1)', ' email(B1)']
['alice(A2)', 'alice@email.com(B2)']
['alex(A3)', 'alex@email.com(B3)']

'''

 

70+ SQL courses for beginners and professionals