Skip to main content
 首页 » 编程设计

python之不遍历整个字典

2025年05月04日9bonelee

所以基本上,我有一个 api,从中我有几个字典/数组。 ( http://dev.c0l.in:5984/income_statements/_all_docs ) 从 api 获取每家公司的财务信息时(例如 sector = technology 和 statement = income)python 应该返回 614 家科技公司,但是我得到这个错误:

Traceback (most recent call last): 
  File "C:\Users\samuel\Desktop\Python Project\Mastercopy.py", line 83, in <module> 
    user_input1() 
  File "C:\Users\samuel\Desktop\Python Project\Mastercopy.py", line 75, in user_input1 
    income_statement_fn() 
  File "C:\Users\samuel\Desktop\Python Project\Mastercopy.py", line 51, in income_statement_fn 
    if is_response ['sector'] == user_input3: 
KeyError: 'sector' 

随机选择一家公司(通常是第 550-600 家公司之一)

这是损益表的函数

def income_statement_fn(): 
    user_input3 = raw_input("Which sector would you like to iterate through in Income Statement?: ") 
    print 'Starting...' 
    for item in income_response['rows']: 
        is_url = "http://dev.c0l.in:5984/income_statements/" + item['id'] 
        is_request = urllib2.urlopen(is_url).read() 
        is_response = json.loads(is_request) 
        if is_response ['sector'] == user_input3: 
            csv.writerow([ 
             is_response['company']['name'], 
             is_response['company']['sales'], 
             is_response['company']['opening_stock'], 
             is_response['company']['purchases'], 
             is_response['company']['closing_stock'], 
             is_response['company']['expenses'], 
             is_response['company']['interest_payable'], 
             is_response['company']['interest_receivable']]) 
            print 'loading...' 
    print 'done!' 
    print end - start 

知道是什么导致了这个错误吗? (我不相信是api本身)

干杯

请您参考如下方法:

好吧,在使用随机数测试您在 urlopen 调用中传递的 url 时,我得到了这个:

{"error":"not_found","reason":"missing"} 

在这种情况下,您的函数将准确返回您收到的错误。如果您希望您的程序很好地处理错误并添加“缺失”行而不是实际数据,您可以这样做:

def income_statement_fn(): 
    user_input3 = raw_input("Which sector would you like to iterate through in Income Statement?: ") 
    print 'Starting...' 
    for item in income_response['rows']: 
        is_url = "http://dev.c0l.in:5984/income_statements/" + item['id'] 
        is_request = urllib2.urlopen(is_url).read() 
        is_response = json.loads(is_request) 
        if is_response.get('sector', False) == user_input3: 
            csv.writerow([ 
             is_response['company']['name'], 
             is_response['company']['sales'], 
             is_response['company']['opening_stock'], 
             is_response['company']['purchases'], 
             is_response['company']['closing_stock'], 
             is_response['company']['expenses'], 
             is_response['company']['interest_payable'], 
             is_response['company']['interest_receivable']]) 
            print 'loading...' 
        else: 
            csv.writerow(['missing data']) 
    print 'done!' 
    print end - start