Giter Club home page Giter Club logo

mini_dataanalysis_project's Introduction

Mini Data Analysis Project

This is a small project developed for the purpose of learning and training Pandas package applications for Data Analysis.

About the database

For this project there are three database sources originated from a service provider company:

  • CadastroFuncionarios.csv
  • CadastroClientes.csv
  • BaseServiçosPrestados.xlsx

The first .csv file is a database containing the company's employees information such as name, salary and work area. The second .csv file contains information regarding each client's name and their monthly contract price. The .xlsx file includes the information related to the company's orders such as, which employee was responsible for each order, which client signed each contract, how many months the client has signed for.

Analysis Objective

This analysis has the objective of identifying six indicators:

  1. Total Payroll Value
  2. Company's Total Revenue
  3. The percentage of employees that have successfully signed a contract
  4. Total sales each area of the company has made
  5. Number of employees per company area
  6. Average Monthly Revenue

Note: this is a project developed for academic purposes, therefore the data contained in "CadastroFuncionarios.csv", "CadastroClientes.csv" and "BaseServiçosPrestados.xlsx" files are fictitious and used only to learn Pandas packages applications.

mini_dataanalysis_project's People

Contributors

hugo-hattori avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.