0

I have 2 pandas dataframe:

df1

Column A Column B Column C
A1 1234 Q1
A2 1253 Q2
A3 1255 Q3
A4 1277 @4
A1 1277 Q5
A3 12345 Q6

df2

Column C Column D Column E
A1 B2 12
A2 B4 23
A3 A2 34
A4 A4 45

I would like to merge the table that looks something like this:

Expected output:

Column A Column B Column D Column E
A1 1234 Q1 B2
A2 1253 Q2 B4
A3 1255 Q3 A2
A4 1277 @4 A4
A1 1277 Q5 B2
A3 12345 Q6 A2

What I tried so far?

df_merged = [df_1[df_1["Column A"] == i] for i in df2["Column C"]]

The above script is time consuming. Hence, I would like a fast and efficient solution.

0 Answers0