df['new_column'] = np.where(df['col2']<9, 'value1', np.where(df['col2']<12, 'value2', np.where(df['col2']<15, 'value3', 'value4')))