回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我想按条件删除重复的列
所以我想做的是,当“类型”是相同的(重复的)时,去掉“数字”一</p>
<p>我知道了</p>
<pre><code>data={"col1":[2,3,4,5,9,2,6],
"col2":[4,2,4,6,0,1,5],
"col3":[7,6,0,11,3,6,7],
"col4":[14,11,22,8,6,3,9],
"col5":[0,5,7,3,8,2,9],
"type":["A","A","C","D","B","B","E"],
"number":["one","two","two","one","one","two","two"]}
df=pd.DataFrame.from_dict(data)
</code></pre>
<p>我想要这个</p>
<pre><code>data={"col1":[3,4,5,2,6],
"col2":[2,4,6,1,5],
"col3":[6,0,11,6,7],
"col4":[11,22,8,3,9],
"col5":[5,7,3,2,9],
"type":["A","C","D","B","E"],
"number":["two","two","one","two","two"]}
df=pd.DataFrame.from_dict(data)
</code></pre>