擅长:python、mysql、java
<p>首先创建示例数据帧:</p>
<pre><code>import pandas as pd
rows = [1, 'it1', 2, 'it2', 3, 'it3']
cols = ['items_0_trialAreas_0_id', 'items_0_trialAreas_0_name', 'items_1_trialAreas_0_id', 'items_1_trialAreas_0_name', 'items_2_trialAreas_0_id', 'items_2_trialAreas_0_name']
df = pd.DataFrame(rows).T
df.columns = cols
</code></pre>
<p>然后添加:</p>
<pre><code>df1 = df.iloc[:,::2].T.reset_index().drop('index', axis=1)
df2 = df.iloc[:,1::2].T.reset_index().drop('index', axis=1)
df_final = pd.concat([df1, df2], axis=1)
df_final.columns = ['item_trialAreas_ids', 'item_trialAreas_names']
</code></pre>
<p>输出:</p>
<pre><code> item_trialAreas_ids item_trialAreas_names
0 1 it1
1 2 it2
2 3 it3
</code></pre>