Round while groupping by in pandas with agg function

Question

Is there any posibilities to round the mean of C in this group by?

df.groupby('A').agg({'B':'sum', 'C':'mean'})

Answer 1

You can place round after the aggregation as shown below:

df.groupby('A').agg({'B':'sum', 'C':'mean'}).round(2)

In an aggregation it is not possible to include round inside. Hence you can place round after the aggregation. It is a simple and effective way.

Round(2) will round it off to two decimal places. You can change 2 to include whatever number of decimal places you want to round off the numbers to. For eg to round off to 3 decimal places you can use .round(3) and so on.