擅长:python、mysql、java
<p>文件格式为(此处名为<code>input.csv</code>):</p>
<pre><code> Gene Element
STBZIP1 G-box
STBZIP1 G-box
STBZIP1 MYC
STBZIP1 MYC
STBZIP1 MYC
STBZIP10 MYC
STBZIP10 MYC
STBZIP10 MYC
STBZIP10 G-box
STBZIP10 G-box
STBZIP10 G-box
STBZIP10 G-box
</code></pre>
<p>这个</p>
<pre><code>import pandas as pd
df = pd.read_csv('input.csv', delim_whitespace=True, skiprows=1)
df.columns = ['Gene', 'Element']
df['Count'] = 1
df = df.pivot_table(index='Gene', columns='Element', aggfunc=sum)
print(df)
</code></pre>
<p>给你</p>
<pre><code> Count
Element G-box MYC
Gene
STBZIP1 2 3
STBZIP10 4 3
</code></pre>