2

I have a csv I want to remove the Header row. So that second row becomes Header

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:

      Time Deposits     Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \
4   Settlement Date  Maturity Date   Order ID     Status     Entity   

I want to delete the top Header Line so that Line below act as a Header and I can do further process.

If I do df7 = df6.iloc[1:] it removes

Settlement Date  Maturity Date   Order ID     Status     Entity

but I want to remove:

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)

Now:

      Time Deposits     Unnamed: 1 Unnamed: 2 Unnamed: 3 Unnamed: 4  \
4   Settlement Date  Maturity Date   Order ID     Status     Entity  

Expected:

4   Settlement Date  Maturity Date   Order ID     Status     Entity   
lexual
  • 46,172
  • 2
  • 15
  • 14
Abhishek Gaur
  • 300
  • 1
  • 5
  • 20
  • Possible duplicate of [Pandas read in table without headers](https://stackoverflow.com/questions/29287224/pandas-read-in-table-without-headers) – Nusrath Jan 21 '19 at 07:10

1 Answers1

3

I suggest you look at the header argument that you can provide to pd.read_csv.

https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_csv.html

I think specifically for you example, if you read the csv in like this:

df1 = pd.read_csv(
    "E:\Sample\LORD ABBETT REPO SHEET 1-14-19_Notes_2.csv",
    header=1) 

Then I believe you will have the column names that you are after, & won't have to munge your dataframe to get the correct data you want.

lexual
  • 46,172
  • 2
  • 15
  • 14