header of the columns as row pandas code example

Example 1: make first row column names pandas

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

Example 2: make first row column names pandas

In [24]: df.drop(df.index[1])
Out[24]: 
1 foo bar baz
0   1   2   3
2   4   5   6