I want to df1 ∩ df2' in a pandas dataframe
df1 has headers (given below) with 100 rows
{a , b, c , d,x,y,v }
df2 has headers (given below) with 100 rows
{a, b, e, f,p,o,i}
the output of the join (just using the header names )
{c , d,x,y,v }
Asked
Active
Viewed 581 times
0
Chris D'mello
- 145
- 2
- 9
-
3`df1.intersection(df2)`? – CristiFati Mar 26 '18 at 12:27
-
2It would probably be helpful if you told us what type `df1` and `df2` are. (I've got a guess, but it's one from a third-party library not among your tags) – Kevin Mar 26 '18 at 12:30
-
Can you tell what exactly you mean by `df2'` ? – Ankit Seth Mar 26 '18 at 12:38
-
@jezrael, this is not intersection, but difference! - reopening. – jpp Mar 26 '18 at 13:02
2 Answers
2
x1 =set(['a' , 'b', 'c' , 'd','x','y','v'])
x2 = set(['a', 'b', 'e', 'f','p','o','i'])
print(x1.difference(x2))
result would be: set(['y', 'x', 'c', 'd', 'v'])
godot
- 3,422
- 6
- 25
- 42
1
Wouldn't a left join mean:
- All elements from
A(left) - plus all elements from
B(right) that are inA
Like so, meaning in essence, the result is A?
If you want all elements of A that are not in B: c = a - b
If you want all elements that are in Aand B (intersection): c = a & b
timmwagener
- 2,368
- 2
- 19
- 27
-
{a , b, c , d,x,y,v } are the headers of df1. they a has some 100 rows. can i use x1.difference(x2) – Chris D'mello Mar 26 '18 at 13:54