Pandas read_sql_query converting integer column to float
<p>I have the following line</p>

<pre><code>df = pandas.read_sql_query(sql = sql_script, con=conn, coerce_float = False)
</code></pre>

<p>that pulls data from Postgres using a sql script. Pandas keeps setting some of the columns to type float64.  They should be just int. These columns contain some null values. Is there a ways to pull the data without having Pandas setting them to float64?</p>

<p>Thanks!</p>

<p>As per the <a href="http://pandas.pydata.org/pandas-docs/stable/gotchas.html#support-for-integer-na" rel="nofollow">documentation</a>, the lack of NA representation in Numpy implies integer NA values can't be managed, so pandas promotes int columns into float.</p>

python pandas