I have large number of csv files (100+) in a directory with same structure and column names. The data is in time series and there are approx 30 columns/file. However i only want to aggregate particular number of columns together while dont care about others.
For example each csv file has particular columns (same column name in each file) say Col A, Col B and Col C. I want to select these columns from each file and add together i.e Col A from file 1,file2.... and Col B from file 1,file2.....
I need help in R coding for this.
csv files look like :
Timestamp , Col A , ColB , ColC ................................
2021/09/02 00:00, 1234 , 1234 , 1234
I found that merge funciton would work best since there could be mismatch in number of rows. Note that Columnn names and column numbers in each file are similar.