Question

How to concatenate pandas DataFrames with different 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', 'geometry'])

df12 = [df1, df2]

df12 = pd.concat(df12)

df12.reset_index(drop=True, inplace=True)

print(df12)
 
 
 
'''
run:
 
          name  algebra  python  java  geometry
0         Tom       91      80  94.0       NaN
1        Emmy       98      85  96.0       NaN
2        Axel       75      83  90.0       NaN
3  Dumbledore       99     100   NaN      98.0
4      Rubeus       87      81   NaN      87.0

'''

 

70+ SQL courses for beginners and professionals