DEV Community

Cover image for Mini project of Data Analysis
Leonardo Damasceno Nascimento
Leonardo Damasceno Nascimento

Posted on

Mini project of Data Analysis

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?

  1. Total payroll amount -> What was the total expenditure on employee salaries by the company?
  2. What's the company's total revenue?
  3. What's the % of employees who have already signed a contract?
  4. Calculate the total number of contracts that each area of the company already signed
  5. Calculate the total number of employees by area
  6. 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)