擅长:python、mysql、java
<p>有带标量的混合列表,所以首先需要一些预处理,然后通过<code>chain</code>和<code>repeat</code>创建数据帧:</p>
<pre><code>n = [x if isinstance(x, list) else [x] for x in df['Number']]
s = [x if isinstance(x, list) else [x] for x in df['String']]
lens = [len(x) for x in n]
from itertools import chain
df = pd.DataFrame({
'Number' : list(chain.from_iterable(n)),
'String' : list(chain.from_iterable(s)),
'Aut' : df['Aut'].values.repeat(lens)
})
print (df)
Number String Aut
0 12 hi are ppppp
1 13 ho to ppppp
2 34 How qqqqq
3 35 are wwwwwww
</code></pre>