Skip to main content

Randomize cells within columns in a CSV file. Like GNU shuf, but for CSV.

Project description

Shuffle cells in a CSV file. Like GNU shuf, but for CSV columns.

Usage

Shuffle the first column of each row of foobar.csv

csvshuf -c1 foobar.csv

Shuffle the third column of each row of foobar.csv using Sattolo’s algorithm

csvshuf -c3 -s foobar.csv

Shuffle all columns of foobar.csv

csvshuf foobar.csv

Shuffle all the columns but the first of foobar.csv

csvshuf -C1 foobar.csv

Shuffle the first and third columns of the first ten lines of foobar.csv

head -10 foobar.csv | csvshuf -c 1,3

Shuffle the first and third columns of the pipe-delimited foobar.csv

csvshuf -c1,3 -d “|” foobar.csv

Shuffle the first and third columns of the tab-delimited foobar.csv

csvshuf -c 1,3 -t foobar.csv

Shuffle the first three columns of the pipe-delimited foobar.csv; output will be comma-delimited

csvshuf -c 1,2,3 -d “|” -o , foobar.csv

Shuffle the first three columns of the comma-delimited foobar.csv; output will be pipe-delimited

csvshuf -c 1,2,3 -o “|” foobar.csv

Shuffle the first two columns of the comma-delimited, pipe-quoted foobar.csv

csvshuf -c 1,2 -d “,” -q “|” foobar.csv

Author

Pere Orga pere@orga.cat, 2016.

Originally forked from csvcut (https://gist.github.com/bycoffe/187278).

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for csvshuf, version 1.0
Filename, size File type Python version Upload date Hashes
Filename, size csvshuf-1.0.tar.gz (16.2 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page