python读取csv第一列数据_在python中读取CSV的第一列

I have a CSV (mylist.csv) with 2 columns that look similar to this:

jfj840398jgg item-2f

hd883hb2kjsd item-9k

jie9hgtrbu43 item-12

fjoi439jgnso item-3i

I need to read the first column into a variable so I just get:

jfj840398jgg

hd883hb2kjsd

jie9hgtrbu43

fjoi439jgnso

I tried the following, but it is only giving me the first letter of each column:

import csv

list2 = []

with open("mylist.csv") as f:

for row in f:

list2.append(row[0])

so the results of the above code are giving me list2 as:

['j', 'h', 'j', 'f']

解决方案

You should split the row and then append the first item

list2 = []

with open("mylist.csv") as f:

for row in f:

list2.append(row.split()[0])

You could also use a list comprehension which are pretty standard for creating lists:

with open("mylist.csv") as f:

list2 = [row.split()[0] for row in f]