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

Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

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

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

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

9,383 questions

12,915 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, 2018 by avibootz
...