I have two kind of files (CSV & Excel). I have 100 csv files (file names start with "Colours") in the path (C:/My data"). These files are not having header, but all data are in same format and same order. So I need to read all these files and add 8-10 headers (i.e column names) and append all of them into 1 single data.
Then I have a excel file (monitered.xlsx) in another path (C:/My data1). I have to read the file and it has only one column, which needs to be vlookup (inner Join) with a column of the above single data (i.e appended csv data)
Then I have another excel file (Assignment.xlsx) in other path (C:/ My data2). I need to put vlookup (inner Join) with the above derived output to this excel file.
Can anyone kindly give me the R coding for the above requirement.