<p>我正在尝试处理以下错误:<code>ValueError: cannot reindex from a duplicate axis</code>。
我的数据集看起来像</p>
<pre><code>first_column second_column ... fifth_column ... eleventh_column ... Age
example 1 first ex ['avers','aaa','hello'] 41241 12
example 2 second ex [] 431 32
another third ex ['AA','B','C','aaa','hello'] 21 32
example 1 example ['avers','aaa','hello'] 41241 12
</code></pre>
<p>我想要这样的东西:</p>
<pre><code>first_column second_column ... fifth_column ... eleventh_column ... Age
example 1 first ex avers 41241 12
example 1 first ex aaa 41241 12
example 1 first ex hello 41241 12
example 2 second ex nan 431 32
another third ex AA 21 32
another third ex B 21 32
another third ex C 21 32
another third ex aaa 21 32
another third ex hello 21 32
example 1 example avers 41241 12
example 1 example aaa 41241 12
example 1 example hello 41241 12
</code></pre>
<p>根据我的理解,我应该申请<code>explode</code>:</p>
<pre><code>df = df.loc[:,~df.columns.duplicated()]
df1=df.set_index('first_column').apply(pd.Series.explode).reset_index()
df1.fifth_column
</code></pre>
<p>但是,我得到了一个错误:</p>
<pre><code>ValueError: cannot reindex from a duplicate axis.
</code></pre>
<p>我做错了什么</p>