df
bins = [-np.inf, 59863.0, 86855.0, 125250.0, 332801]
labels = ['low', 'low_mid', 'high_mid', 'high']
df['category'] = pd.cut(df.val, bins=bins, labels=labels)
df
Trying to convert pandas df series of floats to one of four categorical values based on there respective locations in the series quartiles