title: How to Extracting data from dictionary column?
body: <p>I have dataframe with two columns, date and Details. My details column cantinas dictionary in every cell and i have to get two values from this dictionary and store it in its own cell column.</p>
  <pre><code>Date    Details
  6/14/2022   {&quot;number&quot;:&quot;1&quot;,&quot;name&quot;:&quot;John&quot;}
  6/15/2022   {&quot;number&quot;:&quot;2&quot;,&quot;name&quot;:&quot;Steve&quot;}
  6/16/2022   {&quot;number&quot;:&quot;3&quot;,&quot;name&quot;:&quot;Mira&quot;}
  6/17/2022   {&quot;number&quot;:&quot;17&quot;,&quot;name&quot;:&quot;John&quot;}
  6/18/2022   {&quot;number&quot;:&quot;4&quot;,&quot;name&quot;:&quot;Larry&quot;}
  6/19/2022   {&quot;number&quot;:&quot;33&quot;,&quot;name&quot;:&quot;Bob&quot;}
  6/20/2022   {&quot;number&quot;:&quot;43&quot;,&quot;name&quot;:&quot;james&quot;}
  6/21/2022   {&quot;number&quot;:&quot;112&quot;,&quot;name&quot;:&quot;Joe&quot;}
  </code></pre>
  <p>So what i need to get is dataframe with column Date as it is, column Number with numbers extracted from Details dictionary and column Name with names extracted from the Details dictionary.</p>
  <p>I tried using these methods:
  1.</p>
  <pre><code>df['Name'] = list(df['Details'].keys())[0]
  </code></pre>
  <p>This produces column names with all zeros in it which is wrong</p>
  <p>2.</p>
  <pre><code>df['Name'] = df['Details'].apply(lambda x: x.get([0]))
  </code></pre>
  <p>This approach gives me error: AttributeError: 'str' object has no attribute 'get'</p>
  <p>3.</p>
  <pre><code>df['Name'] = df['Details'].get([0])
  </code></pre>
  <p>This give me NaN</p>
  <p>Any suggestions on how should i go about this?</p>