擅长:python、mysql、java
<p>如注释中所述,从pandas 0.15开始,在<code>read_sql</code>中有一个chunksize选项来逐块读取和处理查询:</p>
<pre><code>sql = "SELECT * FROM My_Table"
for chunk in pd.read_sql_query(sql , engine, chunksize=5):
print(chunk)
</code></pre>
<p>引用:<a href="http://pandas.pydata.org/pandas-docs/version/0.15.2/io.html#querying">http://pandas.pydata.org/pandas-docs/version/0.15.2/io.html#querying</a></p>