Parameters table_name [str] Name of SQL table in database. con [SQLAlchemy connectable or str] A database URI could be provided as as str. SQLite DBAPI connection mode not supported. schema [str, default None] object)] SQL query to be exe- cuted. con [SQLAlchemy connectable(engine/connection), database string URI,] or sqlite3 DBAPI2 connection Using SQLAlchemy makes it possible to use any DB supported by that library to be executed or a table name. con [SQLAlchemy connectable (engine/connection) or database string URI] or DBAPI2 con- nection (fallback mode) Using SQLAlchemy makes it possible to use any DB supported

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database con : SQLAlchemy connectable (or database string URI) Sqlite DBAPI connection mode not supported schema : string, default None 832 Chapter 24. IO Tools

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database con : SQLAlchemy connectable (or database string URI) Sqlite DBAPI connection mode not supported schema : string, default None Name of SQL schema in

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database con : SQLAlchemy connectable (or database string URI) Sqlite DBAPI connection mode not supported schema : string, default None Name of SQL schema in

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database con : SQLAlchemy connectable (or database string URI) Sqlite DBAPI connection mode not supported schema : string, default None Name of SQL schema in

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database con : SQLAlchemy connectable (or database string URI) 24.10. SQL Queries 1087 pandas: powerful Python data analysis toolkit, Release 0.20.2 Sqlite DBAPI

functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) • read_sql_table will now allow reading from views (GH10750). • Enable connect with SQLAlchemy you use the create_engine() function to create an engine object from database URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite table_name : string Name of SQL table in database. con : SQLAlchemy connectable (or database string URI) SQLite DBAPI connection mode not supported. schema : string, default None Name of SQL schema in

xpath must reference a prefix. For example, below XML contains a namespace with prefix, doc, and URI at https://example.com. In order to parse doc:row nodes, namespaces must be used. In [339]: xml = temporary prefix will return no nodes and raise a ValueError. But assigning any temporary name to correct URI allows parsing by nodes. In [342]: xml = """ .....: URI. You only need to create the engine once per database you are connecting to. For more information on create_engine() and the URI formatting, see the examples below

xpath must reference a prefix. For example, below XML contains a namespace with prefix, doc, and URI at https://example.com. In order to parse doc:row nodes, namespaces must be used. In [339]: xml = temporary prefix will return no nodes and raise a ValueError. But assigning any temporary name to correct URI allows parsing by nodes. In [342]: xml = """ .....: URI. You only need to create the engine once per database you are connecting to. For more information on create_engine() and the URI formatting, see the examples below

xpath must reference a prefix. For example, below XML contains a namespace with prefix, doc, and URI at https://example.com. In order to parse doc:row nodes, namespaces must be used. In [339]: xml = temporary prefix will return no nodes and raise a ValueError. But assigning any temporary name to correct URI allows parsing by nodes. In [342]: xml = """ .....: URI. You only need to create the engine once per database you are connecting to. For more information on create_engine() and the URI formatting, see the examples below