Question

How to get data from spreadsheet file (CSV) and store it into lists (list for every column) in Python

Answer 1

import csv

name = []
email = []

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

    i = 0
    for row in reader:
        if i >= 1:
            name.append(row[0])
            email.append(row[1])

        i += 1

print(name)
print(email)

'''
run:

['alice', 'alex']
['alice@email.com', 'alex@email.com']

'''

 

70+ SQL courses for beginners and professionals