/Python/Python pandas difference between two data frames

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 vote131 views1 answer
You are trying to add a non-nullable field without a default
Python
0 vote127 views1 answer
Df groupby loop
Python
1 vote113 views2 answers
Python map list of int to string
Python
0 vote134 views1 answer
How to make a nice login django form
Python
0 vote183 views1 answer
Substring in a django template?
Python Django
0 vote126 views1 answer
Python create sqlite db in memory
Python
2 votes137 views2 answers
Pandas series to dataframe index as column
Python
10 votes121 views1 answer
Print first dictionary keys python
Python
15 votes132 views4 answers
Float to int in python
Python
6 votes124 views2 answers
Python has duplicates
Python