Using two csv files in pandas, how to check if the value of csv1 is in csv2 and, if it's present, get value of csv2's row?

Asked Oct 02 '21 at 00:05

Active Oct 02 '21 at 00:20

Viewed 21 times

Suppose I have two .csv files

First one is:

ID,NAME
1,A
2,B
3,C

The second one is

NAME,COMMENTS
A,foo
B,bar
C,foobar

If I want to match the NAME column of both files and then get the ID of A, B and C on a third file

ID,NAME,COMMENTS
1,A,foo
2,B,bar
3,C,foobar

How should I approach it?

edited Oct 02 '21 at 00:20

asked Oct 02 '21 at 00:05

Masamune

In the shown case `df1.merge(df2)` works, but with some of the default arguments specified its `df1.merge(df2, on='NAME', how='inner')` – Henry Ecker Oct 02 '21 at 00:33
Hey mate, you should throw that as an answer, it really helped me! Thanks – Masamune Oct 02 '21 at 01:13

0 Answers0