I have many files in a folder. Below is the sample one.

abc.csv

Another table as –
bcd.csv

I have the same type csv files in my folder and I would like to merge all of them and keep the seller if its value = 0.

My expected output would be –

Final table –

>Solution :

concat and filter (for example with query), optionally dropping duplicates (drop_duplicates):

out = (pd.concat([abc, bcd]).query('Vaule == 0')
         .drop_duplicates(['Seller', 'Vaule']) # optional
      )

Output:

  Seller  Vaule
2    Cat      0
4   John      0
0   Hari      0