該腳本讀取包含錯誤消息的文件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
提交
取消