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 the following drawbacks: 1. When your Series contains an extension type, its unclear whether Series.values returns a NumPy array or the extension array. Series.array will always return an ExtensionArray internally. See Extension types for how to write your own extension that works with pandas. See Extension data types for a list of third-party libraries that have implemented an extension. The following

return Index . . . . . . . . . . . . . . . . . 24 1.3.2.4 pd.unique will now be consistent with extension types . . . . . . . . . . . . . . . . 25 1.3.2.5 S3 File Handling . . . . . . . . . . . . . . 10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1097 24.10.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1098 is_datetime64tz_dtype . . . . . . . . . . . . . . . . . . . . . . . 1851 34.16.4.11pandas.api.types.is_extension_type . . . . . . . . . . . . . . . . . . . . . . . . . . 1851 34.16.4.12pandas.api.types.is_float_dtype

hold integer dtypes with missing values. This long requested feature is enabled through the use of extension types. Note: IntegerArray is currently experimental. Its API or implementation may change without PandasArray isn’t especially useful on its own, but it does provide the same interface as any extension array defined in pandas or by a third-party library. In [23]: ser = pd.Series([1, 2, 3]) In [24]: (GH22860). This can be used to create any extension array, including extension arrays registered by 3rd party libraries. See the dtypes docs for more on extension arrays. In [26]: pd.array([1, 2, np.nan]

the user guide on missing data. 1.3.2 Dedicated string data type We’ve added StringDtype, an extension type dedicated to string data. Previously, strings were typically stored in object-dtype NumPy arrays experimental. The implementation and parts of the API may change without warning. The 'string' extension type solves several issues with object-dtype NumPy arrays: 1. You can accidentally store a mixture 3.3 Boolean data type with missing values support We’ve added BooleanDtype / BooleanArray, an extension type dedicated to boolean data that can hold missing values. The default bool data type based on

return Index . . . . . . . . . . . . . . . . . 53 1.5.2.4 pd.unique will now be consistent with extension types . . . . . . . . . . . . . . . . 54 1.5.2.5 S3 File Handling . . . . . . . . . . . . . . 10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1132 24.11.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1133 is_datetime64tz_dtype . . . . . . . . . . . . . . . . . . . . . . . 1997 34.19.4.11pandas.api.types.is_extension_type . . . . . . . . . . . . . . . . . . . . . . . . . . 1998 34.19.4.12pandas.api.types.is_float_dtype

operators, for example: x < -0.1 (GH25928) • Fixed bug where casting all-boolean array to integer extension array failed (GH25211) • Bug in divmod with a Series object containing zeros incorrectly raising (GH26835) • Added Series.__array_ufunc__ to better handle NumPy ufuncs applied to Series backed by extension arrays (GH23293). • Keyword argument deep has been removed from ExtensionArray.copy() (GH27083) 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

operators, for example: x < -0.1 (GH25928) • Fixed bug where casting all-boolean array to integer extension array failed (GH25211) • Bug in divmod with a Series object containing zeros incorrectly raising (GH26835) • Added Series.__array_ufunc__ to better handle NumPy ufuncs applied to Series backed by extension arrays (GH23293). • Keyword argument deep has been removed from ExtensionArray.copy() (GH27083) 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

return Index . . . . . . . . . . . . . . . . . 23 1.2.2.4 pd.unique will now be consistent with extension types . . . . . . . . . . . . . . . . 23 1.2.2.5 S3 File Handling . . . . . . . . . . . . . . 10Advanced SQLAlchemy queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1095 24.10.11Sqlite fallback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1096 is_datetime64tz_dtype . . . . . . . . . . . . . . . . . . . . . . . 1718 34.16.4.11pandas.api.types.is_extension_type . . . . . . . . . . . . . . . . . . . . . . . . . . 1718 34.16.4.12pandas.api.types.is_float_dtype

. . . . . . . . . . . . . . . . . . . . . . . . . . 2396 3.16.1 pandas.api.extensions.register_extension_dtype . . . . . . . . . . . . . . . . . . . . . . . . 2396 3.16.2 pandas.api.extensions.regist custom accessors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2468 4.5.2 Extension types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2469 4 PyTables 3.4.3 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

. . . . . . . . . . . . . . . . . . . . . . . . . . 2396 3.16.1 pandas.api.extensions.register_extension_dtype . . . . . . . . . . . . . . . . . . . . . . . . 2396 3.16.2 pandas.api.extensions.regist custom accessors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2468 4.5.2 Extension types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2469 4 PyTables 3.4.3 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