Hello everyone, I have a large dataset of sales made by employees for each month and while doing the analysis, I thought it would be good to know the maximum and minimum sales made for each month and which employee was responsible for it. If anyone can please guide and help me in this using efficient example codes, I would appreciate it. You can use the following example dataset for your codes:
| | Names | Month | Sales |
|---:|:--------------:|:-------:|:------:|
| 0 | Alice | Jan | 2700 |
| 1 | Charlie | Jan | 1800 |
| 2 | Bobby | Mar | 1500 |
| 3 | Noah | Feb | 2200 |
| 4 | Alice | Feb | 3100 |
| 5 | Oliver | Mar | 2900 |
| 6 | Noah | Jan | 2500 |
| 7 | Charlie | Mar | 3300 |
| 8 | Bobby | Jan | 3800 |
| 9 | Alice | Mar | 4000 |
| 10 | Oliver | Jan | 4600 |
| 11 | Oliver | Feb | 4300 |
| 12 | Charlie | Feb | 5000 |
| 13 | Bobby | Feb | 5600 |
| 14 | Noah | Mar | 5200 |