python数据字典排序_当标题处于混合顺序时,如何将数据存储在Python中的数据字典中...

这看起来很简单.将文件处理为数据结构,然后将其导出到csv中.

school = None

headers = None

data = {}

for line in text.splitlines():

if line.startswith("school id"):

school = line.split('=')[1].strip()

headers = None

continue

if school is not None and headers is None:

headers = line.split('|')

continue

if school is not None and headers is not None and line:

if not school in data:

data[school] = []

datum = dict(zip(headers, line.split('|')))

data[school].append(datum)

In [29]: data

Out[29]:

{'273533123': [{'age': '27',

'degree': 'MBA',

'name': 'John B. Black',

'race': 'hispanic',

'year': '2003'},

{'age': '28',

'degree': 'PhD',

'name': 'Steven Smith',

'race': 'black',

'year': '2005'},

{'age': '25',

'degree': 'MBA',

'name': 'Jacob Waters',

'race': 'hispanic',

'year': '2003'}],

'28392': [{'age': '27',

'degree': 'PhD',

'name': 'Susan A. Smith',

'race': 'white',

'year': '2007'},

{'age': '26',

'degree': 'PhD',

'name': 'Fred Collins',

'race': 'hispanic',

'year': '2006'},

{'age': '28',

'degree': 'MBA',

'name': 'Amber Real',

'race': 'white',

'year': '2007'},

{'age': '27',

'degree': 'PhD',

'name': 'Mike Lee',

'race': 'white',

'year': '2003'}],

'3452332': [{'age': '27',

'degree': 'Bachelors',

'name': 'Peter Hintze',

'race': 'white',

'year': '2002'},

{'age': '25',

'degree': 'MBA',

'name': 'Ann Graden',

'race': 'black',

'year': '2004'},

{'age': '28',

'degree': 'PhD',

'name': 'Bryan Stewart',

'race': 'white',

'year': '2004'}]}