Question

How to add (append) row to pandas DataFrame in Python

Answer 1

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])
  
new_row = {'name':'Voldemort', 'algebra':82, 'python':86, 'java':91}

df = df.append(new_row, ignore_index=True)

print(df)

   
   
'''
run:
   
          name  algebra  python  java
0         Tom       91      80    94
1        Emmy       98      95    96
2      Rubeus       87      81    87
3  Dumbledore       99     100    98
4        Axel       75      85    90
5   Voldemort       82      86    91

'''

 

70+ SQL courses for beginners and professionals