擅长:python、mysql、java
<p>可能有一些方法可以使用这些函数,但是您可以不使用它们,而是将其拆分为两个数据帧,然后使用append()将它们堆叠起来。在</p>
<pre><code>df = pd.DataFrame([['John','Sept',1,'Dec',2],['Jane','Sept',1,'Dec',3],['James','Sept',2,'Dec',2]],columns=['Name','Test 1','Score 1','Test 2','Score 2'])
# split off frame 1
df1 = df.loc[:,['Name','Test 1','Score 1']]
df1.columns = ['Name','Date','Score']
df1['Test'] = 1
df1
Out[4]:
Name Date Score Test
John Sept 1 1
Jane Sept 1 1
James Sept 2 1
# split off frame 2
df2 = df.loc[:,['Name','Test 2','Score 2
df2 = df.loc[:,['Name','Test 2','Score 2']]
df2.columns = ['Name','Date','Score']
df2['Test'] = 2
df2
Out[5]:
Name Date Score Test
John Dec 2 2
Jane Dec 3 2
James Dec 2 2
# combine the two frames
df = df1.append(df2)
df.sort_values('N
df = df1.append(df2)
df.sort_values('Name')
Out[6]:
Name Date Score Test
James Sept 2 1
James Dec 2 2
Jane Sept 1 1
Jane Dec 3 2
John Sept 1 1
John Dec 2 2
</code></pre>