无意间看博客看到pandas 和 reduce与lambda的用法,先mark一下
1.pandas
>>> import pandas as pd
>>> data = [
{'A': 'A1','B': 'B2','C': 'C3','D': 'D4'},
{'A': 'AA1','C': 'CC3','D': 'DD4','E': 'EE5'},
{'A': 'AAA1','B': 'BBB2','C': 'CCC3','D': 'DDD4','E': 'EEE5'}
]
>>> df=pd.DataFrame(data).fillna('null')
>>> ls=df.values.tolist()
>>> ls.insert(0,df.columns.tolist())
>>> ls
[['A', 'B', 'C', 'D', 'E'], ['A1', 'B2', 'C3', 'D4', 'null'], ['AA1', 'null', 'CC3', 'DD4', 'EE5'], ['AAA1', 'BBB2', 'CCC3', 'DDD4', 'EEE5']]
>>>
2.reduce
data = [
{'A': 'A1','B': 'B2','C': 'C3','D': 'D4'},
{'A': 'AA1','C': 'CC3','D': 'DD4','E': 'EE5'},
{'A': 'AAA1','B': 'BBB2','C': 'CCC3','D': 'DDD4','E': 'EEE5'}
]
keys = set(reduce(lambda x, y: x + y, [_.keys() for _ in data]))
lst = [[_[key] if key in _ else 'NULL' for key in keys] for _ in data]
lst.insert(0, list(keys))
print lst
转载:https://segmentfault.com/q/1010000010362346