python create JSON string抛出异常

Question

这就是我犯的错误

ERROR:scrapy.core.scraper:Error processing {'action': u'Rent',
 'ad_images': [bla bla bla],
 'ad_link': u'does_not_exit_in_this_website',
 'ad_title': u'boa bra bra',
 'agent_fees': 2300.0,
 'amenities': u'boa bra bra',
 'area': u'does_not_exit_in_this_website',
 'bathrooms': 1.0,
 'bedrooms': u'1',
 'building': u'',
 'category': u'Apartment',
 'city': -1,
 'commission': u'does_not_exit_in_this_website',
 'coordinates': u'does_not_exit_in_this_website',
 'country': u'',
 'ded_licence_number': u'718652',
 'description': u'Description:',
 'furnished': u'No',
 'latitude': -1,
 'link': u'bla bla bla',
 'location': u'',
 'longitude': -1,
 'mobile': u'does_not_exit_in_this_website',
 'payment_type': u'does_not_exit_in_this_website',
 'phone': u'',
 'phoneticarea': u'does_not_exit_in_this_website',
 'phoneticbuilding': u'does_not_exit_in_this_website',
 'phoneticsubarea': u'does_not_exit_in_this_website',
 'posting_date': u'2016-01-04',
 'price': u'does_not_exit_in_this_website',
 'price_sqft': u'does_not_exit_in_this_website',
 'property_reference': u'Ramzi',
 'rent_is_paid': u'Quarterly',
 'rera_registration_number': u'15691',
 'security_deposit': u'does_not_exit_in_this_website',
 'size': 1000.0,
 'source': u'dubizzleproperty',
 'subarea': u'does_not_exit_in_this_website',
 'trade_name': u'BLUE HOME PROPERTIES',
 'type': u'does_not_exit_in_this_website',
 'yearly_cost': 43000.0}
Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/twisted/internet/defer.py", line 588, in _runCallbacks
    current.result = callback(current.result, *args, **kw)
  File "bra bra bla/pipelines.py", line 70, in process_item
    body = '{"building": "{0}", "area" : "{1}", "subarea" : "{2}", "country" : "{3}", "city" : "{4}", "payment_type" : "{5}", "category" : "{6}", "phoneticbuilding" : "{7}", "phoneticarea" : "{8}", "phoneticssubarea": "{9}" }'.format(building, area, subarea, country, city, payment_type, category, phoneticbuilding, phoneticarea, phoneticssubarea)
KeyError: '"building"'

如果你想知道pipelines文件的第70行，这里是：

body = '{"building": "{0}", "area" : "{1}", "subarea" : "{2}", "country" : "{3}", "city" : "{4}", "payment_type" : "{5}", "category" : "{6}", "phoneticbuilding" : "{7}", "phoneticarea" : "{8}", "phoneticssubarea": "{9}" }'.format(building, area, subarea, country, city, payment_type, category, phoneticbuilding, phoneticarea, phoneticssubarea)

Answer 1

尝试转义正文的非格式{和}括号

编辑：这意味着用{{和}}替换它们。见How can I print literal curly-brace characters in python string and also use .format on it?

Answer 2

正如@arthur所说的，你需要用两个方括号替换单个的花括号。我想补充一点，您应该在文本中这样做，文本将是JSON字符串的键值：

例如（字符串的短版本），替换：

body = '{"building": "{0}", "area" : "{1}" }'.format(building, area)

使用：

body = '{{"building": "{0}", "area" : "{1}" }}'.format(building, area)