Python pandas: Nested List of Dictionary into Dataframe

Question

Here is how the data structure is below... It is a List with inner List that contains two Dictionaries each.

I want it into dataframe with these headings: hasPossession, score and spread.

[[{'hasPossession': '0', 'score': '23', 'spread': '-0'},
{'hasPossession': '0', 'score': '34', 'spread': '0.0'}], [{'hasPossession': '0', 'score': '', 'spread': '-7.5'},
{'hasPossession': '0', 'score': '', 'spread': '7.5'}], [{'hasPossession': '0', 'score': '', 'spread': '-1'},
{'hasPossession': '0', 'score': '', 'spread': '1.0'}]]

Generally, above structure is a List that contains 3 Lists and each List contains 2 Dictionary with 2 elements.

How do I transform such into pandas dataframe?

rafaelc · Accepted Answer · 2018-09-16 04:07:12Z

2

flatten the list and use the default constructor

pd.DataFrame([k for item in initial_list for k in item])

    hasPossession   score   spread
0   0               23      -0
1   0               34      0.0
2   0                       -7.5
3   0                       7.5
4   0                       -1
5   0                       1.0

answered Sep 16, 2018 at 4:07

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

userPyGeo Over a year ago

RafaelC, perfect solution you got there.

Collectives™ on Stack Overflow

Python pandas: Nested List of Dictionary into Dataframe

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related