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 fixed this problem - it was becomes some of the column headers had '%' in it. 
I accidentally discovered this reason for the empty tables when I tried to use io and copy_from a temporary csv, instead of to_sql. I got a transaction error based on a % placeholder error. 
Again, this is specific to passing to PSQL; it went through to SQL Server without a hitch.
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.