擅长:python、mysql、java
<p>下面是一个版本,它创建一个列表列表作为输出,并根据您的请求使用pandas导出csv</p>
<pre><code>import pandas as pd
info_dict = {'breee': 9, 'ac': 3, 'mcintosh': 4, 'jackowens': 4, 'mdouglas': 5, 'oren': 9, 'xlg': 6, 'ahmed.miller': 6, 'blossom': 11, 'bpacheco': 3, 'enim.non': 5, 'rr.robinson': 1, 'flavia': 6, 'sri': 3, 'nonummy': 5, 'montanap': 6, 'mai.hendrix': 6, 'kirknixon': 2, 'noel': 5, 'britanni': 1}
error_dict = {'mdouglas': 2, 'noel': 10, 'blossom': 3, 'rr.robinson': 3, 'breee': 1, 'nonummy': 3, 'ahmed.miller': 3, 'jackowens': 4, 'ac': 4, 'kirknixon': 4, 'sri': 4, 'enim.non': 4, 'mcintosh': 7, 'oren': 3, 'britanni': 1}
every_name.sort()
output = []
for name in set(list(info_dict.keys())+list(error_dict.keys())):
info = info_dict.get(name,0)
error = error_dict.get(name,0)
output.append([name, info, error])
df = pd.DataFrame.from_records(output, columns=["username", "info", "errors"])
df.to_csv('output.csv')
</code></pre>