Skip to main content

CLI tool to normalize tabular data and generate schemas

Project description

Usage

Run the CLI on a CSV or Excel file:

data-normalizer path/to/file.csv [OPTIONS]

output/<input_name>OUT_<YYYY-MM-DD>/

If `--out` is provided, outputs are written to:

output/<out>/<input_name>OUT_<YYYY-MM-DD>/

Each run folder contains:
- Normalized CSV data
- JSON records
- SQL schema
- JSON schema
- Profiling report

### CLI Options

input_path  
Path to the input `.csv` or `.xlsx/.xls` file.

--sheet  
Excel sheet name or index (only for Excel files).  
Examples: Sheet1, 0

--preview-rows  
Number of rows to preview in the terminal (0–50).  
Default: 5

--table  
SQL table name used in the generated CREATE TABLE statement.  
Default: normalized_data

--show-schema / --no-show-schema  
Print generated SQL and JSON schemas to the terminal.  
Default: disabled

--export  
Write output files to disk.  
If not provided, no files are written.

--out  
Subfolder inside `./output` used to group runs.  
Example: results  
Outputs will be written to:  
output/results/<input_name>OUT_<YYYY-MM-DD>/

--overwrite / --no-overwrite  
Control whether existing run folders can be reused.  
Default: overwrite enabled

### Overwrite behavior

By default, outputs overwrite files in the run folder if it already exists.  
Use --no-overwrite to prevent replacing existing results.  
If the output folder already exists and overwrite is disabled, the command exits with an error.

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

tj_data_normalizer-0.1.1.tar.gz (8.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

tj_data_normalizer-0.1.1-py3-none-any.whl (9.9 kB view details)

Uploaded Python 3

File details

Details for the file tj_data_normalizer-0.1.1.tar.gz.

File metadata

  • Download URL: tj_data_normalizer-0.1.1.tar.gz
  • Upload date:
  • Size: 8.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.0

File hashes

Hashes for tj_data_normalizer-0.1.1.tar.gz
Algorithm Hash digest
SHA256 ac6154b068ef6d4b57cb7aa3222b77a57e08a2cce9fd8c554aca7cd6f474ea6d
MD5 93e2a22e103aafd623a78119dea74c46
BLAKE2b-256 3ca0e17dffb5a83d25cdc81b0568d5f040943c49fe13b548e8af6e14713a400c

See more details on using hashes here.

File details

Details for the file tj_data_normalizer-0.1.1-py3-none-any.whl.

File metadata

File hashes

Hashes for tj_data_normalizer-0.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 657da1010db68d9bbb14268f35024bef2695e1b38c1be8fcce573a526031b9b4
MD5 d4da2e71fec710d165c0fb5770a7784b
BLAKE2b-256 53059363fbf3d28f17917332750a6dec782f12f6be8642f44a19521da988f6f6

See more details on using hashes here.

Supported by

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