In this tutorial, we will learn how to select or filter rows of a dataframe with partially matching string. dplyr's filter() function selects/filters rows based on values of one or more columns when it completely matches. However, to filter or select rows with partially matching … [Read more...] about dplyr filter(): How to select rows with partially matching string
How to filter rows in a dataframe: dplyr’s filter()
With dplyr's filter() function, one can filter rows or subset rows from a dataframe. In this post, we will learn how to select subset of rows based on values one or more columns in a dataframe using dplyr's filter() function. First we load tidyverse the suit of R … [Read more...] about How to filter rows in a dataframe: dplyr’s filter()
dplyr ends_with(): select columns that end with a suffix
In this tutorial, we will learn how to select columns that ends with a string with multiple examples using dplyr and base R. With dplyr, we can use ends_with(), one of the select helper functions, to select columns that ends with a prefix/string. Similarly, in base R we have … [Read more...] about dplyr ends_with(): select columns that end with a suffix
How to collapse multiple rows based on a column
In this tutorial, we will learn how to collapse multiple rows from a column to a single row based on another column/group. Let us get started by loading tidyverse and checking the tidyr package version. To illustrate collapsing multiple rows into single one, let us … [Read more...] about How to collapse multiple rows based on a column
How to Separate a Column into Multiple Rows in R: Hint tidyr’s spearate_row()
In this tutorial, we will learn how to separate a column with multiple elements separated by a delimiter into different rows. We will use tidy's separate_rows() function first to separate a column with comma separated elements. And then show how to use separate_rows() on multiple … [Read more...] about How to Separate a Column into Multiple Rows in R: Hint tidyr’s spearate_row()