我有以下資料框
recycling 1 metric tonne (1000 kilogram) per waste type Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4 Unnamed: 5
0 1 barrel oil is approximately 159 litres of oil NaN NaN NaN NaN NaN
1 NaN NaN NaN NaN NaN NaN
2 material Plastic Glass Ferrous Metal Non-Ferrous Metal Paper
3 energy_saved 5774 Kwh 42 Kwh 642 Kwh 14000 Kwh 4000 kWh
4 crude_oil saved 16 barrels NaN 1.8 barrels 40 barrels 1.7 barrels
作為參考，請查看影像：
我想要做的是將第 2、3、4 行放入新資料框中的列中。它應該看起來像這樣..
material energy_saved crude_oil saved
plastic 5774Kwh 16 barrels
Glass 42 Kwh NaN
... ... ...
我嘗試使用.melt但它不起作用。如果您注意到，列名稱及其值都在一行中。我只希望它們作為 col 和 value 位于新的資料框中。
uj5u.com熱心網友回復：
IIUC，是不是只是：
out = df.loc[[2,3,4],:].T.reset_index(drop=True)
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/388979.html
上一篇：從串列中洗掉特定值