19 CSV Files

20200421

The command mlr from the package miller is a powerfull command line tool for working with csv, tsv, and tabular json files. Documentation for miller is available from ReadTheDocs.

The command csvlook is handy for a quick formatted look at a CSV file:

csvlook data.csv

It is similar to:

mlr --csv --opprint --barred cat data.csv
+-----+-------+----------------------------------------------------+------+
| day | time  | location                                           | size |
+-----+-------+----------------------------------------------------+------+
| Mon | 11:00 | Comp Lab                                           | 40   |
| Mon | 13:00 | Comp Lab                                           | 40   |
| Tue | 08:00 | Cinema                                             | 153  |
| Tue | 18:00 | Comp Lab                                           | 40   |
| Tue | 12:00 | Comp Lab                                           | 40   |
| Tue | 10:00 | Rms                                                | 60   |
| Wed | 11:00 | Comp                                               | 40   |
| Thu | 10:00 | Cinema                                             | 153  |
| Thu | 18:00 | Comp                                               | 40   |
| Fri | 11:00 | Comp                                               | 40   |
+-----+-------+----------------------------------------------------+------+


Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0