tidytable (version 0.5.4)

top_n.: Select top (or bottom) n rows (by value)

Description

Select the top or bottom entries in each group, ordered by wt.

Usage

top_n.(.df, n = 5, wt = NULL, .by = NULL, by = NULL)
dt_top_n(.df, n = 5, wt = NULL, .by = NULL, by = NULL)

Arguments

.df

A data.frame or data.table

n

Number of rows to return

wt

Optional. The variable to use for ordering. If NULL uses the last column in the data.table.

.by

Columns to group by

by

This argument has been renamed to .by and is deprecated

Examples

# NOT RUN {
test_df <- data.table(
  x = 1:5,
  y = 6:10,
  z = c(rep("a", 3), rep("b", 2)))

test_df %>%
  top_n.(2, wt = y)

test_df %>%
  top_n.(2, wt = y, .by = z)
# }