Coinbase Export: Parse and Process "Convert" Transactions

process_coinbase_export.py

import csv

csv_path = "/path/to/Coinbase-xxxxx-TransactionsHistoryReport-2021-03-13-22-28-28.csv"
outcsv_path = csv_path + ".processed.csv"

with open(csv_path, "r") as fi, open(outcsv_path, "w") as fo:
    r = csv.reader(fi)
    w = csv.writer(fo)
    for i, row in enumerate(r):
        if row and row[-1].startswith("Converted"):
            note = row[-1]
            to_coin = note.split(" ")[-1]
            to_coin_qty = note.split(" ")[-2]
            row += [to_coin, to_coin_qty]
        w.writerow(row)