Pandas dataframe pandas

Question

I have this csv:

message	reported_agents
Missing status flag was removed	host1
Missing status flag was raised	host1
Missing status flag was removed	host2
Missing status flag was raised	host2
Missing status flag was raised	host3

I need to get this

Host	total messages	Missing flag remove	Missing flag raised
host1	2	1	1
host2	2	1	1
host3	1	0	1

This is what I did but it doesn't show what I need. Thank you for your help

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

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

Please post you input and output data as text, or better code that can be copied to get the dataframes directly. — mozway
– mozway, Commented Jul 10, 2021 at 16:34

dm2 · Accepted Answer · 2021-07-10 16:43:32Z

3

Use pandas.crosstab and then sum along columns for totals:

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

Output:

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

edited Jul 10, 2021 at 16:43

answered Jul 10, 2021 at 16:37

dm2

4,3053 gold badges21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas dataframe pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related