python - add a row at top in pandas dataframe

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/43408621/add-a-row-at-top-in-pandas-dataframe

Answer 1

Probably this is not the most efficient way but:

df.loc[-1] = ['45', 'Dean', 'male']  # adding a row
df.index = df.index + 1  # shifting index
df.sort_index(inplace=True) 

Output:

 age  name     sex
0  45  Dean    male
1  30   jon    male
2  25   sam    male
3  18  jane  female
4  26   bob    male