deprecated as of 0.25 and will be removed in a future version. It is recommended to use pyarrow for on-the-wire transmission of pandas objects. (GH27084) 1.3.3 Other deprecations • The deprecated .ix[] indexer 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 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key;

deprecated as of 0.25 and will be removed in a future version. It is recommended to use pyarrow for on-the-wire transmission of pandas objects. (GH27084) 1.3.3 Other deprecations • The deprecated .ix[] indexer 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 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key;

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 Pandas equivalents for some SQL analytic and aggregate functions Top N rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.3 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 pandas equivalents for some SQL analytic and aggregate functions Top n rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.3 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 pandas equivalents for some SQL analytic and aggregate functions Top n rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 Pandas equivalents for some SQL analytic and aggregate functions Top N rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 Pandas equivalents for some SQL analytic and aggregate functions Top N rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

sqlalchemy pyarrow 0.12.0 Parquet, ORC (requires 0.13.0), and feather reading / writing pymysql 0.7.11 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pytables 3.4.2 HDF5 reading / writing or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 Pandas equivalents for some SQL analytic and aggregate functions Top N rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns='tip')

engine for sqlalchemy pyarrow 0.15.0 Parquet, ORC, and feather reading / writing pymysql 0.8.1 MySQL engine for sqlalchemy pyreadstat SPSS files (.sav) reading pyxlsb 1.0.6 Reading for xlsb files or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). -- show all records from both tables SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Angeles 5 pandas equivalents for some SQL analytic and aggregate functions Top n rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [35]: tips.nlargest(10 + 5, columns="tip")

support for databases other than sqlite psycopg2 2.7 PostgreSQL engine for sqlalchemy pymysql 0.8.1 MySQL engine for sqlalchemy Other data sources Dependency Minimum Version Notes PyTables 3.5.1 HDF5-based or not the joined columns find a match. As of writing, FULL JOINs are not supported in all RDBMS (MySQL). Show all records from both tables. SELECT * FROM df1 FULL OUTER JOIN df2 ON df1.key = df2.key; Dinner 2 pandas equivalents for some SQL analytic and aggregate functions Top n rows with offset -- MySQL SELECT * FROM tips ORDER BY tip DESC LIMIT 10 OFFSET 5; In [37]: tips.nlargest(10 + 5, columns="tip")