DataFrame.style PyQt4 Clipboard I/O PyQt5 Clipboard I/O 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 Big Query access psycopg2 PostgreSQL engine for sqlalchemy pyarrow 0.9.0 Parquet and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables data retrieval and to reduce dependency on DB-specific API. Database abstraction is provided by SQLAlchemy if installed. In addition you will need a driver library for your database. Examples of such drivers

serialization of lists and dicts to strings in ExcelWriter (GH8188) • SQL io functions now accept a SQLAlchemy connectable. (GH7877) • pd.read_sql and to_sql can accept database URI as con parameter (GH10214) (datetime column with timezone info) to the appropriate sqlalchemy type (GH9085). • Fixed bug in to_sql dtype argument not accepting an instantiated SQLAlchemy type (GH9083). • Bug in .loc partial setting with database (GH8778). For example, specifying to use the sqlalchemy String type instead of the default Text type for string columns: from sqlalchemy.types import String data.to_sql('data_dtype', engine,

database (GH8778). For example, specifying to use the sqlalchemy String type instead of the default Text type for string columns: from sqlalchemy.types import String data.to_sql(’data_dtype’, engine, version. • Highlights include: – Officially support Python 3.4 – SQL interfaces updated to use sqlalchemy, See Here. – Display interface changes, See Here – MultiIndexing Using Slicers, See Here. – through SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included

version. • Highlights include: – Officially support Python 3.4 – SQL interfaces updated to use sqlalchemy, See Here. – Display interface changes, See Here – MultiIndexing Using Slicers, See Here. – through SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included (database table name or sql query). In practice, you have to provide a SQLAlchemy engine to the sql functions. To connect with SQLAlchemy you use the create_engine() function to create an engine object from

version. • Highlights include: – Officially support Python 3.4 – SQL interfaces updated to use sqlalchemy, See Here. – Display interface changes, See Here – MultiIndexing Using Slicers, See Here. – through SQLAlchemy (GH2717, GH4163, GH5950, GH6292). All databases supported by SQLAlchemy can be used, such as PostgreSQL, MySQL, Oracle, Microsoft SQL server (see documentation of SQLAlchemy on included (database table name or sql query). In practice, you have to provide a SQLAlchemy engine to the sql functions. To connect with SQLAlchemy you use 50 Chapter 1. What’s New pandas: powerful Python data analysis

examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 991 25.9.10 Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 991 25.9.11 Sqlite fallback attribute, the visual effect is the same. (GH11563). • Raise ImportError in the sql functions when sqlalchemy is not installed and a connection string is used (GH11920). • Compatibility with matplotlib 2 (GH13857) • DataFrame.to_sql() has deprecated the flavor parameter, as it is superfluous when SQLAlchemy is not installed (GH13611) • Deprecated read_csv keywords: – compact_ints and use_unsigned have

examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 993 25.9.10 Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 993 25.9.11 Sqlite fallback attribute, the visual effect is the same. (GH11563). • Raise ImportError in the sql functions when sqlalchemy is not installed and a connection string is used (GH11920). • Compatibility with matplotlib 2 (GH13857) • DataFrame.to_sql() has deprecated the flavor parameter, as it is superfluous when SQLAlchemy is not installed (GH13611) • Deprecated read_csv keywords: – compact_ints and use_unsigned have

examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1096 24.10.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1097 24.10.11Sqlite fallback attribute, the visual effect is the same. (GH11563). • Raise ImportError in the sql functions when sqlalchemy is not installed and a connection string is used (GH11920). • Compatibility with matplotlib 2 (GH13857) • DataFrame.to_sql() has deprecated the flavor parameter, as it is superfluous when SQLAlchemy is not installed (GH13611) • Deprecated read_csv keywords: – compact_ints and use_unsigned have

examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1131 24.11.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1132 24.11.11Sqlite fallback attribute, the visual effect is the same. (GH11563). • Raise ImportError in the sql functions when sqlalchemy is not installed and a connection string is used (GH11920). • Compatibility with matplotlib 2 (GH13857) • DataFrame.to_sql() has deprecated the flavor parameter, as it is superfluous when SQLAlchemy is not installed (GH13611) • Deprecated read_csv keywords: – compact_ints and use_unsigned have

examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.11Sqlite fallback attribute, the visual effect is the same. (GH11563). • Raise ImportError in the sql functions when sqlalchemy is not installed and a connection string is used (GH11920). • Compatibility with matplotlib 2 (GH13857) • DataFrame.to_sql() has deprecated the flavor parameter, as it is superfluous when SQLAlchemy is not installed (GH13611) • Deprecated read_csv keywords: – compact_ints and use_unsigned have