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.