title: How to create multiple dataframe from a excel data table
body: <p>I have extracted this data frame from an excel spreadsheet using pandas library,
  after getting the needed columns and,
  I have table formatted like this,</p>
  <pre><code>    REF PLAYERS
  0   103368  Andrés Posada Sanmiguel
  1   300552  Diego Posada Sanmiguel
  2   103304  Roberto Motta Stanziola
  3   NaN NaN
  4   REF PLAYERS
  5   1047012 ANABELLA EISMANN DE AMAYA
  6   104701  FERNANDO ENRIQUE AMAYA CASTRO
  7   103451  AUGUSTO ANTONIO ALVARADO AZCARRAGA
  8   103484  Kevin Adrian Villarreal Kam
  9   REF PLAYERS
  10  NaN NaN
  11  NaN NaN
  12  NaN NaN
  13  NaN NaN
  14  REF PLAYERS
  15  NaN NaN
  16  NaN NaN
  17  NaN NaN
  18  NaN NaN
  19  REF PLAYERS
  </code></pre>
  <p>I want to create multiple dataframes converting each row [['REF', 'PLAYERS']] to a new dataframe columns.
  suggestions are welcomed I also need to preserve the blank spaces. A pandas newbie.</p>