python two csv files pandas compare

Question

I am trying to compare two csv file. I want to compare similarity user_name if the user_name have same name as table1 and table2 create table3 print

for example

table1.csv
id_Acco,     user_name,       post_time
1543603,     SameDavie ,      "2020/09/06"
1543595,     Johntim,         "2020/09/11"
1558245,     ACAtesdfgsf ,    "2020/09/19"

table2.csv
id_Acco,     user_name,     post_time
1543603,    SameDavie,      "2020/09/06"
1543595,    Johntim ,       "2020/09/11"
1558245,    Davidwillian,   "2020/09/19"

OutPut

table3.csv

id_Acco,     user_name,     post_time
1543603,     SameDavie ,    "2020/09/06"
1543595,     Johntim ,      "2020/09/11"

code

`A = pd.read_csv(r'table1.csv')
 B= pd.read_csv(r'table2.csv')
 print(A-B) 
 print(B-A)

Does it answer your question? stackoverflow.com/questions/19618912/… — Arkadiusz
– Arkadiusz, Commented May 28, 2021 at 18:50
Do the rows matter or do you just want a list of the user names that appear in both files? — RJ Adriaansen
– RJ Adriaansen, Commented May 28, 2021 at 18:54

perl · Accepted Answer · 2021-05-28 18:55:53Z

1

You can concat A and B and check for duplicated records:

z = pd.concat([A, B])[['user_name']]
z.loc[z.duplicated()].to_csv('table3.csv')

Output (in table3.csv):

   user_name
0  SameDavie
1    Johntim

P.S. And if you have those trailing spaces sometimes in your files like you have in the example, you may want to strip them after concatenation:

z = pd.concat([A, B])['user_name'].str.strip()
z.loc[z.duplicated()].to_frame().to_csv('table3.csv')

answered May 28, 2021 at 18:55

perl

9,9811 gold badge14 silver badges23 bronze badges

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

2 Comments

john div Over a year ago

thank you and another question how can I pass id_Acco and post_time after it check for duplicated

perl Over a year ago

If you don't specify the column for z then it will use all of them, so z = pd.concat([A, B]) as the first line, and then the same z.loc[z.duplicated()] (I'm assuming you stripped those spaces already -- if not, you can do it after concatenation)

Collectives™ on Stack Overflow

python two csv files pandas compare

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related