How can i set second row as a name of columns in DataFrame

Question

How i can make from this DataFrame: (try df.drop([0]), df.iloc[1:] but dont work)

     A B C
  0  1 2 3
  1  X Y Z

this:

     1 2 3
  0  X Y Z

Does this answer your question? [Convert row to column header for Pandas DataFrame,](https://stackoverflow.com/questions/26147180/convert-row-to-column-header-for-pandas-dataframe) — Arpit Singh, May 11 '20 at 18:30

score 5 · Accepted Answer · answered May 11 '20 at 18:08

in two steps,

df.columns = df.iloc[0]

df = df.iloc[1:].reset_index(drop=True)


print(df)

   1  2  3
0  X  Y  Z

a better method would be to use skiprows in your read argument.

from io import StringIO
d = """   A B C
    1 2 3
    X Y Z"""

df = pd.read_csv(StringIO(d),sep='\s+',skiprows=1)
print(df)

   1  2  3
0  X  Y  Z

score 3 · Answer 2 · answered May 11 '20 at 18:15

3

df.T.set_index(0).T.reset_index(drop=True).rename_axis(columns=None)
   1  2  3
0  X  Y  Z

answered May 11 '20 at 18:15

ansev

2 Answers2