重命名列名——Python Pandas
我们可以使用该rename()方法重命名列名。假设以下是具有3列的PandasDataFrame-
dataFrame = pd.DataFrame(
{
"Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'],"Reg_Price": [7000, 1500, 5000, 8000, 9000, 6000],"Units": [90, 120, 100, 150, 200, 130]
}
)我们将两列重命名，即“Car”为“CarNames”，“Reg_Price”为“RegistrationCost”：
dataFrame.rename(columns={dataFrame.columns[0]: 'Car Names', dataFrame.columns[1]: 'Registration Cost'})示例
以下是代码-
import pandas as pd
#创建数据帧
dataFrame = pd.DataFrame(
{
"Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'],"Reg_Price": [7000, 1500, 5000, 8000, 9000, 6000],"Units": [90, 120, 100, 150, 200, 130]
}
)
print"DataFrame ...\n",dataFrame
#重命名列
res = dataFrame.rename(columns={dataFrame.columns[0]: 'Car Names', dataFrame.columns[1]: 'Registration Cost'})
print"\nUpdated DataFrame with renamed column names...\n",res输出结果这将产生以下输出-
DataFrame ...
Car Reg_Price Units
0 BMW 7000 90
1 Lexus 1500 120
2 Tesla 5000 100
3 Mustang 8000 150
4 Mercedes 9000 200
5 Jaguar 6000 130
Updated DataFrame with renamed column names...
Car Names Registration Cost Units
0 BMW 7000 90
1 Lexus 1500 120
2 Tesla 5000 100
3 Mustang 8000 150
4 Mercedes 9000 200
5 Jaguar 6000 130