I have one main data frame which has columns as:
df_main =
col1 col2 col3
--------------------
32132 horse desc1
43531 rabbit desc2
12334 pig desc3
Then I have a few other data frames which has columns like:
df_1 =
col2 values1 values2
-------------------------
horse 100 2000
rabbit 200 3000
pig 300 4000
df_2 =
col2 values3 values4
-------------------------
horse 200 3000
rabbit 300 4000
pig 400 5000
df_3 =
col2 values5 values6
-------------------------
horse 300 4000
rabbit 400 5000
pig 500 6000
The last data frames, i.e. df_1, df_2, and df_3 I have in a ordinary list, while the df_main is just a data frame by itself.
Now what I wish to do is just adding the value columns to the df_main with respect to col2 so that the resulting data frame looks something like:
df_final =
col1 col2 col3 values1 values2 values3 values4 values5 values6
--------------------------------------------------------------------------------------
32132 horse desc1 100 2000 200 3000 300 4000
43531 rabbit desc2 200 3000 300 4000 400 5000
12334 pig desc3 300 4000 400 5000 500 6000
