json - 忽略 JSON 字典中的空值 - Python 3

Question

我开始学习 python 并且无法解决这个问题（花了几个小时在谷歌上搜索它）。

这是我所拥有的：

response = urllib.request.urlopen(url)
data = json.loads(response.read())

table_data = []
for i in data['items']:
    attendeeid = i['attendee id']
    if 'reg: how hear ' in i:
        howhear = i['reg: how hear ']
    else:
        howhear = 'No Data'
    orderid = i['order_id']
    totalprice = i['total price']
    ordernumber = i['order_number']
    email = i['email']
    state = i['state']
    country = i['country']
    companyname = i['company name']
    packagename = i['package name']
    orderdate = i['order date']
    pipedurl = i['piped url']
    revenue = i['revenue']
    lineitemquantity = i['line item quantity']
    timebaseitemprice = i['time base item price']
    table_data.append([attendeeid, howhear, orderid, totalprice, ordernumber, email, state, country, companyname, packagename, orderdate, pipedurl, revenue, lineitemquantity, timebaseitemprice])

但是，我发现并非所有记录在 state 字段中都有值。如何创建异常来处理空状态值？

谢谢。

标签： jsonapipython-3.7