<pre><code>info=[[{'$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'}]}]]
info = np.squeeze(info).tolist()
dflines = pd.DataFrame(columns = ["id", "name", "modeName", "disruptions", "serviceTypes"])
dfserviceTypes=pd.DataFrame(columns =["$type","name","uri"])
i=0
j=0
for dic in info:
for key in dic:
if key in dflines.columns.tolist():
dflines.loc[i,key]=str(dic[key])
if key=='serviceTypes':
for dic2 in dic[key]:
for key2 in dic2:
if key2 in dfserviceTypes.columns.tolist():
dfserviceTypes.loc[j,key2]=str(dic2[key2])
j+=1
i+=1
</code></pre>
<p><strong>请记住,如果将数据帧划分为两个数据帧,则可视化更容易,这样就不必面对将一个数据帧插入另一个数据帧的任务,从而不会丢失信息</strong></p>
<pre><code>dflines
</code></pre>
<blockquote>
<p>Output:</p>
</blockquote>
<pre><code>id name modeName disruptions serviceTypes
0 piccadilly Piccadilly tube [] [{'$type': 'Tfl.Api.Presentation.Entities.Line...
1 victoria Victoria tube [] [{'$type': 'Tfl.Api.Presentation.Entities.Line...
</code></pre>
<p><strong>和服务类型:</strong></p>
<pre><code>dfserviceTypes
</code></pre>
<blockquote>
<p>Output:</p>
</blockquote>
<pre><code> $type name uri
0 Tfl.Api.Presentation.Entities.LineServiceTypeI... Regular /Line/Route?ids=Piccadilly&serviceTypes=Regular
1 Tfl.Api.Presentation.Entities.LineServiceTypeI... Night /Line/Route?ids=Piccadilly&serviceTypes=Night
2 Tfl.Api.Presentation.Entities.LineServiceTypeI... Regular /Line/Route?ids=Victoria&serviceTypes=Regular
3 Tfl.Api.Presentation.Entities.LineServiceTypeI... Night /Line/Route?ids=Victoria&serviceTypes=Night
</code></pre>