title: Python Pandas write to sql with NaN values
body: <p>I'm trying to read a few hundred tables from ascii and then write them to mySQL.  It seems easy to do with Pandas but I hit an error that doesn't make sense to me:</p>
  
  <p>I have a data frame of 8 columns.  Here is the column list/index:</p>
  
  <pre><code>metricDF.columns
  
  Index([u'FID', u'TYPE', u'CO', u'CITY', u'LINENO', u'SUBLINE', u'VALUE_010', u'VALUE2_015'], dtype=object)
  </code></pre>
  
  <p>I then use <code>to_sql</code> to append the data up to mySQL</p>
  
  <pre><code>metricDF.to_sql(con=con, name=seqFile, if_exists='append', flavor='mysql')
  </code></pre>
  
  <p>I get a strange error about a column being "nan":</p>
  
  <pre><code>OperationalError: (1054, "Unknown column 'nan' in 'field list'")
  </code></pre>
  
  <p>As you can see all my columns have names.  I realize mysql/sql support for writing appears in development so perhaps that's the reason?  If so is there a work around?  Any suggestions would be greatly appreciated.</p>