Pandas Copy columns from one data frame to another with different name

Question

I have to copy columns from one DataFrame A to another DataFrame B. The column names in A and B do not match.

What is the best way to do it? There are several columns like this. Do I need to write for each column like B["SO"] = A["Sales Order"] etc.

Answer 1

i would use pd.concat

combined_df = pd.concat([df1, df2[['column_a', 'column_b']]], axis=1)

also gives you the power to concat different size dateframes , outer join etc.