Question

How to concatenate pandas DataFrames with similar columns 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, df2]

df12 = pd.concat(df12, sort=False)

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

 

70+ SQL courses for beginners and professionals