I have data, that contains:
FOLDER1(Results) --> FOLDER2(Batch1, Batch2, ..., Batch10, Reservoir1, Reservoir2, Reservoir3) --> FOLDER3(ID4985-1, ID4985-2, ID4985-3, ect.) --> RAW(ID4985-1, ID4985-2, ID4985-3, ect.)
I need to have a result or table that would give a count of raw files in each FOLDER3, something like this:
FOLDER2 FOLDER3 no. of .raw files
BATCH1 ID4985-1 4
BATCH1 ID4985-1 0
BATCH1 ID4985-1 2
BATCH1 ID4985-1 4
BATCH1 ID4985-1 4
.... .... ....
Is there any script or workflow that would help me accomplish this? Kinda amateur on R so any input, advise or answer would help. Thanks a lot!