python_将字典转成二维列表

将字典转成二维列表

orderList = [{"姓名": "小张", "年龄": "23"}, {"姓名": "小李", "性别": "女"}]

# 初始化一个列表用于存储遇到的键，保持顺序
ordered_keys = []
# 遍历data中的每个字典，添加其键到ordered_keys，如果该键还未被添加
for d in orderList:
    for key in d.keys():
        if key not in ordered_keys:
            ordered_keys.append(key)
print(ordered_keys)

#要得到[["姓名", "年龄", "性别"],["小张", "23", ""],["小李", "", "女"]]
# 首先添加键名行
result = [list(ordered_keys)]

# 对于每个字典，按顺序添加值，没有的键用空字符串填充
for d in orderList:
    row = [str(d.get(key, '')) for key in ordered_keys]
    result.append(row)
print(result)