pandas 批量修改列名_从列表中更改Pandas Dataframe中的列名称

Is is possible to change Column Names using data in a list?

df = pd.DataFrame([[1, 1.0, 2.3,0.2,0.53], [2, 3.35, 2.0,0.2,0.65], [2,3.4,

2.0,0.25,0.55], [3,3.4,2.0,0.25,0.55], [1,3.4,2.0,0.25,0.55],

[3,3.4,2.0,0.25,0.55]],

columns=["ID", "A", "B","C","D"])\

.set_index('ID')

I have my new labels as below:

New_Labels=['NaU', 'MgU', 'AlU', 'SiU']

Is possible to change the names using data in the above list? My original data set has 100 columns and I did not want to do it manually for each column.

I was trying the following using df.rename but keep getting errors. Thanks!

解决方案

Using rename is a formally more correct approach. You just have to provide a dictionary that maps your current columns names to the new ones (thing that will guarantee expected results even in case of misplaced columns)

new_names = {'A':'NaU', 'B':'MgU', 'C':'Alu', 'D':'SiU'}

df.rename(index=str, columns=new_names)

Notice you can provide entries for the sole names you want to substitute, the rest will remain the same.