Python Pandas - Create list of values AND count by two columns

Question

So I have the following pandas dataframe:

What I would like to do is create a new column that contains a unique list of all the dest_hostnames by the user_agent and user columns.

I also want another column that has the total count of events based on the useragent and user columns.

So the final dataset should look like:

I've been doing the following but can't figure out a way to do both so it's one in dataframe:

browsers.groupby(['user','user_agent'])['dest_hostname'].apply(list).reset_index(name='browser_hosts')

browsers.value_counts(["user", "user_agent"])

It_is_Chris · Accepted Answer · 2021-06-15 20:07:51Z

1

IIUC use agg

df.groupby(['user', 'user_agent'])['dest_hostname'].agg(['unique', 'count'])

answered Jun 15, 2021 at 20:03

It_is_Chris

14.2k3 gold badges27 silver badges45 bronze badges

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

1 Comment

@HenryEcker, thanks, I missed the "contains a unique list" part of the question.