擅长:python、mysql、java
<p>设置</p>
<pre><code>df1=df.reset_index().melt('index')
df1=df1[df1.value.eq(1)]
</code></pre>
<p>1个</p>
<pre><code>df1.groupby('index')['variable'].apply(lambda x : ','.join(x)).to_frame().reindex(df.index)
Out[846]:
variable
2017-01-01 NaN
2017-01-02 W02
2017-01-03 NaN
2017-01-04 W01,W03
</code></pre>
<p>二</p>
<pre><code>df1.groupby('index')['variable'].apply(lambda x : list(x)).apply(pd.Series).reindex(df.index)
Out[852]:
0 1
2017-01-01 NaN NaN
2017-01-02 W02 NaN
2017-01-03 NaN NaN
2017-01-04 W01 W03
</code></pre>