dfpeek 0.1.6

Peek into a dataframe from the command line

dfpeek

A fast command-line tool for peeking at tabular data files (CSV, TSV, Parquet, Feather, Excel) with concise, chainable options inspired by Unix tools like ls.

Installation

Install from PyPI (recommended):

pip install dfpeek

Or, for Excel/Parquet support:

pip install dfpeek[excel,parquet]

Usage

Run from the command line:

dfpeek <datafile> [options]

Options

Option	Description
-h N	Show first N rows
-t N	Show last N rows
-r START END	Show rows in range START to END (zero-based, END excl.)
-u COL	Show unique values for column COL
-c COL	Show info about column COL (type, nulls, etc.)
-v COL	Show value counts for column COL
-s COL	Show stats for numerical column COL
-l	List column names
-i	Show file info (rows, columns, memory usage)
-d DELIM	Set delimiter for CSV/TSV files (e.g., , or \t)
-xs N	Select Excel sheet N (1-based indexing)
-xr N	Skip first N rows

All options can be chained in any order.

Examples

Show first 10 rows:

dfpeek data.csv -h 10

Show last 5 rows:

dfpeek data.csv -t 5

Show rows 20 to 30:

dfpeek data.csv -r 20 30

Show unique values for column city:

dfpeek data.csv -u city

Show info about column city:

dfpeek data.csv -c city

Show value counts for column status:

dfpeek data.csv -v status

Show stats for column age:

dfpeek data.csv -s age

List columns:

dfpeek data.csv -l

Show file info:

dfpeek data.csv -i

Show info and first 5 rows (default if no options):

dfpeek data.csv

Use a custom delimiter (e.g., tab):

dfpeek data.tsv -d "\t" -h 5

Use a specific Excel sheet (e.g., the 3rd sheet):

dfpeek data.xlsx -xs 3 -h 10

Skip the first 2 rows of an excel file:

dfpeek data.xlsx -xr 2 

Supported Formats

• CSV (.csv)
• TSV (.tsv)
• Parquet (.parquet)
• Feather (.feather)
• Excel (.xlsx)

Notes

• For very large files, output may be slow if printing many rows.
• All rows/columns are shown in full (no abbreviation).
• Requires Python 3.7+

License

MIT