How to use group by with sum, with many columns, without renaming

Question

I have DataFrame like this(bat with 200 columns +):

uid sel_type1 sel_type2 sel_type3
123 1         0         1
123 1         1         0
100 0         1         2

and after i use

df.groupBy(col("uid")).sum()

i have something like this:

uid sum(sel_type1) sum(sel_type2) sum(sel_type3)
123 2              1              1
100 0              1              2

Bat i wont this:

uid sel_type1 sel_type2 sel_type3
123 2         1         1
100 0         1         2

How can i do it?

this question didn't help [stackoverflow.com/questions/33516490/… — Gumada Yaroslav
– Gumada Yaroslav, Commented Aug 15, 2022 at 19:54

qaziqarta · Accepted Answer · 2022-08-15 20:06:55Z

0

As seen here:

df.groupBy(col("uid")).sum().toDF(df.columns:_*)

answered Aug 15, 2022 at 20:06

qaziqarta

1,9541 gold badge6 silver badges13 bronze badges

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

1 Answer 1