In R, there are many ways to save a dataframe as Excel file *.xlsx. In this tutorial, we will use the R package openxlsx and learn how to save a dataframe as xlsx file. First we will learn how to save a xlsx file using write.xlsx() function in openxlsx package. And then we will … [Read more...] about How to Save Dataframe into XLSX file in R
How To Check If One or More Elements is in a Vector
In this tutorial, we will learn about is.element() function available in base R and use it to check if one or more elements is present in a vector. Let us create a sample vector in R Our simple vector hs 6 elements. If we want to check if a value us present in the … [Read more...] about How To Check If One or More Elements is in a Vector
dplyr’s arrange(): Sort a Dataframe Columns
In this tutorial, we will learn how to sort a dataframe by a column in R. We will see three examples of using tidyverse's arrange() function to sort a dataframe by one of its columns. First, we will sort a dataframe by numerical column in ascending order, next we will sort it in … [Read more...] about dplyr’s arrange(): Sort a Dataframe Columns
How to Create a dataframe from vectors in R
In this tutorial, we will learn how to create a dataframe from scratch in R. We will learn to create a dataframe from two vectors of same length. Let us get started creating two vectors in R. We use results from OReilly's 2021 Data/AI Salary Survey giving average salary … [Read more...] about How to Create a dataframe from vectors in R
Remove rows with missing values using drop_na() in R
In this tutorial we will learn how to remove rows containing missing values using drop_na() function available in tidyr package in R. drop_na() available in tidyverse is a versatile function. First we will see an example of removing all rows with at least one missing values using … [Read more...] about Remove rows with missing values using drop_na() in R