json-tabulate 0.1.0

Python library and CLI app that translates arbitrarily-nested JSON into CSV

json-tabulate

Python library and CLI app that translates arbitrarily-nested JSON into CSV

Usage

Python library

pip install json-tabulate

>>> from json_tabulate.core import translate_json
>>> translate_json(r'{"name": "Ken", "age": 26}')
'$.age,$.name\n26,Ken\n'

CLI app

Here's the usage string displayed by the CLI app:

json-tabulate --help

 Usage: json-tabulate [OPTIONS] [JSON_STRING]

 Translate JSON into CSV.

 Usage examples:

  • json-tabulate '{"name": "Ken", "age": 26}' (specify JSON via argument)
  • echo '{"name": "Ken", "age": 26}' | json-tabulate (specify JSON via STDIN)
  • cat input.json | json-tabulate > output.csv (write CSV to file)

╭─ Arguments ──────────────────────────────────────────────────────────────────╮
│   json_string      [JSON_STRING]  JSON string to translate. If not provided, │
│                                   program will read from STDIN.              │
╰──────────────────────────────────────────────────────────────────────────────╯
╭─ Options ────────────────────────────────────────────────────────────────────╮
│ --version          Show version number and exit.                             │
│ --help             Show this message and exit.                               │
╰──────────────────────────────────────────────────────────────────────────────╯

Development

Using VS Code? The file, .vscode/tasks.json, contains VS Code task definitions for several of the commands shown below. You can invoke those tasks via the command palette, or—if you have the Task Runner extension installed—via the "Task Runner" panel.

Setup Python virtual environment

Here's how you can create a Python virtual environment and install the Python dependencies within it:

uv sync

Lint Python source code

uv run ruff check --fix

# Other option: Do a dry run.
uv run ruff check

Format Python source code

uv run ruff format

# Other option: Do a dry run.
uv run ruff format --diff

Check data types

uv run mypy

The default configuration is defined in pyproject.toml.

Run tests

uv run pytest

# Other option: Run tests and measure code coverage.
uv run pytest --cov

The default configuration is defined in pyproject.toml.

Build distributable package

uv build

The build artifacts will be in the dist/ directory.