– NameResolutionError was removed because it isn’t necessary anymore. • Define and document the order of column vs index names in query/eval (GH6676) • concat will now concatenate mixed Series and DataFrames drop unused order argument from Series.sort; args now are in the same order as Series.order; add na_position arg to conform to Series.order (GH6847) • default sorting algorithm for Series.order is now quicksort quicksort, to conform with Series.sort (and numpy defaults) • add inplace keyword to Series.order/sort to make them inverses (GH6859) • DataFrame.sort now places NaNs at the beginning or end of the sort

AVG(mean_temp) as MEAN_TEMP FROM publicdata:samples.gsod WHERE YEAR = 2000 GROUP BY STATION, MONTH ORDER BY STATION, MONTH ASC""" # Fetch the result set for this query # Your Google BigQuery Project ID GH4618), allow method= in reindexing on a Se- ries to work • Series.copy no longer accepts the order parameter and is now consistent with NDFrame copy 32 Chapter 1. What’s New pandas: powerful Python handle non-unique columns (GH3495) – Duplicate indexes with getitem will return items in the correct order (GH3455, GH3457) and handle miss- ing elements like unique indices (GH3561) – Duplicate indexes with

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 554 21.4 Sorting and Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 557 21.5 categorical variables exported to Stata data files. • Added flag order_categoricals to StataReader and read_stata to select whether to order im- ported categorical data (GH8836). See here for more information object as key (GH8667) • Bug in merge where how=’left’ and sort=False would not preserve left frame order (GH7331) • Bug in MultiIndex.reindex where reindexing at level would not reorder labels (GH4088)

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 653 22.4 Sorting and Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 656 22.5 API PRIOR to 0.17.0: • Series.sort is INPLACE while DataFrame.sort returns a new object. • Series.order returns a new object • It was possible to use Series/DataFrame.sort_index to sort by values by passing the merger of DataFrame.sort(), Series.sort(), and Series.order(), to handle sorting of values. • The existing methods Series.sort(), Series.order(), and DataFrame.sort() have been depre- cated and will

producing an error for non-unique columns; now handles non-unique columns and returns columns in original order (except for the case of two DataFrames with pairwise=False, where behavior is unchanged) (GH7542) and can be replaced by .describe() (GH8481) • The Index set operations + and - were deprecated in order to provide these for numeric type operations on certain index types. + can be replaced by .union() – NameResolutionError was removed because it isn’t necessary anymore. • Define and document the order of column vs index names in query/eval (GH6676) • concat will now concatenate mixed Series and DataFrames

assignment fail when using chained indexing? . . . . . . . . . . . . . . . . . . . 569 13.21.2 Evaluation order matters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 570 14 MultiIndex . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 802 22.4 Sorting and Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 802 22.4 nunique . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1579 pandas.Index.order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1579 pandas.Index

assignment fail when using chained indexing? . . . . . . . . . . . . . . . . . . . 571 13.21.2 Evaluation order matters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 572 14 MultiIndex . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 804 22.4 Sorting and Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 804 22.4 nunique . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1582 pandas.Index.order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1582 pandas.Index

. . . . . . . . . . . . . . . . 32 1.3.2.14 Index.intersection and inner join now preserve the order of the left Index . . . . . . 32 1.3.2.15 Pivot Table always returns a DataFrame . . . . . . . . assignment fail when using chained indexing? . . . . . . . . . . . . . . . . . . . 633 12.22.2 Evaluation order matters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 634 13 MultiIndex . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 890 21.4 Sorting and Order . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 891 21.4

toolkit, Release 1.0.0 1.3.4 convert_dtypes method to ease use of supported extension dtypes In order to encourage use of the extension dtypes StringDtype, BooleanDtype, Int64Dtype, Int32Dtype, etc., 7/site-packages/numpy/core/_asarray.py in ˓→asarray(a, dtype, order) 83 84 """ ---> 85 return array(a, dtype, copy=False, order=order) 86 87 /pandas/pandas/core/arrays/masked.py in __array__(self from_arrays() will no longer infer names from arrays if names=None is explicitly pro- vided (GH27292) • In order to improve tab-completion, Pandas does not include most deprecated attributes when introspect- ing

NaN] Categories (2, object): [a < b] 1.2.14 Column order is preserved when passing a list of dicts to DataFrame Starting with Python 3.7 the key-order of dict is guaranteed. In practice, this has been now treats a list of dicts in the same way as it does a list of OrderedDict, i.e. preserving the order of the dicts. This change applies only when pandas is running on Python>=3.6 (GH27309). In [63]: New Behavior: The column order now matches the insertion-order of the keys in the dict, considering all the records from top to bottom. As a consequence, the column order of the resulting DataFrame has