Python合并来自两个源的数据-类型错误

Question

我正在尝试获取一个Excel文件，并将该文件中的一些列添加到现有字典中。字典是由产品API创建的，所以我坚持使用现有的格式。

错误消息：

File "C:\Users\me\RISC.py", line 143, in <listcomp>
    devices=[x for x in assets  if x['data'] 
['identifying_ip']==CMDB_device[ip_col]]
TypeError: list indices must be integers or slices, not str

下面是调用代码：

    CMDBlist=self._csv_dict_list(CMDBfile) #imports .csv as ordered dict
    for CMDB_device in CMDBlist:           
        assets=device_list['assets'] #a dictionary that includes a list of devices
        devices=[x for x in assets  if x['data']['identifying_ip']==CMDB_device[ip_col]]
        if devices.length()>0: # We matched on IP...do work

device_list的数据结构示例

{
"assets": [
  {
    "data": {
      "deviceid": 12581177603741,
      "devicetype": "Generic SNMP Device",
      "hostname": "myhost",
      "identifying_ip": "10.1.2.3",
      "ips": [
        {
          "ip": "10.1.2.3"
        }
      ],
    "scantime": "1531184292"
    },
    ...

我的眼睛可能会因为看太久而变得模糊。你知道我把事情搞砸了吗？