如何在Python中将其放入数据帧中？

Question

我有一个API列表：

[[{'$type': 'Tfl.Api.Presentation.Entities.Line, Tfl.Api.Presentation.Entities',
   'id': 'piccadilly',
   'name': 'Piccadilly',
   'modeName': 'tube',
   'disruptions': [],
   'created': '2019-08-20T16:25:25.35Z',
   'modified': '2019-08-20T16:25:25.35Z',
   'lineStatuses': [],
   'routeSections': [],
   'serviceTypes': [{'$type': 'Tfl.Api.Presentation.Entities.LineServiceTypeInfo, Tfl.Api.Presentation.Entities',
     'name': 'Regular',
     'uri': '/Line/Route?ids=Piccadilly&serviceTypes=Regular'},
    {'$type': 'Tfl.Api.Presentation.Entities.LineServiceTypeInfo, Tfl.Api.Presentation.Entities',
     'name': 'Night',
     'uri': '/Line/Route?ids=Piccadilly&serviceTypes=Night'}],
   'crowding': {'$type': 'Tfl.Api.Presentation.Entities.Crowding, Tfl.Api.Presentation.Entities'}}],
 [{'$type': 'Tfl.Api.Presentation.Entities.Line, Tfl.Api.Presentation.Entities',
   'id': 'victoria',
   'name': 'Victoria',
   'modeName': 'tube',
   'disruptions': [],
   'created': '2019-08-20T16:25:25.36Z',
   'modified': '2019-08-20T16:25:25.36Z',
   'lineStatuses': [],
   'routeSections': [],
   'serviceTypes': [{'$type': 'Tfl.Api.Presentation.Entities.LineServiceTypeInfo, Tfl.Api.Presentation.Entities',
     'name': 'Regular',
     'uri': '/Line/Route?ids=Victoria&serviceTypes=Regular'},
    {'$type': 'Tfl.Api.Presentation.Entities.LineServiceTypeInfo, Tfl.Api.Presentation.Entities',
     'name': 'Night',
     'uri': '/Line/Route?ids=Victoria&serviceTypes=Night'}]

我想得到一个包含以下列的数据帧：id、name、modeName、中断、serviceTypes等等，但我找不到正确的解决方案。你知道吗

这就是我所尝试的：

dflines = pd.DataFrame(columns = ["id", "name", "modeName", "disruptions", "serviceTypes"])

for i, row in range(len(info)):
    id = row["id"]
    name = row["name"]
    modeName = row["modeName"]
    disruptions = row["disruptions"]
    dflines.loc[i] = [id, name, modeName, disruptions, want, serviceTypes]

dflines.head(20)

我得到了这个错误：-----------------------------------------------------

TypeError                                 Traceback (most recent call last)
<ipython-input-80-bec7efd03786> in <module>
      1 dflines = pd.DataFrame(columns = ["id", "name", "modeName", "disruptions", "serviceTypes"])
      2 
----> 3 for i, row in range(len(info)):
      4     id = row["id"]
      5     name = row["name"]

TypeError: cannot unpack non-iterable int object

有人能帮我吗？你知道吗

Answer 1

您看到的错误是由于您试图从range迭代器中“解包”两个值

for i, row in range(len(info)):

range函数返回单个值的迭代（即0, 1, 2, ...）。你可能想enumerate，像这样：

for i, row in enumerate(info):

enumerate函数返回迭代值加索引，如(0, first_value), (1, second_value), ...