Python-Data-Analysis-Capstone

Python data analysis project using Pandas and NumPy for data cleaning, transformation, and EDA.

🐍 Python Data Analysis Capstone Project

🔹 Project Overview

This project focuses on data analysis using Python by working with multiple datasets including Employee, Project, and Seniority data.

🔹 Objectives

• Create and manage dataframes
• Perform data cleaning and transformation
• Handle missing values using running average
• Merge datasets for analysis
• Apply business logic and conditions
• Perform exploratory data analysis (EDA)

🔹 Key Tasks Performed

• Created 3 datasets and converted them into CSV files
• Handled missing values in project cost column
• Split name column into first and last name
• Merged multiple datasets into a final dataset
• Calculated bonus for completed projects
• Updated designation levels based on conditions
• Generated total project cost per employee
• Filtered data based on specific conditions

🔹 Tools Used

• Python
• Pandas
• NumPy

📊 Project Files

• Jupyter Notebook (.ipynb)
• Dataset (.csv)
• Project PDF

🔹 Conclusion

This project demonstrates strong skills in data cleaning, transformation, and analysis using Python, along with problem-solving using real-world scenarios.