{"id":1183,"date":"2020-06-18T12:08:27","date_gmt":"2020-06-18T03:08:27","guid":{"rendered":"https:\/\/www.kwonline.org\/memo2\/?p=1183"},"modified":"2020-06-18T12:08:27","modified_gmt":"2020-06-18T03:08:27","slug":"ubuntu-transpose-csv-columns-rows-with-datamash","status":"publish","type":"post","link":"https:\/\/www.kwonline.org\/memo2\/2020\/06\/18\/ubuntu-transpose-csv-columns-rows-with-datamash\/","title":{"rendered":"Ubuntu: datamash \u30b3\u30de\u30f3\u30c9\u3067CSV\u3092\u7e26\u6a2a\u5909\u63db"},"content":{"rendered":"<p>\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067CSV\u3092\u7e26\u6a2a\u5909\u63db\u51fa\u6765\u308bdatamash\u30b3\u30de\u30f3\u30c9\u304c\u4fbf\u5229\u306a\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<p>\u307e\u305a\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n$ sudo apt install datamash -y\r\n<\/pre>\n<p>CSV\u30d5\u30a1\u30a4\u30eb\u3092\u7528\u610f\u3059\u308b\u3002<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n1,2,3\r\nhoge,fuga,piyo\r\nfoo,bar,baz\r\n<\/pre>\n<p>datamash\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n$ cat tmp.csv | datamash transpose -t,\r\n\r\n1,hoge,foo\r\n2,fuga,bar\r\n3,piyo,baz\r\n<\/pre>\n<p>\u7e26\u6a2a\u304c\u5165\u308c\u66ff\u308f\u3063\u3066\u51fa\u529b\u3055\u308c\u308b\u3002<\/p>\n<p>\u5217\u6570\u304c\u4e0d\u63c3\u3044\u306a\u5834\u5408\u306f\u3001 &#8211;no-strict \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u3048\u3070\u8db3\u308a\u306a\u3044\u30ab\u30e9\u30e0\u306f N\/A \u3068\u3044\u3046\u6587\u5b57\u3067\u57cb\u3081\u3066\u304f\u308c\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067CSV\u3092\u7e26\u6a2a\u5909\u63db\u51fa\u6765\u308bdatamash\u30b3\u30de\u30f3\u30c9\u304c\u4fbf\u5229\u306a\u306e\u3067\u30e1\u30e2\u3002 \u307e\u305a\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002 $ sudo apt install datamash -y CSV\u30d5\u30a1\u30a4\u30eb\u3092\u7528\u610f\u3059\u308b\u3002 1,2,3 hoge,fu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1183","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/comments?post=1183"}],"version-history":[{"count":2,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1183\/revisions"}],"predecessor-version":[{"id":1187,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/posts\/1183\/revisions\/1187"}],"wp:attachment":[{"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/media?parent=1183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/categories?post=1183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kwonline.org\/memo2\/wp-json\/wp\/v2\/tags?post=1183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}