Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

R script to import multiple files

Hi everyone

I have this R code below which is importing into Powerbi a data from a one single zip file. I am wondering if I have multiple files that I needed to import.  How can I do that?

 

#create temp file

temp <- tempfile ()

#download zip archive to temp file

urlzipArchive = “https://github.com/CriticalPathTraining/PBI365/tree/master/Student/Data

download.file (urlzipArchive ,temp)

#extract csv file out of zip

csvFile = unz(temp, “SalesByCustomer.csv”)

#load new data frame from data in CSV file

customers <-read.csv(csvFile)

#perform cleanup

unlink (temp)

remove (csvFile)

remove(temp)

remove(urlzipArchive)

2 Replies