I have a dataframe1:
JavaScript
x
5
1
id val
2
a1 0
3
a1 5
4
a2 3
5
and dataframe2:
JavaScript
1
6
1
id type1 type2
2
a1 main k
3
a2 secondary b
4
a3 old k
5
a4 deleted n
6
i want to join type column to dataframe1 by id to get:
JavaScript
1
5
1
id val type1 type2
2
a1 0 main k
3
a1 5 main k
4
a2 3 secondary b
5
How could I do that? as you see output table is same shape as dataframe1? but when i use pd.merge output is larger
Advertisement
Answer
Try this:
JavaScript
1
2
1
out = pd.merge(dataframe1, dataframe2, how='inner', on=['id'])
2
Output:
JavaScript
1
5
1
id val type1 type2
2
a1 0 main k
3
a1 5 main k
4
a2 3 secondary b
5