/Python/Find difference between two pandas dataframes

Find difference between two pandas dataframes

Python pandas difference between two data frames

diff_df = pd.merge(df1, df2, how='outer', indicator='Exist')

diff_df = diff_df.loc[diff_df['Exist'] != 'both']

Source: stackoverflow.com

Pandas difference between two dataframes

source_df.merge(target_df,how='left',indicator=True).loc[lambda x:x['_merged']!='both']

Find difference between two pandas dataframes

# by doing outer, you will get records from both the sides.
f = df1.merge(df2,indicator = True, how='outer').loc[lambda x : x['_merge']!='both']
Out[421]: 
   A  B     _merge
1  2  3  left_only
2  3  4  left_only
3  3  4  left_only

left_unique_result = f.loc[lambda x: x['_merge'] == 'left_only']
right_unique_result = f.loc[lambda x: x['_merge'] == 'right_only']

Source: stackoverflow.com

Similar codes

0 vote146 views2 answers
How to get value from txtbox in flask
Python Flask
12 votes122 views6 answers
How to import matplotlib in python
Python
-2 votes116 views1 answer
Ceil in python3
Python
16 votes118 views1 answer
Python reload function from file
Python
8 votes110 views1 answer
Pygame draw rect syntax
Python
0 vote118 views2 answers
Remove unicode from string python
Python
0 vote272 views1 answer
Change form type flask from text to selection flask admin
Python
0 vote129 views1 answer
How to create a python script to automate software installation?
Python
0 vote105 views1 answer
Gensim wordvector vocabulary list
Python
13 votes74 views2 answers
Pd.set_option('display.max_columns' none)
Python