Convert first row of pandas dataframe to column name

Question

I have a pandas dataframe

   0     1     2
0  pass fail  warning
1  50    12    34

I am trying to convert first row as column name something like this

   pass fail  warning
0  50    12    34

I am currently doing this by renaming the column name

 newdf.rename(columns={0: 'pass', 1: 'fail', 2:'warning'})

and then deleting the first row. Any better way to do it .

Answer 1

For the dataframe DF, the following line of code will set the first row as the column names of the dataframe:

DF.columns = DF.iloc[0]

Answer 2

I believe need to add parameter to read_html:

df = pd.read_html(url, header=1)[0]

Or:

df = pd.read_html(url, skiprows=1)[0]