title: How to flatten the columns with Series in pandas dataframe?
body: <p>I have a pandas df,i need to flatten the series column</p>
  
  <pre><code>data = pd.DataFrame([['TRAN',[{'Name':'Ben','Age':'24'}],'T','Good'],
                       ['LMI',[{'Name':'Zoe','Age':'32'}],'U','Better'],
                       ['ARN',[{'Name':'Jack','Age':'28'}],'V','Best']
                       ], 
                      columns=['Type', 'Applicant', 'Decision', 'Action'])
  </code></pre>
  
  <p>data is pandas dataframe, Applicant column is a Series, </p>
  
  <pre><code>#data
  type(data)
  Out[25]: pandas.core.frame.DataFrame
  #Applicant Column
  type(data.Applicant)
  Out[26]: pandas.core.series.Series
  </code></pre>
  
  <p>I need to flatten the series and convert the dataframe with column names as <code>'Type'</code>, <code>'Applicant.Name'</code>, <code>'Applicant.Age'</code>, <code>'Decision'</code>, <code>'Action'</code>.</p>