Question

How to append a pandas DataFrame to another in Python

Answer 1

import pandas as pd

df1 = pd.DataFrame(
	[['Tom', 91, 80, 94],
	 ['Emmy', 98, 85, 96],
	 ['Axel', 75, 83, 90]],
	columns=['name', 'algebra', 'python', 'java'])

df2 = pd.DataFrame(
	[['Dumbledore', 99, 100, 98],
	 ['Rubeus', 87, 81, 87]],
	columns=['name', 'algebra', 'python', 'java'])

df12 = df1.append(df2, ignore_index=True, sort=False)

print(df12)
 
 
 
'''
run:
 
          name  algebra  python  java
0         Tom       91      80    94
1        Emmy       98      85    96
2        Axel       75      83    90
3  Dumbledore       99     100    98
4      Rubeus       87      81    87

'''

 

70+ SQL courses for beginners and professionals