Learning various data operation in R with references to SQL commands for easy understanding

Hello there, welcome to my blog post. The reason behind this post is to practice R and R markdown for myself and share my work with the audience. I would make references to SQL/relational database commands while working with R. If you are not familiar with SQL then ignore SQL parts, this is just for easy understanding.

Prerequisites:

1. Install R
2. R Studio (for ease otherwise R itself is sufficient)

Assumption : You know what your working directory is and where you have to keep the files to upload.

How to import multiple .csv files R where files share same column format

Loading multiple csv files in R which share same column format

Scenario - We have number of csv files with identical column format and we would like to import all of this data into one data frames.

Solution - following code can help upload multiple identical files into list of data frames in R and then into one big data frame:

Common R commands to learn on early days

If you are just starting with R then here is the list of some commands which you must master. 

These commands will immensely help you in this journey. Here they are:

How to install R on Macbook Pro

• Download R from https://cran.r-project.org/bin/macosx/
• Select appropriate version. In this example we will use R-4.0.0.pkg
• When downloaded, put the package in your working directory or leave it in the download folder