擅长:python、mysql、java
<p>将<a href="https://docs.python.org/3.6/library/itertools.html#itertoos.product" rel="nofollow noreferrer">^{<cd1>}</a>与<code>list comprehenion</code>一起使用,仅首先使用<code>applymap</code>创建列表:</p>
<pre><code>from itertools import product
df1 = df.applymap(lambda x: x.split(', ') if isinstance (x, str) else [x])
df2 = pd.DataFrame([j for i in df1.values for j in product(*i)], columns=df.columns)
print (df2)
Origin Destination Weight
0 PVG AMS 10000
1 PVG FRA 10000
2 CAN LAX 25000
3 CAN ORD 25000
4 XMN LAX 25000
5 XMN ORD 25000
</code></pre>