擅长:python、mysql、java
<p>下面是一个用Python2.7实现的方法</p>
<pre><code>from collections import Counter
with open("in.txt") as f:
next(f) # do this to skip the first row of the file
c = Counter(tuple(row.split()) for row in f if not row.isspace())
sites = sorted(set(x[0] for x in c))
species = sorted(set(x[1] for x in c))
print 'Site\t', '\t'.join(species)
for site in sites:
print site,'\t', '\t'.join(str(c[site, spec]) for spec in species)
</code></pre>