Intersection on two keys python panda

Asked Jan 17 '18 at 13:08

Active Jan 17 '18 at 13:18

Viewed 37 times

I have two csv file say one.csv and two.csv. Format of file is One.csv:

ID1 , att 1 , att 2
a1    b1      c1
a2    b2      c2
a3    b3      c3

for two.csv

ID2, att1, att2
E1    b6    c9
E2    b2    c2
E3    b1    c1
E4    b1    c3

I need create a new csv file three .csv where only the entries with same att1 and att2 value should be present

ID1 ,   ID2,   att1 ,  att2
a1       E3      b1      c1
a2       E2      b2      c2

How can i achieve this in python using panda? I've gone through Merge two DataFrames based on multiple keys in pandas. But in my case the length of both the data frames is different.

edited Jan 17 '18 at 13:18

asked Jan 17 '18 at 13:08

vishu

Did you try a merge? – cs95 Jan 17 '18 at 13:08
length is not equal error – vishu Jan 17 '18 at 13:09
I want to see your code, then. – cs95 Jan 17 '18 at 13:10
@jezrael as att1 and att2 are same for both of them – vishu Jan 17 '18 at 13:10
I need both att1 and att2 to be same not just att1 @jezrael – vishu Jan 17 '18 at 13:12
Sorry, `df = pd.merge(df1, df2, on=['att1', 'att2'])` – jezrael Jan 17 '18 at 13:12
@jezrael this gives a not in index error . KeyError: "['A' 'C'] not in index" – vishu Jan 17 '18 at 13:15
@user3767047 - then use `df = pd.merge(df1, df2, left_on=['a', 'b'], right_on=['c', 'd'])` - join for columns a, b in df1 with c,d columns in df2 – jezrael Jan 17 '18 at 13:23
@jezrael i still get the error len(right_on) must equal len(left_on) – vishu Jan 17 '18 at 13:27
so there is not same length of columns in `left_on` and `right_on` ? – jezrael Jan 17 '18 at 13:27

0 Answers0