Use part of first row and part of second row as column headers in python pandas

Question

I have a smiliar question to this one.

But somehow the solotion is not working, my dataframe looks like:

    Unnamed: 0  Unnamed: 1  Unnamed: 2  Unnamed: 3      Ist 1-4     Plan 1-4    HoRe 04     Plan
0   D           B           Hil           V Gesamt:     -83053      -83628    -262596     -257276
1   V           V           Vor            Perso        -896        -833    -2720         -2504

So basically I need to have for the first four columns the row number 0 as headers (D B Hil V Gesamt:) and then the last 4 columns (Ist 1-4 Plan 1-4 HoRe 04 Plan), when I run the script:

#set first row by columns names
df.iloc[0,:] = df.columns

#reset_index
df = df.reset_index()
#set columns from first row
df.columns = df.iloc[0,:]
df.columns.name= None
#remove first row
df.iloc[1:,:]

its still wrong, the outcome does not change.

My output should be:

    D   B   Hil     V Gesamt        Ist 1-4     Plan 1-4    HoRe 04     Plan
0   V    V  Vor     Perso           -896        -833       -2720         -2504

could u post an example of ur expected output

sammywemmy
– sammywemmy

2020-01-30 14:06:23 +00:00
Commented Jan 30, 2020 at 14:06 — sammywemmy
– sammywemmy, Commented Jan 30, 2020 at 14:06

jezrael · Accepted Answer · 2020-01-30 14:12:03Z

1

I think you can convert first 4 values of first row to list and add to all columns names:

df.columns = df.iloc[0,:4].tolist() + df.columns[4:].tolist()
#alternative
#df.columns = np.concatenate([df.iloc[0,:4], df.columns[4:]])
df = df.iloc[1:].reset_index(drop=True)
print (df)
   D  B  Hil V Gesamt:  Ist 1-4  Plan 1-4  HoRe 04  Plan
0  V  V  Vor     Perso     -896      -833    -2720 -2504

edited Jan 30, 2020 at 14:12

answered Jan 30, 2020 at 14:08

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Use part of first row and part of second row as column headers in python pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related