title: Removing lists from each cell in pandas dataframe
body: <p>I have one dataframe that contains lists in many of the individual cells. Some cells do not have lists and are just strings and some are just integers or numbers.</p>
  
  <p>I would like to get rid of all lists in the dataframe (keeping the value or string that was in the list of course). How would I go about this?</p>
  
  <p>Below are two dataframes, one is the "raw data" which has lists and numbers and strings throughout. The second is the clean data that I am hoping to create.</p>
  
  <p>What is the simplest and most efficient way to do this?</p>
  
  <pre><code>import pandas as pd
  
  #create two dataframes, one called raw, one called end result
  #raw data
  raw_data = {'Name': [['W1'], ['W3'], ['W2'], ['W1'], ['W2'],['W3'],['G1']],
              'EVENT':['E1', 'E2', 'E3', 'E4', 'E5','E6','E1'],
          'DrillDate': [['01/01/2000'], 23, '04/01/2000', ['05/15/2000'], [''],[''],'02/02/2000']}
  dfRaw = pd.DataFrame(raw_data, columns = ['Name','EVENT','DrillDate'])
  dfRaw
  
  
  # cleaned data
  clean_data = {'Name': ['W1', 'W3', 'W2', 'W1', 'W2','W3','G1'],
              'EVENT':['E1', 'E2', 'E3', 'E4', 'E5','E6','E1'],
          'DrillDate': ['01/01/2000', 23, '04/01/2000', '05/15/2000', '','','02/02/2000']}
  dfEndResult = pd.DataFrame(clean_data, columns = ['Name','EVENT','DrillDate'])
  dfEndResult
  </code></pre>