Select and Order Data

5.3.1 Select and Order Data

OREdplyr functions for selecting and ordering data in columns and rows of an ore.frame object.

Table 5-2 Selecting and Ordering Columns and Rows

Function	Description
`arrange` `arrange_`	Orders rows by the specified columns.
`desc`	Sorts an `ore.number`, `ore.factor`, or `ore.character` object in descending order
`distinct` `distinct_`	Selects unique rows from an input `ore.frame` object over the specified columns.
`filter` `filter_`	Filters rows by matching the specified condition.
`mutate` `mutate_`	Adds new columns.
`rename` `rename_`	Renames the specified columns and keeps all columns.
`select` `select_`	Selects only the specified columns.
`slice` `slice_`	Selects rows by position; ignores the grouping of the input ordered `ore.frame` object.
`tranmute` `tranmute_`	Adds new columns and drops the existing columns.

Examples of using these functions are the following:

Examples of Selecting Columns
Examples of the select and rename functions of the OREdplyr package.
Examples of Programming with select_
Examples of the select_ function of the OREdplyr package.
Examples of Selecting Distinct Columns
Examples of the distinct and arrange functions of the OREdplyr package.
Examples of Selecting Rows by Position
Examples of the slice and filter functions of the OREdplyr package.
Examples of Arranging Columns
Examples of the arrange and desc functions of the OREdplyr package.
Examples of Filtering Columns
Examples of the filter function of the OREdplyr package.
Examples of Mutating Columns
Examples of the mutate and transmute functions of the OREdplyr package.

Parent topic: Data Manipulation Using OREdplyr