CODEWITHSUNDEEP
rimport-from-excel
Kristopher
Kristopher

Reputation: 1

Trying to combine multiple imported excel files in R into one long file

I am using RStudio to practice data cleaning and visualization in R. I downloaded and imported several excel files into R Studio. But now, I want to combine the 5 separate files into one long file so I can conduct analysis on the different places. Each excel file is a different location regarding home sales. I want to combine all of the files into one so I can develop insights into which location does better as far as sales during different times of the year, which location has the best month out of each year, etc. Is there a way to combine the separate imported files into one massive file?

I haven't tried it yet, but I was wondering if I need to possibly combine the files while in excel into one large file. Then import the one file into R. Am I on the right track? Can I combine the files once they're individually imported into R?

Upvotes: 0

Views: 62

Answers (1)

C. Sebastian
C. Sebastian

Reputation: 157

Do they have the same column names?

Then you can import them into R individually and merge them using the function bind_rows()

Upvotes: 0

Related Questions