CSV – wp.jochen.hayek.name/blog-en

XML Shell: xmlsh: csv2xml

Sep 5, 2017

—

by

http://www.xmlsh.org https://github.com/xmlsh/xmlsh1_3 they also provide a Java .jar file and a shell script etc around it, so you can run it on your platform http://www.xmlsh.org/CommandCsv2xml – builtin csv2xml A couple of command line options we are using: -delim ‘;’ – German excel files get exported to CSV files with ‘;’ as column separator / delimiter, so when we…

XML Shell: xmlsh

Aug 31, 2017

—

by

johayek

in CSV, nxml-mode, relax-ng, XML

http://www.xmlsh.org https://github.com/xmlsh/xmlsh1_3 they also provide a Java .jar file and a shell script etc around it, so you can run it on your platform http://www.xmlsh.org/CommandCsv2xml – builtin csv2xml, funny! http://www.xmlsh.org/CommandRngconvert – that’s trang, dealing with “Relax NG“ examples for csv2xml: $ csv2xml -header my_file.csv $ csv2xml -header -attr my_file.csv # for CSV files created by Excel…

Python and file formats: CSV, INI, netrc, xdrlib, plistlib (for Mac OS X .plist files)

Dec 17, 2015

—

by

johayek

in CSV

https://docs.python.org/2/library/ https://docs.python.org/2/library/fileformats.html https://docs.python.org/3/library/ https://docs.python.org/3/library/fileformats.html

O’Reilly Media book: “Data Science at the Command Line” – installing the tools …

Apr 15, 2015

—

by

johayek

in CSV

http://shop.oreilly.com/product/0636920032823.do excercising the tools within the Vagrant VM is fun … and certainly supplying the VM is a good and rather low-trouble start for the studies … but installing the tools in your real-life environment is the “challenge” … Appendix A lists the tools and their home pages http://csvkit.readthedocs.org – I just installed the csvkit,…

O’Reilly Media book: Data Science at the Command Line

Jul 5, 2014

—

by

johayek

in CSV

http://shop.oreilly.com/product/0636920032823.do http://datascienceatthecommandline.com http://datasciencetoolbox.org http://jeroenjanssens.com/2013/09/19/seven-command-line-tools-for-data-science.html https://github.com/jeroenjanssens/data-science-at-the-command-line/issues http://csvkit.readthedocs.org Become a more efficient and productive data scientist by leveraging the power of the command line. With this practical guide, you’ll learn seven command-line tools for obtaining, scrubbing, and exploring data—including three tools developed by the author. If you rely on one-time scripts for working with data, this book…

perl: a nice exercise with DBD::CSV

Sep 7, 2012

—

by

johayek

in CSV, The Perl Programming Language

http://perlmaven.com/calculate-bank-balance-take-two-dbd-csv

Gábor Szabó: How to read a CSV file using Perl?

Jan 19, 2012

—

by

johayek

in CSV, The Perl Programming Language

http://szabgab.com/how-to-read-a-csv-file-using-perl.html https://metacpan.org/pod/Text::CSV

CSV Kit — commandline tools for working with CSV files

Jan 18, 2012

—

by

johayek

in CSV

Nat Torkington’s Four short links: 17 January 2012: http://csvkit.readthedocs.io — commandline tools for working with CSV files. (via Hadley Wickham)[…] A little longer: csvkit (CSV kit) is a suite of utilities for converting to and working with CSV.

table_pdf2csv.pl : extracting tables from PDF, saving them as CSV

Jan 7, 2012

—

by

johayek

in CSV

I leave the PDF extraction bit to “pdftohtml -xml“. My perl scripts tells you, at what “physical columns” text gets found within the PDF file. You choose, which “physical columns” really makes sense to you as logical column starters. Now you run my perl script with those few serious physical columns specified, and it creates…