csvpy

Open a CSV file in a Python shell

$ csvpy [data.csv]

$ csvpy -t [data.tsv]

$ csvpy --agate [data.csv]

$ csvpy -e [latin1] [data.csv]

$ csvpy --no-header-row [data.csv]

csvpy [options] file

csvpy is part of csvkit that loads a CSV file into an interactive Python shell for exploration and analysis. The data is available as a reader object or, with --agate, as a full-featured agate Table.
In default mode, the CSV data is loaded into a variable named reader, a csv.reader object. With --dict, it becomes a DictReader where each row is a dictionary. With --agate, it becomes a table variable with analysis capabilities.
This tool is useful for quick data exploration, testing data transformations, and prototyping analysis code. The interactive environment allows immediate feedback while working with the data.

FILE

CSV file to load into the Python environment.

Field delimiter (default: comma).

Use tabs as delimiter.

Input file encoding.

File has no header row.

Load file as an agate Table instead of csv reader.

Disable type inference.

Load as DictReader (rows as dictionaries).

Large files may use significant memory when loaded entirely. The default reader is consumed after iteration; use --agate for reusable data. Requires familiarity with Python for effective use.

csvpy is part of csvkit, created by Christopher Groskopf in 2011. It provides a quick way to drop into Python for ad-hoc data analysis without writing boilerplate file loading code.

csvkit(1), python(1), ipython(1)