datatools

README

datatools

Command line utilities for simplifying work with CSV, JSON, Excel Workbooks and plain text files or content.

• csvcols - a tool for formatting command line arguments intoa CSV row or filtering CSV rows for specific columns
• csvfind - a tool for filtering a CSV file by column's value
• csvjoin - a tool to join to CSV files on common values in designated columns, writes combined CSV rows to stdout
• csv2json - a tool to take a CSV file and convert it into a JSON blob array or a list of JSON blobs one per line
• csv2mdtable - a tool to render CSV as a Github Flavored Markdown table
• csv2xlsx - a tool to take a CSV file and add it as a sheet to a Excel Workbook file.
• 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 (ARM7). See https://github.com/caltechlibrary/datatools/releases.

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

Overview

datatools package is a collection of Go based command line tools for working with JSON content

@Author R. S. Doiel, <rsdoiel@caltech.edu>

Copyright (c) 2017, Caltech All rights not granted herein are expressly reserved by Caltech.

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.

2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

3. Neither the name of the copyright holder nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Index

• Constants
• func ApplyStopWords(fields []string, stopWords []string) []string
• func CSVMarshal(fields []string) ([]byte, error)
• func Filter(c rune, allowableCharacters string, allowPunctuation bool) bool
• func Levenshtein(src string, target string, insertCost int, deleteCost int, substituteCost int, ...) int
• func NormalizeDelimiter(s string) string
• func Text2Fields(r *bufio.Reader, options *Options) ([]byte, error)
• type Options

Constants

const (
	Version = "v0.0.7"

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

	// Constants for datatools functions
	AsDelimited = iota
	AsCSV       = iota
	AsJSON      = iota
)

Functions

func ApplyStopWords

func ApplyStopWords(fields []string, stopWords []string) []string

ApplyStopWords takes a list of words (array of strings) and removes any occurrences of the stop words return a revised list of words.

func CSVMarshal

func CSVMarshal(fields []string) ([]byte, error)

CSVMarshal takes a list of strings and returns a byte array of CSV formated output.

func Filter

func Filter(c rune, allowableCharacters string, allowPunctuation bool) bool

Filter filters out characters from string. By default it allows letters and numbers through with options for allow punctuation and other specific characters. Returns true if matches filter, false otherwise

func Levenshtein

func Levenshtein(src string, target string, insertCost int, deleteCost int, substituteCost int, caseSensitive bool) int

Levenshtein does a fuzzy match on two strings.

func NormalizeDelimiter

func NormalizeDelimiter(s string) string

NormalizeDelimiters handles the messy translation from a format string recieved as an option in the cli to something useful to pass to Join.

func Text2Fields

func Text2Fields(r *bufio.Reader, options *Options) ([]byte, error)

Text2Fields process a io.Reader as input and returns byte array of fields and error Options provides the configuration to apply

Types

type Options

type Options struct {
	AllowCharacters  string
	AllowPunctuation bool
	ToLower          bool
	ToUpper          bool
	StopWords        []string
	Delimiter        string
	Format           int
}

Options is the data structure to configure the Text2Fields parser