Cleaning Data - Some Important Tricks (Part 5) - Load data

1. Read csv file

#dat <- read.csv("Physicians.csv", header = TRUE, sep = ',')

2. Load heavy file

#install.packages("data.table")
#library(data.table)
#dat2 <- fread ("Data.csv", header = T, sep = ',')

3. Load excel file

#install.packages("gdata")
#library(gdata)
#dat3 <- read.xls("New_List.xlsx", sheet = 1, header = TRUE)

4. Load excel file with multiple sheets

#install.packages("rio")
#library(rio)
#mysheets <- import_list("data_cognos.xlsx")

• Combine all above sheets into 1 sheet

  #install.packages("data.table") to use rbind function
  #library(data.table)
  #data4 <- rbindlist(mysheets)