回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个dataframe,它有一个非常不一致的列。例如:</p>
<pre><code>df = pd.DataFrame(columns=["CID", "CM"], data=[['xxx-1','skill_start=skill1,skill2,||skill_complete=skill1,'],['xxx-2','survey=1||skill_start=skill1,skill3||skill_complete=skill3'],['xxx-3','skill_start=skill2,skill3||skill_complete=skill2,skill3||abandon_custom=0']])
</code></pre>
<p>我正在尝试拆分CM列。我试过这个,它让我非常接近:</p>
<p><code>df = df.join(metrics['CM'].str.split('\|\|', expand=True).add_prefix('CM'))</code></p>
<p>但由于数据不一致,列排列不整齐。我该如何分类呢</p>
<p>所需输出示例:</p>
<p><code>['CID', 'survey', 'skill_start', 'skill_complete', 'abandon_custom'],['xxx-1','NaN','skill1,skill2','skill1','NaN'],['xxx-2','1','skill1,skill3','skill3','NaN'],['xxx-3','NaN','skill2,skill3','skill2,skill3','0']</code></p>