擅长:python、mysql、java
<pre><code>def clean_value(x):
try:
return int(x)
except ValueError:
return 0
def clean_list_of_dicts(l):
return [{
k:v if k not in ('overall', 'vote') else clean_value(v) \
for k, v in d.items()
} for d in l]
</code></pre>
<p>对输入数据的测试表明此解决方案有效</p>
<pre><code>>>> clean_list_of_dicts([{'overall': 5.0,
'vote': 'overall',
'reviewerID': 'AAP7PPBU72QFM'},
{'overall': 3.0,
'vote': '5',
'reviewerID': 'A2E168DTVGE6SV'}
])
</code></pre>
<p>给出输出:</p>
<pre><code>[{'overall': 5,
'vote': 0,
'reviewerID': 'AAP7PPBU72QFM'},
{'overall': 3,
'vote': 5,
'reviewerID': 'A2E168DTVGE6SV'}]
</code></pre>