header.py

# ----- get header row ----- #

# list to contain all headers
headers = []

# iterate over all rows
for row in rows:
    if last column empty:
        headers.append(rows)
    else:
        break

# ----- remove headers ----- #

valid_transactions = []  # list to contain valid transactions

# iterate over all rows
for row in rows:
    if row not in headers:
        valid_transactions.append(row)