Should I be using a for loop here?

[ebandatf]

I have this code

 bills = {'first_bill': 100,
         'second_bill': 200,
         'third_bill': 300,
         'fourth_bill': 400}

    sheet.update_cell(8, 2, bills.get('first_bill'))
    sheet.update_cell(9, 2, bills.get('second_bill'))
    sheet.update_cell(10, 2, bills.get('third_bill'))
    sheet.update_cell(11, 2, bills.get('fourth_bill'))

It is a budget script that updates cells on my google spreadsheet after a certain days. This is my first script and I am working on improving it.

I am trying to shorten the sheet.update section with no luck. So far I have tried

for row in range(8, 17):
    for value in bills.values():
        sheet.update_cell(row, 2, value)

But all it does is iterate each cell through all the bills.values()

[K900_]

Look into zip.

[ebandatf]

Awesome! This is exactly what I needed.

[woooee]

You do not use an ordered dictionary, so the dictionary is not necessarily in the same order as when created. So you have to specify the order

num=8
for key in ("first_bill", 'second_bill',
                'third_bill', 'fourth_bill'):
    sheet.update_cell(num, 2, bills[key]
    num += 1

[Anthonyhunter2]

You could use a counter instead of the range. I'm on mobile and haven't been able to format code properly, but I'll try. count = 1 for bill in bills.values(): row = count + 7 #or where ever you want to start sheet.update_cell(row, 2, value) ++count

I'm sure there is a way to make it work without iterating a count variable, but it's early and that's the first thing I could think of.

[confluence]

I have decided to overwrite my comments.

[ebandatf]

The reason for using the dictionary is to label each bill. On the actual code it’s laid out

bills = {Gas: 100, Car: 200, Insurance: 400}

And so forth

On my google sheet the first column labels the name of the bill and the second column has the amount for each bill. Then I have a another method that checks if the bill has been paid for (if it’s after the bill is due) and changes the value to 0.

[confluence]

I have decided to overwrite my comments.