Writing to a CSV file in Python using a 'for' loop

Question

I'm currently trying to write to a CSV file in python, however I only want to print 'CurrentInv' every 60 iterations. For example

outfile = open("Pension.csv", 'w')
for k in range(1,Iterations+1):
    outfile.write(str( str(k) + ','))
    outfile.write(str(CurrentInv[k][0])+',')
    outfile.write(str(CurrentInv[k][60])+',')
    outfile.write(str(CurrentInv[k][120])+',')
    outfile.write(str(CurrentInv[k][180])+',')
    outfile.write(str(CurrentInv[k][240])+',')
    outfile.write(str(CurrentInv[k][300])+',')
    outfile.write(str(CurrentInv[k][360])+',')
    outfile.write(str('\n'))
outfile.close()

But I would like to obtain this in a loop. I have tried

 outfile = open("Pension5.csv", 'w')
 for k in range(1,Iterations+1):
     outfile.write(str( str(k) + ','))
     for i in range(0,Months+1):
        outfile.write(str(CurrentInv[k][i])+',')
        i=i+60
     outfile.write(str('\n'))
 outfile.close()`

However, this still prints all values for CurrentInv from 0 to Months instead of every 60 iterations. Any help would be appreciated!

I think the range he wants to modify is the other one @kabanus — Adirio
– Adirio, Commented Oct 3, 2017 at 15:14
@kabanus * looks suspiciously to the new pen icon in the comment * - Guess I was wrong :P — Adirio
– Adirio, Commented Oct 4, 2017 at 10:44

Adirio · Accepted Answer · 2017-10-03 15:10:46Z

1

Try the following:

with open("Pension5.csv", 'w') as outfile:
    for k in range(1, Iterations+1):
        outfile.write(str(str(k) + ','))
        for i in range(0, Months+1, 60):
            outfile.write(str(CurrentInv[k][i]) + ',')
        outfile.write(str('\n'))

It specifies a step of 60 for the range so that each iteration it adds 60 instead of 1. Months should be 360 in the example case. If you want Months to be 6 instead of 360 check the following:

with open("Pension5.csv", 'w') as outfile:
    for k in range(1, Iterations+1):
        outfile.write(str(str(k) + ','))
        for i in range(0, Months+1):
            outfile.write(str(CurrentInv[k][i*60]) + ',')
        outfile.write(str('\n'))

answered Oct 3, 2017 at 15:10

Adirio

5,3061 gold badge17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing to a CSV file in Python using a 'for' loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related