擅长:python、mysql、java
<p>使用:</p>
<pre><code>def expand(col):
return (
col.astype(str)
.replace('', np.nan).dropna().str.split(r"\s\\n")
.explode().reset_index(drop=True)
)
df[["column1", "column2", "column3"]] = df[[
"column1", "column2", "column3"]].apply(expand)
print(df)
</code></pre>
<p>这张照片是:</p>
<pre><code> column1 column2 column3
0 3 2 8
1 9 89 56
2 8 6 4
3 4 12 32
4 9 12 5
5 78 68 56
</code></pre>