Add a new Row with specific Index Name at the Top of a DataFrame

Question

I have a DataFrame (df1) looking like this:

        0   
Height  175     
Weight  80

Now I want to add a row Age with the value 37 but not at the end (for this we have already a solution) but on Top of my DataFrame.

What I have yet tries is:

pd.DataFrame(np.insert(df1.values, 0, values=['n',5], axis=0)) but I can onyl get this to work without the 'n' string and then there is only one column left.

Anyone a better idea that solves my problem?

jezrael · Accepted Answer · 2019-05-15T12:37:18.373

4

Use DataFrame contructor with DataFrame.append or concat:

df = pd.DataFrame([37], index=['Age'], columns=[0]).append(df)
print (df)
          0
Age      37
Height  175
Weight   80

Alternative solution:

df = pd.concat([pd.DataFrame([37], index=['Age'], columns=[0]), df])

edited May 15 '19 at 12:37

answered May 15 '19 at 12:35

jezrael

822,522
95
1,334
1,252

1

perfect, this works for me. Thanks a lot and even with two possible ways. – ruedi May 15 '19 at 12:37

score 1 · Answer 2 · answered May 15 '19 at 12:35

1

Because I can't comment, what do you want to do with the values['n',5] ?

answered May 15 '19 at 12:35

Hanggy

25
9

Add a new Row with specific Index Name at the Top of a DataFrame

2 Answers2