擅长:python、mysql、java
<p>让我们尝试<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.get_dummies.html" rel="nofollow noreferrer">^{<cd1>}</a>标记值&<code>groupby</code>索引以减少数据帧<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html" rel="nofollow noreferrer">^{<cd3>}</a>沿列索引将创建的<code>dummies</code>与<code>original dataframe</code>连接起来</p>
<pre><code>import pandas as pd
dummies = (
pd.get_dummies(df.hoppy.str.split("/").explode())
.groupby(level=0).sum()
)
print(pd.concat([df, dummies], axis = 1))
</code></pre>
<hr/>
<pre><code>personID hoppy baseball reading soccer
0 x1234 baseball/soccer 1 0 1
1 y1234 reading/baseball 1 1 0
2 z1234 NaN 0 0 0
3 a1234 soccer 0 0 1
</code></pre>