擅长:python、mysql、java
<p>使用<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.set_index.html" rel="nofollow noreferrer">^{<cd1>}</a>和<code>append=True</code>表示<code>MultiIndex</code>并通过<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.unstack.html" rel="nofollow noreferrer">^{<cd4>}</a>重塑形状,然后删除不必要的列并通过<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.join.html" rel="nofollow noreferrer">^{<cd5>}</a>连接到原始列:</p>
<pre><code>df1 = df.set_index('PARMAM_NAME', append=True)['PARMAM_VALUE'].unstack()
df = df.drop(['PARMAM_NAME','PARMAM_VALUE'],axis=1).join(df1)
print (df)
col1 col2 a b c d
0 1 1 100.0 NaN NaN NaN
1 2 2 NaN 200.0 NaN NaN
2 3 3 NaN NaN 300.0 NaN
3 4 4 NaN NaN NaN 400.0
</code></pre>