pldatacli 0.1.0

A data analysis cli tool using polars lazyframes

pldatacli

A simple command-line tool for quick CSV data analysis.

---

Tech Stack

• Polars – fast DataFrame engine with lazy execution for efficient data processing
• Typer – modern CLI framework for building command-line interfaces
• Rich – beautiful terminal rendering for clean table output

---

Usage

Basic command

pldatacli FILE [OPTIONS]

Example file:

SampleSuperstore.csv

---

Filter rows

pldatacli SampleSuperstore.csv \
  --filter "State=Texas"

Multiple filters:

pldatacli SampleSuperstore.csv \
  --filter "State=Texas" \
  --filter "Category=Furniture"

---

Group by columns

Single column:

pldatacli SampleSuperstore.csv \
  --groupby Region

Multiple columns:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --groupby Category

---

Aggregations

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=sum"

Multiple aggregations:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=sum,mean"

Multiple columns with aggregations:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --groupby Category \
  --agg "Sales=sum,mean" \
  --agg "Profit=sum"

---

Sorting

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=sum" \
  --sort "Profit_sum:desc"

Multiple sorts:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=sum" \
  --sort "Region:asc" \
  --sort "Profit_sum:desc"

---

Rounding results

Round float columns to 2 digits:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=mean" \
  --round 2

Custom rounding:

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --agg "Profit=mean" \
  --round 4

---

Full example

pldatacli SampleSuperstore.csv \
  --groupby Region \
  --groupby Category \
  --agg "Profit=sum,mean" \
  --sort "Profit_sum:desc" \
  --round 2