first row as header pandas code example
Example 1: first row as column df
df.rename(columns=df.iloc[0])
Example 2: 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
Example 3: set header in dataframe 2nd line
In [23]: df.columns = df.iloc[1]