Convert row to column header for Pandas DataFrame,
In [21]: df = pd.DataFrame([(1,2,3), ('foo','bar','baz'), (4,5,6)])In [22]: dfOut[22]: 0 1 20 1 2 31 foo bar baz2 4 5 6Set the column labels to equal the values in the 2nd row (index location 1):
In [23]: df.columns = df.iloc[1]If the index has unique labels, you can drop the 2nd row using:
In [24]: df.drop(df.index[1])Out[24]: 1 foo bar baz0 1 2 32 4 5 6If the index is not unique, you could use:
In [133]: df.iloc[pd.RangeIndex(len(df)).drop(1)]Out[133]: 1 foo bar baz0 1 2 32 4 5 6Using df.drop(df.index[1]) removes all rows with the same label as the second row. Because non-unique indexes can lead to stumbling blocks (or potential bugs) like this, it's often better to take care that the index is unique (even though Pandas does not require it).