title: Translate Pandas Dataframe
body: <p>I have a Pandas Dataframe read in from a CSV file.</p>
  
  <p>I want to create a larger Dataframe what includes some of the columns in the CSV file - however the header names are different so translation is needed.</p>
  
  <p>The larger Dataframe values not included in the CSV file should be settable to some default value.</p>
  
  <p>My best idea so far is to start with the dataframe from the CSV and use a dictionary to translate the column names.  Then I can add the remaining columns to the resulting structure.  This feels a bit clunky tho - any suggestions on how to best approach this?</p>
  
  <p>An illustrative example</p>
  
  <p><strong>Initial CSV file:</strong></p>
  
  <pre><code>Name,Age,Address,PhoneNumber
  </code></pre>
  
  <p><strong>Dataframe output:</strong></p>
  
  <p>Given the above we have - Age=Age, FullName=Name, HomeAddress=Address.</p>
  
  <p>The defaults for example could be - Nationality="USA", WorkAddress="Google", StarSign="Leo".</p>
  
  <p>PhoneNumber is ignored completely in the output.</p>
  
  <pre><code>Age,Nationality,FullName,HomeAddress,WorkAddress,StarSign
  </code></pre>