python3 nonetype_“ NoneType”对象在python3中不可迭代

TypeError Traceback (most recent call last)

in ()

15 execute Align_rsUnitedSpecPolicyDataFeed

16 """

---> 17 df = pd.read_sql(sql,conn)

18 df.shape

19 #df.to_excel(r"C:\Users\Username\Test.xlsx")

C:\Users\oserdyuk\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\sql.py in read_sql(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize)

397 sql, index_col=index_col, params=params,

398 coerce_float=coerce_float, parse_dates=parse_dates,

--> 399 chunksize=chunksize)

400

401 try:

C:\Users\Username\AppData\Local\Continuum\Anaconda3\lib\site-packages\pandas\io\sql.py in read_query(self, sql, index_col, coerce_float, params, parse_dates, chunksize)

1435 args = _convert_params(sql, params)

1436 cursor = self.execute(*args)

-> 1437 columns = [col_desc[0] for col_desc in cursor.description]

1438

1439 if chunksize is not None:

TypeError: 'NoneType' object is not iterable