pandas.read_sql()

pandas.read_sql

pandas.read_sql(sql, con, index_col=None, coerce_float=True, params=None, parse_dates=None, columns=None, chunksize=None)

Read SQL query or database table into a DataFrame.

Parameters:

Parameters:	sql : string SQL query or SQLAlchemy Selectable (select or text object) to be executed, or database table name. con : SQLAlchemy connectable(engine/connection) or database string URI or DBAPI2 connection (fallback mode) Using SQLAlchemy makes it possible to use any DB supported by that library. If a DBAPI2 object, only sqlite3 is supported. index_col : string or list of strings, optional, defa 登录查看完整内容 ← → Copyright©2021 w3cschool编程狮\|闽ICP备15016281号-3\|闽公网安备35020302033924号违法和不良信息举报电话：173-0602-2364\|举报邮箱：jubao@eeedong.com 意见反馈 X 意见反馈：联系方式：查看完整版笔记违规举报 X 广告等垃圾信息不友善内容违反法律法规的内容不宜公开讨论的政治内容其他

sql : string SQL query or SQLAlchemy Selectable (select or text object)

to be executed, or database table name.

con : SQLAlchemy connectable(engine/connection) or database string URI

or DBAPI2 connection (fallback mode) Using SQLAlchemy makes it possible to use any DB supported by that library. If a DBAPI2 object, only sqlite3 is supported.

index_col : string or list of strings, optional, defa

登录查看完整内容