how to get only match column values in pandas between two same csv file

Question

I have two CSV file both have more than 50000 rows and now I want to find only matches records between two CSV files. I have tried so many pandas function like and all records return response is only true and false.

How do I get only matches column values between two CSVs?

 df2 = id externalcode
       1   00
       2   00




 df2 = id externalcode
        1   00
        2   00

Any help would be appreciated. The code which I have tried is given below:

data_frame1 = pd.read_csv("one.csv")
data_frame2 = pd.read_csv("two.csv")
print(type(data_frame1),type(data_frame2))
result = data_frame1[data_frame1['id'] == data_frame2['id']]
df1 = data_frame1['id'].isin(data_frame2['id'])
df2 = data_frame1['values_externalCode'].isin(data_frame2['values_externalCode'])

You want matching rows or matching columns? Can you also add your desired output df? : — Roelant
– Roelant, Commented Mar 12, 2020 at 10:42
only want to match only column values between two data frames. — Faraz Khan Yz
– Faraz Khan Yz, Commented Mar 12, 2020 at 10:59

tianlinhe · Accepted Answer · 2020-03-12 10:35:58Z

1

df1 = data_frame1[data_frame1['id'].isin(list(data_frame2['id']))]

I modified one of your attempts, please let me know if it works! So this code will select ids in data_frame1 which also appear in data_frame2.

answered Mar 12, 2020 at 10:35

tianlinhe

9891 gold badge6 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to get only match column values in pandas between two same csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related