擅长:python、mysql、java
<p>我会用awk:</p>
<pre><code>awk -F, 'NR==1{print} NR>1{a[$1] += $2}END{for (i in a) print i","a[i]}' file
</code></pre>
<p>如果要忽略空行,可以忽略小于2列的行:</p>
<pre><code>awk -F, 'NR==1{print} NR>1 && NF>1{a[$1] += $2} END{for (i in a) print i","a[i]}' file
</code></pre>
<p>或者忽略没有两列的:</p>
<pre><code>awk -F, 'NR==1{print} NR>1 && NF==2{a[$1] += $2} END{for (i in a) print i","a[i]}' file
</code></pre>
<p>或者,您可以检查第二列是否以数字开头:</p>
<pre><code>awk -F, 'NR==1{print} NR>1 && $2~/^[0-9]/{a[$1] += $2} END{for (i in a) print i","a[i]}' file
</code></pre>