pandas多列中的两列互换了位置，之后合并，不希望合并后的数据集按对应列合并，直接合并，按第一个数据集的列索引就好

Question

您好，您能帮我解决下这个问题吗，实在是不会咋弄，初学Python。万分感谢！

Answer 1

额，df2换个头，不行吗？

import pandas as pd

df1 = pd.DataFrame(
    {
        "A": ["A0", "A1", "A2"],
        "B": ["B0", "B1", "B2"],
        "C": ["C0", "C1", "C2"],
        "D": ["D0", "D1", "D2"],
        "E": ["E0", "E1", "E2"],
    },
    index=[0, 1, 2],
)
df2 = pd.DataFrame(
    {
        "B": ["B0", "B1", "B2"],
        "A": ["A0", "A1", "A2"],
        "C": ["C0", "C1", "C2"],
        "D": ["D0", "D1", "D2"],
        "E": ["E0", "E1", "E2"],
    },
    index=[0, 1, 2],
)

df2 = df2.rename(columns={"A":"B","B":"A"})
pd.concat([df1,df2],axis=0, join="outer",ignore_index=True,keys=["C","D","E"])