使命令从csv文件中读取命令命令 [英] Make dicts read from a csv file ordered dicts

问题描述

使用csv.DictReader将csv文件读入词典列表时，如何使每本词典成为在csv文件中以相同顺序排序的有序字典?谢谢.

When using csv.DictReader to read a csv file into a list of dictionaries, how can I make each dictionary an ordered dictionary ordered in the same order in the csv file? Thanks.

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中的每个命令dict在csv文件中的排序方式都不相同吗?

Each ordered dict in lst_orderedDict isn't ordered in the same way in the csv file?

推荐答案

使用带csv.reader的OrderedDict:

Use an OrderedDict with 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])

这篇关于使命令从csv文件中读取命令命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！