Hi everyone. How are you?
That's a post of a challenge of Data analysis for beginners.
It's from a Python for Data Analysis course I'm doing.
What do we have for him?
We have 3 files of 2019 from an Enterprise (all data are fake).
- RegisterEmployer.csv
- RegisterClient.csv
- BaseServicesProvided.xlsx
What do we want to know?
- Total payroll amount -> What was the total expenditure on employee salaries by the company?
- What's the company's total revenue?
- What's the % of employees who have already signed a contract?
- Calculate the total number of contracts that each area of the company already signed
- Calculate the total number of employees by area
- What's the average monthly ticket of contract?
If you do the challenge, tell me in the comments if you liked it or if you have some doubts ;)
The feedback's on my GitHub: https://github.com/LeoDNascimento/Challenge-1E
Top comments (0)