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 In [37]: %mkdir templates mkdir: templates: File exists This next cell writes the custom template. We extend the template html.tpl, which comes with pandas. In [38]: %%file templates/myhtml.tpl {% extends

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 import Styler In [37]: %mkdir templates This next cell writes the custom template. We extend the template html.tpl, which comes with pandas. In [38]: %%file templates/myhtml.tpl {% extends "html.tpl"

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 = """ .....: .....: .....: .....: templates select="row"/> .....: .....: .....:

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 = """ .....: .....: .....: .....: templates select="row"/> .....: .....: .....:

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 = """ .....: .....: .....: .....: templates select="row"/> .....: .....: .....:

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 import Styler In [37]: %mkdir templates This next cell writes the custom template. We extend the template html.tpl, which comes with pandas. In [38]: %%file templates/myhtml.tpl {% extends "html.tpl"

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 [343]: xml = temporary prefix will return no nodes and raise a ValueError. But assigning any temporary name to correct URI allows parsing by nodes. In [346]: xml = """ .....: .....: .....: .....: templates select="row"/> .....: .....: .....:

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 [382]: xml = temporary prefix will return no nodes and raise a ValueError. But assigning any temporary name to correct URI allows parsing by nodes. In [385]: xml = """ .....: .....: .....: .....: templates select="row"/> .....: .....: .....:

create an engine object from database 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 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. from sqlalchemy import from pandas.io.formats.style import Styler We’ll use the following template: [42]: with open("templates/myhtml.tpl") as f: print(f.read()) {% extends "html.tpl" %} {% block table %}

{{ table_title|default("My

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