title: Convert row to column header for Pandas DataFrame,
body: <p>The data I have to work with is a bit messy.. It has header names inside of its data. How can I choose a row from an existing pandas dataframe and make it (rename it to) a column header?</p>
  
  <p>I want to do something like:</p>
  
  <pre><code>header = df[df['old_header_name1'] == 'new_header_name1']
  
  df.columns = header
  </code></pre>