Finding the best employee per project

Question

Here is my Data:

                 Rev
Project Emp         
A       dave    5000
        Ron    21000
        Lily   12000
B       Maya   15000
        Jon    34000
        Alex   31000
C       Allen  18000
        Ji     10000
        Shan   28000

I need to find out the employee name of the highest Rev collector per project. The output should contain Employee's name and the Rev both. How can I do that in Pandas?

Is Project an index? Do you mind to share this data via df.to_dict()? — rpanai, Jul 19 '22 at 13:09
what did you try so far? stackoverflow is not a homework solving platform. — Stef, Jul 19 '22 at 13:10

score 2 · Answer 1 · answered Jul 19 '22 at 13:13

2

Here is one way to do it

df[df['Rev'].eq(df.groupby('Project')['Rev'].transform('max'))]


    Project     Emp     Rev
1         A     Ron     21000
4         B     Jon     34000
8         C     Shan    28000

answered Jul 19 '22 at 13:13

Naveed

11,495
2
14
21

bpfrd · Answer 2 · 2022-07-19T13:30:08.667

0

Try this:

df.merge(df.groupby('Project').agg({'Rev': max}), on=['Project', 'Rev'])

Output:

    Project Emp Rev
0   A   Ron 21
1   B   Jon 34
2   C   Shan    28

edited Jul 19 '22 at 13:30

answered Jul 19 '22 at 13:10

bpfrd

945
3
11

score 0 · Answer 3 · answered Jul 19 '22 at 13:15

0

You can use Pandas groupby to group the underlying data on one or more columns and estimate useful statistics like count, mean, median, min, max etc.

then you can get the maximum value of rev :

df.groupby('Project')['Rev'].max()

answered Jul 19 '22 at 13:15

Hamed Parvaresh

21
6

Finding the best employee per project

3 Answers3