Blog

Write to Excel (Multiple Sheets)

This post is about exporting Excel files using R, we will also look at how we can export multiple datasets to multiple sheets within the same workbook.

Select Empty Columns

This post is about selecting empty columns using R and tidyverse, specifically dplyr. There might be a need where you want to select only empty columns from a table for…

Create Table Permission in SQL

While working on a code that writes data to SQL database, I ran into an issue where R gives me an error as below

Reorder columns

There are several methods to change the order of columns in R. While the select function from dplyr is a common way to do it, we will also explore other functions that can…

Create SQL DB in R

To produce a SQL database, we will utilize the RSQLite and DBI packages and the “iris” data set available in R.

Interact with SQL Server

We will go through how to connect to a sql server and fetch tables.

Filter with str_detect

To filter using str_detect, generally you can use the code as follows: