merge_cols = ['risk_factor'
pd.merge(sensis, self.risk_weights.loc[self.risk_weights['risk_type'] == self.risk_type, merge_cols + ['risk_weight']], on=merge_cols, how='left')