python - 如何在读取 CSV 文件后重命名熊猫列

Question

我有以下文件：

https://dzbqqjpt.labs.coursera.org/notebooks/assignments/assignment3/assets/Energy%20Indicators.xls

我正在读它，跳过页眉和页脚行

Energy = pd.read_excel('assets/Energy Indicators.xls', header=None, sheet_name='Energy', skiprows=18, skip_footer=38
                       )  

Energy.rename(columns={Energy.columns[2]:'Country'})
Energy.rename(columns={Energy.columns[3]:'Energy Supply'})
Energy.rename(columns={Energy.columns[4]:'Energy Supply per Capita'})
Energy.rename(columns={Energy.columns[5]:'% Renewable'})


print(Energy)

当我打印它时，我得到这个输出：

   0                          1                          2     3    4  \
0   NaN                Afghanistan                Afghanistan   321   10   
1   NaN                    Albania                    Albania   102   35   
2   NaN                    Algeria                    Algeria  1959   51   
3   NaN             American Samoa             American Samoa   ...  ...   
4   NaN                    Andorra                    Andorra     9  121   
..   ..                        ...                        ...   ...  ...   
222 NaN                   Viet Nam                   Viet Nam  2554   28   
223 NaN  Wallis and Futuna Islands  Wallis and Futuna Islands     0   26   
224 NaN                      Yemen                      Yemen   344   13   
225 NaN                     Zambia                     Zambia   400   26   
226 NaN                   Zimbabwe                   Zimbabwe   480   32   

              5  
0     78.669280  
1    100.000000  
2      0.551010  
3      0.641026  
4     88.695650  
..          ...  
222   45.321520  
223    0.000000  
224    0.000000  
225   99.714670  
226   52.536120  

[227 rows x 6 columns]

所以我不明白为什么列的重命名不起作用，它仍然打印 6 列，应该只有 4 列。

标签： pythonpandas