title: Remove header Row in Python 3.4.2 using Pandas
body: <p>I have a csv I want to remove the Header row. So that second row becomes Header</p>
  
  <p>I have a csv I want to remove the Header row. So that second row becomes Header
  I have rows which I wanted to delete in the starting. But it takes one column value and makes it a header like:</p>
  
  <pre><code>      Time Deposits     Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \
  4   Settlement Date  Maturity Date   Order ID     Status     Entity   
  </code></pre>
  
  <p>I want to delete the top Header Line so that Line below act as a Header and I can do further process.</p>
  
  <p>If I do <code>df7 = df6.iloc[1:]</code> it removes </p>
  
  <pre><code>Settlement Date  Maturity Date   Order ID     Status     Entity
  </code></pre>
  
  <p>but I want to remove:</p>
  
  <pre><code>Time Deposits     Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \
  
  import pandas as pd
  
  
  # making data frame from csv file 
  df1 = pd.read_csv("E:\Sample\LORD ABBETT REPO SHEET 1-14-19_Notes_2.csv") 
  
  df2=df1.dropna(axis=0, how='any', thresh=None, subset=None, inplace=False)
  
  #df2.index = np.arange(1, len(df2) + 1)
  
  #df3=df2.drop(['Time Deposits'])
  
  
  print (df2)
  </code></pre>
  
  <p>Now:</p>
  
  <pre><code>      Time Deposits     Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \
  4   Settlement Date  Maturity Date   Order ID     Status     Entity  
  </code></pre>
  
  <p>Expected:</p>
  
  <pre><code>4   Settlement Date  Maturity Date   Order ID     Status     Entity   
  </code></pre>