First row as column df

Make first row columns pandas

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

Source: stackoverflow.com

First row as column df

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

-1

Source: stackoverflow.com

Similar codes

31 votes138 views6 answers
Python dataframe sort by column name
Python
0 vote135 views1 answer
For loop to create a set of counters in python
Python
0 vote128 views1 answer
Date format django template filter
Python Django
1 vote82 views3 answers
Python create file if not exists
Python
3 votes119 views1 answer
Python legend being cut off
Python
18 votes72 views2 answers
Python string append character
Python
6 votes105 views5 answers
Python fill zeros left
Python
1 vote116 views1 answer
Module turtle has no forward member
Python
49 votes98 views2 answers
Add new element to python dictionary
Python
0 vote102 views2 answers
How to return a missing element in python
Python