import pandas as pd df1 = pd.read_csv('items.csv',sep=',') df2 = pd.read_csv('signup.csv',sep=',') df3 = pd.merge(left=df1,right=df2,how='right',on='item_id') a = df3.groupby(['item_name'])['employee_id'].count() print(a)