擅长:python、mysql、java
<p>如果数据中有多个输入错误,可能需要<code>split</code>两次才能将格式返回<code>dict</code>,然后将<code>dict</code>传递给<code>pandas.DataFrame</code>构造函数</p>
<pre><code>pd.DataFrame([dict(x)for x in df.Read.str.split('&').apply(lambda x : [tuple(y.split('=',1)) for y in x])])
Out[128]:
Column1 Column2 Column3 Column4 Column5 column4
0 variable11 variable12 variable13 NaN NaN variable14
1 variable1=21 variable22 variable23 NaN NaN NaN
2 variable1=31 variable32 variable33 variable34 variable35 NaN
df=pd.DataFrame([dict(x)for x in df.Read.str.split('&').apply(lambda x : [tuple(y.split('=',1)) for y in x])])
df.columns=df.columns.str.upper()
df=df.sum(axis=1,level=0)
</code></pre>