Microsoft Fabric, Data Engineering, Data Science, Python.
df[df['status'] == 'approved'] df = df.merge( df_client, left_on=["card_number"], right_on=["credit_card_number"] ) daily_transaction_count = df.groupby(df['city'])["transaction_id"] \ .agg("count") \ .reset_index(name='total') \ .sort_values("total") display(daily_transaction_count) print("--- %s