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

preview_player
Показать описание
This video shows you how to read in multiple excel files in R, and then combine the data. The packages readxl and tidyr are used. If you find this video helpful please subscribe to my channel.
Рекомендации по теме
Комментарии
Автор

Thanks Mate.. Its 2021 and still helpful !

Dilgazab
Автор

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!

ericksousa
Автор

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

elainelu
Автор

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.

oluwaseyidada
Автор

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

mariviana.
Автор

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

vaibhavborgaonkar
Автор

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?

grzegorzpochwatko
Автор

great,but how i can combine diffrent columns numbers

cgeyrvu
Автор

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

fauzanraeva
Автор

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

agent
Автор

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?

biancacosta
Автор

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

takla
welcome to shbcf.ru