Read and Write HUNDREDS of Excel Files using R programming
➡️ Get the code: https://felixanalytix.com
Newsletter: https://felixanalytix.substack.com
Twitter: / felixanalytix
Buy me a coffee: https://www.buymeacoffee.com/felixana...
00:00 - Intro
00:54 - Read and write a unique Excel file
01:47 - Write multiple Excel files from R
03:00 - Read and join multiple Excel files using R
In this video I show you how to read and write hundreds of Excel files using the R programming language. First we will create a very simple loop that writes multiple Excel files in a folder. Then we will read all these Excel files we just created back into R, using another loop. I will also show you how you can write additional R code to clean or validate each Excel file data. Finally we will see how easy it is to join all your Excel files data into a single and consolidated dataset with R.