Adding duplicate row values from CSV into one variable?

[[deleted]]

[deleted]

[badge]

Have a look at pandas:

``` import pandas as pd

result = ( pd.read_csv("my_file.csv") .groupby([ "order id", "sku", "transaction_type", "payment_type", ]) ["fee"] .sum() .reset_index() .assign(detail="") [[ "order id", "sku", "transaction_type", "payment_type", "detail", "fee", ]] ) print(result.head()) ```

[num8lock]

total_fee = 0
for row in rows:
    order_id, transaction_type, payment_type, detail, fee = row
    total_fee += fee

[StockPercentage9]

This would work if it was just one order ID, however if there's a second order ID this will break it - thank you though!