Pandas数据帧Pandas

Question

我有一个csv：

^{tb1}$

我需要得到这个

^{tb2}$

这就是我所做的，但它没有显示我需要什么。谢谢你的帮助

def load_data():
    event = pd.read_csv("events.csv")
    return event
data = load_data()

def GCmissing(data):
        x=data.groupby('hosts')['message'].value_counts()         

Answer 1

使用pandas.crosstab然后沿列求和以获得总计：

out_df = pd.crosstab(index = df['reported_agents'], columns = df['message'])
out_df['total_messages'] = out_df.sum(axis = 1)

输出：

reported_agents Missing status flag was raised  Missing status flag was removed total_messages
host1           1                               1                               2
host2           1                               1                               2
host3           1                               0                               1