Relative Content

Tag Archive for pythonpandasdataframegroup-by

dataframe filter groupby based on a subset

df_example = pd.DataFrame({‘name’: [‘a’, ‘a’, ‘a’, ‘b’, ‘b’, ‘b’], ‘class’: [1, 2, 2, 3, 2, 2], ‘price’: [2, 4, 3, 1, 6, 5]}) I want to filter each name where the price is larger than the smallest price in a subset class==2 within name grounp: df_example.sort_values([‘name’, ‘price’], inplace=True) df_tem = df_example[df_example[‘class’] == 2].groupby(‘name’).first() Below is […]