For suppose if these are my dataframes, then how to make them as below. Is it possible?
#Dataframe1
col1 col2 col3
CA 19 0.34
TX 22 0.35
FL 11 0.24
OR 34 0.42
GA 52 0.62
MN 12 0.17
NC 19 0.34
#dataframe2
col1 col2 col4
FL 22 0.35
MN 22 0.35
CA 11 0.24
TX 52 0.62
#final dataframe
col1 col2 col3 col4
CA 30 0.34 0.24
TX 64 0.35 0.62
FL 33 0.24 0.35
OR 34 0.42 0.42
GA 52 0.62
MN 34 0.17
NC 19 0.34