回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想将列的内部提取为多个列。这是导入到dataframe后的原始数据</p>
<pre><code>data = {'ID': ['A0001', 'A0002', 'A0003', 'A0004', 'A0005'],
'Name': ['John', 'Micheal', 'Angle', 'Jim', 'Rome'],
'Details': ['Type:\nHouse\nVector:\nTriangle\n\nMission:\nCompleted,lv5\n\nNote user:\n#', 'Type:\n#\nVector:\n\n\nMission:\nFailed\nNote user:\n#', 'Type:\nCar\nVector:\nSquare\nMission:\nCompleted\nNote user:\n', 'Type:\n#\nVector:\n#\nMission:\nCompleted without award\n\nNote user:\nNo end', 'Type:\n#\nVector:\n#\nMission:\n\n\nNote user:\nThere are many mistake.\nI cant choose.\nI cant buy.']
}
df = pd.DataFrame (data, columns=['ID', 'Name', 'Details'])
df
ID Name Details
A0001 John Type:\nHouse\nVector:\nTriangle\n\nMission:\nCompleted,lv5\n\nNote user:\n#
A0002 Micheal Type:\n#\nVector:\n\n\nMission:\nFailed\nNote user:\n#
A0003 Angle Type:\nCar\nVector:\nSquare\nMission:\nCompleted\nNote user:\n
A0004 Jim Type:\n#\nVector:\n#\nMission:\nCompleted without award\n\nNote user:\nNo end
A0005 Rome Type:\n#\nVector:\n#\nMission:\n\n\nNote user:\nThere are many mistake.\nI cant choose.\nI cant buy.
</code></pre>
<p>我想提取“详细信息”列中的值。但我不知道该怎么做</p>
<p>我预期的数据如下所示</p>
<pre><code>data = {'ID': ['A0001', 'A0002', 'A0003', 'A0004', 'A0005'],
'Name': ['John', 'Micheal', 'Angle', 'Jim', 'Rome'],
'Type': ['House', '#', 'Car', '#', '#'],
'Vector': ['Triangle', '', 'Square', '#', '#'],
'Mission': ['Completed,lv5', 'Failed', 'Completed', 'Completed without award', ''],
'Note user': ['#', '#', '', 'No end', 'There are many mistake.I cant choose.I cant buy.']
}
df = pd.DataFrame (data, columns=['ID', 'Name', 'Type', 'Vector', 'Mission', 'Note user'])
df
ID Name Type Vector Mission Note
A0001 John House Triangle Completed,lv5 #
A0002 Micheal # Failed #
A0003 Angle Car Square Completed
A0004 Jim # # Completed without award No end
A0005 Rome # # There are many mistake.I cant choose.I cant buy.
</code></pre>