
平臺(tái) 論壇博客文庫

› 論壇 › 程序設(shè)計(jì) › Shell › awk 數(shù)值計(jì)算

[文本處理] awk 數(shù)值計(jì)算 [復(fù)制鏈接]

寂寞卜孤單

白手起家

論壇徽章:: 1

15-16賽季CBA聯(lián)賽之山東
日期:2016-03-02 14:33:02

電梯直達(dá)

1樓 [收藏(0)] [報(bào)告]

發(fā)表于 2016-01-21 16:43 |只看該作者 |倒序?yàn)g覽

A文件
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-16 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-16 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-16 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-16 欠款 2 T 1412.24
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-15 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-15 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-15 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-15 欠款 2 T 1411.19
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-28 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-28 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-28 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-28 欠款 2 T 1394.38
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-29 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-29 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-29 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-29 欠款 2 T 1394.38
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-13 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-13 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-13 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-13 欠款 2 T 1409.09
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-14 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-14 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-14 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05-14 欠款 2 T 1410.14
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-01 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-01 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-01 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-01 欠款 2 T 1397.53
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-29 【維仕金融】 1
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-29 逾期 2 T
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-29 逾期 2 F
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06-29 欠款 2 T 1394.38
B文件月份當(dāng)月欠款總金額欠款次數(shù)
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05 欠款 2 T 8431.42 6
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06 欠款 2 T 2791.91 2
A文件>>>B文件
以前兩列為Key,當(dāng)?shù)谒牧袨?quot;欠款",第六列為'T'時(shí)(即最后一列第七列不為空)，統(tǒng)計(jì)每月的欠款金額總和以及當(dāng)月欠款次數(shù)并輸出，其他不做處理

文庫|博客

使用正則表達(dá)式與lex實(shí)現(xiàn)詞法分析器
C語言的MIPS匯編實(shí)現(xiàn)（四）SWITCH
Requested init /linuxrc failed (error -2).
比較 csv 文件中數(shù)據(jù)差異
LMD ElPack v2019.7新版亮點(diǎn)：Transparent mode全新升級(jí)|附下載

winee

白手起家

論壇徽章:: 0

2樓 [報(bào)告]

發(fā)表于 2016-01-21 17:42 |只看該作者

awk '$4 == "欠款"{split($3,tmp,"-");sum[tmp[1]tmp[2]] += $NF}END{for (i in sum)print $1,$2,i,$4,$5,$6,sum[i]}' a
185037 59D65A56AB0D1A81A4B9081A779D188B 201506 欠款 2 T 2791.91
185037 59D65A56AB0D1A81A4B9081A779D188B 201505 欠款 2 T 8431.42

實(shí)戰(zhàn)分享：從技術(shù)角度談機(jī)器學(xué)習(xí)入門| 【大話IT】RadonDB低門檻向MySQL集群下戰(zhàn)書 | ChinaUnix打賞功能已上線！ | 新一代分布式關(guān)系型數(shù)據(jù)庫RadonDB知多少？

jason680

富可敵國

論壇徽章:: 145

3樓 [報(bào)告]

發(fā)表于 2016-01-21 23:44 |只看該作者

回復(fù) 1# 寂寞卜孤單

$ awk 'BEGIN{OFS="\t"}$4=="欠款"&&$6=="T"{k=$1"\t"$2"\t"substr($3,1,7);if(!a[k]++){++t;a[t]=k};v[k]+=$7;b=$4;s=$6;m=$5}END{for(n=1;n<=t;n++)print a[n],b,m,s,v[a[n]],a[a[n]]}' FILE
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-05 欠款 2 T 8431.42 6
185037 59D65A56AB0D1A81A4B9081A779D188B 2015-06 欠款 2 T 2791.91 2

實(shí)戰(zhàn)分享：從技術(shù)角度談機(jī)器學(xué)習(xí)入門| 【大話IT】RadonDB低門檻向MySQL集群下戰(zhàn)書 | ChinaUnix打賞功能已上線！ | 新一代分布式關(guān)系型數(shù)據(jù)庫RadonDB知多少？

返回列表

Chinaunix › 論壇 › 程序設(shè)計(jì) › Shell › awk 數(shù)值計(jì)算

積分 0, 距離下一級(jí)還需積分

亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

[文本處理] awk 數(shù)值計(jì)算 [復(fù)制鏈接]