title: Python Pandas 'Unnamed' column keeps appearing
body: <p>I am running into an issue where each time I run my program (which reads the dataframe from a .csv file) a new column shows up called 'Unnamed'. </p>
  
  <p>sample output columns after running 3 times - </p>
  
  <pre><code>  Unnamed: 0  Unnamed: 0.1            Subreddit  Appearances
  </code></pre>
  
  <p>here is my code. for each row, the 'Unnamed' columns simply increase by 1.</p>
  
  <pre><code>df = pd.read_csv(Location)
  while counter &lt; 50:
      #gets just the subreddit name
      e = str(elem[counter].get_attribute("href"))
      e = e.replace("https://www.reddit.com/r/", "")
      e = e[:-1]
      if e in df['Subreddit'].values:
          #adds 1 to Appearances if the subreddit is already in the DF
          df.loc[df['Subreddit'] == e, 'Appearances'] += 1
      else:
          #adds new row with the subreddit name and sets the amount of appearances to 1.
          df = df.append({'Subreddit': e, 'Appearances': 1}, ignore_index=True)
      df.reset_index(inplace=True, drop=True)
      print(e)
      counter = counter + 2
  #(doesn't work) df.drop(df.columns[df.columns.str.contains('Unnamed', case=False)], axis=1)
  </code></pre>
  
  <p>The first time i run it, with a clean .csv file, it works perfect, but each time after, another 'Unnamed' column shoes up.
  I just wanted the 'Subreddit' and 'Appearances' columns to show each time. </p>