How to sort by column

[sergeevabc]

$ tv sample.csv {magic switch} num_emails

[alexhallam]

Thanks for the suggestion. I am trying to keep tv a viewer only. If you want to do data manipulation on the command line there is nothing better than duckdb cli. https://github.com/alexhallam/tv#use-with-duckdb

duckdb --csv -c "SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi.csv GROUP BY passenger_count ORDER BY passenger_count" | tv 

or in your case

duckdb --csv -c "SELECT * FROM sample.csv ORDER BY num_emails " | tv

[sergeevabc]

Unfortunately, your command outputs the data from num_emails column only, omitting the rest.

I ended up with PowerShell:

Import-CSV sample.csv | Sort {[int]$_.num_emails} -Desc | Format-Table

[alexhallam]

Sorry,

here is the correction

duckdb --csv -c "SELECT * FROM sample.csv ORDER BY num_emails " | tv