new_header = df.iloc[0] #grab the first row for the headerdf = df[1:] #take the data less the header rowdf.columns = new_header #set the header row as the df header
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.
If you want a one-liner, you can do:
df.rename(columns=df.iloc[0]).drop(df.index[0])