Im trying to create a data frame using 6 other excel worksheets. The problem is that Im trying to match different values from different sheets to one ID and if no value or ID was present in one of the sheets the value for that sheet should be NA/NULL/0 doesnt matter. I dont know how to do that.
I have tried numerous functions and options but I have been always getting stuck on an error that said that length of data frames is different.
My data looks like this:
Excel_sheet_1 > ID1 value1 > ID3 value3 > ID4 value4
Excel_sheet_2 > ID1 value1(might be different that the one in Excel_sheet_1) > ID2 value2(might be different that the one in Excel_sheet_1) > ID70 value70 > ID1902 value1902
I want it to look like this:
Final_table > ID1 value_excel1 value_excel2 > ID3 NA value_excel2 > ID3 value_excel1 NA > ID4 value_excel1 NA > ID70 NA value_excel2 > ID1902 NA value_excel2