CSV Filter (alpha)

Written in python, this program is a command-line interface, providing the ability to mutate data in a CSV file when spreadsheet applications lack functionality.

Usage

For now, calling the program looks a bit rough, but it gets the job done.

You can call the program this way: python csv_filter/__init__.py

--file/-f: Specify file to filter
--deduplicate/-d (optional): Specify deduplication column
--filter (optional): Specify filter column and regex pattern
--filter_inverse (optional): Inverse filter matches
--ignore_case/-i (optional): Enable case insensitivity
--verbose/-v (optional): Enable verbose output

Examples

Deduplicating rows based on a column uniqueness

python csv_filter/__init__.py --file export.csv --deduplicate=email -i -v

Filter rows based on a regex

python csv_filter/__init__.py --file export.csv --filter "_address_country_id=(NL|BE)" -i -v

Issue reporting/contributing