Skip to content

Latest commit

 

History

History
54 lines (38 loc) · 1.73 KB

README.md

File metadata and controls

54 lines (38 loc) · 1.73 KB
Raw

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.