Print csv files in columnated format, either plain or as a Markdown or LaTeX table
Project description
csvprint
A command-line utility for pretty printing csv files and converting to other formats.
Installation
If Python 3 with the package manager pip is installed, doing pip3 install csvprint
in your terminal should do the trick.
Usage
csvprint [filename]
prints a formatted table if filename
is a comma separated file.
» cat imdb.csv
Title,Release Year,Estimated Budget
Shawshank Redemption,1994,$25 000 000
The Godfather,1972,$6 000 000
The Godfather: Part II,1974,$13 000 000
The Dark Knight,2008,$185 000 000
12 Angry Men,1957,$350 000
» csvprint imdb.csv
Title Release Year Estimated Budget
Shawshank Redemption 1994 $25 000 000
The Godfather 1972 $6 000 000
The Godfather: Part II 1974 $13 000 000
The Dark Knight 2008 $185 000 000
12 Angry Men 1957 $350 000
You can also pipe into csvprint
:
» cat imdb.csv | csvprint
Title Release Year Estimated Budget
Shawshank Redemption 1994 $25 000 000
The Godfather 1972 $6 000 000
The Godfather: Part II 1974 $13 000 000
The Dark Knight 2008 $185 000 000
12 Angry Men 1957 $350 000
Options
Command | Result |
---|---|
--markdown |
print as markdown |
--latex |
print as latex table |
--header |
add header decoration around the first line |
-p [n] |
add a padding of n spaces for each column, on both sides |
-s 'char' |
file is delimited by char (instead of comma), tab for tab |
-d [string] |
specify the string to separate columns |
-a |
specify alignment (left or right) - see examples below |
-c |
specify which columns to print |
-h |
print help message |
Alignment example
There are three options for specifying alignment. One can use l
or r
for aligning all cells to the left or right, respectively. One can also specify a distinct alignment option for each column. Then the number of options will need to match the number of columns.
» csvprint imdb.csv -a l r r
Title Release Year Estimated Budget
Shawshank Redemption 1994 $25 000 000
The Godfather 1972 $6 000 000
The Godfather: Part II 1974 $13 000 000
The Dark Knight 2008 $185 000 000
12 Angry Men 1957 $350 000
Markdown example
Markdown output also supports left and right alignment.
» csvprint examples/imdb.csv --markdown -a l r r
Title | Release Year | Estimated Budget
:----------------------|-------------:|----------------:
Shawshank Redemption | 1994 | $25 000 000
The Godfather | 1972 | $6 000 000
The Godfather: Part II | 1974 | $13 000 000
The Dark Knight | 2008 | $185 000 000
12 Angry Men | 1957 | $350 000
When rendered as HTML, this looks like
Title | Release Year | Estimated Budget |
---|---|---|
Shawshank Redemption | 1994 | $25 000 000 |
The Godfather | 1972 | $6 000 000 |
The Godfather: Part II | 1974 | $13 000 000 |
The Dark Knight | 2008 | $185 000 000 |
12 Angry Men | 1957 | $350 000 |
Testing
Run pytest
while in the root directory of this repository.
Project details
Release history Release notifications | RSS feed
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
Hashes for csvprint-0.6-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cc613cb4e7d87a959ee75abc6c9b399d28f099a67e53b2e7b520c37c8fc34596 |
|
MD5 | ae4e86abbe3742f01089667c0e8a5b40 |
|
BLAKE2b-256 | 97fcb773a9ef04834c2fecde3f060e8db66656bd8f00b16db5dc3107e411d06a |