csvtool

Command-line utility to work with .CSV files in bash.

Installation:

Using PIP with Git (recommended):

pip3 install git+https://github.com/maroofi/csvtool.git

Using pypi (Not sure it's always updated):

pip3 install csvtool

Directly using Git repo:

git clone https://github.com/maroofi/csvtool.git

cd csvtool

python3 setup.py install --user

Note: To use it independetly as a command-line tool, make sure you have ~/.local/bin in $PATH variable.

1. Change to your home directory by: cd $HOME
2. Open the .bashrc file.
3. Add the following line to the file.

export PATH=~/.local/bin/:$PATH

4. Save the file and exit
5. then use:

source .bashrc

Example:

csvtool -h

Show the long version of the help for more information.

Sample test.csv file:

1. Select all the 'Chevy' car and show the year, price and model:

csvtool -c 2 -s '^Chevy$' test.csv | csvtool --no-header -c 1,5,3

output:

Year,Price,Model
1999,4900.00,"Venture ""Extended Edition"""
1999,5000.00,"Venture ""Extended Edition, Very Large"""

2. Select only year and name of the cars:

csvtool -c 1,2 test.csv

output:

Year,Make
1997,Ford
1999,Chevy
1999,Chevy
1996,Jeep

TODO LIST

1. Add header to the output. ✔️
2. Add replace command to replace some specific values.