B2B Analysis for employee data

I was given a task to :

• Calculate full-time employee growth for all companies from 2015 to 2020
• Find out which company is growing the fastest?
• What is the most common job type for each of the companies?
• Which city has the most full-time employees for each of the 3 companies?
• From 2015 to 2020, how many employees left their firm every year across the 3 firms?
• How would you standardize this metric for comparison’s sake?
• Calculate the number of job promotions annually for the 3 companies.
• From 2015 to 2020 annually, what was the average tenure of employees at each of the 3 firms?

First we will import the libraries:

We read the files and now we will join them to have full table.

After merging we dropped null values and now we are ready to go through our questions. We will extract data from 2015 and 2020.

Now we have count of employees for 3 companies through 2015 and 2020.

Now we extracted the count of employees at each company based on their profession/ title.

Now we did groupby and got the count based on cities.

Above we calculated the number of employees who left their job each year.

I will post remaining answers separately. In case you have any questions please reach me at kristinelpetrosyan@gmail.com.