擅长:python、mysql、java
<p>如果你不喜欢熊猫,想留在标准图书馆:</p>
<p><strong>代码:</strong></p>
<pre><code>import csv
from collections import Counter
with open('file1', 'rU') as f:
reader = csv.reader(f, delimiter='\t')
header = next(reader)
lines = [line for line in reader]
counts = Counter([l[1] for l in lines])
new_lines = [l + [str(counts[l[1]])] for l in lines]
with open('file2', 'wb') as f:
writer = csv.writer(f, delimiter='\t')
writer.writerow(header + ['Total_GeneralID'])
writer.writerows(new_lines)
</code></pre>
<p><strong>结果:</strong></p>
^{pr2}$