Convert aggregate function from R to python

Question

I have a R's aggregate function:

usefulTopics = aggregate(Count ~ ID1 + Topic1 + ID2 + Topic2, data = usefulTopics, sum, na.rm = TRUE)

I want to convert this code to python and get the dataframe. How can I do so?

Have you tried this? https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.aggregate.html — Roman Luštrik, Sep 28 '18 at 07:06

score 0 · Answer 1 · answered Sep 28 '18 at 07:10

0

This should do the trick:

usefulTopics = usefulTopics.groupby('Count')['ID1', 'Topic1', 'ID2', 'Topic2'].agg('sum')

answered Sep 28 '18 at 07:10

Joe Patten

1 Answers1