GitHub - mithrandie/csvq: SQL-like query language for csv
Csvq is intended for one-time queries and routine processing described in source files on the amount of data that can be handled by spreadsheet applications. It is not suitable for handling very large data since all data is kept on memory when queries are executed. There is no indexing, calculation order optimization, etc., and the execution speed is not fast due to the inclusion of mechanisms for
jq コマンドで JSON を CSV に変換する
jq can mangle the data format that you have into the one that you want with very little effort, and the program to do… とっても優秀な jq コマンドは、ご丁寧にフィルターで加工した値をCSV形式で出力する機能を用意してくれています。 > jq -r '<CSV 形式で出力したい要素を取り出すフィルター> | @csv'最期の|@csv が重要です。 簡単な例を使って、振る舞いを確認してみます。 出力(1) サンプルデータ(sample1.json)の内容の確認> cat sample1.json [ {"key1": "value11", "key2": "value12", "key3": "value13"}, {"key1": "value21", "key2":
シェル芸で使いたい jqイディオム - Qiita
$ jq -h jq - commandline JSON processor [version 1.5] Usage: jq [options] <jq filter> [file...] jq is a tool for processing JSON inputs, applying the given filter to its JSON text inputs and producing the filter's results as JSON on standard output. The simplest filter is ., which is the identity filter, copying jq's input to its output unmodified (except for formatting). For more advanced filters
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
GitHub - alingse/jsoncsv: a command tool easily convert json file to csv or xlsx wiki https://deepwiki.com/alingse/jsoncsv
GitHub - y01m/dig-options: command line options of dig
GitHub - greymd/teip: Masking tape to help commands "do one thing well"
GitHub - YS-L/csvlens: Command line csv viewer
GitHub - benhoyt/goawk: GoAWK: an AWK interpreter written in Go
GitHub - harelba/q: q - Run SQL directly on delimited files and multi-file sqlite databases
csvや標準入力をsqlで取得できるqコマンド - Qiita