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