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
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ac6154b068ef6d4b57cb7aa3222b77a57e08a2cce9fd8c554aca7cd6f474ea6d
|
|
| MD5 |
93e2a22e103aafd623a78119dea74c46
|
|
| BLAKE2b-256 |
3ca0e17dffb5a83d25cdc81b0568d5f040943c49fe13b548e8af6e14713a400c
|
File details
Details for the file tj_data_normalizer-0.1.1-py3-none-any.whl.
File metadata
- Download URL: tj_data_normalizer-0.1.1-py3-none-any.whl
- Upload date:
- Size: 9.9 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.10.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
657da1010db68d9bbb14268f35024bef2695e1b38c1be8fcce573a526031b9b4
|
|
| MD5 |
d4da2e71fec710d165c0fb5770a7784b
|
|
| BLAKE2b-256 |
53059363fbf3d28f17917332750a6dec782f12f6be8642f44a19521da988f6f6
|