擅长:python、mysql、java
<p>根据<code>Type</code>列将它们分为两个数据帧之后,可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.merge.html" rel="nofollow">^{<cd1>}</a>。你知道吗</p>
<pre><code>In [14]: df_1 = df.loc[(df['Type'] == "Beta"), ['Samples', 'variable', 'value']]
In [15]: df_2 = df.loc[(df['Type'] == "FPKM"), ['Samples', 'value']]
In [16]: df_1['Beta'] = df_1['value']
In [17]: df_2['FPKM'] = df_2['value']
In [18]: df_1[['Samples', 'variable', 'Beta']].merge(df_2[['Samples', 'FPKM']], on="Samples")
Out[18]:
Samples variable Beta FPKM
0 PE01I 267N12.3_Beta 0.066517 0.000000
1 PE01R R267N12.3_Beta 0.061617 0.003430
2 PE02I 267N12.3_Beta 0.071013 0.272144
3 PE02R 267N12.3_Beta 0.056623 0.005753
4 PE03I 267N12.3_Beta 0.071633 0.078708
</code></pre>