I have two different Pandas data-frames that have one column in common. Example:
dataframe 1
ID col1 col2 ...
1 - -
2 - -
3 - -
4 - -
dataframe 2
ID col3 col4 ...
3 - -
4 - -
7 - -
What I want to achieve is a dataframe with columns from both dataframes but without the ID's found in dataframe2. i.e:
desired result:
ID col1 col2 col3 col4
1 - - - -
2 - - - -
Thanks!