Worksheet Editor

Overview

The Worksheet Editor is a Python script designed for working with Excel worksheets using the Pandas and Openpyxl libraries. It provides functions to extract, filter, and manipulate data in Excel files, supporting common data processing tasks.

Features

• Extract Column Values: Extracts and lists the values of a specified column in a Pandas DataFrame.
• Filter DataFrame: Filters a DataFrame based on a specific value in a specified column.
• Remove Duplicates: Removes duplicate values from a list while preserving the original order.
• Generate DataFrames: Creates separate DataFrames for each unique value in a specified column.
• Generate Excel Files: Generates Excel files for each DataFrame, saving them with a user-defined suffix.

Usage

1. Clone the repository:

   git clone https://github.com/Rjj18/Worksheet-editor.git
   cd Worksheet-editor
   

2. Install the required dependencies:

   pip install -r requirements.txt

3. Run the script:

   python worksheet_editor.py
   

Contributing:

We welcome contributions to improve and enhance the Worksheet Editor. To contribute, follow these steps:

Fork the repository:

Click the "Fork" button at the top right of the repository's page.

Clone your fork:

Clone your forked repository to your local machine:

git clone https://github.com/YourUsername/Worksheet-editor.git
cd Worksheet-editor

Create a new branch:

Create a new branch for your changes:

git checkout -b feature/your-feature-name

• Make your changes:

Make the necessary changes and improvements. Commit your changes:

Commit your changes with a descriptive commit message:

git add .
git commit -m "Add a concise commit message"

• Push to your fork: Push your changes to your fork on GitHub:

git push origin feature/your-feature-name

Open a pull request:

Open a pull request on the original repository with a detailed description of your changes.

License

Copyright (c) [2023] [Roger Oliveira]

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.