title: Change Df column headers from a list
body: <p>I hope you can help me with this:</p>
  <p>I wanted to know if there was a way to df.rename() from a list?</p>
  <p>In the following code, i selected a df that contains dates as headers, so i wanted to change their format and replace them with the current ones.</p>
  <pre><code>import pandas as pd
  import numpy as np
  from datetime import datetime
  #1)Read CSV File
  df = pd.read_csv('')
  
  
  for col in df.columns[5:]:
      
   
     
  
      df.rename(columns={col:new_format}
  </code></pre>
  <p>everything works until i try to run <code>df.rename(columns={col:new_format})</code></p>
  <p>But doesnt update the df with the new header</p>
  <p>I believe this is because the forloop is overlapping the previous runs.</p>
  <p>Would anyone know a solution to this problem?</p>
  <p>Thanks in advance</p>