Forum Discussion
Solved
Groupby
Hi, I'm trying to filter a list of all reps conversations to 1 reps conversations. I would previously have used a sort, filter, lamda combination but this looked simpler. I don't seem to be able to ...
You data set has 579 rows for AP, but when you summarise them with GROUPBY duplicates are, as the function name suggests grouped and counted. There are 24 entries for AP with a count greater than 1. The number of grouped rows equals 550, but the sum of the counts is still 579.
You data set has 579 rows for AP, but when you summarise them with GROUPBY duplicates are, as the function name suggests grouped and counted. There are 24 entries for AP with a count greater than 1. The number of grouped rows equals 550, but the sum of the counts is still 579.
Thanks. I didn't realise it was removing duplicates. That explains it.
