title: Pandas - Drop function error (label not contained in axis)
body: <p>I have a CSV file that is as the following:</p>
  
  <pre><code>index,Avg,Min,Max
  Build1,56.19,39.123,60.1039
  Build2,57.11,40.102,60.2
  Build3,55.1134,35.129404123,60.20121
  </code></pre>
  
  <p>Based off my question <a href="https://stackoverflow.com/questions/44929516/python-pandas-working-with-numeric-data-but-adding-non-numeric-data-back">here</a> I am able to add some relevant information to this csv via this short script:</p>
  
  <pre><code>import pandas as pd
  
  df = pd.read_csv('newdata.csv')
  print(df)
  
  df_out = pd.concat([df.set_index('index'),df.set_index('index').agg(['max','min','mean'])]).rename(index={'max':'Max','min':'Min','mean':'Average'}).reset_index()
  
  with open('newdata.csv', 'w') as f:
      df_out.to_csv(f,index=False)
  </code></pre>
  
  <p>This results in this CSV:</p>
  
  <pre><code>index,Avg,Min,Max
  Build1,56.19,39.123,60.1039
  Build2,57.11,40.102,60.2
  Build3,55.1134,35.129404123,60.20121
  Max,57.11,40.102,60.20121
  Min,55.1134,35.129404123,60.1039
  Average,56.1378,38.1181347077,60.16837
  </code></pre>
  
  <p>I would like to now have it so I can update this csv. For example if I ran a new build (build4 for instance) I could add that in and then redo the Max, Min, Average rows. My idea is that I therefore delete the rows with labels Max, Min, Average, add my new row, redo the stats. I believe the code I need is as simple as (just for Max but would have lines for Min and Average as well):</p>
  
  <pre><code>df = pd.read_csv('newdata.csv')
  df = df.drop('Max')
  </code></pre>
  
  <p>However this always results in an <strong>ValueError: labels ['Max'] not contained in axis</strong></p>
  
  <p>I have created the csv files in sublime text, could this be part of the issue? I have read other SO posts about this and none seem to help my issue. </p>
  
  <p>I am unsure if this allowed but here is a <a href="https://drive.google.com/file/d/0BxmTrEaEFKHbLUFrSE5nTnVqZ1E/view?usp=sharing" rel="noreferrer">download link to my csv</a> just in case something is wrong with the file itself. </p>
  
  <p>I would be okay with two possible answers:</p>
  
  <ol>
  <li>How to fix this drop issue</li>
  <li>How to add more builds and update the statistics (a method without drop)</li>
  </ol>