Skip to main content

A GUI/CLI tool for manipulating CSV file data

Project description

CSV Remapper

A GUI/CLI tool for manipulating CSV file data

Description

Allows you to remap, extract and combine data from multiple CSV sources. Key features:

  • Easy to use GUI for creating mapping Templates and processing files
  • Batch-remap files using command line interface
  • Combine data from multiple csv sources
  • Extract data using Regex
  • Omit data based on predefined values

Getting Started

Dependencies

  • Python 3.7 or higher

Installing

pip install csv-remapper

Executing

Display help:

csv-remapper -h

Run in GUI mode:

csv-remapper

Workflow

Launch csv-remapper in GUI mode and create an Output Template (Edit → New Template... → Output) by selecting a CSV file. This file doesn't need to contain any data (apart from the header) and should contain all the columns you wish to see in the final output.

Create an Input Template by selecting a CSV file containing sample data from your source application.

Open Template Editor (Edit → Edit Templates), select your Output template and begin remapping data by dragging and dropping table headers.

If some values need changing (e.g. date format) do so by selecting the correct In/Out data types (double-click to edit)

If you have additional data you wish to insert, which is not present in your main input, you can do so by adding Alias Data tables in the Output section. Populate the "Alias Values" column - these values will be used for selecting the correct row before data extraction. As previously, drag and drop table headers in both Output and Input sections to create mappings.

All tables are editable via direct data manipulation (double-click) or the context menu (right-click)

Once the templates are set up, you can remap your CSV files via GUI or by using the command line, e.g.:

csv-remapper -t "Out-Template-Name" -o "//output/dir" -f "file1.csv" "file2.csv" "file3.csv" ...

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

csv-remapper-1.1.7.tar.gz (191.0 kB view details)

Uploaded Source

Built Distribution

csv_remapper-1.1.7-py3-none-any.whl (59.2 kB view details)

Uploaded Python 3

File details

Details for the file csv-remapper-1.1.7.tar.gz.

File metadata

  • Download URL: csv-remapper-1.1.7.tar.gz
  • Upload date:
  • Size: 191.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: python-requests/2.27.1

File hashes

Hashes for csv-remapper-1.1.7.tar.gz
Algorithm Hash digest
SHA256 8238ae4d4974b273edc1699595dab063d3bf26480978f37318823b6a91298a8b
MD5 c90b5e5efa26f8fbe11a9194fd2ce553
BLAKE2b-256 642cc1c0d5f5153684c21d80da9423adab0f9724d756139f3b36748539300c01

See more details on using hashes here.

File details

Details for the file csv_remapper-1.1.7-py3-none-any.whl.

File metadata

  • Download URL: csv_remapper-1.1.7-py3-none-any.whl
  • Upload date:
  • Size: 59.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: python-requests/2.27.1

File hashes

Hashes for csv_remapper-1.1.7-py3-none-any.whl
Algorithm Hash digest
SHA256 0c5c454c1135ae2a84c33fc8815f5628d287a6c3d8c6221499fadb1c57beb255
MD5 dc247760459069b9e14fcfc2240457fb
BLAKE2b-256 833082048ad49dc9db168397fe071b0531f38679a0a552821e07c9b3e3ef2d80

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page