How to groupby on a index column in pyspark pandas?

Question

I have a pandas API for spark (Koala) dataframe as below,

         c1   c2
id name
a1 a     1    1
a1 b     2    2
b1 c     3    3

How can I do groupby like below,

df.groupby(level=1).sum()

score 1 · Answer 1 · answered Mar 15 '23 at 08:17

1

reset the level first:

df.reset_index(level=1).groupby('name').sum()

answered Mar 15 '23 at 08:17

G.G

1 Answers1