擅长:python、mysql、java
<p>您可以连接<code>explode()</code>,然后将表旋转回所需的输出</p>
<pre><code>df = df.explode('cNames').explode('cValues')
df['cValues'] = pd.to_numeric(df['cValues'])
print(df.pivot_table(columns='cNames',index='number',values='cValues'))
</code></pre>
<p>输出:</p>
<pre><code>cNames a b c d
number
10 2.0 2.0 2.0 NaN
20 66.0 66.0 NaN 66.0
</code></pre>
<p>遗憾的是,explode的输出是<code>object</code>类型,因此,我们必须在旋转之前首先将其转换为<code>pd.to_numeric()</code>。否则,将没有要聚合的数值</p>