回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个JSON数据类型raw.JSON</p>
<pre><code>{"time": 12.640, "name": "machine1", "value": 24.0}
{"time": 12.645, "name": "machine2", "value": 0.0}
{"time": 12.65002, "name": "machine3", "value": true}
{"time": 12.66505, "name": "machine4", "value": 1.345}
{"time": 12.67007, "name": "machine5", "value": 5.068}
{"time": 12.67508, "name": "machine4", "value": 1.075}
{"time": 12.6801, "name": "machine5", "value": 2.0868}
{"time": 12.6851, "name": "machine4", "value": 0.0}
{"time": 12.6901, "name": "machine5", "value": 12.633}
{"time": 12.69512, "name": "machine5", "value": 13.13}
{"time": 12.70013, "name": "machine3", "value": false}
{"time": 12.70515, "name": "machine3", "value": false}
{"time": 12.71016, "name": "machine3", "value": false}
{"time": 12.71517, "name": "machine5", "value": 131.633}
</code></pre>
<p>因此,在我的python脚本中,我能够生成逐行读取并生成一个列表</p>
<pre><code>import json
data = [];
timestamp =[];
with open('raw.json') as f:
for line in f:
data.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>(json.loads(line))
f.close()
for idx, val in enumerate(data):
time = data[idx]['time']
name = data[idx]['name']
value = data[idx]['value']
data_list = idx+1, time, name, value
print data_list
</code></pre>
<p>输出:</p>
<pre><code>(1, 12.64, u'machine1', 24.0)
(2, 12.645, u'machine2', 0.0)
(3, 12.65002, u'machine3', True)
(4, 12.66505, u'machine4', 1.345)
(5, 12.67007, u'machine5', 5.068)
(6, 12.67508, u'machine4', 1.075)
(7, 12.6801, u'machine5', 2.0868)
(8, 12.6851, u'machine4', 0.0)
(9, 12.6901, u'machine5', 12.633)
(10, 12.69512, u'machine5', 13.13)
(11, 12.70013, u'machine3', False)
(12, 12.70515, u'machine3', False)
(13, 12.71016, u'machine3', False)
(14, 12.71517, u'machine5', 131.633)
</code></pre>
<p>我希望对这些数据进行排序,以便可以使用单独的列表(数组)。e、 g</p>
<pre><code>machine1 = [12.640, 24.0];
machine2 = [12.645, 0.0];
machine3 = [
12.65002,true
12.70013,false
12.70515,false
12.71016,false
];
machine4 = [
12.66505 1.345
12.67508 1.075
12.6851 0.0
];
</code></pre>
<p>除此之外,我还可以如何直接搜索这个元组或列表来生成元数据,如machine1、machine 2等的sum/average</p>
<pre><code>Sum_Machine1 = 24;
Sum_Machine2 = 0;....
</code></pre>