I have 2 Dataframes as shown and I want a new DataFrame where the 1st column is the 1st column of the 1st DataFrame and 2nd column from the 1st column of the 2nd DataFrame. I have tried pivot table etc but have no luck.
A B
0 1 2
1 3 67
2 4 54
C D
0 0 19
1 23 6
2 55 5
I need a new DataFrame like this.
A C B D
0 1 0 2 19
1 3 23 67 6
2 4 55 54 5