Save a list from cvs.DictReader in python

Question

i have a simply csv file like this:

col1,col2,col3 house,55,600 cottage,88,100

I read in this way:

with open("house.csv", "r+", newline="", encoding="UTF-8") as csv_file:
    file_r = csv.DictReader(csv_file)
    for row in file_r:
        print(row["col1"])

How can I save the result of row["col1"] to a list?

Thanks

I try to save like this:

a = list(row["col1"])
        print(a)

But I obtained

['h', 'o', 'u', 's', 'e']
['c', 'o', 't', 't', 'a', 'g', 'e']

Omri · Accepted Answer · 2022-10-29 13:15:15Z

1

When you write list(row["col1"]) you are converting the string value in col1 in each row to a list. What you want is to append each value to a list:

col1_values = []

for row in file_r:
    col1_values.append(row["col1"])

answered Oct 29, 2022 at 13:15

Omri

5024 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Save a list from cvs.DictReader in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related