. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 6.12 Aliasing Axis Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 7 Intro lxml fails to parse. a list of parsers to try until success is also valid • The internal pandas class hierarchy has changed (slightly). The previous PandasObject now is called PandasContainer and a new not specified (e.g. you don’t have an index, or wrote it with df.to_csv(..., index=False), then any names on the columns index will be lost. In [20]: from pandas.util.testing import makeCustomDataframe as

2 Defining custom windows for rolling operations We’ve added a pandas.api.indexers.BaseIndexer() class that allows users to define how window bounds are created during rolling operations. Users can define to_numpy() to control the value used for missing data (GH30322) • MultiIndex.from_product() infers level names from inputs if not explicitly provided (GH27292) • DataFrame.to_latex() now accepts caption and label Avoid using names from MultiIndex.levels As part of a larger refactor to MultiIndex the level names are now stored separately from the levels (GH27242). We recommend using MultiIndex.names to access the

NumFOCUS sponsored project. This will help ensure the success of the development of pandas as a world-class open-source project and makes it possible to donate to the project. Project governance The governance other materials provided with the distribution. * Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without have value 0 and 1. 0 for not survived and 1 for survived. • Pclass: There are 3 classes: Class 1, Class 2 and Class 3. • Name: Name of passenger. • Sex: Gender of passenger. • Age: Age of passenger.

NumFOCUS sponsored project. This will help ensure the success of the development of pandas as a world-class open-source project and makes it possible to donate to the project. Project governance The governance other materials provided with the distribution. * Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without have value 0 and 1. 0 for not survived and 1 for survived. • Pclass: There are 3 classes: Class 1, Class 2 and Class 3. • Name: Name of passenger. • Sex: Gender of passenger. • Age: Age of passenger.

NumFOCUS sponsored project. This will help ensure the success of the development of pandas as a world-class open-source project and makes it possible to donate to the project. Project governance The governance other materials provided with the distribution. * Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without have value 0 and 1. 0 for not survived and 1 for survived. • Pclass: There are 3 classes: Class 1, Class 2 and Class 3. • Name: Name of passenger. • Sex: Gender of passenger. • Age: Age of passenger.

NumFOCUS sponsored project. This will help ensure the success of development of pandas as a world- class open-source project, and makes it possible to donate to the project. Project governance The governance other materials provided with the distribution. * Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without have value 0 and 1. 0 for not survived and 1 for survived. • Pclass: There are 3 classes: Class 1, Class 2 and Class 3. • Name: Name of passenger. • Sex: Gender of passenger. • Age: Age of passenger.

NumFOCUS sponsored project. This will help ensure the success of development of pandas as a world- class open-source project, and makes it possible to donate to the project. Project governance The governance other materials provided with the distribution. * Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without have value 0 and 1. 0 for not survived and 1 for survived. • Pclass: There are 3 classes: Class 1, Class 2 and Class 3. • Name: Name of passenger. • Sex: Gender of passenger. • Age: Age of passenger.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241 7.12 Aliasing Axis Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 242 7.13 Creating dtype; previously these would raise TypeError (GH8938) • Bug in NDFrame: conflicting attribute/column names now behave consistently between getting and setting. Previously, when both a column and attribute example and caveats w.r.t. prior versions of pandas. • Added support for searchsorted() on Categorical class (GH8420). Other enhancements: • Added the ability to specify the SQL type of columns when writing

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 7.12 Aliasing Axis Names . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234 7.13 Creating NumPy >= 1.7.0 (GH7711) • Highlights include: – The Categorical type was integrated as a first-class pandas type, see here – New scalar type Timedelta, and a new index type TimedeltaIndex, see here the rolling and expanding moment funtions, see here – Internal refactoring of the Index class to no longer sub-class ndarray, see Internal Refactoring – dropping support for PyTables less than version 3

average_weight kind cat 9.1 9.5 8.90 dog 6.0 34.0 102.75 [2 rows x 3 columns] Pass the desired columns names as the **kwargs to .agg. The values of **kwargs should be tuples where the first element is the column constructors (GH25065) • DataFrame.query() and DataFrame.eval() now supports quoting column names with backticks to refer to names with spaces (GH6508) • merge_asof() now gives a more clear error message when merge 210 return wrapper /pandas/pandas/core/indexes/multi.py in __new__(cls, levels, codes, sortorder, names, ˓→dtype, copy, name, verify_integrity, _set_identity) 270 271 if verify_integrity: --> 272 new_codes