Hi! so I have three excel doc loaded into R studio as data frames. The first df doc has 8932 obs. with 14 variables. The second has 1142 obs with 16 variables. The third df has 0 obs. and 19 variables. I need to copy and paste information from the first and second df's to populate certain columns in the third df. I am running into issues trying to use join and even paste because the third excel doc is empty. To summarize, I need to copy specific columns from df1 and df2 into df3 to populate it. I know the columns I need to copy from each doc and where they need to be pasted into the third df, but I am unable to get the copy and paste to be successful.
Ex: df3$id <- paste(df2$"Item_ID")
output: Error: Assigned data paste(df2$\"Item_ID"`)` must be compatible with existing data.
x Existing data has 0 rows.
x Assigned data has 8932 rows.
i Only vectors of size 1 are recycled.