(df .loc[lambda df: df.unique_apt.isin(l_unique_apt_gn)] .groupby(['unique_apt']) .apply(lambda gdf: gdf.assign(min_trade_date=lambda df: df.trade_date.min())) .sort_values('min_trade_date') )