Python将csv导入列表
我有一个大约有2000条记录的CSV文件。
每个记录都有一个字符串和一个类别:
This is the first line,Line1This is the second line,Line2
This is the third line,Line3
我需要将此文件读入如下列表:
data = [('This is the first line', 'Line1'), ('This is the second line', 'Line2'),
('This is the third line', 'Line3')]
如何使用Python将CSV导入到我需要的列表中?
回答:
使用csv模块:
import csvwith open('file.csv', newline='') as f:
reader = csv.reader(f)
data = list(reader)
print(data)
输出:
[['This is the first line', 'Line1'], ['This is the second line', 'Line2'], ['This is the third line', 'Line3']]
如果你需要元组:
import csvwith open('file.csv', newline='') as f:
reader = csv.reader(f)
data = [tuple(row) for row in reader]
print(data)
输出:
[('This is the first line', 'Line1'), ('This is the second line', 'Line2'), ('This is the third line', 'Line3')]
旧的Python 2答案,也使用csv模块:
import csvwith open('file.csv', 'rb') as f:
reader = csv.reader(f)
your_list = list(reader)
print your_list
# [['This is the first line', 'Line1'],
# ['This is the second line', 'Line2'],
# ['This is the third line', 'Line3']]
以上是 Python将csv导入列表 的全部内容, 来源链接: utcz.com/qa/431801.html