<p>添加数据帧:</p>
<pre><code>import pandas as pd
import numpy as np
data2 = {'RecordID': ['a', 'b', 'c'],
'good': [0, 1, 1],
'bad': [0, 0, 1],
'horrible': [0, 1, 1],
'ok': [1, 0, 0]}
# Convert the dictionary into DataFrame
df = pd.DataFrame(data2)
</code></pre>
<p>熔化数据:
<a href="https://pandas.pydata.org/docs/reference/api/pandas.melt.html" rel="nofollow noreferrer">https://pandas.pydata.org/docs/reference/api/pandas.melt.html</a></p>
<pre><code>melted = df.melt(id_vars='RecordID', var_name='Column', value_name='Value')
melted
</code></pre>
<p><a href="https://i.stack.imgur.com/p7evK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p7evK.png" alt="enter image description here"/></a></p>
<p>可选:分组方式-对于总和或平均值:</p>
<pre><code>f2 = melted.groupby(['Column']).sum()
df2
</code></pre>
<hr/>
<p><a href="https://i.stack.imgur.com/fFf1B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fFf1B.png" alt="enter image description here"/></a></p>
<p><a href="https://i.stack.imgur.com/idbUR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/idbUR.png" alt="enter image description here"/></a></p>