python - 让字典从 csv 文件中读取有序字典

Question

何时 using csv.DictReader to read a csv file into a list of dictionaries ，如何使每个字典成为按 csv 文件中相同顺序排序的有序字典？谢谢。

import csv
import collections
with open("in.csv") as csvfile:
    reader = csv.DictReader(csvfile,delimiter=" ")
    lst = list(reader)
    lst_orderedDict = [collections.OrderedDict(x) for x in lst]

lst_orderedDict 中的每个有序字典在 csv 文件中的排序方式不同？

Answer 1

将 OrderedDict 与 csv.reader 一起使用:

from collections import OrderedDict
with open("in.csv") as csvfile:
    reader = csv.reader(csvfile,delimiter=" ")
    keys = next(reader)
    print([OrderedDict(zip(keys,row)) for row in reader ])


[OrderedDict([('first_name', 'Baked'), ('last_name', 'Beans')]), OrderedDict([('first_name', 'Lovely'), ('last_name', 'Spam')]), OrderedDict([('first_name', 'Wonderful'), ('last_name', 'Spam')])]

或者将两者结合起来:

from collections import OrderedDict

with open("in.csv") as csvfile:
    reader = csv.DictReader(csvfile,delimiter=" ")
    keys = reader.fieldnames
    r = csv.reader(csvfile,delimiter=" ")
    print([OrderedDict(zip(keys, row)) for row in r])