该脚本读取包含错误消息的文件syslog.log，对其进行解析，构建字典，然后将字典写入文件user_statistics.csv。我想写出key:list不带括号、引号或空格的整数。#!/usr/bin/python3import 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: y = csv.writer(csvfile1) y.writerow(['Username', 'INFO', 'ERROR']) y.writerows(per_user.items())user_statistics.csv 中收到的输出Username,INFO,ERRORac,"[1, 0]"blossom,"[0, 1]"bpacheco,"[0, 1]"enim.non,"[1, 1]"mcintosh,"[2, 1]"mdouglas,"[0, 1]"oren,"[0, 2]"期望的输出是Username,INFO,ERRORac,1,0blossom,0,bpacheco,0,1enim.non,1,1mcintosh,2,1mdouglas,0,1oren,0,2
2 回答
慕莱坞森
TA贡献1810条经验 获得超4个赞
你只需要做类似的事情：
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:
writer = csv.writer(csvfile1)
writer.writerow(['Username', 'INFO', 'ERROR'])
for name, (info, error) in per_user.items():
writer.writerow([name, info, error])
冉冉说
TA贡献1877条经验 获得超1个赞
用 pandas 解决方案（而不是第二个with语句）。
import pandas as pd
keys = 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,ERROR
ac,1,0
blossom,0,1
bpacheco,0,1
enim.non,1,1
mcintosh,2,1
mdouglas,0,1
oren,0,2
添加回答
举报
0/150
提交
取消