Remove header Row in Python 3.4.2 using Pandas

Question

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

Possible duplicate of Pandas read in table without headers

Nusrath
– Nusrath

2019-01-21 07:10:54 +00:00
Commented Jan 21, 2019 at 7:10 — Nusrath
– Nusrath, Commented Jan 21, 2019 at 7:10

lexual · Accepted Answer · 2019-01-21 05:46:16Z

4

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.

answered Jan 21, 2019 at 5:46

lexual

49.1k2 gold badges18 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remove header Row in Python 3.4.2 using Pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related