Groupby Error on new update

Product Help
1

I just upgraded anaconda to 23.9.0 on my Mac. I went to an old file to re-run it and keep getting hit with an error on a groupby method.

  • TypeError: can only concatenate str (not “int”) to str
  • TypeError: agg function failed [how->mean,dtype->object]

this is super frustrating as my other computer (different version) of Anaconda, has no problem running this cell

2

image
image1278×88 6.02 KB

3

image
image808×115 9.13 KB

4

example: fraudtype_df.groupby([‘category’]).agg({‘amount’: ‘mean’, ‘fraud’ : ‘mean’})

This gives me the category which is a string along with the mean of the amount of fraud and the fraud risk which are both floating points.

1 Like
5

This fixed similar issue I had. Thnx!

6

use .mean(numeric_only=True)