Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
GreenGeeks Web Hosting - Faster, Scalable & Eco-Friendly

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Distribute your Resume to 500+ Job Boards & Recruiters


7,930 questions

11,045 answers

573 users

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

1 Answer

0 votes
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']

'''

 




answered Jun 29 by avibootz
...