create sub dataframe according to columns values in r

In R, you can create a sub dataframe based on the values of specific columns using the subset() function or using dplyr package.

Using subset():


main.r
# create dataframe
df <- data.frame(
  a = c(1, 2, 3),
  b = c("x", "y", "z")
)

# create sub dataframe where column b equals "y"
sub_df <- subset(df, b == "y")
161 chars
9 lines

Using dplyr:


main.r
# load dplyr package
library(dplyr)

# create dataframe
df <- data.frame(
  a = c(1, 2, 3),
  b = c("x", "y", "z")
)

# create sub dataframe where column b equals "y"
sub_df <- df %>% filter(b == "y")
201 chars
12 lines

Both of these methods create a sub dataframe where only the rows that meet the condition specified in the subset() or filter() function are included.

similar r code snippets

set the first row as headers in r

filter nycflights13 by month of july in r

read all files in a directory into a data frame, with a column recording filename in r

check if column values have 90 percent overlap in vlaues in r

mutate a column via its name in r

tidyverse overlap 90 percent column values in r

in a dataframe where the concentration column goes 10, 5, 2, 1 repeatedly, reverse the order of the concentration column in r

read all files in a directory into a data frame, with a column recording filename using tidyverse in r

how to create a dataframe in r

recode some rows of dataframe in r

related categories

r

data wrangling

subsetting

subsetting dataframes

dplyr