python - 编写一个字典，其中的值是不带括号的csv整数列表

Question

该脚本读取包含错误消息的文件syslog.log，对其进行解析，构建字典，然后将字典写入文件user_statistics.csv。

我想写出key:list不带括号、引号或空格的整数。

#!/usr/bin/python3

import csv

per_user = {'noel': [2, 2], 'mcintosh': [2, 1], 'enim.non': [1, 1], 'oren': [0, 2], 'bpacheco': [0, 1], 'mdouglas': [0, 1], 'ac': [1, 0], 'blossom': [0, 1]}

with open('user_statistics.csv', 'w') as csvfile1:

        y = csv.writer(csvfile1)  

        y.writerow(['Username', 'INFO', 'ERROR'])

        y.writerows(per_user.items())

user_statistics.csv 中收到的输出

Username,INFO,ERROR

ac,"[1, 0]"

blossom,"[0, 1]"

bpacheco,"[0, 1]"

enim.non,"[1, 1]"

mcintosh,"[2, 1]"

mdouglas,"[0, 1]"

oren,"[0, 2]"

期望的输出是

Username,INFO,ERROR

ac,1,0

blossom,0,

bpacheco,0,1

enim.non,1,1

mcintosh,2,1

mdouglas,0,1

oren,0,2

Answer 1

你只需要做类似的事情：import csvper_user = {'noel': [2, 2], 'mcintosh': [2, 1], 'enim.non': [1, 1], 'oren': [0, 2], 'bpacheco': [0, 1], 'mdouglas': [0, 1], 'ac': [1, 0], 'blossom': [0, 1]}with open('user_statistics.csv', 'w') as csvfile1:    writer = csv.writer(csvfile1)      writer.writerow(['Username', 'INFO', 'ERROR'])    for name, (info, error) in per_user.items():        writer.writerow([name, info, error])

Answer 2

用 pandas 解决方案（而不是第二个with语句）。import pandas as pdkeys = per_user.keys()values = per_user.values()df_keys = pd.DataFrame(keys, columns=['Username'])df_values = pd.DataFrame(values, columns=['INFO', 'ERROR'])data = df_keys.join(df_values)data.to_csv("user_statistics.csv", index=False)输出：Username,INFO,ERRORac,1,0blossom,0,1bpacheco,0,1enim.non,1,1mcintosh,2,1mdouglas,0,1oren,0,2