回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我试图删除数据框中的重复值和空格,然后对所有值重新排序,以便在一行中,所有列值以相同的数字结尾:</p>
<p><strong>这是我当前的数据帧:</strong></p>
<pre><code> brand code des price year
0 brand1 code1 des1 price1 year1
1 brand2 code2 price2
2 brand3 code3 des3 price3 year3
3 brand4 code4 price4
4 brand5 code5 des5 price5 year5
5 brand6 code6 price6
6 code2 des2 year2
7 code4 des4 year4
8 code6 des6 year6
</code></pre>
<p><strong>这就是我想要的输出:</strong></p>
<pre><code> brand code des price year
0 brand1 code1 des1 price1 year1
1 brand2 code2 des2 price2 year2
2 brand3 code3 des3 price3 year3
3 brand4 code4 des4 price4 year4
4 brand5 code5 des5 price5 year5
5 brand6 code6 des6 price6 year6
</code></pre>
<p>这是我写的代码,如果有人能指导我怎么做,我将非常感激:</p>
<pre><code>import pandas as pd
data = {
'code': ['code1','code2','code3','code4','code5','code6','code2','code4','code6'],
'des': ['des1','','des3','','des5','','des2','des4','des6'],
'price': ['price1','price2','price3','price4','price5','price6','','',''],
'year': ['year1','','year3','','year5','','year2','year4','year6'],
'brand': ['brand1','brand2','brand3','brand4','brand5','brand6','','','']
}
df = pd.DataFrame.from_dict(data)
print(df)
</code></pre>