title: How to extract key, value of a list of dict of string
body: <p>I've tried to find a solution but with no success...</p>
  
  <h1>First I pull the data from a db mysql</h1>
  
  <pre><code>vod = pd.read_sql("SELECT * from x", conn)
  </code></pre>
  
  <h1>I have a structured DataFrame like that (called df)</h1>
  
  <pre><code>---------------------------------------------------------------
  index     id        remuneration    benefits        describe  
  
  
  500      354           1500         example below     none
  
  501      355           1200         example below     none
  
  502      356           1300         example below     none
  
  ----------------------------------------------------------------
  </code></pre>
  
  <h1>column benefits is like that:</h1>
  
  <pre><code>[{"value":"Insalubre","selected":false},{"value":"Perigoso","selected":false}]
  </code></pre>
  
  <h1>Objective</h1>
  
  <p>I want to create 2 new columns on this df => (Insalubre = false or true) and (Perigoso = false or true)</p>
  
  <h1>Details:</h1>
  
  <pre><code>type(df['benefits'])
  </code></pre>
  
  <p>output: <code>pandas.core.series.Series</code></p>
  
  <h1>When I try</h1>
  
  <p>input:</p>
  
  <pre><code>for key, value in df.items():
      print(key, value)
  </code></pre>
  
  <p>output: </p>
  
  <pre><code>6325 [{"value":"Insalubre","selected":false},{"value":"Perigoso","selected":false}]
  </code></pre>
  
  <p>input:</p>
  
  <pre><code>df['benefits']
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>0       [{"value":"Insalubre","selected":false},{"valu...
  
  Name: benefits, Length: 6326, dtype: object
  </code></pre>
  
  <p>What way can I do to achieve my objective?</p>