Is there a function to compare two DataFrames and output the different elements?

user_14403635 0
Viewed 37

I am trying to compare two different DataFrames to check the new_df symbol does it exists in old_df, if it doesnt exist in the old_df, I want to output to a list.

Code looks like this:

old_df = pd.DataFrame({'symbol': ['A', 'B', 'C', 'D', 'E']})
new_df = pd.DataFrame({'symbol': ['C', 'A', 'B', 'F', 'H']})

I want the output like this:

['F','H']
pandas dataframe python
2 Answers

isin() as a mask

old_df = pd.DataFrame({'symbol': ['A', 'B', 'C', 'D', 'E']})
new_df = pd.DataFrame({'symbol': ['C', 'A', 'B', 'F', 'H']})

new_df[~np.isin(new_df.values,old_df.values)].values

output

array([['F'],
       ['H']], dtype=object)
user_94414040

What about

>>> set(new_df.symbol.unique()) - set(old_df.symbol.unique())
{'F', 'H'}

Using the python built-in set.

user_41940790
Related