import pandas as pand
lst = [{"Worker": [{"Project": 871, "Salary": 12000},
{"Project": 190, "Salary": 8000},
{"Project": 271, "Salary": 6000},
],
"Name": "Darth Vader"},
{"Worker": [{"Project": 871, "Salary": 13000},
{"Project": 881, "Salary": 7000},
{"Project": 553, "Salary": 9000},
],
"Name": "Luke Skywalker"}]
record = []
for data in lst:
block = data['Worker']
nm = data['Name']
for row in block:
row['Name']= nm
record.append(row)
df = pand.DataFrame(record)
print(df)
'''
run:
Project Salary Name
0 871 12000 Darth Vader
1 190 8000 Darth Vader
2 271 6000 Darth Vader
3 871 13000 Luke Skywalker
4 881 7000 Luke Skywalker
5 553 9000 Luke Skywalker
'''
