df = df[df["amount"] > 100] df = df.groupby("segment").agg({"amount": "mean"}) df = df.sort_values("amount")