import pandas as pd df1 = pd.DataFrame({ 'A': range(4), 'B': range(4), 'C': range(4), 'D': range(4) }) df2 = pd.DataFrame({ 'D': [11, 22, 33], 'E': ['aa', 'bb', 'cc'] }) new_A = pd.concat([df1['A'], df2['D'], df2['E']], ignore_index=True) df1 = df1.reindex(range(df2.shape[0] * 2 + df1.shape[0])) df1['A'] = new_A print(df1)