title: Parse JSON in a Pandas DataFrame
body: <p>I have some data in a pandas DataFrame, but one of the columns contains multi-line JSON. I am trying to parse that JSON out into a separate DataFrame along with the CustomerId. Here you will see my DataFrame...</p>
  <pre><code>df
  
  Out[1]: 
  Id                                           object
  CustomerId                                   object
  CallInfo                                     object
  </code></pre>
  <p>Within the CallInfo column, the data looks like this...</p>
  <pre><code>[{&quot;CallDate&quot;:&quot;2021-06-21&quot;,&quot;CallLength&quot;:362},{&quot;CallDate&quot;:&quot;2021-06-24&quot;,&quot;CallLength&quot;:402}]
  </code></pre>
  <p>I want to create a new DataFrame called df_norm which contains the CustomerId, CallDate, and CallLength.</p>
  <p>I have tried several ways but couldn't find a working solution. Can anyone help me with this?</p>
  <p>Mock up code example...</p>
  <pre><code>import pandas as pd
  import json
  
  Id = [1, 2, 3]
  CustomerId = [700001, 700002, 700003]
  CallInfo = ['[{&quot;CallDate&quot;:&quot;2021-06-21&quot;,&quot;CallLength&quot;:362},{&quot;CallDate&quot;:&quot;2021-06-24&quot;,&quot;CallLength&quot;:402}]', '[{&quot;CallDate&quot;:&quot;2021-07-09&quot;,&quot;CallLength&quot;:102}]', '[{&quot;CallDate&quot;:&quot;2021-07-11&quot;,&quot;CallLength&quot;:226},{&quot;CallDate&quot;:&quot;2021-07-11&quot;,&quot;CallLength&quot;:216}]']
  
  # Reconstruct sample DataFrame
  df = pd.DataFrame({
          &quot;Id&quot;: Id,
          &quot;CustomerId&quot;: CustomerId,
          &quot;CallInfo&quot;: CallInfo
      })
  
  print(df)
  </code></pre>