Flatten a list of nested dictionaries into a table

Asked Aug 11 '20 at 05:52

Active Aug 11 '20 at 14:36

Viewed 36 times

I have a list of dict like the one below

[
  {
    'profile': 
      '{"101":{"updatedBy":"user1","updatedOn":"2020-04-02","justification":"Tier 1 user"}}'
  },
  {
    'profile': 
      '{"102":{"updatedBy":"user2","updatedOn":"2019-06-08","justification":"Tier 1 user"}}'
  },
  {
    'profile': 
      '{"103":{"updatedBy":"user1","updatedOn":"2018-05-02","justification":"Tier 1 user"}}'
  },
  {
    'profile': 
      '{"104":{"updatedBy":"user2","updatedOn":"2020-06-12","justification":"Tier 1 user"}}'
  },
  {
    'profile': 
      '{"105":{"updatedBy":"user1","updatedOn":"2019-06-18","justification":"Tier 1 user"}}'
  }
]

I want to convert them into a data frame

Can anyone help me how to do it.

edited Aug 11 '20 at 14:36

asked Aug 11 '20 at 05:52

Lisa Mathew

Are the values for the key `profile` all strings? Why are they in single quotes? – Diptangsu Goswami Aug 11 '20 at 06:08
What is the source of this data? Why are the values always strings? – juanpa.arrivillaga Aug 11 '20 at 06:53
@DiptangsuGoswami yes they are string – Lisa Mathew Aug 11 '20 at 14:35
@juanpa.arrivillaga the source of this data is DynamoDB – Lisa Mathew Aug 11 '20 at 14:35
@LisaMathew You have to first convert all of that string to `dict` objects before you can do anything with it. – Diptangsu Goswami Aug 11 '20 at 15:18

Flatten a list of nested dictionaries into a table

0 Answers0