My Excel Filter

This is a Python program that allows you to filter Excel data using a simple GUI. It's open-source and available on GitHub.

Features

• Select an input Excel file using a file dialog
• Normalize column names to remove any accents or special characters
• Prompt the user to select a column to filter on using a dropdown menu
• Collect the different values in the selected column and prompt the user to choose one in a dropdown menu
• Apply the filter and generate a new Excel file
• Export the filtered data to an Excel file of the user's choice
• Simple and easy to use GUI

How to Use

1. Run the program by executing the filter_excel.py file
2. Select the input Excel file using the file dialog
3. Select a column to filter on from the dropdown menu
4. Select a value to filter on from the dropdown menu
5. Enter an output Excel file name
6. Click the "Filter" button
7. A new Excel file will be generated with the filtered data

Build

You can use the file make.py to build the program into an actual desktop app with a GUI capable of running in any Windows pc.

Dependencies

• Python 3.x • pandas • unicodedata • tkinter

Installation

1. Clone or download the repository from GitHub

2. Install the dependencies using pip: pip install pandas unicodedata

3. Run the program by executing the filter_excel.py file

Contributing

This program is open-source, and contributions are welcome. To contribute, please follow these steps:

1. Fork the repository
2. Create a new branch for your changes
3. Make your changes and commit them to your branch
4. Push your changes to your forked repository
5. Open a pull request

License

This program is licensed under the MIT License. See the LICENSE file for more information.