5  Sorting and taking

sort orders the rows, and descending reverses one key.

R

sales |> sort(descending(revenue)) |> take(3)

region	product	revenue	cost
East	Widget	500	100
West	Gadget	300	100
West	Widget	200	50

Python

sales >> sort(descending(col.revenue)) >> take(3)

region	product	revenue	cost
East	Widget	500	100
West	Gadget	300	100
West	Widget	200	50

There is no ascending, because ascending is what happens when you do not ask for anything, and a word meaning “do the default” is a second way to say the same thing. Sorting by several keys reads left to right.

R

sales |> sort(product, descending(revenue))

region	product	revenue	cost
West	Gadget	300	100
West	Gadget	150	50
East	Widget	500	100
West	Widget	200	50
West	Widget	100	40

Python

sales >> sort(col.product, descending(col.revenue))

region	product	revenue	cost
West	Gadget	300	100
West	Gadget	150	50
East	Widget	500	100
West	Widget	200	50
West	Widget	100	40