Salary Market

fix : OLD CODE

if column_associe_condition == []:

result ["number_organisation"]=pd.merge(result, compensations_extraction.groupby(condition)['companyId'].nunique().reset_index(), on=condition, how="left")['companyId']
result ["number_employee_panel"]=pd.merge(result, compensations_extraction.groupby(condition)['base_salary'].count().reset_index(), on=condition, how="left")['base_salary']
result["number_employee_company"] = (
pd.merge(
result,
compensations_extraction[compensations_extraction["companyId"] == companyId]
.groupby(condition)['base_salary']
.count()
.reset_index(),
on=condition,
how="left"
)['base_salary']
.fillna(0)
.astype(int)
)

result = result[result["number_employee_panel"] > result["number_employee_company"]]
                result = result[result["number_employee_panel"] != 1]
                #result = result.drop(["number_organisation","number_employee_panel","number_employee_company"], axis=1)
            else:
                pass

NEW
result["number_organisation"] = pd.merge(
result,
compensations_extraction.groupby(condition1)['companyId'].nunique().reset_index(),
on=condition1,
how="left"
)['companyId']

result["number_employee_panel"] = pd.merge(
result,
compensations_extraction.groupby(condition1)['base_salary'].count().reset_index(),
on=condition1,
how="left"
)['base_salary']

result["number_employee_company"] = (
pd.merge(
result,
compensations_extraction[compensations_extraction["companyId"] == companyId]
.groupby(condition1)['base_salary']
.count()
.reset_index(),
on=condition1,
how="left"
)['base_salary']
.fillna(0)
.astype(int)
)

result = result[result["number_employee_panel"] > result["number_employee_company"]]
result = result[result["number_employee_panel"] != 1]
#result = result.drop(["number_organisation","number_employee_panel","number_employee_company"], axis=1)