title: Pandas Import not Inserting All Rows
body: <p>I am importing a .csv file with 3300 rows of data via the following:</p>
  
  <pre><code>myCSVfile = pd.read_csv(csv_file)
  myCSVfile.to_sql(con=engine, name='foo', if_exists='replace')
  </code></pre>
  
  <p>Once successfully imported, I do a "select * from ..." query on my table, which returns 3100 rows, so where are the missing 200 rows?</p>
  
  <p>I am assuming there is corrupt data which cannot be read in, which I further assume is then skipped over by pandas. However there is no warning, log or message to explicitly say so. The script executes as normal.</p>
  
  <p>Has anyone experienced similar problems, or am I missing something completely obvious?</p>