未分類

memo

メモ

sort -t, -k1,1 -k2,2nr test.txt | uniq -w4

cat hoge.csv | awk -F, '{arr[$1] = arr[$1] + $2}END{for(i in arr){print i , arr[i]} }'

cat transport-inputdata-22-1.csv | awk -F, '$3=="バス"{sum_bus+=$7}$3=="電車"{sum_train+=$7}END{print "バス:"sum_bus;print "電車:"sum_train;print "合計:"sum_bus+sum_train}'

https://atmarkit.itmedia.co.jp/ait/articles/1704/06/news025.html

-未分類