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
df.rename(columns=df.iloc[0])
In [24]: df.drop(df.index[1]) Out[24]: 1 foo bar baz 0 1 2 3 2 4 5 6