csvRowBlot

The project was for a removing some rows from a csv file

Description:

The csvRowBlot Python-based project developed to facilitate the manipulation and refining of data within CSV (Comma-Separated Values) files. What initially stemmed from a client's request to extract data based on specific genders has evolved into a comprehensive tool capable of filtering rows based on multiple criteria, including gender. The blot.py file is only gender specific. But the blotmore.py file allows the user to choose what to take out and what to create a new file with, it is more flexible and easy to use.

Key Features:

• Efficiently removes designated rows from CSV files.
• Compatible with large datasets, ensuring optimal performance.
• Maintains the integrity of the original CSV file structure while removing specified genders.
• Suitable for a wide range of applications, including data science, research, and data-driven decision-making.

Future Improvements:

• Enhanced Filtering Options:
• Expand the filtering capabilities to include multiple genders or specific combinations of genders.
• Configurable Output Formats:
• Provide options to generate output files in various formats, such as JSON or Excel.
• Error Handling and Validation:
• Implement robust error handling and input validation mechanisms to ensure the tool gracefully handles unexpected data or user inputs.
• Performance Optimization:
• Explore optimization techniques to enhance the project's performance, especially for handling large datasets.
• User Interface Enhancements:
• Continuously improve the user interface with features such as progress indicators, tooltips, and clear instructions.

Challenges:

• User-Friendly Interface Design: Design an intuitive and clear user interface with informative prompts and error messages.
• Adapting to Changing Gender Terminology: Stay updated with current gender terminology and ensure the project remains inclusive and adaptable.

Walk through

• The folder before the new file is created
  

• The user is prompted for the name of the file, gender to blot and name for the new file.
  

• The folder after the new file is created.
  

Due to work Ethics and to preserve the identity of those in the file, I cannot share the csv file. You may use the code to check and suggest improvements