I have a dataset, for example below
Dataset 1:
account | name |
12 | Alex |
12 | Alex |
33 | Alex |
43 | Tom |
2 | Tom |
So based on the name column I have to create 2 files one where all the Alex is data is and another for Tom,
Output Alex.xlsx and Tom.xlsx
Note: The catch is there could be n number of names So I cant just put 2 output tool I have to group by and somehow create it
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |