pandas read first row as column names code example

Example 1: make first row column names 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 2: make first row column names pandas

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