擅长:python、mysql、java
<p>要展开所有参数,可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.extractall.html#pandas.Series.str.extractall" rel="nofollow noreferrer">^{<cd1>}</a>:</p>
<pre><code>x = (
df.Misc.str.extractall(r"([^=\s]+)=([^;]+);?")
.groupby(level=0)[[0, 1]]
.apply(lambda x: dict(zip(x[0], x[1])))
.apply(pd.Series)
.fillna("N/A")
)
df_out = pd.concat([df, x], axis=1)
print(df_out)
</code></pre>
<p>印刷品:</p>
<pre class="lang-none prettyprint-override"><code> Misc xxx yyyblah xyx xyz yzxx
0 1. xxx=something;yyyblah=somethingelse;xyx=blah something somethingelse blah N/A N/A
1 2. xyz=meh;yzxx=random;xyx=meh N/A N/A meh meh random
</code></pre>