擅长:python、mysql、java
<p>因此,假设您的数据如下所示:
<a href="https://i.stack.imgur.com/lfJSr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lfJSr.png" alt="enter image description here"/></a></p>
<p>我们可以做到:</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
data = pd.read_csv('doc.csv')
</code></pre>
<p>得到
<a href="https://i.stack.imgur.com/PUwzH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PUwzH.png" alt="enter image description here"/></a></p>
<p>最后</p>
<pre class="lang-py prettyprint-override"><code>split_by_comma = data.col1.str.split(',').tolist()
blood_group = [lst[0].split('- ')[1] for lst in split_by_comma]
hiv = [lst[1].split('- ')[1] for lst in split_by_comma]
pd.DataFrame({'Blood Group': blood_group, 'HIV/HBsAg/HCV': hiv})
</code></pre>
<p>要获得此信息:
<a href="https://i.stack.imgur.com/zWyOn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zWyOn.png" alt="enter image description here"/></a></p>