Python Pandas Replacing Header with Top Row

We Are Going To Discuss About Python Pandas Replacing Header with Top Row. So lets Start this Python Article.

Python Pandas Replacing Header with Top Row

How to solve Python Pandas Replacing Header with Top Row

new_header = df.iloc[0] #grab the first row for the header df = df[1:] #take the data less the header row df.columns = new_header #set the header row as the df header

Python Pandas Replacing Header with Top Row

new_header = df.iloc[0] #grab the first row for the header df = df[1:] #take the data less the header row df.columns = new_header #set the header row as the df header

Solution 1

new_header = df.iloc[0] #grab the first row for the header
df = df[1:] #take the data less the header row
df.columns = new_header #set the header row as the df header

Original Author rgalbo Of This Content

Solution 2

The dataframe can be changed by just doing

df.columns = df.iloc[0]
df = df[1:]

Then

df.to_csv(path, index=False) 

Should do the trick.

Original Author JoeCondron Of This Content

Solution 3

If you want a one-liner, you can do:

df.rename(columns=df.iloc[0]).drop(df.index[0])

Original Author ostrokach Of This Content

Solution 4

Another one-liner using Python swapping:

df, df.columns = df[1:] , df.iloc[0]

This won’t reset the index

Although, the opposite won’t work as expected df.columns, df = df.iloc[0], df[1:]

Original Author ijoel92 Of This Content

Conclusion

So This is all About This Tutorial. Hope This Tutorial Helped You. Thank You.

Also Read,

ittutorial team

I am an Information Technology Engineer. I have Completed my MCA And I have 4 Year Plus Experience, I am a web developer with knowledge of multiple back-end platforms Like PHP, Node.js, Python and frontend JavaScript frameworks Like Angular, React, and Vue.

Leave a Comment