擅长:python、mysql、java
<p>首先将类别列中的大写T替换为小写:</p>
<pre><code>df['category']=df['category'].str.replace('T','t')
</code></pre>
<p>现在使用<code>pd.get_dummies()</code>、<code>drop()</code>和<code>reset_index()</code>方法:</p>
<pre><code>out=pd.get_dummies(df.set_index('project').drop(['ftecount>3','bpssscore','lifecycle'],1)).reset_index()
</code></pre>
<p>最后使用<code>gt()</code>和<code>astype()</code>方法:</p>
<pre><code>out['ftecount>3']=df['ftecount>3'].gt(3).astype(int)
out['bpssscore']=df['bpssscore'].gt(3).astype(int)
</code></pre>
<p>现在,如果您打印<code>out</code>,您将获得:</p>
<p><a href="https://i.stack.imgur.com/pBya2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pBya2.png" alt="enter image description here"/></a></p>