title: read and write to a csv file
body: <p>While working with the pandas library, I want to read and write data to a csv file.  Everything is going fine using to_csv to write the DataFrame to the csv file.  My problem arises when I try to read the values back to the python interpreter.</p>
  
  <p>The parameter index_col=None doesn't change the output.</p>
  
  <pre><code>#Pass some keys and values to a pandas DataFrame held in variable df
  df = pd.DataFrame({'Artist':['Sublime','Blink 182','Nirvana'],
  'Album':['Sublime','Blink 182','Nevermind'],
  'Hit Single':["What I've Got", 'All the Small Things',
  'Smells Like Teen Spirit']})
  
  #Print DataFrame
  df
  
  
  #Write the data to a spreadsheet(comma separated value file type)
  df.to_csv('filename.csv')
  
  #Read the values back into the df varaible
  df =pd.read_csv('filename.csv')
  
  #Print out values in df variable
  df
  </code></pre>
  
  <p>After reading the data back using read_csv there is Unnamed: at the top of the second column as well as an extra set of numeric indices counting up from 0 to 2 0 appearing twice.  How can I get rid of this extra unwanted column?</p>