HiveBrain v1.2.0
Get Started
← Back to all entries
snippetbashTip

csvsort — Sort CSV files. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scrip

Submitted by: @import:tldr-pages··
0
Viewed 0 times
clicsvsorttldrcommand-line
commandfilessortincludedclicsvsortcsvcsvkit

Problem

How to use the csvsort command: Sort CSV files. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvsort.html>.

Solution

csvsort — Sort CSV files. Included in csvkit. More information: <https://csvkit.readthedocs.io/en/latest/scripts/csvsort.html>.

Sort a CSV file by column 9:
csvsort {{[-c|--columns]}} {{9}} {{data.csv}}


Sort a CSV file by the "name" column in descending order:
csvsort {{[-r|--reverse]}} {{[-c|--columns]}} {{name}} {{data.csv}}


Sort a CSV file by column 2, then by column 4:
csvsort {{[-c|--columns]}} {{2,4}} {{data.csv}}


Sort a CSV file without inferring data types:
csvsort {{[-I|--no-inference]}} {{[-c|--columns]}} {{columns}} {{data.csv}}

Code Snippets

Sort a CSV file by column 9

csvsort {{[-c|--columns]}} {{9}} {{data.csv}}

Sort a CSV file by the "name" column in descending order

csvsort {{[-r|--reverse]}} {{[-c|--columns]}} {{name}} {{data.csv}}

Sort a CSV file by column 2, then by column 4

csvsort {{[-c|--columns]}} {{2,4}} {{data.csv}}

Sort a CSV file without inferring data types

csvsort {{[-I|--no-inference]}} {{[-c|--columns]}} {{columns}} {{data.csv}}

Context

tldr-pages: common/csvsort

Revisions (0)

No revisions yet.