Breaking News: Grepper is joining You.com. Read the official announcement!

remove common rows in two dataframes pandas

Add Answer

Ultimate Gohan answered on March 23, 2022 Popularity 6/10 Helpfulness 3/10

Contents

answer remove common rows in two dataframes pandas

More Related Answers

Remove duplicates with pandas

python: remove duplicate in a specific column

drop multiple columns pandas

pandas remove repeated index

drop duplicates pandas first column

remove duplicate in df ignore one column

remove duplicate row in df

Python - Drop row if two columns are NaN

remove duplicates based on two columns in dataframe

delete the entire row while remove duplicates with python'

drop first two rows pandas

dataframe delete duplicate rows with same column value

remove duplicate values in data frame r

remove duplicates in dataframe by index python

remove all odd row pandas

dataframe delete duplicate rows with same column value

pandas drop duplicates from column

remove duplicate columns python dataframe

pandas merge two dataframes remove duplicates

pandas drop duplicates but keep most recent date

how to remove last 2 rows in a dataframe

pandas remove repeated index

remove row if all are the same value pandas

how to drop duplicate columns in pandas that dont have the same name?

df index drop duplicates

remove duplicates index pandas

removing rows dataframe not in another dataframe using two columns

pandas remove duplicate rows least nan

remove df rows if two column values are not matching

drop duplicates data frame pandas python

remove common rows in two dataframes pandas

Comment

0

In [1]: import pandas as pd
df_1 = pd.DataFrame({"A":["foo", "foo", "foo", "bar"], "B":[0,1,1,1], "C":["A","A","B","A"]})
df_2 = pd.DataFrame({"A":["foo", "bar", "foo", "bar"], "B":[1,0,1,0], "C":["A","B","A","B"]})

In [2]: df = pd.concat([df_1, df_2])

In [3]: df
Out[3]: 
     A  B  C
0  foo  0  A
1  foo  1  A
2  foo  1  B
3  bar  1  A
0  foo  1  A
1  bar  0  B
2  foo  1  A
3  bar  0  B

In [4]: df.drop_duplicates(keep=False)
Out[4]: 
     A  B  C
0  foo  0  A
2  foo  1  B
3  bar  1  A

Popularity 6/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: pandas python

Share

Link to this answer
Share Copy Link

Ultimate Gohan

Contributed on Mar 23 2022

Ultimate Gohan

0 Answers Avg Quality 2/10

X

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

X

Grepper Account Login Required

Oops, You will need to install Grepper and log-in to perform this action.

Install Grepper Here