回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我不认为这是标准的<code>json</code>格式。我在其他例子中没有看到冒号。例如,您可以看到第一行显示佛罗里达州(FL)。所以我想我会看到类似“State”:“FL”的东西。这里没有显示标题,但是当我查看网页结果时,会显示标题。是否需要冒号才能有效地解析它?最后我想把这个转换成CSV格式,这样我就可以把它加载到Excel中。以下是该文件的示例。在</p>
<pre><code>{
'aaData':[
[
[
'99.04,99.08,99.08,99.12,99.08,99.11,99.12,99.13,99.11,99.11,99.12,99.13,99.11,99.10,99.09,99.06,99.09,99.11,99.09,99.13,99.11,99.07,98.96,98.38,98.66,99.11,99.10,98.70',
'2961916',
'4'
],
'**FL**',
'Atmore',
'WALNUT HILL',
'JAKES ROAD',
'WLHLFL',
'EquipmentType',
'.',
'1-1-2-1',
'.',
'2015-09-10',
'2015-10-07',
None,
'6.14',
'99.13',
'908',
'345',
'448',
'971',
'24.00',
'2672',
'0',
'0',
'0',
'Critical',
'2672',
'2015-10-09 12:57:50'
],
[
[
'98.31,98.06,97.55,96.10,97.62,98.20,97.18,97.26,97.74,96.94,97.61,98.03,98.66,97.69,98.17,97.61,98.23,96.98,97.97,97.84,97.62,98.16,97.05,98.05,98.11,97.40,96.72,95.87',
'3133016',
'4'
],
'FL',
'Atmore',
'MOLINO',
'QUINTETTE',
'MOLNFL',
'EquipmentType',
'.',
'1-1-2-1',
'.',
'2015-09-10',
'2015-10-07',
None,
'3.07',
'98.66',
'1017',
'338',
'416',
'916',
'31.39',
'2687',
'0',
'0',
'0',
'Critical',
'2687',
2015-10 -09 12:57:50
]
]
</code></pre>
<p>现行代码</p>
^{pr2}$
<p>编辑</p>
<p>添加此代码可以将我添加到要提取的数据:</p>
<pre><code>list1 = obj['aaData'][0][1:]
print(list1)
list2 = obj['aaData'][1][1:]
print(list2)
list3 = obj['aaData'][2][1:]
print(list3)
</code></pre>
<p>结果:</p>
<pre><code>['FL', 'Atmore', 'WALNUT HILL', 'JAKES ROAD', 'WLHLFL', 'EquipmentType', '.', '1-1-2-1', '.', '2015-09-11', '2015-10-08', None, '6.14', '99.13', '916', '357', '430', '969', '24.00', '2672', '0', '0', '0', 'Critical', '2672', '2015-10-10 09:02:28']
['FL', 'Atmore', 'MOLINO', 'QUINTETTE', 'MOLNFL', 'EquipmentType', '.', '1-1-2-1', '.', '2015-09-11', '2015-10-08', None, '3.07', '98.66', '1027', '341', '412', '907', '31.39', '2687', '0', '0', '0', 'Critical', '2687', '2015-10-10 09:02:28']
['FL', 'Atmore', 'WALNUT HILL', 'BAY SPRINGS', 'WLHLFL', 'EquipmentType', '.', '1-1-2-1', '.', '2015-09-11', '2015-10-08', None, '6.14', '99.13', '1062', '428', '438', '760', '31.53', '2688', '0', '0', '0', 'Critical', '2688', '2015-10-10 09:02:28']
</code></pre>
<p>但需要迭代这些实例并查找每个实例。模式是<code>['aaData'][0][1:]</code>,<code>['aaData'][1][1:]</code>,<code>['aaData'][2][1:]</code>。这个文件可以有很多这样的。如何迭代或循环文件并打印这些文件?在</p>
<p>编辑-最终有效的代码</p>
<pre><code>from urllib.request import urlopen
import json
import csv
url_fl = 'http://company.server.org'
url_response = urlopen(url_fl).read().decode('utf-8')
obj = json.loads(url_response)
obj_parse = obj['aaData']
with open('test.csv', 'w', newline='') as fp:
data = csv.writer(fp, delimiter=',')
for row in obj_parse:
data.writerows([row[1:]])
</code></pre>