returning a Series when there was a column named sparse rather than the accessor (GH30758) • Fixed operator.xor() with a boolean-dtype SparseArray. Now returns a sparse result, rather than object dtype (GH31025) pipes and more recently dplyr and magrittr, which have introduced the popular (%>%) (read pipe) operator for R. The implementation of pipe here is quite clean and feels right at home in python. We encourage function match. The operator %in% is used to return a logical vector indicating if there is a match or not: s <- 0:4 s %in% c(2,4) The isin() method is similar to R %in% operator: In [12]: s = pd.Series(np

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1251 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1252 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1745 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1745 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] (continues on

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1251 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1252 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1745 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1745 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1212 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1213 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1678 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1679 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1216 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1217 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1681 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1682 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1214 4.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1215 4.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1679 4.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1680 4.4.6 Function out-of-bound values are present (GH31491) Numeric • Bug in dtypes being lost in DataFrame.__invert__ (~ operator) with mixed dtypes (GH31183) and for extension-array backed Series and DataFrame (GH23087) Plotting

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1273 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1274 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1775 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1776 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1272 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1273 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1774 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1775 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1360 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1361 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1852 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1853 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1413 3.3.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1414 3.3.6 Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1918 3.4.5 Binary operator functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1919 3.4.6 Function filtering by rows for which the class is either 2 or 3 and combining the two statements with an | (or) operator: In [18]: class_23 = titanic[(titanic["Pclass"] == 2) | (titanic["Pclass"] == 3)] In [19]: class_23