Employee Performance Analysis using Python & Pandas

Overview

This project demonstrates an end-to-end employee performance analysis using Python and Pandas. It includes data exploration, cleaning, feature engineering, filtering, aggregation, and business reporting.

Technologies Used

• Python
• Pandas

Features

• Data Exploration
• Missing Value Handling
• Duplicate Removal
• Data Cleaning
• Feature Engineering
• Data Filtering
• GroupBy & Aggregation
• Business Insights
• CSV Report Generation

Project Files

• employee_performance_analysis.py - Main Python script
• Sales.csv - Input dataset
• manager_performance_report.csv - Output report

Business Questions Answered

• Manager with the highest number of employees
• Department with the highest average salary
• City with the highest total salary
• Manager with the highest average bonus
• Month with the highest employee joinings
• Department with the highest total experience
• Employee with the highest salary
• City with the lowest total bonus
• Employee count by department

Output

The project generates a manager-wise performance report and exports it as:

manager_performance_report.csv

Author

Emmanuel Thomas