Pandas .to_sql is not inserting any records for a dataframe I want to send to sql. Are there any generic reasons why this might be the case?
I was also facing same issue because dot was added in header. remove dot then it will work.
Pandas .to_sql is not inserting any records for a dataframe I want to send to sql. Are there any generic reasons why this might be the case? 

I am not getting any error messages. The column names appear fine, but the table is entirely empty. 
When I try to send over a single column (i.e. data.ix[2]), it actually works. 
However, if I try to send over more than one column (data.ix[1:3]), I again get a completely blank table in sql. 

I have been using this code for other dataframes and have never encountered this problem. It still runs for other dataframes in my set.