title: What is the best way to both drop columns and insert column names using Python Pandas?
body: <p>I have a csv with a few dozen columns that are all unnamed by default and about half of which need to be removed. I've figured out how to name the columns upon import. Example:</p>
  <pre><code>df = pandas.read_csv('ColumnNameTest.csv', names=['ID', 'Name', 'Flavor'])
  </code></pre>
  <p>And I <em>think</em> I figured out how to drop columns:</p>
  <pre><code>df.drop('Flavor', axis='columns', inplace=True)
  </code></pre>
  <p>But what is the most efficient way to drop about a dozen columns and insert the column names?
  Do I have to name all the columns first, then just drop them?</p>