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, — Arpit Singh
– Arpit Singh, Commented May 11, 2020 at 18:30

Umar.H · Accepted Answer · 2020-05-11 18:08:27Z

5

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

answered May 11, 2020 at 18:08

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ansev · Accepted Answer · 2020-05-11 18:15:50Z

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, 2020 at 18:15

ansev

31k5 gold badges21 silver badges33 bronze badges