To concentrate on the need to rename of replace column names that has a pre-present list, I am going to produce a new sample dataframe df with Preliminary column names and unrelated new column names. Your authentic is suitable as-is, except you need to take away the problem mark at the end mainly