Learning R: 17 Read in multiple excel files in R and combine Data

[@ericksousa5666]

Dude, great video! I watched others that were longer and way confusing. Yours is very clear and worked combining 77 files into one, with more than 80k obs. Thanks a lot!

[@climbingdoudou]

the easiest and clearest tutorial I've ever seen. Thanks!

[@oluwaseyidada3828]

Hey Dude, Great video !! it worked for me, your methodology was simple and on point but plz remember to always increase the volume next time cuz i had to put my volume to 100% before i could hear you.

[@Dilgazab]

Thanks Mate.. Its 2021 and still helpful !

[@AnalyticoHub]

You're welcome!

[@arefcr7]

It is 2024 and still helpful!

[@vaibhavborgaonkar7706]

Extra Ordinary, you deserve half of my pay from this week, lol!

[@AnalyticoHub]

Happy to help. Please consider subscribing.

[@GauriSharma-m7k]

Very Helpful

[@dinhoin]

Nice and clear! Thanks!

[@Xnko100]

Very helpful! Thanks a lot :)

[@mariviana.]

thanks a lot, used it for my uni's project

[@grzegorzpochwatko2596]

hi, very helpful, thanks! BUT for some reason I get a df with just filenames, unless I specify cell range. I see that you specified just the certain sheet,. any idea why?

[@imranahmad4840]

Very helpful

[@AnalyticoHub]

Glad you think so!

[@石矻]

great，but how i can combine diffrent columns numbers

[@fauzanraeva4806]

i've done it, but this will change my column names, how i change my column names back to the original?

[@biancacosta5374]

I did exactly how you said, but i got only a list of the names of the files. Also I need to merge those files skipping the first 7 rows, how can I do it?

[@AnalyticoHub]

can you post or send me a copy of the script? To skip first 7 rows, you can use the skip = 7 argument in line 15.

[@agent1759]

How do you get 4 different tbls with the same name as the file ?

[@takla195]

Hi! If u have a minute :D After running my files a list of xlsx files have been shown up properly but lapply runs with a "path does not exist" error. Specificly with one file but it is there :D. I try to find out why is that but you maybe faster than me :D Thx

[@livingwithtrend]

im getting expected < error

[@AnalyticoHub]

What is the exact error you are getting? Do all files have same number of columns and data types?

[@livingwithtrend]

resolved when i changed file extension from xlsb to xlsx

[@natalialago690]

@@AnalyticoHubI keep getting an error because I have a different number of columns. I then tried using bind_rows instead and I got the error 'Arguments 17 must have names' Any ideas?

[@AnalyticoHub]

@@natalialago690 What I do is only call the number or columns that I need from all files. see line 16 in the video.

[@livingwithtrend]

pls answers