Read columns from csv in python

Question

I have a csv file with columns id, name, address, phone. I want to read each row such that I store the data in two variables, key and data, where data contains name, address and phone. I want to do this because I want to append another column country in each row in a new csv. Can anyone help me with the code in python. I tried this but it didn't work:

dict = {}
reader = csv.reader(open('info.csv', 'r'))
for row in reader:
    key, *data = row
    dict[key] = ','.join(data)

key, *data = row only works in Python 3...

dawg
– dawg

2016-10-29 00:53:00 +00:00
Commented Oct 29, 2016 at 0:53 — dawg
– dawg, Commented Oct 29, 2016 at 0:53
Can you provide some example input and output?

SIGSTACKFAULT
– SIGSTACKFAULT

2016-10-29 00:53:33 +00:00
Commented Oct 29, 2016 at 0:53 — SIGSTACKFAULT
– SIGSTACKFAULT, Commented Oct 29, 2016 at 0:53

Alex Hall · Accepted Answer · 2016-10-29 00:52:54Z

3

key, *data = row is Python 3 syntax. For Python 2 you can do this:

key, data = row[0], row[1:]

answered Oct 29, 2016 at 0:52

Alex Hall

36.2k5 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad Rahman · Accepted Answer · 2016-10-29 02:39:32Z

0

You can try the code below. I have put two option one is to make a list for each row, and other is comma separated. Based on the usage you can use either one.

import csv
dict = {}
reader = csv.reader(open('info.csv', 'r'))
for row in reader:
    data = []
    print row
    key,data = row[0],row[1:]
    dict[key] = data
    # dict[key] = ','.join(data)
print dict

edited Oct 29, 2016 at 2:39

user6655984

answered Oct 29, 2016 at 0:59

Mohammad Rahman

1

Collectives™ on Stack Overflow

Read columns from csv in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related