output=df.merge(flattened,how='left',left_on='account_id',right_on='account_id')