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
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)
Thank you for your help. I'll try it
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.