datatools

package module

v0.0.3 Latest Latest Go to latest Published: Mar 1, 2017 License: BSD-3-Clause Imports: 0 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/caltechlibrary/datatools

Links

Open Source Insights

README ¶

datatools

Various utilities for simplifying JSON, Excel Workbook and CSV data work on the command line.

csvcols - a tool for formatting command line arguments intoa CSV row or filtering CSV rows for specific columns
csvjoin - a tool to join to CSV files on common values in designated columns, writes combined CSV rows to stdout
csv2mdtable - a tool to render CSV as a Github Flavored Markdown table
jsoncols - a tool for exploring and extracting JSON values into columns
jsonrange - a tool for iterating for JSON maps and arrays
xlsx2json - a tool for converting Excel Workbooks to JSON files
xlsx2csv - a tool for converting Excel Workbooks sheets to a CSV file(s)

Compiled versions are provided for Linux (amd64), Mac OS X (amd64), Windows 10 (amd64) and Raspbian (ARM6, ARM7). See https://github.com/caltechlibrary/datatools.

Use the utilities try "-help" option for a full list of options.

Installation

datatools is go get-able.

    go get github.com/caltechlibrary/datatools/...

Or see INSTALL.md for details for installing compiled versions of the programs.

Documentation ¶

Index ¶

Constants

Constants ¶

View Source

const (
	Version = "v0.0.3"

	LicenseText = `` /* 1530-byte string literal not displayed */

)

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

This section is empty.

Source Files ¶

View all Source files

datatools.go

Directories ¶

Path	Synopsis
cmds
csv2mdtable csv2mdtable - is a command line that takes CSV input from stdin and writes out a Github Flavored Markdown table.	csv2mdtable - is a command line that takes CSV input from stdin and writes out a Github Flavored Markdown table.
csv2xlsx csv2xlsx is a command line utility that will convert a CSV file and insert it into a named sheet in an Excel Workbook.	csv2xlsx is a command line utility that will convert a CSV file and insert it into a named sheet in an Excel Workbook.
csvcols csvcols - is a command line that takes each argument in order and outputs a line in CSV format.	csvcols - is a command line that takes each argument in order and outputs a line in CSV format.
csvjoin csvjoin - is a command line that takes two CSV files and joins them by match a designated column in each.	csvjoin - is a command line that takes two CSV files and joins them by match a designated column in each.
jsoncols jsoncols is a command line tool for filter JSON data from standard in or specified files.	jsoncols is a command line tool for filter JSON data from standard in or specified files.
jsonrange jsonrange iterates over an array or map returning either a JSON expression or map keep to stdout @Author R. S. Doiel, <rsdoiel@caltech.edu>	jsonrange iterates over an array or map returning either a JSON expression or map keep to stdout @Author R. S. Doiel, <rsdoiel@caltech.edu>
xlsx2csv xlsx2csv.go is a command line utility that converts individual Excel Workbook Sheets to CSV.	xlsx2csv.go is a command line utility that converts individual Excel Workbook Sheets to CSV.
xlsx2json xlsx2json.go is a command line utility that converts an Excel Workboom Sheet into JSON.	xlsx2json.go is a command line utility that converts an Excel Workboom Sheet into JSON.
dotpath dotpath.go package provides a convient way of mapping JSON dot path notation to a nested map structure.	dotpath.go package provides a convient way of mapping JSON dot path notation to a nested map structure.

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL