Creating columns from counts in pyhton

Asked May 10 '23 at 17:34

Active May 10 '23 at 17:34

Viewed 14 times

I have a dataset

 Manager_Name     Hire_Type      Person_Hired    Status 
    Adam             FT             James        Pending
    Adam             PT             Emily        Approved
    Ben              FT             Paul         Approved 
    Ben              FT             Sarah        Approved

I need to create two columns with the counts by Manager_Name of how many pending and approved hires each manager has.

Desired output:

     Manager_Name    Approvals     Pending
        Adam             1            1
        Ben              2            0

Thank you

asked May 10 '23 at 17:34

Coding_Nubie

1

`pd.crosstab(df['Manager_Name'], df['Status'])` – mozway May 10 '23 at 17:35
Will you please provide the code you've written so far in attempt to solve this issue? – h0r53 May 10 '23 at 17:35

Creating columns from counts in pyhton

0 Answers0