included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The ’mysql’ flavor is deprecated. The new functions read_sql_query() and read_sql_table() URI. You only need to create the engine once per database you are connecting to. For an in-memory sqlite database: 12 Chapter 1. What’s New pandas: powerful Python data analysis toolkit, Release 0.14 from sqlalchemy import create_engine # Create your connection. In [44]: engine = create_engine(’sqlite:///:memory:’) This engine can then be used to write or read data to/from this database: In [45]:

included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The ’mysql’ flavor is deprecated. The new functions read_sql_query() and read_sql_table() are connecting to. For an in-memory sqlite database: In [43]: from sqlalchemy import create_engine # Create your connection. In [44]: engine = create_engine(’sqlite:///:memory:’) This engine can then database. New in version 0.14.0. If SQLAlchemy is not installed, a fallback is only provided for sqlite (and for mysql for backwards compatibility, but this is deprecated and will be removed in a future

included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The ’mysql’ flavor is deprecated. The new functions read_sql_query() and read_sql_table() are connecting to. For an in-memory sqlite database: In [43]: from sqlalchemy import create_engine # Create your connection. In [44]: engine = create_engine(’sqlite:///:memory:’) This engine can then database. New in version 0.14.0. If SQLAlchemy is not installed, a fallback is only provided for sqlite (and for mysql for backwards compatibility, but this is deprecated and will be removed in a future

PyTables 3.4.2 HDF5-based reading / writing SQLAlchemy 1.1.4 SQL support for databases other than sqlite SciPy 0.19.0 Miscellaneous statistical functions XLsxWriter 0.9.8 Excel writing blosc Compression for your database. Examples of such drivers are psycopg2 for PostgreSQL or pymysql for MySQL. For SQLite this is included in Pythons standard library by default. You can find an overview of supported drivers dialect in the SQLAlchemy docs. If SQLAlchemy is not installed, a fallback is only provided for sqlite (and for mysql for backwards compatibility, but this is deprecated and will be removed in a future

included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The ’mysql’ flavor is deprecated. The new functions read_sql_query() and read_sql_table() are connecting to. For an in-memory sqlite database: In [43]: from sqlalchemy import create_engine # Create your connection. In [44]: engine = create_engine('sqlite:///:memory:') This engine can then database. New in version 0.14.0. If SQLAlchemy is not installed, a fallback is only provided for sqlite (and for mysql for backwards compatibility, but this is deprecated and will be removed in a future

Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 991 25.9.11 Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 992 index has a CustomBusinessDay frequency (GH7222). • Bug in .to_sql for datetime.time values with sqlite fallback (GH8341) • Bug in read_excel failing to read data with one column when squeeze=True (GH12157) included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The 'mysql' flavor is deprecated. The new functions read_sql_query() and read_sql_table()

Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 993 25.9.11 Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 994 index has a CustomBusinessDay frequency (GH7222). • Bug in .to_sql for datetime.time values with sqlite fallback (GH8341) • Bug in read_excel failing to read data with one column when squeeze=True (GH12157) included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The 'mysql' flavor is deprecated. The new functions read_sql_query() and read_sql_table()

10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1097 24.10.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1098 index has a CustomBusinessDay frequency (GH7222). • Bug in .to_sql for datetime.time values with sqlite fallback (GH8341) • Bug in read_excel failing to read data with one column when squeeze=True (GH12157) included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The 'mysql' flavor is deprecated. The new functions read_sql_query() and read_sql_table()

10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1132 24.11.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1133 index has a CustomBusinessDay frequency (GH7222). • Bug in .to_sql for datetime.time values with sqlite fallback (GH8341) • Bug in read_excel failing to read data with one column when squeeze=True (GH12157) included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The 'mysql' flavor is deprecated. The new functions read_sql_query() and read_sql_table()

10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1096 index has a CustomBusinessDay frequency (GH7222). • Bug in .to_sql for datetime.time values with sqlite fallback (GH8341) • Bug in read_excel failing to read data with one column when squeeze=True (GH12157) included dialects). The functionality of providing DBAPI connection objects will only be supported for sqlite3 in the future. The 'mysql' flavor is deprecated. The new functions read_sql_query() and read_sql_table()