避免在修改数据帧列名时重复相同的数据帧列名

Question

我有一个超过30列的数据框。我正在对特定的列进行各种修改，并希望找到一种方法来避免总是列出特定的列。有捷径吗

例如：

matrix_bus_filled.loc[matrix_bus_filled['FNR'] == 'AB1122', ["Ice", "Tartlet", "Pain","Fruit","Club","Focaccia","SW of Month","Salad + Dressing","Planchette + bread","Muffin"]] = matrix_bus_filled[matrix_bus_filled['FNR'] == 'AB1120'][["Ice", "Tartlet", "Pain","Fruit","Club","Focaccia","SW of Month","Salad + Dressing","Planchette + bread","Muffin"]].values

我能简单地定义一下术语“SpecificColumns”然后粘贴到这里吗

matrix_bus_filled.loc[matrix_bus_filled['FNR'] == 'AB1122', ["SpecificColumns"]] = matrix_bus_filled[matrix_bus_filled['Flight Number'] == 'AB1120'][["SpecificColumns]].values

这里呢

matrix_bus_filled [["SpecificColumns"]] = matrix_bus_filled [["SpecificColumns"]].apply(scale, axis=1)

Answer 1

只需定义一个列表并使用它来调用列

specific_columns = ["Ice", "Tartlet", "Pain","Fruit","Club","Focaccia","SW of Month","Salad + Dressing","Planchette + bread","Muffin"]

matrix_bus_filled[specific_columns] = matrix_bus_filled[specific_columns].apply(scale, axis=1)