– 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

NAMESPACE: kyuubi STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: The chart has been installed! In order to check the release status, use: helm status kyuubi -n kyuubi or for more detailed info helm Kerberos Ticket Cache to JVM Search Path JVM determines the ticket cache location in the following order: 1. Path specified by KRB5CCNAME environment variable. Path must start with FILE:. 2. /tmp/krb5cc_%{uid} Spark [https://spark.apache.org/docs/latest/security.html#kerberos] Hadoop Credentials Manager In order to pass the authentication of a kerberos secured hadoop cluster, kyuubi currently submits engines

NAMESPACE: kyuubi STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: The chart has been installed! In order to check the release status, use: helm status kyuubi -n kyuubi or for more detailed info helm Kerberos Ticket Cache to JVM Search Path JVM determines the ticket cache location in the following order: 1. Path specified by KRB5CCNAME environment variable. Path must start with FILE:. 2. /tmp/krb5cc_%{uid} Spark [https://spark.apache.org/docs/latest/security.html#kerberos] Hadoop Credentials Manager In order to pass the authentication of a kerberos secured hadoop cluster, kyuubi currently submits engines

NAMESPACE: kyuubi STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: The chart has been installed! In order to check the release status, use: helm status kyuubi -n kyuubi or for more detailed info helm Kerberos Ticket Cache to JVM Search Path JVM determines the ticket cache location in the following order: 1. Path specified by KRB5CCNAME environment variable. Path must start with FILE:. 2. /tmp/krb5cc_%{uid} Spark [https://spark.apache.org/docs/latest/security.html#kerberos] Hadoop Credentials Manager In order to pass the authentication of a kerberos secured hadoop cluster, kyuubi currently submits engines