How I can combine data

General
1

Hai.. Im Wijaya and I m still new in working with R. I have a project to complish and I find a problem. Hope you all can help me. I have a lot of data seperately in different excel file. Each file show me the data in daily in each year. So I have a lot of seperate file. How can I combine all of it to extract my main goal from that data because if I combine it in excel, it would not enough. Thank you

2

Code like the following example reads all of the Excel files in a directory into a list and then combines that list into one data frame. The Excel files should have identical column structure.

library(purrr)
library(dplyr)
library(readxl)

ExcelFiles <- list.files(path = "R/Play", pattern = ".xlsx",
                         full.names = TRUE)

AllFiles <- map(ExcelFiles, .f = read_excel)
AllData <- bind_rows(AllFiles)
3

Thank you for your help. I'll try it

4

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.