pandas 将熊猫数据框的第一行转换为列名

Convert first row of pandas dataframe to column name

提问by Hariom Singh

I have a pandas dataframe

我有一个Pandas数据框

   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 .

然后删除第一行。任何更好的方法来做到这一点。

采纳答案by jezrael

I believe need to add parameter to read_html:

我相信需要将参数添加到read_html：

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

Or:

或者：

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

回答by Vidya P V

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

对于数据框 DF，以下代码行将第一行设置为数据框的列名：

DF.columns = DF.iloc[0]