<p>此函数递归地调用自身以展平字典和列表。在</p>
<pre><code>from collections import OrderedDict
def flatten(json_object, container=None, name=''):
if container is None:
container = OrderedDict()
if isinstance(json_object, dict):
for key in json_object:
flatten(json_object[key], container=container, name=name + key + '_')
elif isinstance(json_object, list):
for n, item in enumerate(json_object, 1):
flatten(item, container=container, name=name + str(n) + '_')
else:
container[str(name[:-1])] = str(json_object)
return container
</code></pre>
<p>示例:</p>
^{pr2}$
<p>回应:</p>
<pre><code># j = json string
>>> pd.DataFrame(flatten(j), index=[0]).T
0
perMinuteLimit 10
distance 10
perMonthCurrent 0
longitude 35.751607
perMonthLimit 2000
latitude -6.162959
perMinuteCurrent 0
networkRank_1_networkId 6402
networkRank_1_type3G_sampleSizeSpeed 29
networkRank_1_type3G_averageRssiAsu 9.5429091136
networkRank_1_type3G_pingTime 320.9600
networkRank_1_type3G_networkType 3
networkRank_1_type3G_averageRssiDb -69.5664329624972
networkRank_1_type3G_networkName Vodacom
networkRank_1_type3G_networkId 6402
networkRank_1_type3G_downloadSpeed 1508.1304
networkRank_1_type3G_uploadSpeed 893.7692
networkRank_1_type3G_reliability 0.804236452826138
networkRank_1_type3G_sampleSizeRSSI 948
networkRank_1_networkName Vodacom
networkRank_2_networkId 6400
networkRank_2_type3G_sampleSizeSpeed 21
networkRank_2_type3G_averageRssiAsu 15.3537142857
networkRank_2_type3G_pingTime 259.0000
networkRank_2_type3G_networkType 3
networkRank_2_type3G_averageRssiDb -61.4563389583101
networkRank_2_type3G_networkName tiGO
networkRank_2_type3G_networkId 6400
networkRank_2_type3G_downloadSpeed 516.0000
networkRank_2_type3G_uploadSpeed 320.4211
networkRank_2_type3G_reliability 0.911904765537807
networkRank_2_type3G_sampleSizeRSSI 935
networkRank_2_networkName tiGO
networkRank_3_networkId 6403
networkRank_3_type3G_sampleSizeSpeed 21
networkRank_3_type3G_averageRssiAsu 13.2729999375
networkRank_3_type3G_pingTime 194.5556
networkRank_3_type3G_networkType 3
networkRank_3_type3G_averageRssiDb -58.1521092977699
networkRank_3_type3G_networkName Airtel
networkRank_3_type3G_networkId 6403
networkRank_3_type3G_downloadSpeed 1080.2500
networkRank_3_type3G_uploadSpeed 572.1579
networkRank_3_type3G_reliability 0.554680264185345
networkRank_3_type3G_sampleSizeRSSI 587
networkRank_3_networkName Airtel
network_type None
apiVersion 2
</code></pre>