How to convert the header row to a normal row in pandas

Question

I am having a excel sheet where I skipped multiple rows and finally arrived at a dataframe with some little structure. But I have a dataframe which looks like this. Bold are headers.

There are some columns on top which I hid in this screenshot as well. While reading a dataframe by skipping rows from excel, there is a multi level indexing. I wanted to have the numbers in header to come as a row. Please advice how to achieve this.

Thank you in advance

Sorry @PV8 cannot add it. its not a duplicate one... because the one in the forum you pointed out, just reads the excel directly by excluding rows. Whereas this is little different. From the dataframe, I need to make the header to row — python_interest
– python_interest, Commented Aug 28, 2019 at 8:20

MLAlex · Accepted Answer · 2019-08-28 08:20:07Z

2

You can skip header with header = None if you use .read_csv

df = pd.read_csv(file_path, header=None, usecols=[3,6])

answered Aug 28, 2019 at 8:20

MLAlex

14210 bronze badges

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

2 Comments

python_interest Over a year ago

not while reading a csv file. Because I also need the headers on top of it which forms multi level indexing.

MLAlex Over a year ago

Can you add a little more insight to your question, please.

Ted · Accepted Answer · 2019-08-28 09:13:37Z

1

The following will add your current columns as the last row in the dataframe. You could then put this row into position 0, or rename the columns, if necessary.

row = pd.Series(df.columns, index=df.columns)
df.append(row, ignore_index=True)

answered Aug 28, 2019 at 9:13

Ted

1,2329 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to convert the header row to a normal row in pandas

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related