擅长:python、mysql、java
<p>我将创建一个列映射器字典,您可以随时间添加到其中:</p>
<pre><code>col_map = {
"postcode": "PostCode",
"brands": "brand",
}
col_order = ["PostCode", "brand"]
renamed_df = df.columns.map(lambda x: col_map.get(x, x)) # <- Renames the cols to the dict values
ouput = renamed_df.reindex(columns=col_order ) # <- reorders the cols based on the config list
</code></pre>
<p><strong>注意</strong>
<code>col_map.get(x, x)</code>如果是新的,则返回到提供的列,即“品牌”</p>
<p>相反,如果您希望它出错,以便能够轻松识别问题并更新<code>col_map</code>,则可以使用<code>df.columns.map(col_map)</code></p>