Transformation

import pandas as pd
import numpy as np

databankcrap = pd.read_csv('/Users/annacrotty/Downloads/contribrpt.csv')

opps = pd.DataFrame(columns=['Member ID','Campaign Name', 'Segment Code', 'Type', 
                             'Method', 'Date', 'Amount'])


for x in range(0, 2270):
    for i in range (1,50):
        colnum = 14+(6*i)
        rownum = x
        if pd.notnull(databankcrap.iloc[rownum,colnum+4]): 
            tempdf = pd.DataFrame([[
            databankcrap.iloc[rownum,0],
            databankcrap.iloc[rownum,colnum],
            databankcrap.iloc[rownum,colnum+1],
            databankcrap.iloc[rownum,colnum+2],
            databankcrap.iloc[rownum,colnum+3],
            databankcrap.iloc[rownum,colnum+4],
            databankcrap.iloc[rownum,colnum+5]
            ]],    
                
            columns = ['Member ID','Campaign Name', 'Segment Code', 'Type', 
                             'Method', 'Date', 'Amount'])
            opps=opps.append(tempdf)
opps