misty (version 0.8.3)

df.subset: Subsetting Data Frames

Description

This function returns subsets of data frames which meet conditions.

Usage

df.subset(data, ..., subset = NULL, drop = TRUE, check = TRUE)

Value

Returns a data frame containing the variables and rows selected in the argument ... and rows selected in the argument subset.

Arguments

data

a data frame.

...

an expression indicating variables to select from the data frame specified in data. See Details for the list of operators used in this function, i.e., +, -, ~, :, ::, and !. Note that all variables are selected if the argument ... is not specified.

subset

a logical expression indicating rows to keep, e.g., var == 1, var1 == 1 & var2 == 3, or gender == "female". By default, all rows of the data frame specified in data are kept. Note that logical queries for rows resulting in missing values are not select.

drop

logical: if TRUE (default), data frame with a single column is converted into a vector.

check

logical: if TRUE (default), argument specification is checked.

Author

Takuya Yanagida

Details

The argument ... is used to specify an expression indicating the variables to select and/or remove from the data frame specified in data. There are six operators which can be used in the expression ...:

Plus (+) Operator

The plus operator is used to select variables matching a prefix from the data frame specified in data. For example, df.subset(dat, +x) selects all variables with the prefix x. Note that this operator is equivalent to the function starts_with() from the tidyselect package.

Minus (-) Operator

The minus operator is used to select variables matching a suffix from the data frame specified in data. For example, df.subset(dat, -y) selects all variables with the suffix y. Note that this operator is equivalent to the function ends_with() from the tidyselect package.

Tilde (~) Operator

The tilde operator is used to select variables containing a word from the data frame specified in data. For example, df.subset(dat, ~al) selects all variables with the word al. Note that this operator is equivalent to the function contains() from the tidyselect package.

Colon (:) operator

The colon operator is used to select a range of consecutive variables from the data frame specified in data. For example, df.subset(dat, x:z) selects all variables from x to z. Note that this operator is equivalent to the : operator from the select function in the dplyr package.

Double Colon (::) Operator

The double colon operator is used to select numbered variables from the data frame specified in data. For example, df.subset(dat, x1::x3) selects the variables x1, x2, and x3. Note that this operator is similar to the function num_range() from the tidyselect package.

Exclamation Point (!) Operator

The exclamation point operator is used to drop variables from the data frame specified in the argument data or for taking the complement of a set of variables. For example, df.subset(dat, !x) selects all variables except the variable x, df.subset(dat, !~x) selects all variables except variables with the prefix x, or df.subset(dat, x1:x10, !x3:x5) selects all variables from x1 to x10 but excludes all variables from x3 to x5. Note that this operator is equivalent to the ! operator from the select function in the dplyr package.

Operators can be combined within the same function call. For example, df.subset(dat, +x, -y, !x2:x4, z) selects all variables with the prefix x and with the suffix y but excludes variables from x2 to x4 and selects variable z.

References

Becker, R. A., Chambers, J. M. and Wilks, A. R. (1988) The New S Language. Wadsworth & Brooks/Cole.

See Also

df.check, df.duplicated, df.unique, df.head, df.tail, df.long, df.wide, df.merge, df.move, df.rbind, df.rename, df.sort,

Examples

if (FALSE) {
#————————————————————————————————————————————————————————————————————————————
# Select Single Variables

# Example 1: Select 'Sepal.Length' and 'Petal.Width'
df.subset(iris, Sepal.Length, Petal.Width)

#————————————————————————————————————————————————————————————————————————————
# Select Rows

# Example 2a: Select all variables, select rows with 'Species' equal 'setosa'
df.subset(iris, subset = Species == "setosa")

# Example 2b: Select all variables, select rows with 'Petal.Length' smaller 1.2
df.subset(iris, subset = Petal.Length < 1.2)

# Example 2C: Select 'Sepal.Length' and 'Petal.Width',
# select rows with 'Species' equal 'setosa'
df.subset(iris, Sepal.Length, Petal.Width, subset = Species == "setosa")

#————————————————————————————————————————————————————————————————————————————
# Select Variables Matching a Prefix using the + Operator

# Example 3: Select variables with prefix 'Petal'
df.subset(iris, +Petal)

#————————————————————————————————————————————————————————————————————————————
# Select Variables Matching a Suffix using the - Operator

# Example 4: Select variables with suffix 'Width'
df.subset(iris, -Width)

#————————————————————————————————————————————————————————————————————————————
# Select Variables Containing a Word using the ~ Operator

# Example 5: Select variables containing 'al'
df.subset(iris, ~al)

#————————————————————————————————————————————————————————————————————————————
# Select Consecutive Variables using the : Operator

# Example 6: Select all variables from 'Sepal.Width' to 'Petal.Width'
df.subset(iris, Sepal.Width:Petal.Width)

#————————————————————————————————————————————————————————————————————————————
# Select Numbered Variables using the :: Operator

# Example 7: Select all variables from 'x1' to 'x3' and 'y1' to 'y3'
df.subset(anscombe, x1::x3, y1::y3)

#————————————————————————————————————————————————————————————————————————————
# Drop Variables using the ! Operator

# Example 8a: Select all variables except 'Sepal.Width'
df.subset(iris, !Sepal.Width)

# Example 8b: Select all variables except variables with prefix 'Petal'
df.subset(iris, !+Petal)

# Example 8c: Select all variables except variables with suffix 'Width'
df.subset(iris, !-Width)

# Example 8d: Select all variables except 'Sepal.Width' to 'Petal.Width'
df.subset(iris, !Sepal.Width:Petal.Width)

#————————————————————————————————————————————————————————————————————————————
# Combine +, -, !, and : Operators

# Example 9: Select variables with prefix 'x' and suffix '3', but exclude
# variables from 'x2' to 'x3'
df.subset(anscombe, +x, -3, !x2:x3)
}