xmaihh / csvfilter

CSVFilter is a project that allows for filtering and processing of CSV files. It can read CSV files and filter data rows or columns based on specified conditions. The results can be exported to a new CSV file for further analysis.

Quickstart

⚠️ CSVFilter works with Python 3.7+. To check your Python version, run python --version.

If you have both Python 2 and Python 3 installed, you may need to use python3 instead of python. This is becoming less common as Python 2 is sunsetting.

Requirements

The requirements.txt is a simple text file which lists the dependencies, or necessary packages that are required to run the code. Install the required packages from requirements.txt

pip install -r requirements.txt

Usage

The program can then be executed from a command line using the main.py executable:

→ D:\<your-local-directory>\CSVFilter [main]› python main.py

Executables

Make sure you have the Requirements installed, and then install PyInstaller from PyPI:

pip install -U pyinstaller

Open a command prompt/shell window, and navigate to the directory where main.py file is located, then build app with the following command:

pyinstaller main.py

Your bundled application should now be available in the dist folder.

pyinstaller -F --add-data "resources/*;resources/" --add-data "config.ini;."  --icon=.\resources\csv_filter.ico -w --clean --name CSVFilter main.py

The project folder follows this structure:

├── CSVFilter/
    ├── csv_toolbox
    │   ├── data
    │   ├── lib_base
    │   ├── lib_csv_filter
    │   ├── lib_csv_to_excel
    │   ├── lib_data_preprocess
    │   ├── lib_excel_beautifier
    │   ├── lib_excel_merge
    │   ├── lib_i18n
    │   ├── lib_log
    │   └── lib_utils
    ├── docs
    ├── resources
    ├── scripts
    └── tests

csvfilter's Issues

Error found in `publish-to-release` workflow

❌Update configuration file
 Run python ./csvfilter/version.py
  python ./csvfilter/version.py
  shell: C:\Program Files\PowerShell\7\pwsh.EXE -command ". '{0}'"
  env:
    OUTPUT_FILE_PREFIX: CSVFilter.Setup
    pythonLocation: C:\hostedtoolcache\windows\Python\3.[1](https://github.com/xmaihh/CSVFilter/actions/runs/7578068355/job/20640033224#step:5:1)[2](https://github.com/xmaihh/CSVFilter/actions/runs/7578068355/job/20640033224#step:5:2).1\x64
C:\hostedtoolcache\windows\Python\[3](https://github.com/xmaihh/CSVFilter/actions/runs/7578068355/job/20640033224#step:5:3).12.1\x6[4](https://github.com/xmaihh/CSVFilter/actions/runs/7578068355/job/20640033224#step:5:4)\python.exe: can't open file 'D:\\a\\CSVFilter\\CSVFilter\\csvfilter\\version.py': [Errno 2] No such file or directory
Error: Process completed with exit code 1.