擅长:python、mysql、java
<p>首先用分号扩展dataframe,然后使用<code>melt</code>函数来创建预期的输出。你知道吗</p>
<pre><code>df1= pd.concat([df, df['Application'].str.split(';', expand=True)], axis=1)
df1.melt(['Machine','Vulnerability'], value_name='a').drop('variable', 1)
# Machine Vulnerability a
# 0 1 vuln1 App1
# 1 1 vuln2 App1
# 2 1 vuln3 App1
# 3 1 vuln1 App2
# 4 1 vuln2 App2
# 5 1 vuln3 App2
# 6 1 vuln1 App3
# 7 1 vuln2 App3
# 8 1 vuln3 App3
</code></pre>