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.