new_header = df.iloc #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
Here is what the above code is Doing:
1. Grabbing the first row of the dataframe and setting it as the header.
2. Taking the data less the header row.
3. Setting the header row as the df header.