Google表更新由于速率限制而导致的错误和Python代码

Question

我正在尝试使用Python玩Google表格，但这给了我错误。这可能是由于没有优化代码逻辑。

错误

gspread.exceptions.apierror：{'code'：429，'消息'：“配额指标'写入请求'超过配额，并限制'service'seervice'seervice'seervice'shees.googleapis.com' 。 。 >

shop_names = ['wilmermobel', 'masonheron', 'flashree', 'jochiwon', 'senangku', 'dutchgaming', 'hiranai', 'chairsy', 'genelotrics', 'bahemas', 'gameniture', 'martenkaiser', 'secretracer']
web_data_non_ful = ['0', '5.13', '0', '0', '0.00', '0.00', '0', '0', '6.25', '0.58', '0', '0', '0.00']
web_data_late_ship = ['0', '8.89', '0', '0', '8.33', '0.00', '0', '0', '0', '1.51', '0', '0', '0.00']
web_data_pre_time = ['0', '1.50', '2.02', '1.49', '2.17', '0.93', '2.04', '0.94', '1.30', '1.77', '', '', '1.07']
web_data_resp_rate = ['57.00', '96.01', '95.45', '100.00', '98.26', '98.32', '92.97', '91.05', '98.70', '97.44', '100.00', '57.00', '97.04']
web_data_shop_rate = ['0', '4.85', '5.00', '5.00', '4.70', '4.78', '4.89', '4.74', '4.88', '4.74', '5.00', '0', '4.71']
web_data_penal_points = ['0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0']

def sheet_updater('sheet1', col_num, col_data):

    for cn, cd in zip(col_num, col_data):
        try:
            r = 2
            x = 0
            for i in range(13):
                try:
                    time.sleep(1)
                    t = sheet.update_cell(r, cn, cd[x])
                    print(t)
                    r += 1
                except:
                    pass
                x += 1
        except:pass


col_data = [shop_names, web_data_non_ful, web_data_late_ship,web_data_pre_time, web_data_resp_rate, web_data_shop_rate, web_data_penal_points]
col_num = [1, 2, 3, 4, 5, 6, 7]
sheet_updater('sheet1', col_num, col_data)
   

Answer 1

在您的脚本中，下面的修改如何？

修改后的脚本：

shop_names = ['wilmermobel', 'masonheron', 'flashree', 'jochiwon', 'senangku', 'dutchgaming', 'hiranai', 'chairsy', 'genelotrics', 'bahemas', 'gameniture', 'martenkaiser', 'secretracer']
web_data_non_ful = ['0', '5.13', '0', '0', '0.00', '0.00', '0', '0', '6.25', '0.58', '0', '0', '0.00']
web_data_late_ship = ['0', '8.89', '0', '0', '8.33', '0.00', '0', '0', '0', '1.51', '0', '0', '0.00']
web_data_pre_time = ['0', '1.50', '2.02', '1.49', '2.17', '0.93', '2.04', '0.94', '1.30', '1.77', '', '', '1.07']
web_data_resp_rate = ['57.00', '96.01', '95.45', '100.00', '98.26', '98.32', '92.97', '91.05', '98.70', '97.44', '100.00', '57.00', '97.04']
web_data_shop_rate = ['0', '4.85', '5.00', '5.00', '4.70', '4.78', '4.89', '4.74', '4.88', '4.74', '5.00', '0', '4.71']
web_data_penal_points = ['0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0']

def sheet_updater(shop_names, col_num, col_data):
    values = []
    for cn, cd in zip(col_num, col_data):
        try:
            temp = []
            r = 2
            x = 0
            for i in range(13):
                try:
                    temp.append(cd[x])
                    r += 1
                except:
                    pass
                x += 1
            values.append(temp)
        except:
            pass
    return [list(x) for x in zip(*values)]

col_data = [shop_names, web_data_non_ful, web_data_late_ship,web_data_pre_time, web_data_resp_rate, web_data_shop_rate, web_data_penal_points]
col_num = [1, 2, 3, 4, 5, 6, 7]
res = sheet_updater('sheet1', col_num, col_data)
sheet.update('A1', res, value_input_option='USER_ENTERED')

• 在此修改中，将值放在列表中，并使用Sheet Sheet API将列表放在电子表格中。通过此流程，通过一个API调用将值放入电子表格中。这样，我认为您的问题可以被删除。

参考：