Among many subfolders, find CSVs starting with a given string and within ZIPs or not, and merge them while adding their names in a new column with R
In a folder (path = "D:/DataLogs/), I have several subfolders. Inside these subfolders, I would like to retrieve all the csv starting only with “QCLog” and merge them (rbind) into a single data.frame (all these csv have the same headers and structures), while creating a first new column including the full name of these QCLog csv.
The difficulty is that, in some subfolders, there may be csv (starting with QCLog or not) directly accessible and others located in several zip files (examples within the green rectangles below).
Is this feasible?
Thanks for help