title: Unpacking Json with nested Lists in Pandas
body: <p>I have a json file that I am trying to unpack that looks like this:</p>
  <pre><code>[{'batter': 'LA Marsh',
    'bowler': 'MJG Nielsen',
    'non_striker': 'M Kapp',
    'runs': {'batter': 0, 'extras': 0, 'total': 0}},
   {'batter': 'LA Marsh',
    'bowler': 'MJG Nielsen',
    'non_striker': 'M Kapp',
    'runs': {'batter': 0, 'extras': 0, 'total': 0},
    'wickets': [{'player_out': 'LA Marsh', 'kind': 'bowled'}]},
   {'batter': 'EA Perry',
    'bowler': 'MJG Nielsen',
    'non_striker': 'M Kapp',
    'runs': {'batter': 0, 'extras': 0, 'total': 0}}]
  </code></pre>
  <p>using the following code:</p>
  <pre><code>df = pd.json_normalize(data)
  </code></pre>
  <p>I get the following:</p>
  <p><a href="https://i.stack.imgur.com/PPIeE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PPIeE.png" alt="enter image description here" /></a></p>
  <p>As you can see, the second entry has a nested list in it. In place of the column 'wickets' I would like to have two columns &quot;player_out&quot; and &quot;kind&quot;. My preferred output looks like this:</p>
  <p><a href="https://i.stack.imgur.com/CK1Gz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CK1Gz.png" alt="enter image description here" /></a></p>