You would first have to pivot or aggregate the table to get more features per row to perform reduction on. GroupBy (concatenate or sum methods) or Pivot to manipulate your data in such a way. At some point, you may also want analyze the transaction data by category, segment, etc. without losing the micro data. In this case, Group Loop may prove useful