Skip to content

README.md

Latest commit

 

History

History
44 lines (31 loc) · 1.27 KB

README.md

File metadata and controls

44 lines (31 loc) · 1.27 KB
Raw

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.