I want to find how many employees were associated with the company code per month year

Asked Mar 30 '22 at 06:21

Active Mar 30 '22 at 06:27

Viewed 17 times

    Person  WorkAgreement   StartDate   CompanyCode CostCenter  DeliveryServiceOrg    
0   abc45   1        2021-04-27     3910        SL1R0001              SL1R  
1   abc219  1        2018-11-19     RO10        RO1T0001              RO1T  
2   abc220  1        2018-12-03     RO10        RO1T0001              RO1T  
3   abc221  1        2018-12-03     RO10        RO1T0001              RO1T

I have given this dataframe ,EndDate is current date

I tried grouping by company code , but I not getting how do i calculate which employee working in which month. please help

edited Mar 30 '22 at 06:27

Biffen

5,791
5
29
34

asked Mar 30 '22 at 06:21

Prachi

paste the code you tried? – Lei Yang Mar 30 '22 at 06:23

I want to find how many employees were associated with the company code per month year

0 Answers0