The R Stuff
Home
Blog
Projects
Ravi Chowdhury
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.
Apr 14, 2024
Ravi Chowdhury
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…
Dec 12, 2023
Ravi Chowdhury
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
Apr 12, 2023
Ravi C
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…
Mar 1, 2023
Ravi C
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.
Feb 28, 2023
Ravi C
Interact with SQL Server
We will go through how to connect to a sql server and fetch tables.
Feb 13, 2023
Ravi C
Filter with str_detect
To filter using str_detect, generally you can use the code as follows:
Jan 25, 2023
Ravi C
No matching items