擅长:python、mysql、java
<p>我假设第2行和第3行的<code>Column1=variable1=21</code>是错误的</p>
<pre><code>df = pd.read_csv('file', header=None)
df = df[0].str.split('=|&', expand=True)
tmp = df.loc[:,1::2].copy()
tmp.columns = df.loc[:,::2].apply(lambda x: x.dropna().iloc[0])
</code></pre>
<p>输出</p>
<pre><code> Column1 Column2 Column3 column4 Column5
0 variable11 variable12 variable13 variable14 None
1 variable21 variable22 variable23 None None
2 variable31 variable32 variable33 variable34 variable35
</code></pre>