In this tutorial we will learn how to find the difference between two date objects in R in terms of days, months, and years. We will learn how to use time_length() function available in tidyverse as part of lubridate package to get the difference as dyas, weeks, months, and … [Read more...] about How to Find difference between two dates as days, weeks, months and years
dplyr’s anti_join() to find rows based on presence or absence in a dataframe
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
tidyr’s separate_delim_wider(): Split a string into columns
In this tutorial, we will learn how to split a string in a column into multiple columns using a delimiter. We will use tidyr's separate_delim_wider() function, that separates a string in a column into multiple columns using delimiter. After spliting the dataframe is wider with … [Read more...] about tidyr’s separate_delim_wider(): Split a string into columns
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