In this tutorial, we will learn how to use dplyr's anti_join() function to filter rows from one dataframe based on the presence or absence of matches in another dataframe. dplyr's anti_join() function is extremely useful for cases when we want to find what row is present or … [Read more...] about dplyr’s anti_join() to find rows based on presence or absence in a dataframe
rstats101
How to select rows with multiple partial matching strings
In this tutorial, we will learn how to select or filter rows of a dataframe with multiple partially matching strings. dplyr's filter() function selects/filters rows based on values of one or more columns when it completely matches. However, if you want to select rows with … [Read more...] about How to select rows with multiple partial matching strings
How to compute annualized return of a stock with tidyverse
In this tutorial, we will learn how to compute annualized return of stock using tidyverse from scratch. Annualized return of an investment is the average returns of the investment that is held over many years. In comparison to simple mean of yearly returns, annualized return is … [Read more...] about How to compute annualized return of a stock with tidyverse
How to get product of all elements in a column
In this tutorial we will learn how to compute product of all elements of a column in a dataframe using tidyverse. We will use prod() function in base to multiple all elements of a columns. Let us first load tidyverse. We will create a simple dataframe using tidyverse' … [Read more...] about How to get product of all elements in a column
slice_min: Get Rows with minimum values of a column
In this tutorial, we will learn how to get rows with lowest values of a column from a data frame in R. We will use dplyr's slice_min() function to select rows with lowest values for a column in a data frame. We will also use slice_min() function in dplyr to find the bottom n … [Read more...] about slice_min: Get Rows with minimum values of a column