擅长:python、mysql、java
<pre class="lang-py prettyprint-override"><code>
import pandas as pd
d = {'cNames': [['a','b','c'], ['a','b','d']], 'cValues': [[1,2,3],
[55,66,77]], 'number': [10,20]}
df = pd.DataFrame(data=d)
df['series'] = df.apply(lambda x: dict(zip(x['cNames'], x['cValues'])), axis=1)
df = pd.concat([df['number'], df['series'].apply(pd.Series)], axis=1)
print(df)
number a b c d
0 10 1.0 2.0 3.0 NaN
1 20 55.0 66.0 NaN 77.0
</code></pre>
<p>如果列顺序重要:</p>
<pre class="lang-py prettyprint-override"><code>
columns = ['a', 'b', 'c', 'd', 'number']
df = df[columns]
a b c d number
0 1.0 2.0 3.0 NaN 10
1 55.0 66.0 NaN 77.0 20
</code></pre>