Employee Management System

Overview

This project is a Python-based Employee Management System that enables users to perform CRUD (Create, Read, Update, Delete) operations on employee data stored in a CSV file. The program includes features such as:

Adding new employees.

Updating existing employee details.

Deleting employee records.

Searching for an employee by their ID.

Listing all employees.

Approach

Problem Diagnosis

An issue occurred when attempting to load employee data from a CSV file with a header row. The program misinterpreted the header row as data, leading to a ValueError when attempting to convert the string 'Salary' to a float.

Solution Implementation

Header Row Handling:

Modified the load_data method to skip the header row using the next(reader, None) function.

Ensured only valid employee data rows were processed.

Data Validation:

Ensured the program gracefully handles empty or malformed rows in the CSV file.

Testing:

Tested the program with various scenarios, including:

Valid CSV files with headers.

Missing or incomplete rows.

Empty files.

Files without headers.