擅长:python、mysql、java
<p>你需要<a href="https://docs.scipy.org/doc/numpy/reference/generated/numpy.repeat.html" rel="nofollow noreferrer">np.repeat</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.stack.html" rel="nofollow noreferrer">df.stack()</a></p>
<pre><code>out_df=pd.DataFrame(columns=df.columns)
out_df['Machine']=np.repeat(df['Machine'].values,repeats=len(df['Application'].str.split(';')),axis=0)
out_df['Vulnerability']=np.repeat(df['Vulnerability'].values,repeats=len(df['Application'].str.split(';')),axis=0)
out_df['Application']=df['Application'].str.split(';',expand=True).stack().values
print(out_df)
Machine Vulnerability Application
0 1 vuln1 App1
1 1 vuln1 App2
2 1 vuln1 App3
3 1 vuln2 App1
4 1 vuln2 App2
5 1 vuln2 App3
6 1 vuln3 App1
7 1 vuln3 App2
8 1 vuln3 App3
</code></pre>