I am trying to automate a process in Rstudio that I have to manually complete in excel. Currently, I have two excels docs loaded into Rstudio as two different data frames DF1 and DF2. I need to copy information from these excel docs/data frames into specific columns in the new data frame DF3.
Ex: df1$'group ID' is equal to the df3$'ID' column and df2$'Item ID' is also equal to the df3$'ID' column. Furthermore, I need to copy the information across multiple columns into specific columns in DF3. So DF1 has multiple columns, but I need the corresponding information from DF1$'group ID', DF1$'date', DF1$'item number' .. copied into the DF3$ID, DF3$'date', and DF3$'item' columns.