title: In pandas, can I add a new row with the colum names?
body: <p>I'm dealing with messy data and upon import the header of the DF has values I actually need, Can I convert these to rows and perhaps remove the column name or rename them? My end goal here is to convert this to a json from pandas.</p>
  <p><code>df</code></p>
  <pre><code>    Url                     https://www.intuit.com/oidam/intuit/ic/en_us/content/intuit-cr-report-2020-icom.pdf
  0   company_id              53
  1   current_value scope 1   1912
  2   current_value scope 2   5136
  3   current_value scope 3   30476 
  </code></pre>
  <p>You can see it's all key values except the header for the first column is Url so when I later do, <code>df.to_json()</code> I get:</p>
  <pre><code>{&quot;Url&quot;:{&quot;0&quot;:&quot;company_id&quot;,&quot;1&quot;:&quot;current_value scope 1&quot;,&quot;2&quot;:&quot;current_value scope 2&quot;,&quot;3&quot;:&quot;current_value scope 3&quot;},&quot;https:\/\/www.intuit.com\/oidam\/intuit\/ic\/en_us\/content\/intuit-cr-report-2020-icom.pdf&quot;:{&quot;0&quot;:53,&quot;1&quot;:1912,&quot;2&quot;:5136,&quot;3&quot;:30476}}
  </code></pre>