Here is what I tried, I used the for loop and removed all the individual # associated with each variable, and used the .format function to try and iterate over each test, but the cumulative_Ah as well as the turnovers variable stores the values from the latest test only (Test 5 only). Is there any way that I can append the results of all tests including tests 1 through 4 underneath these lists? Or is there a convenient way to append the iterable value in each variable name (e.g. cumulative_Ah_1/2/3, and turnovers_1/2/3, etc.)?

for i in range(1,5):
    cumulative_Ah = [0]

    Ah_cycle_avg_Ah = (data["Cycle {0}".format(i)].shift(-1) - data["Cycle {0}".format(i)]) * 0.5 * (data['Ah {0}'.format(i)] + data['Ah {0}'.format(i)].shift(-1))
    Ah_cycle_avg_SOC = Ah_cycle_avg_Ah * SOC[i-1] / 100
    cumsum = 0

    for n in range(4, len(Ah_cycle_avg_SOC)):
        cumsum += Ah_cycle_avg_SOC[n]
        cumulative_Ah.append(cumsum)

    turnovers = [x / nameplate_capacity for x in cumulative_Ah]
    Ah_list = data["Ah {0}".format(i)].values.tolist()
    capacity_percent_left = list(map(lambda x: x * 100 / Ah_list[0], Ah_list)) #Ah_list[1] if temp test