<h2>第2版:</h2>
< P> <强>重复行,移动面部2至面部1,也考虑Typol值< /强> </P>
<pre><code>c = ['Date','ID','Typol','Facial#1','Facial#2']
d = [['abril',426,'COR',1000,500],
['test1',537,'LAR',1500,750]]
import pandas as pd
df = pd.DataFrame(d,columns=c)
df['Typol_X'] = df['Typol']
df.loc[(df['Typol'] == 'COR'), 'Typol_X'] = 'LAR'
df.loc[(df['Typol'] == 'LAR') & (df['Typol_X'] == 'LAR'), 'Typol_X'] = 'COR'
print (df)
df = df.loc[df.index.repeat(2)]
df.iloc[1::2,3] = df.iloc[::2,4]
df.iloc[1::2,2] = df.iloc[::2,5]
df.drop(['Facial#2','Typol_X'], axis=1,inplace=True)
df.reset_index(drop=True, inplace=True)
print (df)
</code></pre>
<p>其输出将为:</p>
<p><strong>原始数据帧:</strong></p>
<pre><code> Date ID Typol Facial#1 Facial#2 Typol_X
0 abril 426 COR 1000 500 LAR
1 test1 537 LAR 1500 750 COR
</code></pre>
<p><strong>更新的数据帧:</strong></p>
<pre><code> Date ID Typol Facial#1
0 abril 426 COR 1000
1 abril 426 LAR 500
2 test1 537 LAR 1500
3 test1 537 COR 750
</code></pre>
<h2>第1版:</h2>
<p><strong>复制行,将面部2移动到面部1</strong></p>
<p>另一种方法如下:</p>
<pre><code>c = ['Date','ID','Typol','Facial#1','Facial#2']
d = [['abril',426,'COR',1000,500],
['test1',537,'DPS',1500,750]]
import pandas as pd
df = pd.DataFrame(d,columns=c)
df = df.loc[df.index.repeat(2)]
df.iloc[1::2,3] = df.iloc[::2,4]
df.drop(['Facial#2'], axis=1,inplace=True)
df.reset_index(drop=True, inplace=True)
print (df)
</code></pre>
<p>其输出将为:</p>
<p><strong>原始数据帧:</strong></p>
<pre><code> Date ID Typol Facial#1 Facial#2
0 abril 426 COR 1000 500
1 test1 537 DPS 1500 750
</code></pre>
<p><strong>更新的数据帧:</strong></p>
<pre><code> Date ID Typol Facial#1
0 abril 426 COR 1000
1 abril 426 COR 500
2 test1 537 DPS 1500
3 test1 537 DPS 750
</code></pre>